How to use Microsoft Office Interop Excel on a machine without installed MS Office

Question

I m writing an application which works with excel files  I need a feature to delete a sheet  I have to use an assembly Microsoft Office Interop Excel dll   It s running fine on developer machine but when I try to deploy it on server I m getting an error      Could not load file or assembly  office  Version 14 0 0 0    Culture neutral  PublicKeyToken 71e9bce111e9429c  or one of its   dependencies   I understand that problem occurs when MS Office is not installed on a machine  Customer don t want to install and buy MS Office on a server not at any price   I install  Redistributable Primary Interop Assemblies  on developer machine as advised here  http   forums asp net t 1530230 aspx 1 and compile my project again   Code sample   public bool DeleteSheet string tableName        Excel Application app   null      Excel Workbooks wbks   null      Excel  Workbook  wbk   null      Excel Sheets shs   null       bool found   false       try               app   new Excel Application            app Visible   false          app DisplayAlerts   false          app AlertBeforeOverwriting   false           wbks   app Workbooks           wbk   wbks Add xlsfile           shs    wbk Sheets          int nSheets   shs Count           for  int i   1  i  lt   nSheets  i                          Excel  Worksheet  iSheet    Excel  Worksheet shs get Item i               if   iSheet Name    tableName                                 iSheet Delete                    found   true                   Marshal ReleaseComObject  iSheet                   break                            Marshal ReleaseComObject  iSheet                      if   found              throw new Exception string Format  Table    0    was t found   tableName              wbk SaveAs connect   wbk FileFormat  Missing Value  Missing Value  Missing Value          Missing Value  Microsoft Office Interop Excel XlSaveAsAccessMode xlNoChange          Missing Value  Missing Value  Missing Value  Missing Value  Missing Value             finally                wbk Close null  null  null           wbks Close            app Quit             Marshal ReleaseComObject shs           Marshal ReleaseComObject  wbk           Marshal ReleaseComObject wbks           Marshal ReleaseComObject app             return true      An exception     Retrieving the COM class factory for component with CLSID    00024500-0000-0000-C000-000000000046  failed due to the following   error  80040154 Class not registered  Exception from HRESULT    0x80040154  REGDB E CLASSNOTREG      occurs on the line   app   new Excel Application      Can anyone advise on how to get this feature working successfully

User · Accepted Answer

You can t use  Microsoft Office Interop Excel without having ms office installed    Just search in google for some libraries  which allows to modify xls or xlsx    http   code google com p excellibrary  http   simpleooxml codeplex com   only xlsx

User · Answer

Look for GSpread NET  You can work with Google Spreadsheets by using API from Microsoft Excel  You don t need to rewrite old code with the new Google API usage  Just add a few row   Set objExcel   CreateObject  GSpreadCOM Application     app MailLogon Name  ClientIdAndSecret  ScriptId     It s an OpenSource project and it doesn t require Office to be installed   The documentation available over here http   scand com products gspread index html

User · Answer

If the  Customer don t want to install and buy MS Office on a server not at any price   then you cannot use Excel     But I cannot get the trick  it s all about one basic Office licence which costs something like 150 USD     And I guess that spending time finding an alternative will cost by far more than this amount

User · Answer

you can create a service and generate excel on server and then allow clients download excel  cos buying excel license for 1000 ppl  it is better to have one license for server   hope that helps

[c#] How to use Microsoft.Office.Interop.Excel on a machine without installed MS Office?

Examples related to c#

Examples related to excel

Examples related to dll

Examples related to interop