Exporting to Excel with line breaks in a cell

shibily
shibily Member Posts: 89
edited 2008-10-14 in NAV/Navision Classic Client
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.

Answers

  • Belias
    Belias Member Posts: 2,998
    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
    -Mirko-
    "Never memorize what you can easily find in a book".....Or Mibuso
    My Blog
  • Administrator
    Administrator Member, Moderator, Administrator Posts: 2,506
    [Topic moved from NAV Tips & Tricks to NAV/Navision forum]
  • shibily
    shibily Member Posts: 89
    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

Categories