How many times have you developed a web-application that requires user to be able to get their data out of your nice, clean, rich web application into an Excel sheet. I know I have more than one time. However either you need to invest in some 3rd party library that is way past the stage where you would scream “feature creep” or it will require your web-server to have MS Office installed locally and furthermore require you to have a reference to System.Windows.Forms (in your nice clean web-app).
Well, some maybe, can live with this, but there is actually a very simple way to make Excel “eat” your data. Only one small problem – it is only supported as of Office 2003.
It is of course the XML format – easy to understand, easy to develop. However a wrapper onto of this format can be a little nice. Therefor: introducing Veggerby.Excel (version 0.1.0).
Current feature list includes:
- Basic styling
- Formulas with easy to use referencing (not requiring absolute referencing)
- Cell merging
- And some others…
Check it out and read (a little) more here: Veggerby.Excel
