Excel Column Formatting Question

[g-nf-5]

I have an app that is creating an Excel file for import into another process that is giving me fits. Our items are alpha, and when I export an item that is all numerical with leading zeroes. the zeroes are dropped. What command would I need so that the column realizes the values to be text instead of general?

 

[mosfin]

maybe you can try and export them as string (i.e: enclose with ")
or prefix them with single quote '
(AFAIK Excel treats number that prefixed with single-quote as string)

 

[g-nf-5]

Sweet! great call. Thanks!

 

[g-nf-5]

It was the single quote preceeding the item number that did it for me.

 

[tamhas]

You might want to look at http://www.oehive.org/project/libooxml and get away from this whole category of problem and gain much more control.

 

[D.Cook]

http://www.oehive.org/project/libooxml

Wow thanks tamhas, this library looks extremely useful, especially allowing us to export reports on a unix server!

What command would I need so that the column realizes the values to be text instead of general?

You can set the cell format to text with the following command. Although note that Excel may display a warning about numeric values stored as text (this warning could be disabled programmatically but I forget how).

chExcelWorksheet:Columns("A:B"):NumberFormat = "@"

 

[jmac13]

Personally id format the cells/column to the number format i want.. rather than turning it into a string

e.g.
chWorkSheet:Range(w-chrRange):numberformat = "##,###,##0.00"