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


I need a feature I am writing an application that works with Excel files I remove a sheet . . I'm having right

Developer machine to use an assembly Microsoft.Office.Interop.Excel.dll, but to deploy the server when I try I'm getting an error:

could not load file or assembly work, version = 14.0.0.0, Culture = neutral, PublicKeyToken = 71e9bce111e9429c 'or one of its dependencies

I think The problem that occurs when the MS Office is not installed on the machine and the customer is not installed I do not want to buy MS Office at a price at any cost.

As suggested here I installed "Redistribution primary interop gatherings" on the developer machine. And re-compile my project

Code sample: 

  public bool DeleteSheet (string Talikanam) {Excel.Application app = null; Excel Workbooks wbks = null; Excel._Workbook _wbk = null; Excel.Sheets shs = null; Bull got = wrong; {App = New Excel.Application (try); App View = false; App DisplayLetter = False; App.AlertBeforeOverwriting = false; Wbks = app.Workbooks; _wbk = wbks.Add (xlsfile); Shs = _wbk.Sheets; Int nSheets = shs.Count; {Excel._Worksheet _iSheet = (Excel._Worksheet) shs.get_Item (i) for (Int i = 1; I & lt; = nSheets; i ++); If (_iSheet.Name == table name) {_iSheet.Delete (); Found = true; Marshal.ReleaseComObject (_iSheet); break; } Marshal. Release Com Object (_iSheet); } If ((found!) New exception throw (string.format ("table \" {0} \ "not found", tagname)); _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 (empty, null, void); Wbks.Close (); App.Quit (); Marshal.ReleaseComObject (SHS); Marshal.ReleaseComObject (_wbk); Marshal.ReleaseComObject (wbks); Marshal.ReleaseComObject (app); } Back true; }   
 exception  
 
 CLSID is gaining COM class factory for component with {00024500-0000-0000-C000-000000000046} following error Failed due to: 80040154 class not registered (Exception from HRESULT: 0x80040154 (REGDB_E_CLASSNOTREG))   
 on line  
  application = new Excel.Application ();   
 Can anyone give any advice about this feature to work successfully?   
 
 
 You can not use Microsoft Office.  
  
  •  (only xlsx)      
     ul>  

     

    •

    Comments

    Post a Comment

    Popular posts from this blog

    java - NullPointerException for a 2d Array -

    नक्शा = नया बफर्ड इमेज [चौड़ाई] [ऊंचाई]; के लिए (int i = 0; i & lt; height; i ++) {for (int j = 0; j & lt; चौड़ाई; j ++) {if (charMap [j] [i] == पर्वत। इंडेंटफार्म) {if (j + 1 & lt ; चौड़ाई और amp; amp; j-1 & gt; = 0) {if (charMap [j-1] [i]! = पर्वत। इंडेंटिफ़ायर & amp; amp; & amp; amp; charMap [j + 1] [i]! = पर्वत। इंडेंटफार्म) {नक्शा [जे] [आई] = टाइल ग्रिड [1] [10]; }} और {नक्शा [जे] [आई] = टाइल ग्रिड [8] [10]; }}} यह कोड है जिसे मैं सेल के चारों ओर प्रत्येक टाइल को चेक करके 2 डी सर की जांच करने के लिए उपयोग कर रहा हूं लेकिन मुझे लगता है कि किसी को भी सोच रहा हूँ मदद कर सकता है? मुझे संदेह है कि आपको NullPointerException को charMap [j] से प्राप्त हो रहा है [ I] == पर्वत। इंडेंटिफ़ायर लाइन। सुनिश्चित करें कि आप ज्योफ द्वारा सुझाए गए दोनों मानचित्रों के लिए आंतरिक सरणियों को प्रारंभ करते हैं।
    Read more

    python - Assemble mpeg file unable to play in mediaplayer -

    I am currently working on a school project and I think that is to gather some problems with the MPEG file I The scope of my project is: 1) Split the MPEG file into pieces of many fixed sizes. 2) Collecting some of them and leaving some part. Problem 1: When I run the file in the media player, it will play the video until it reaches that segment which I left Give it Example: Chunk = ["yui_1", "yui_2", "yui_3", "yui_5", "yui_6"] Duration of each segment: 1 second * If you think I have left the "yui_4" section. * If I went to collect all the parts except "yui_4", then the video will play the first 2 seconds before being hanged throughout the period. Problem 2: When I gather the first part off the part, it is unable to run the full MPEG file is. Duration of each piece: 1 second Example: wheel = ["yui_2", "yui_3", "yui_4", "yui_5", "yui_6"...
    Read more

    c# - NameSpace Manager or XsltContent to parse aspx page -

    How can I use the namespace manager or XSLT content to parse the aspx page? I am using HtmlAgilityPack I am trying to parse the aspx page to get the button and label control ID. When I try to select a node with the asp: button element, I get the following error Here is the error message: Namespace Manager or XsltContext is required This query contains a prefix, variable, or user-defined function. HtmlAgilityPack.HtmlDocument htmldoc = new HtmlAgilityPack.HtmlDocument (); String filePath = @ "C: \ webform4.aspx"; Htmldoc.load (filepath); Foreach (html.doc.DocumentNode.SelectNodes ("// div") in HtmlNode div) {Response.Write (div.Id); HtmlNode ASP ("asp: button") in foreach (div.SelectNodes) {Response.Write (asp.Id); }} My aspx page looks like: & lt;% @page language = "c #" autoevolutionwireup = "true" codebahind = "Webform 4 Aspx.cs" Inheritance = "WebApplication 1.WebForm4"%> & Lt ;...
    Read more