Excel Buffer Number Format

Sowkarthika

Hi,

Has anybody tried exporting Amount value in Excel using Excel Buffer (NAV 2016) ?

I need the amount to be formatted like 307,909.44, 199,675.32 etc..

I tried below codes :
1) EnterCell(ExcelRowNo,3,Amount,TRUE,FALSE,FALSE,'',CellType::Text) : Exports Amount in the required format but it is text.

2) EnterCell(ExcelRowNo,3,Amount,TRUE,FALSE,FALSE,'',CellType::Number) : Amount is not formatted as required


Function : EnterCell(RowNo ; ColumnNo ;CellValue ;Bold ;Italic;UnderLine;NumberFormat ;CellType )

lynge

Use the "look" from the user defined formats (from Cell formats) in Excel as "Numberformat" - try:
EnterCell(ExcelRowNo,3,Amount,TRUE,FALSE,FALSE,'#,##0.00',CellType::Number)