Yesterday, my friend asked me a question how to export data to excel with Multiple Sheets From Business Central SaaS. So I created a very easy sample code, and thought it would make sense to write a blog post to explain the code.
In this article, we will try to list down methods required to export data to excel using Excel Buffer.
For Demo, let’s assume we would like to Export data from Sales Header Table with associated Sales Line entries.
Note : The Function that is used to write data into excel buffer is AddColumn which requires following parameters –