Question about importing information from Nav to Excel

Archy
Archy Member Posts: 70
Hello!

I have to export data from Navision to Excel. Is it possible to format from Navision this Excel sheet? I need to define fonts height, column width and format.

Comments

  • kriki
    kriki Member, Moderator Posts: 9,121
    Use table 370:"Excel Buffer". In it are some functions you can use to send data to Excel and to do some formatting. In it is not enough, you can add functionality to the table.
    Search the forum for more info on the table.
    Regards,Alain Krikilion
    No PM,please use the forum. || May the <SOLVED>-attribute be in your title!


  • Archy
    Archy Member Posts: 70
    Some functions doesn't work well on this codeunit, actually, formatting doesn't work at all. :( And I didn't find these, which allow to define column width. Maybe somebody could advice, how to make such a functions? I don't have any detailed manual about working with Excel. Please, help!!!
  • Mbad
    Mbad Member Posts: 344
    Can use the same functionality as utilized in transfering data in Analisys by dimensions. Reading through that code will teach you a lot about the automation.
  • Archy
    Archy Member Posts: 70
    Thanks a lot! :)