Export Data- Giving Format to Excel column about excel HOT 3 CLOSED

Hi,
yes, I got your problem and am working on a solution. I've to change the code in the Helper. It has to check the type of data and then set explicitly the type of the cell in the sheet. The problem is that there is no explicit Cell-Type for Dates in PHP-Excel.
I'll have to do some more checks and tests and will probably publish a new release the next days.

from excel.

changed the way data is filled in cells:

• if data ist of type string or date, cell type will be explicitly set to string (seems to be correct type for dates, too)
• if data is numeric, numeric cell type will be used.

Please test and close the issue if you're ok with the solution

from excel.

Yes, exactly like that is working.
The problem is when a varchar has only number it put type numeric, when it is varchar.

The trick i did was just to concatenate a '\x20' to my field. Then is a string. :(

Anyway thanks for the help.

from excel.