leading zero

[Davor Palaic]

How can I get leading zero when I'm exporting to MS Excel?
I have query like this one:

select '01234'
from dual

In preview I see 01234 but in MS Excel value is 1234. Zero is somehow lost. I tried with CSV and through Get external data in MS Excel and everything is fine. The problem is only when I'm exporting directly to the MS Excel.

Is there some workaround for this? If not can you do something in your OLE (I suppose that you are using OLE to do export to MS Excel ?)

I'm using QueryReporter 2.0.4.180, MS Excel 2000 (9.0.3821 SR-1), W2000 SP4.

Thanks,

Davor.

 

[Marco Kalter]

This is currently not possible, Excel will always try to interpret the data. In the next release character data will not be interpreted by Excel though.

 

[Davor Palaic]

If I understand you correctly the new release will not have the feature that the old release alredy has. If this is true, can you send me the prerelease?

 

[Marco Kalter]

You can download a pre-release here .

 

[Davor Palaic]

Thanks.
It works fine. I'll use this pre-release version.
I have noticed that you significantly improved MS Excel exporting. Now it is much faster.

Davor.