Question about importing information from Nav to Excel

Archy

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.

kriki

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.

Archy

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

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

Thanks a lot!