Howdy, Stranger!
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
- 115 Navision DOS
- 854 Navision e-Commerce
- 1K NAV Tips & Tricks
- 772 NAV Dutch speaking only
- 615 NAV Courses, Exams & Certification
- 2K Microsoft Dynamics-Other
- 1.5K Dynamics AX
- 301 Dynamics CRM
- 109 Dynamics GP
- 10 Dynamics SL
- 1.5K Other
- 993 SQL General
- 384 SQL Performance
- 34 SQL Tips & Tricks
- 34 Design Patterns (General & Best Practices)
- Architectural Patterns
- 10 Design Patterns
- 5 Implementation Patterns
- 53 3rd Party Products, Services & Events
- 1.7K General
- 1.1K General Chat
- 1.6K Website
- 79 Testing
- 1.2K Download section
- 23 How Tos section
- 259 Feedback
- 12 NAV TechDays 2013 Sessions
- 13 NAV TechDays 2012 Sessions
How to autofit with Excel Buffer, without using Openexcel ( Nav 2015 excel buffer version)
DenisR
Member Posts: 1
Hi,
I have a problem with Excel Buffer,I'm working on Nav 2015 and I have to create a report that export data from Purchase Line to Excel. After creating the excel I have this code on PostDataItem :
TempExcelBuffer.CreateBook(Title);
TempExcelBuffer.WriteSheet(Title,COMPANYNAME,USERID);
TempExcelBuffer.CloseBook;
....
Then I send the excel directly from the server via Mail to the target Recipient. The problem is that in the new Excel Buffer, the excel is generated using only XlWrkBkWriter, XlWrkShtWriter and the XlWrkBk or XlWrkSht are not initialized. I don't know how to initialized those variable to make the autofit of column, without using TempExcelBuffer.OpenExcel that download the file to client (I need to have the file modified server side).
Does anyone have any idea?
Thank You
I have a problem with Excel Buffer,I'm working on Nav 2015 and I have to create a report that export data from Purchase Line to Excel. After creating the excel I have this code on PostDataItem :
TempExcelBuffer.CreateBook(Title);
TempExcelBuffer.WriteSheet(Title,COMPANYNAME,USERID);
TempExcelBuffer.CloseBook;
....
Then I send the excel directly from the server via Mail to the target Recipient. The problem is that in the new Excel Buffer, the excel is generated using only XlWrkBkWriter, XlWrkShtWriter and the XlWrkBk or XlWrkSht are not initialized. I don't know how to initialized those variable to make the autofit of column, without using TempExcelBuffer.OpenExcel that download the file to client (I need to have the file modified server side).
Does anyone have any idea?
Thank You
0
Answers
After Excel file is complited, try to open it "hidden" without GiveUseControl. Make formatting and send by e-mail.
Yury