Text Format while using Automation for Excel

smitapanda

Hi All,

I am developing one report in Automation for Excel.

I am facing problem for printing Item No in excel which start with a 0(zero). for example - 07023001,03028029,03002001 etc.

i have already used '@' fot text format.Also used FORMAT for the cell value.But the excel output shows the item nos without the firts 0 in excel.Example- 7023001,3028029,3002001 etc.

My code is - Printcell(Index,RowNo,FORMAT("Sales Invoice Line"."No."),1,0,false,'@');

Please help what to do.....Thanks in advance !!

MGM08

Try this

''''+FORMAT("Sales Invoice Line"."No.")

Search the forum for excel with zeros you will get many solutions.

smitapanda

I tried your solution but it didnt work.

Thanks for your reply

mohana_cse06

MGM08 wrote:

Search the forum for excel with zeros you will get many solutions.

What about this?

smitapanda

I searched teh forum .But generally people have suggested for using '@' of FORMAT(Value). I have seen using both of these.But not helped.

I think this helps in using Excel buffer.But mine is in Automation.

AntidotE

did you really use '<Value> to put in Excel? the ' is obligatory, this way Excel translates Value as text and no leading zeros are deleted.

Savatage

smitapanda wrote:

I tried your solution but it didnt work.
Thanks for your reply

Are you sure you tried the "4 single quotes" properly?

EnterCell(Row,column, ''''+Item."No.", FALSE, FALSE, FALSE);