Excel Without Excel Buffer

tabularasa

Does anyone know how to create Excel File with multiple sheets and basic to advanced formatting, without using Excel Buffer with or without excel buffer add ons.

Slawek_Guzek

You have a few options: I am aware of two .NET libraries capable of writing files in Excel format directly: OpenXML by Microsoft, and ClosedXML - an OpenXML "wrapper", build to make manipulations easier. The third option is to use Excel directly, start the process on the client and 'talk' to it using .NET excel interop library, or old style Excel automation object.

How exactly - look into the Excel Buffer table code and steal some ideas from there, if you don't want to use built-in solution.

RockWithNAV

Automation is way more faster then Excel Buffer.

tabularasa

I was able to create multiple tabs and all data without using the excel buffer. The problem is in formatting. That´s were I gave up for now. We are solving this for now by creating the excel sheet and linking it from there to NAV.