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: Microsoft Office
Restrict Styles In a Word Document
- in Microsoft Office
Restrict styles in a Word Document Background: I need to restrict styles in a Word Document. There are various reasons one might want to do this. One for me was we needed to set up…
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…