Exporting to Excel with line breaks in a cell

shibily

Hi All,
I have generated an Excel from Navision. I want line breaks in one of the cells. I use Repeat... until... functionality in Navision to get the data which i need to be inserted in a particular cell. However i want all the lines to be inserted in a single cell in excel with a line break after each line. Anybody please help.

Thanks in advance
Shibily.

Belias

try

chr10 := 10;
xlapp.range('A1').value := 'myfirstline' + format(chr10) + 'mysecondline'

where chr10 is a variable of type char
i don't know if the syntax is correct, never tried but it should work

Administrator

[Topic moved from NAV Tips & Tricks to NAV/Navision forum]

shibily

Belias wrote:

try

chr10 := 10;
xlapp.range('A1').value := 'myfirstline' + format(chr10) + 'mysecondline'

where chr10 is a variable of type char
i don't know if the syntax is correct, never tried but it should work

Hi Belias
Thank you very much. It is working fine now.

Regards
Shibily