c# - Unable to write to or read from Worksheet.CustomProperties in a console application -


in console application, trying write , read customproperties of excel worksheet. have reference microsoft.office.interop.excel v14 assembly.

at line calls firstworksheet.customproperties.add method, exception hresult 0x800a03ec.

below relevant bit of code:

static void writetoexcelcustomdocumentproperties(     string excelfile,     string outputfolder,     string propertyname,      object propertyvalue) {     excel::application excel = null;     workbook workbook = null;     worksheet firstworksheet = null;      try     {         excel = new excel::application();          workbook = excel.workbooks.open(excelfile);          firstworksheet = workbook.worksheets[1] worksheet;          firstworksheet.customproperties.add(propertyname, propertyvalue);          var outputfilepath = getoutputfilepath(excelfile, outputfolder);          workbook.saveas(outputfilepath);     }     catch(exception ex)     {         console.writeline("\nerror:");         console.writeline($"{excelfile}!{firstworksheet.name}");         console.writeline($"{ex.message}\n");     }         {         if (workbook != null)             workbook.close();          if (excel != null)             excel.quit();     } }

and below error receive:

{"exception hresult: 0x800a03ec"}     data: {system.collections.listdictionaryinternal}     errorcode: -2146827284     hresult: -2146827284     helplink: null     ipforwatsonbuckets: 0x7177fe49     innerexception: null     istransient: false     message: "exception hresult: 0x800a03ec"     remotestacktrace: null     source: ""     stacktrace: "   @ system.runtimetype.forwardcalltoinvokemember(string membername, bindingflags flags, object target, int32[] awrappertypes, messagedata& msgdata)\r\n   @ microsoft.office.interop.excel.customproperties.add(string name, object value)\r\n   @ customdocumentproperties.program.writetoexcelcustomdocumentproperties(string excelfile, string outputfolder, string propertyname, object propertyvalue) in c:\\sathyaish\\dotnet\\customdocumentproperties\\customdocumentproperties\\program.cs:line 61"     targetsite: {system.object forwardcalltoinvokemember(system.string, system.reflection.bindingflags, system.object, int32[], system.runtime.remoting.proxies.messagedata byref)}     watsonbuckets: null     _hresult: -2146827284     _classname: null     _data: {system.collections.listdictionaryinternal}     _dynamicmethods: null     _exceptionmethod: {system.object forwardcalltoinvokemember(system.string, system.reflection.bindingflags, system.object, int32[], system.runtime.remoting.proxies.messagedata byref)}     _exceptionmethodstring: null     _helpurl: null     _innerexception: null     _ipforwatsonbuckets: 0x7177fe49     _message: "exception hresult: 0x800a03ec"     _remotestackindex: 0     _remotestacktracestring: null     _safeserializationmanager: {system.runtime.serialization.safeserializationmanager}     _source: ""     _stacktrace: {sbyte[96]}     _stacktracestring: null     _watsonbuckets: null     _xcode: -532462766     _xptrs: 0x00000000

and if try read information using code listed below, exception follows code listing.

static object readfromexcelcustomdocumentproperties(     string excelfile,      string propertyname) {     excel::application excel = null;     workbook workbook = null;     worksheet firstworksheet = null;     object value = null;      try     {         excel = new excel::application();          workbook = excel.workbooks.open(excelfile);          firstworksheet = workbook.worksheets[1] worksheet;          value = firstworksheet.customproperties[(object)propertyname].value;     }     catch (exception ex)     {         console.writeline($"\nerror in {nameof(readfromexcelcustomdocumentproperties)}:");         console.writeline($"{excelfile}!{firstworksheet.name}");         console.writeline($"{ex.message}\n");     }         {         if (workbook != null)             workbook.close();          if (excel != null)             excel.quit();     }      return value; }

gives me following error:

enter image description here

below dump of exception class object.

{"type mismatch. (exception hresult: 0x80020005 (disp_e_typemismatch))"}     data: {system.collections.listdictionaryinternal}     errorcode: -2147352571     hresult: -2147352571     helplink: null     ipforwatsonbuckets: 0x7177fe49     innerexception: null     istransient: false     message: "type mismatch. (exception hresult: 0x80020005 (disp_e_typemismatch))"     remotestacktrace: null     source: ""     stacktrace: "   @ system.runtimetype.forwardcalltoinvokemember(string membername, bindingflags flags, object target, int32[] awrappertypes, messagedata& msgdata)\r\n   @ microsoft.office.interop.excel.customproperties.get__default(object index)\r\n   @ customdocumentproperties.program.readfromexcelcustomdocumentproperties(string excelfile, string propertyname) in c:\\sathyaish\\dotnet\\customdocumentproperties\\customdocumentproperties\\program.cs:line 131"     targetsite: {system.object forwardcalltoinvokemember(system.string, system.reflection.bindingflags, system.object, int32[], system.runtime.remoting.proxies.messagedata byref)}     watsonbuckets: null     _hresult: -2147352571     _classname: null     _data: {system.collections.listdictionaryinternal}     _dynamicmethods: null     _exceptionmethod: {system.object forwardcalltoinvokemember(system.string, system.reflection.bindingflags, system.object, int32[], system.runtime.remoting.proxies.messagedata byref)}     _exceptionmethodstring: null     _helpurl: null     _innerexception: null     _ipforwatsonbuckets: 0x7177fe49     _message: "type mismatch. (exception hresult: 0x80020005 (disp_e_typemismatch))"     _remotestackindex: 0     _remotestacktracestring: null     _safeserializationmanager: {system.runtime.serialization.safeserializationmanager}     _source: ""     _stacktrace: {sbyte[96]}     _stacktracestring: null     _watsonbuckets: null     _xcode: -532462766     _xptrs: 0x00000000

it appears this answer above observed behavior may attributed bug in interop assemblies.

however, this answer seems suggest poster has been able run code successfully.

are able run code successfully? have seen error , know fix?

it's possible don't know mean custom properties, if referring properties file->info section in excel:

enter image description here

like come sharepoint, access them using contenttypeproperties collection of workbook object.

here example of how access them in image above:

// excel.workbook wb;  string dmdregion = wb.contenttypeproperties["demand region"].value.tostring(); wb.contenttypeproperties["demand region"].value = "emea";

your example showed worksheet object, again, may have totally missed boat.


Comments

Post a Comment

Popular posts from this blog

Sort a complex associative array in PHP -

this question has answer here: php sort array subarray value 5 answers i have associative array in php like: $newarray1 = array ( [producta] => array ( [link] => http://sanjosespartan.com/blog/products/agile-java-development/ [visitcount] => 4 ) [productd] => array ( [link] => http://sanjosespartan.com/blog/products/intro-to-go/ [visitcount] => 1 ) [productg] => array ( [link] => http://sanjosespartan.com/blog/products/node-js-for-developers/ [visitcount] => 1 ) [productb] => array ( [link] => http://sanjosespartan.com/blog/products/beginning-mysql/ [visitcount] => 1 ) [productc] => array ( [link] => http://sanjosespartan.com/blog/products/computer-networks/ [visitcount] => 1 ) ...
Read more

vb.net - How to ignore if a cell is empty nothing -

how use roscolor() ignore value (like empty cell) ? color row if value upper 5 when there nothing in cell, want ignore roscolor() apply, how? public sub roscolor() integer = 0 quotedatagridview1.rows.count() - 1 step +1 dim val integer val = quotedatagridview1.rows(i).cells(3).value if val = vbempty quotedatagridview1.rows(i).defaultcellstyle.backcolor = color.white elseif val < 5 quotedatagridview1.rows(i).defaultcellstyle.backcolor = color.red elseif val > 5 , val < 10 quotedatagridview1.rows(i).defaultcellstyle.backcolor = color.lightyellow end if next end sub you can check empty value following public sub roscolor() integer = 0 quotedatagridview1.rows.count() - 1 step +1 dim val = quotedatagridview1.rows(i).cells(3).value if isdbnull(val) or val nothing quotedatagridview1.rows(i).defaultcellstyle.backcolor = color.white ...
Read more

recursion - Can every recursive algorithm be improved with dynamic programming? -

i first year undergraduate csc student looking competitive programming. recursion involves defining , solving sub problems. understand, top down dynamic programming (dp) involves memoizing solutions sub problems reduce time complexity of algorithm. can top down dp used improve efficiency of every recursive algorithm overlapping sub problems? dp fail work , how can identify this? the short answer is: yes. however, there constraints. obvious 1 recursive calls must overlap. i.e. during execution of algorithm, recursive function must called multiple times same parameters. lets truncate recursion tree memoization. can use memoization reduce number of calls. however, reduction of calls comes price. need store results somewhere. next obvious constraint need have enough memory. comes not-so obvious constraint. memory access requires time. first need find result stored , maybe copy location. in cases, might faster let recursion calculate result instead of loading somewher...
Read more