create excel sheet on server without MS office

Question

User708331725 posted

 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

Answer 1

User312496708 posted

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.

Answer 2

User708331725 posted

 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.

You need ddls for using that assembly.

What is ddls?

Answer 3

User312496708 posted

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

Answer 4

User708331725 posted

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?