Create nicely formatted excel files in ASP.net without having Excel on the server
Generating normal columnar data in an excel file is pretty straightforward, but any of you have created excel files having data in different blocks, laid out on different sheets and formatted perfectly without having to manipulate the excel file using COM [which I want to avoid]. Any ideas would be really helpful.
The excel output file must be compatible with Office 2003 + office 2007
a source to share
Not sure exactly (how I installed Excel on both my dev and server machines), but I think ExcelPackage can do the trick.
a source to share
If you don't create many spreadsheets, or don't want to buy a product that makes it easier, your solution might be to use templates.
Create an excel document in the style you want and then save it as xml. Then modify the XML document to your liking, using place holders or whatever, to create your documents.
This works for simple reports where you don't want to use a third party product. For whatever it is, I would recommend a product that specializes in this.
a source to share