Exporting special characters from php to Excel problem

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....

 

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.

 

Hi,

Thanks for your reply.I have used header("Content-type: application/csv");

 

Anyone pls solve my issue.