Exporting special characters from php to Excel problem

Contributor
5Jan2010,11:51   #1
rekha's Avatar
Hi,

I am exporting my data from php to Excel.For example if my data is -R2500.00 this value is not exporting properly.It is exported as zero and in some cases it may result in invalid #name error.I used double quotes but still the problem is not solved.

Anyone pls help....
Newbie Member
5Jan2010,14:19   #2
vb_reader's Avatar
how are you exporting the data? if you are using response, and content type. then change the charset appropriately . if you can tell what you are trying to export and what is actually exported. I can be more specific in what to do.
Contributor
5Jan2010,14:26   #3
rekha's Avatar
Hi,

Thanks for your reply.I have used header("Content-type: application/csv");
Contributor
7Jan2010,16:43   #4
rekha's Avatar
Anyone pls solve my issue.