hello

We are using Windows server edition 2003 standard edition on server and it does not have MS office installed. In my application I need to create report in excel. I used assembly, Microsoft.Office.Interop.Excel but this is not recognised on the server. Is there any way to create excel sheet without installing MS office on server?

Regards,

Puneri

You need ddls for using that assembly. What you can do is format the data in XML or csv and save in the server. Excell can easily open these format and show the data.

 Excel sheet has very complex format and it is not possible to use XML or csv. From using 3-4 different tables to populate the excel sheet.

vik20000in:

You need ddls for using that assembly.

What is ddls?

sorry I meant dll's It was a bad typo.

just found out including dll also does not work... http://forums.asp.net/t/1124743.aspx and http://forums.asp.net/t/1022102.aspx (last post by gsbell) any other way to create excel sheet?