Using ClosedXML to create Excel files from a Database
- in C#
I was struggling to create an Excel file from a database table using OpenXML. OpenXML is fine if you need to build a file and save it to the hard drive. Also there was a…
Category: Excel
Looping Excel Macro to move contents of one cell to another
- in Excel
I had to send some data to a vendor for my job in an Excel spreadsheet. When I created the spreadsheet from the data some of the columns were shifted and things didn’t line up…