MS Excel is a great tool that a lot of employees at a company are very familiar with using. It helps structure and organize data in a way that is very intuitive to users without the users needing to be especially technical. So it should come as no surprise that sometimes you will want to write code to interface with data from Excel. Continue reading “How to Loop Through an Excel Spreadsheet in a .NET Application”
ClosedXML Nicely Formatted Header Row
In this article I’ll show a simple example of nicely formatting a header row in a generated Excel document (using the open source ClosedXML library).
If you would first like some background into setting up and calling functions using .Net and the ClosedXML library, have a look at a previous article I wrote, or visit my site (jwcooney.com) and browse the available categories. Continue reading “ClosedXML Nicely Formatted Header Row”
Pivot a Row or Column of Data in Excel
Excel is a great tool for data manipulation. One feature that can come in handy is the ability to pivot a data row into a column or pivot data in a column of information into a row. Continue reading “Pivot a Row or Column of Data in Excel”