c# - Error while saving the workbook : System.Runtime.InteropServices.COMException: Exception from HRESULT: 0x800A03EC -

-

i creating excel file asp.net application. hosting site on iis7.

when run server, giving error while saving workbook.

my code

workbook.saveas(server.mappath("folder") + "\\" + filename + ".xls" , excel.xlfileformat.xlhtml, objopt, objopt, false, false ,excel.xlsaveasaccessmode.xlshared, false, false, objopt, objopt);

i have been trying solve week. hope ll find here

this error

system.runtime.interopservices.comexception: exception hresult: 0x800a03ec

i using office 2000,iis7. have set authorizations. suggestions highly appreciated.

interop not supported in sever-scenarios (like iis) ms.

there many options read/edit/create excel files without interop/installing excel on server:

ms provides free openxml sdk v 2.0 - see http://msdn.microsoft.com/en-us/library/bb448854%28office.14%29.aspx (xlsx only)

this can read+write ms office files (including excel).

another free option see http://www.codeproject.com/kb/office/openxml.aspx (xlsx only)

if need more handling older excel versions (like xls, not xlsx), rendering, creating pdfs, formulas etc. there different free , commercial libraries closedxml (free, xlsx only), epplus (free, xlsx only), aspose.cells, spreadsheetgear, libxl , flexcel etc.


Comments

Post a Comment

Popular posts from this blog

c# - how to write client side events functions for the combobox items -

-
<dx:aspxcombobox id="aspxcombobox2" runat="server" clientidmode="autoid" selectedindex="-1" onselectedindexchanged="aspxcombobox1_selectedindexchanged1" > <clientsideevents selectedindexchanged="function(s, e) { grid.selectrows();}" /> <items> <dx:listedititem text="selecte rows" /> <dx:listedititem text="unselectall" /> </items> </dx:aspxcombobox> i want write event "unselect all" item in combobox. how can this? you'll need write javascript function iterates thru combo-box , marks selected items false. see select/unselect checkbox fields using pure javascript , html sample code msdn:
Read more

exception - Python, pyPdf OCR error: pyPdf.utils.PdfReadError: EOF marker not found -

-
pypdf throws exception: pypdf.utils.pdfreaderror: eof marker not found i don't need fix pypdf, need eof error cause "except" block execute , skip on file, doesn't work. still causes program stop running. background: batch ocr program pdfs python, pypdf, adobe pdf ocr error: unsupported filter /lzwdecode ... saga continues. i got 10,000 pdfs in folder. ocrd, not. can't tell 'em apart. step 1 figure out ones not ocrd , ocr (see other threads details). so i'm using pypdf. exceptions related unrecognized characters , unsupported filters when try read text. guestimated if throws exception, it's got text in , doens't go in list. problem solved, right? so: pypdf import pdffilewriter, pdffilereader import sys, os, pypdf, re path = 'c:\users\homer\documents\my pdfs' filelist = os.listdir(path) has_text_list = [] does_not_have_text_list = [] pdf_name in filelist: pdf_file
Read more