Justin Cooney
Web Development Tips and Examples
Category: Excel 2007
-
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…
-
In an earlier article I covered how to generate Excel reports on the fly using the Interop.Excel Namespace. This is a really handy technique that also gives you full control over the minutia of the document you are creating. However the catch in using this technique is that you will need to update the configuration of…
Justin Cooney 