web
You’re offline. This is a read only version of the page.
close
Skip to main content

Announcements

No record found.

News and Announcements icon
Community site session details

Community site session details

Session Id :
Dynamics 365 Community / Forums / Business Central forum / Can We use Excel Buffe...
Business Central forum

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

(0) ShareShare
ReportReport
Posted on by Manikanta_501 245

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

Categories:
Inventory and warehouse management
Business Central
Purchasing
Other
Web and mobile experience
I have the same question (0)
  • Suggested answer
    Teddy Herryanto (That NAV Guy) Profile Picture
    Teddy Herryanto (Th... 14,306 Super User 2026 Season 1 on at

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

  • Suggested answer
    Stefano Demiliani Profile Picture
    Stefano Demiliani 37,166 Most Valuable Professional on at

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

    UploadIntoStream

    SelectSheetsNameStream

    OpenBookStream

  • Manikanta_501 Profile Picture
    Manikanta_501 245 on at

    Actually I wrote code like below in my Report.

    Excelbuff.PNG

    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.

  • Suggested answer
    Teddy Herryanto (That NAV Guy) Profile Picture
    Teddy Herryanto (Th... 14,306 Super User 2026 Season 1 on at

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

  • Manikanta_501 Profile Picture
    Manikanta_501 245 on at

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

  • Community Member Profile Picture
    Community Member on at

    Hi Stefano Demiliani, Im new on Business Central, do you have an example of how to read an excel file? it would be very helpful

  • Alexey Finogenov Profile Picture
    Alexey Finogenov 1,659 on at

    maybe useful.. I've created such example huge (we are running so fast... that time is fast too) time ago.. may be still actual

    github.com/.../ALF-Export-Setup-Tabs-to-Excel

    Alexey

  • MiguelCradoso Profile Picture
    MiguelCradoso 5 on at

    Hello

    they could give me an idea of how to read a .*.xls extension file, because when I want to read it sends me error the codes of the ExcelBuffer table. Microsoft.Dynamics.Nav.OpenXml.Spreadsheet.WorkbookReader.

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

November Spotlight Star - Khushbu Rajvi

Congratulations to a top community star!

Forum Structure Changes Coming on 11/8!

In our never-ending quest to help the Dynamics 365 Community members get answers faster …

Dynamics 365 Community Platform update – Oct 28

Welcome to the next edition of the Community Platform Update. This is a status …

Leaderboard > Business Central

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans