Justin Cooney

Web Development Tips and Examples

recent posts

about

I am a Senior Applications Programmer / Analyst with years of experience developing enterprise solutions using the Microsoft technology stack including C#, VB.NET, ASP.NET, AJAX, IIS and SQL Server. I specialize in Web application development with a focus on building secure systems, integrating applications, and designing robust database structures.

Category: Excel 2007

  • ASP.NET – Generating an Excel Report on the Fly Using the Interop.Excel Namespace

    As a developer, a commonly requested feature is the ability to export data from the Web into MS Excel. Choosing the best way to export your data from an ASP.NET Web page to Excel for your users is never an easy task. There are several ways to generate your reports, with each way having its pros…

  • SQL OpenRowSet Excel Query Returns Null Values

    In an earlier article I reviewed how to query an Excel spreadsheet from SQL Server Management Studio (SSMS). I’ve found that this functionality is very useful, especially when working with data maintained by business users outside of a database system. For an overview of how to connect SSMS with an Excel WorkSheet, please see my detailed article covering…

  • Generating Excel documents through HTML, XML, and CSS – Part 2

    Overview: The latest versions of Excel (2007, 2010) differ from Excel 2003 in their support of streaming a HTML document containing Excel-specific markup. Although core markup features still work, some of the previously supported functionality has now been removed. This directly affects the ability in code to stream a table to Excel and then use MSO…