Hi,

I am creating a report on Asp.net 3.5/C#. This report shoule be in excel format with following considerations

• Excel is not installed on web server, so can not use COM object of excel.
  
• A report will consist of one file having multiple sheets, so can not generate HTML's table and output as excel (as normally we do).
• I think best way is to create excel report in XML. But really unable to find what should be header of file and how to decorate the text ?

Suggestions/Advices/Links are needed.

 Thank you all in anticipation.,

Waiting .......

Hi,

As you mentioned that you want to convert your EXCEL file to XML format, as far as I know, we cannot use general API to achieve that programmatically. But I’ve found some tools for you which relates to XML operations.

Excel XML Toolbox for Microsoft Office Excel (For 2003 only)

http://www.microsoft.com/downloads/details.aspx?familyid=e315c516-2c2c-4870-a189-d47a5d7ffeb3&displaylang=en

Besides, have you thought about using CSV format to stored the data instead?

Thanks.

Or another solution is to use some 3rd party library for writing Excel files.

I recommend you take a look at GemBox.Spreadsheet .NET Excel library and these two features:

• Import/export DataSet to Excel file - example
• Save Excel file to ASP.NET stream - web demo

Free version has some restrictions but you can use it freely in commercial apps.