Customize an Excel export?

This blog post shows how you might accomplish that in one step:

https://www.acumatica.com/blog/how-to-build-a-custom-excel-export-process/

This is really helpful, thanks… I knew I saw something somewhere about this which is what made me think it was possible.

Any thoughts on how a template for the other sheets (in our case basically an instruction and summary tab) might be implemented in an extensible way?

THANKS!

Alas, I haven’t explored how strong the integration to Excel is with that library. The big thing, in my mind, to make it extensible is to come up with a way that the template can store the instructions that the engine needs to follow. IOW, how will your engine know what data to put where?

If the Excel library isn’t able to leverage Excel’s internal logic for copying formulas across columns and down rows for you automatically, then you’ll have a lot or work to do. And if the library doesn’t do formatting (cell colouring, box lines, etc) then your outputs are going to be plain or constrained in terms of appearance.

I’m not sure if Velixo would be able to help you here but it’s worth taking a look at.

Edit: It looks like many formatting options are available