Justin Cooney
Web Development Tips and Examples
Category: MS Office
-
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…
-
There are some great ways to hunt down duplicate values in the desktop version of MS Excel. Today I will take a look at using the free online SkyDrive version of Excel that is integrated with Outlook.com to find duplicates between two columns.
-
Have you ever wanted to help your users move data from Excel to your Web application? In this article I will give an example in ASP.NET that takes copied Excel spreadsheet rows from the user’s clipboard and saves the information to a SQL Server database table. Since ASP.NET runs at the server level, you will need to…