Need "force text type" for XLS conversion


We generate the report contaning the table of values like '05.30'.

The output report have to be examined and updated by the user.
So we convert it to excel. For each cell excel highlites warning "!" like: "cell contains date value with no century assigned".
Then the user changes that value by means of pressing <ENTER> on cell, excel converts it to 'may 30'.

Is it possible to force the text type for the cell?

We have tried to use IS_DETECT_CELL_TYPE option but it does not help at all.
sp_const's picture
Joined: Oct 31 2006 - 9:59pm
Last seen: 16 years 10 months ago

1 Answer:


Why do you say it does not help at all?
Do you have an error, or things do not seem to change in any way?
Which XLS exporter are you using? The POI-based one or the JExcelApi one?

Thank you,
teodord's picture
Joined: Jun 30 2006 - 9:00am
Last seen: 3 hours 12 min ago