Excel, Excel 2007, MS Office, Programming, Software

Skydrive Excel: Find Duplicates Between Two Columns

Find Duplicates in Excel
Find Duplicates in Excel

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. Continue reading “Skydrive Excel: Find Duplicates Between Two Columns”

.Net, ADO.NET, ASP.NET, C#, DB Connection Example, Example Connection, Excel, Excel 2003, Excel 2007, JavaScript, JQuery, Programming, Regular Expressions, Web Development

JQuery with ASP.NET: Save Copy / Paste Excel Data to a Database Table

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 use JavaScript/JQuery to get the Excel information from the user’s clipboard. You will need to use a different command to get the information depending on the user’s browser. In this example, I code specifically for Internet Explorer, but this is just since I am giving an example. In a real-world application you would code for all of the major browsers. Continue reading “JQuery with ASP.NET: Save Copy / Paste Excel Data to a Database Table”

.Net, ASP.NET, Excel, Excel 2003, Excel 2007, Excel 2010, IIS, IIS6, MS Office, Outlook, Security, Web Development, Web Server, WebForms

Configuring a Web Server to Allow Excel File Creation via the Interop.Excel Namespace

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 your Web server to allow Web users to trigger Excel on your Web server. This can mean some pretty drastic security changes and possible loopholes in your Web server’s security so you should do a risk analysis before choosing this method.

In this article I will review the Web server security updates that need to be made to allow using the Interop.Excel Namespace to generate Excel documents for your Web site.

Please note that since I am developing this site for an Intranet, I am not as concerned with locking down the server. If you are working with a server that is exposed to the Web then you will want to review these security changes much more thoroughly.

Continue reading “Configuring a Web Server to Allow Excel File Creation via the Interop.Excel Namespace”