Dave Ballantyne has put together a Biml script to create complex Excel spreadsheets from data sets:
Anyway, i’ve combined these two pain points to create a BIML routine that uses EPPlus to output multi-sheeted Excel spreadsheet reliably and fast.
At the moment its very basic , take SQL statements and output the data to an excel file, but in time i will be hoping to create some meta data to start ‘getting the crayons out’ and making them look a bit more pretty.
Check out his GitHub repo for more details.