SBX - Search With Button

SBX - Forum Post Title

Can We use Excel Buffer Table in Business Central of Cloud Version(SaaS).?

Dynamics 365 Business Central Forum

Manikanta Adabala asked a question on 12 Jun 2019 7:58 AM

Question Status

Suggested Answer

Can We use Excel Buffer Table in Business Central of Cloud Version(SaaS) .?

Reply
Teddy Herryanto responded on 12 Jun 2019 3:16 PM
My Badges
Suggested Answer

I don't see why not. Did you encounter any issue ?

Reply
Suggested Answer

On SaaS you need to use the Excel Buffer functions based on Stream:

UploadIntoStream

SelectSheetsNameStream

OpenBookStream

Reply
Manikanta Adabala responded on 12 Jun 2019 11:44 PM

Actually I wrote code like below in my Report.

I am getting error "The type or method 'CreateBookAndOpenExcel' cannot be used for 'Extension' development and 'Record "Excel Buffer"' does not contain a definition for 'GiveUserControl'"..

Could you please suggest me the the Solution to this problem , If it's Possible please Write Acceptable code for my code.

Thanks in Advance.

Reply
Teddy Herryanto responded on 13 Jun 2019 3:27 PM
My Badges
Suggested Answer

Since we are dealing with cloud, you need to use OpenBookStream, UpdateBookStream, etc.

Reply
Manikanta Adabala responded on 13 Jun 2019 11:46 PM

Can you give me Example for Below code (in SaaS)

   procedure CreateExcelbook()

   var

   begin

       ExcelBuf.CreateBookAndOpenExcel('', 'Shipment Statistics', '', COMPANYNAME, USERID);

   end;

In This Code I want to create and open Excel Sheet , can you give me example , how to write code for create and open a excel sheet in Cloud version(SaaS).

Reply
Teddy Herryanto responded on 12 Jun 2019 3:16 PM
My Badges
Suggested Answer

I don't see why not. Did you encounter any issue ?

Reply
Suggested Answer

On SaaS you need to use the Excel Buffer functions based on Stream:

UploadIntoStream

SelectSheetsNameStream

OpenBookStream

Reply
Teddy Herryanto responded on 13 Jun 2019 3:27 PM
My Badges
Suggested Answer

Since we are dealing with cloud, you need to use OpenBookStream, UpdateBookStream, etc.

Reply

SBX - Two Col Forum

SBX - Migrated JS