generating nicely formatted excel files in ASP.net without having Excel on server

Generating normal columnar data in excel file is quite easy but does any one of you have generated excel files having datas in different blocks placed in different sheets and beautifully formatted without having to manipulate the excel file using COM [which i want to avoid]. Any ideas would be really helpful.

The output excel file should be compatible with Of开发者_如何转开发fice 2003 + office 2007

Don't know exactly (as I've Excel installed on both my dev and server machines) but I think ExcelPackage can do the trick.

Check spread sheet gear, with the help of spread sheet gear I have created excel with very good formating as well

http://www.spreadsheetgear.com/

If you're not creating many spreadsheets, or don't wish to buy a product which makes this easier, your solution might be to use templates.

Create a excel document, in the style you want, then save it as xml. Then modify the xml document as you like, using place holders or whatever, to generate your documents.

This works for simple reports where you don't want to use a 3rd party product. For anything else I'd recommend a product specializing in this.

You can check SmartXLS for .net.