Exporting special characters from php to Excel problem

rekha's Avatar
Contributor
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....
vb_reader's Avatar, Join Date: Nov 2009
Newbie Member
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.
rekha's Avatar
Contributor
Hi,

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