The format of the field after exporting to Excel

sunnyk · **Posted:** Thu Jun 21, 2012 3:58 am

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,

Code: Select all

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,

Code: Select all

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 · **Posted:** Thu Jun 21, 2012 6:20 am

Did you try to send ' before Item No..

Code: Select all

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

sunnyk · **Posted:** Thu Jun 21, 2012 7:08 am

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.

mibuso.com

The format of the field after exporting to Excel

Who is online