Question about importing information from Nav to Excel

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.
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.
0
Comments
-
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!0 -
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!!!
0 -
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.0
-
Thanks a lot!0
Categories
- All Categories
- 73 General
- 73 Announcements
- 66.6K Microsoft Dynamics NAV
- 18.7K NAV Three Tier
- 38.4K NAV/Navision Classic Client
- 3.6K Navision Attain
- 2.4K Navision Financials
- 116 Navision DOS
- 851 Navision e-Commerce
- 1K NAV Tips & Tricks
- 772 NAV Dutch speaking only
- 617 NAV Courses, Exams & Certification
- 2K Microsoft Dynamics-Other
- 1.5K Dynamics AX
- 320 Dynamics CRM
- 111 Dynamics GP
- 10 Dynamics SL
- 1.5K Other
- 990 SQL General
- 383 SQL Performance
- 34 SQL Tips & Tricks
- 35 Design Patterns (General & Best Practices)
- 1 Architectural Patterns
- 10 Design Patterns
- 5 Implementation Patterns
- 53 3rd Party Products, Services & Events
- 1.6K General
- 1.1K General Chat
- 1.6K Website
- 83 Testing
- 1.2K Download section
- 23 How Tos section
- 252 Feedback
- 12 NAV TechDays 2013 Sessions
- 13 NAV TechDays 2012 Sessions