Autofit with Excel Buffer and sending as attachment via Mail

(0) Share

Report

Posted on by Community Member

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 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

*This post is locked for comments

I have the same question (0)

All responses (6)

Answers (0)

Suggested answer

Andrey Baludin 3,941 on at

Like (1)

Report

Hi! In 2016 version there is an AutoFit function directly in Excel buffer Table.

Works like ExcelBuffer.AutoFit('A:Z');

Please, check it in 2015.

Was this reply helpful? Yes No
Community Member on at

Like (0)

Report

Thank you, there is an Autofit function even in 2015, XlHelper.AutoFitRangeColumns(XlWrkBk,ActiveSheetName,RangeName);

But I have to pass XlWrkBk that is not initialized, I don't know how...

Was this reply helpful? Yes No
Suggested answer

Andrey Baludin 3,941 on at

Like (0)

Report

Try next:

TempExcelBuffer.CreateBook(Title);

TempExcelBuffer.WriteSheet(Title,COMPANYNAME,USERID);

TempExcelBuffer.PostOpenExcel;

TempExcelBuffer.CloseBook;

Was this reply helpful? Yes No
Community Member on at

Like (0)

Report

It pops this error with this code:

An instance of a DOTNET variable has not been created. Attempt to call microsoft.office.interop.Excel.ApplicationClass.ActiveWorkbook in table excel buffer: PostOpenExcel

Was this reply helpful? Yes No
Suggested answer

Andrey Baludin 3,941 on at

Like (0)

Report

I've made small experiment and autofit works in it without additional initialization:

Was this reply helpful? Yes No
Suggested answer

4BzSoftware 6,073 on at

Like (0)

Report

Hi Denis R.,

If you need to modify the file at Server Side, you have to install Excel for the Server.

Was this reply helpful? Yes No