Web Development

Ask something
Discussion Locked

excel,com,national characters

0 helpful
7 replies

by proselyte

Closed to new repliesThis discussion is closed. It stays readable, but it takes no new replies.

I use PHP and COM to create a MS-excel sheet. When I insert text I get a problem with countryspecific characters, these are replaced with a box in excel.

Does any one know why and is there a solution for this?

7 replies

by huda

maybe your country specific characters in not in ASCII format or not ANSI character? try to use UNICODE because UNICODE almost support all language in the world...including....CJK(Chines, Japanese, Korean).....middle east(Arabic, Parsian, Urdu) and many more...

by albert franco ii

What is the environment? All this is on the same machine or do we have a server and clients?

What is the codepage that you are using? The best for European languages is 850. Make sure that all the machines use the same codepage.

Also, what is the source of the data that you are putting into the worksheet? Is it a dbf file, a paradox file, an SQl database? If the source of the data is not in ASCII your problem may be in the translation to Excel. all databases on DOS and Windows machineshave a predetermined language for the file. Make sure that it is compatible with the codepage and language settings on the machines where your program runs.

If this is the case you can either change the language driver for your database or perform the translation in code. The first option is preferable if possible.

Hope that helps,

Al Franco, II
APF Creations
Pamplona, Spain

This discussion is closed to new replies.