Problem while generating Excel file from classic report

poppins

Hi everyone,
I am trying to generate an Excel file from a report.I have a trouble with the following line of code:

ExcelBuf.AddColumn('(01)',FALSE,'',TRUE,FALSE,TRUE,'');

I want the value (01) to be displayed in the column header, but what I get in the Excel file is -1.
How can I display what I want?
Thanks in advance

Luc_VanDyck

If you start up Excel and type (01) in a cell, you also get -1. You need to precede your text with '.
When you type '(01) then you see (01) in the cell.

lubost

Hi,

you should use ' (apostroph) as a first char in such fields. Excel shows such fields without apostroph and doesn't perform formatting (for Excel such fields are strings).