CreateBookAndOpenExcel function in DBC 365

rnjbng

Hi Folks -

The function CreateBookAndOpenExcel is not supported in Extension development. Does anyone know any alternative solution for this issue. Many Thanks for your help.

local procedure CreateExcelbook();
begin
ExcelBuf.CreateBookAndOpenExcel('',Text012,'',COMPANYNAME,USERID);
ERROR('');
end;

ERROR
The type or method 'CreateBookAndOpenExcel' cannot be used for 'Extension' development.

Thanks
RJ.

binesh

//Create a Procedure CreateExcelBook()

//In this function again call the standard functions from table 370 as shown below.

local procedure CreateExcelBook()
begin
TempExcelBuffer.CreateNewBook('Customers');
TempExcelBuffer.WriteSheet('Customers', CompanyName(), UserId());
TempExcelBuffer.CloseBook();
TempExcelBuffer.OpenExcel();
end;

//Note: for full code see in the bottom i have attached a report for exporting.
Screenshot taken from mobile so please zoom In for better view.

rnjbng

Many Thanks Binesh, this is very helpful.