Dave Burke : Freelance .NET Web Developer specializing in Online Communities

Outputting [pretty data] to native Excel

This is one of those low-tech, high-banger hacks to pretty-up your ASP.NET data when outputting to Excel.  I posted darn-near a year ago on how easy ASP.NET makes it to output to native Excel. Consider this post as the 2005 enhanced version. 

I had to update an ASP page this morning (last-modified in 2001 for a, um, budget conscious client) which output data to Excel.  Working in ASP after four years is another story, but I won't bore you or myself with the painful details of that.  The point is that I wanted to purdy-up the output which is where I came up with my hack.

Take your output report (in Excel), format it the way you want it and save it to HTML.  Open the html file in Textpad (or whatever), copy the

Comments (2) | Post RSS RSS comment feed

Posted on 4/4/2005 4:20:00 AM by Dave Burke
Categories:
Tags:

Related posts

Comments (2) -

4/4/2005 10:40:34 AM Permalink

Very nice and a good tip.  So, you don't like working in ASP after being in .NET for  years?  It's not been that long for me but is still a struggle every time.

Erik Lane |

4/4/2005 10:49:13 AM Permalink

Erik, thanks for your comment.  I told the client it was take longer since it was in ASP, but I wasn't prepared for the time-consuming issues that came up, things that a simple compile with .NET runtime errors would have handled for me.  I don't try to think about how I could have done it better or more efficiently at this point, since its such a rare experience having to mess with ASP.  There are a lot of guys who work in ASP every day!  That's what amazes me.

daveburke |


Powered by BlogEngine.NET 2.0.0.36
Theme by Dave Burke