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 Office 2003 + office 2007
Check spread sheet gear, with the help of spread sheet gear I have created excel with very good formating as well
Don't know exactly (as I've Excel installed on both my dev and server machines) but I think ExcelPackage can do the trick.
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 output to html and use css for formatting: http://stackoverflow.com/questions/440892/how-to-output-an-excel-xls-file-from-classic-asp