create excel sheet on server without MS office RRS feed

  • Question

  • User708331725 posted


    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?




    Monday, September 7, 2009 3:01 AM

All replies

  • 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.

    Monday, September 7, 2009 4:38 AM
  • 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?

    Monday, September 7, 2009 4:44 AM
  • User312496708 posted

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

    Monday, September 7, 2009 9:17 PM
  • 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?

    Wednesday, September 9, 2009 4:41 AM