MS Office – Page 2 – Justin Cooney

.Net, ASP.NET, Excel, HTML, MS Office, Programming, Software, Technology, Tool, VB.NET, Web Development, WebForms

ClosedXML Nicely Formatted Header Row

2016-10-092016-10-09 Justin Cooney

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” →

Excel, Excel 2003, Excel 2007, Excel 2010, MS Office, Programming, Software, Tool

Pivot a Row or Column of Data in Excel

2016-01-20 Justin Cooney

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” →

.Net, ASP.NET, DataTable, Excel, Excel 2003, Excel 2007, Excel 2010, MS Office, Programming, Software, VB.NET, Web Development, WebForms

Using ClosedXML.Excel with ASP.NET to Generate Excel Documents on the Fly

2015-10-082016-10-09 Justin Cooney

I’ve been playing around with the ClosedXML.Excel library for creating or reading MS Excel documents in your ASP.NET code. Bottom line is that this tool is going to save you a lot of time:

In simplifying your task of putting the Workbook and Worksheets together
and I can’t stress enough how much time this will save you from trying to re-jig your Web server to serve Excel documents using the Microsoft.Office.Interop.Excel library.

Continue reading “Using ClosedXML.Excel with ASP.NET to Generate Excel Documents on the Fly” →