A week ago, my friend Daniel asked a question on Twitter how to use the Excel Buffer to export data with Business Central online. Many functions on the Excel Buffer are only available for on-prem. When you change the target in app.json to ‘Cloud’ then those functions become unavailable.
Luckily I had a code example available so I decided to put that on GitHub. But I thought it would make sense to write a blog post to explain the code.