The format of the field after exporting to Excel

sunnyk

Hi,
In of the Report we have used Excelbuffer Table to export report data to excel.
For one the column we have wrote like below,

EnterCell(RowNo,5,Format("Item No."),FALSE,FALSE,FALSE);

and the value of Item No is 5-7056.
Where the function Entercell is like this,

EnterCell(RowNo : Integer;ColumnNo : Integer;CellValue : Text[250];lvBold : Boolean;Italic : Boolean;UnderLine : Boolean
TempExcelBuffer.INIT;
TempExcelBuffer.VALIDATE("Row No.",RowNo);
TempExcelBuffer.VALIDATE("Column No.",ColumnNo);
TempExcelBuffer."Cell Value as Text" := CellValue;
TempExcelBuffer.Formula := '';
TempExcelBuffer.Bold := Bold;
TempExcelBuffer.Italic := Italic;
TempExcelBuffer.Underline := UnderLine;
TempExcelBuffer.INSERT;

but in Excel the Value is coming as May-56 instead of 5-7056. Have anybody encountered this type of case.

mohana_cse06

Did you try to send ' before Item No..

EnterCell(RowNo,5,'''' + Format("Item No."),FALSE,FALSE,FALSE);

sunnyk

Hi Mohan,
Thanks. It is corrected. but I still didn't understand why it as like that even though i have used he format and the cell value was in text.