Options

Question about importing information from Nav to Excel

ArchyArchy 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

  • Options
    krikikriki Member, Moderator Posts: 9,090
    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!


  • Options
    ArchyArchy 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!!!
  • Options
    MbadMbad 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.
  • Options
    ArchyArchy Member Posts: 70
    Thanks a lot! :)
Sign In or Register to comment.