c# - Excel exception HRESULT: 0x800A03EC from ChartArea.Copy() -

-

i'm working on c# application thats interacts excel instance using excel interop.dll v11.0. i'm using following code copy chart excel worksheet clipboard:

public image readchart(chart chartaccess) {     try {         microsoft.office.interop.excel.worksheet sheet = workbook.sheets[chartaccess.sheet.name];         microsoft.office.interop.excel.chartobject chart = sheet.chartobjects(chartaccess.name);         chart.chart.chartarea.copy();  // exception gets thrown here          return system.windows.forms.clipboard.getimage();     } catch (comexception) {         // display error dialog etc...     }

this worked fine excel 2007. since switching excel 2013 function chartarea.copy() results in following comexceptions being thrown:

message:      "dimension not valid chart type" stack trace:  system.runtimetype.forwardcalltoinvokemember(string membername, bindingflags flags, object target, int32[] awrappertypes, messagedata& msgdata)               microsoft.office.interop.excel.chartarea.copy()  message:      "hresult: 0x800a03ec" stack trace:  system.runtimetype.forwardcalltoinvokemember(string membername, bindingflags flags, object target, int32[] awrappertypes, messagedata& msgdata)               microsoft.office.interop.excel.chartarea.copy()

this happens excel sheets of old .xls format, xlsm / xlsx files work fine. using newer versions of interop.dll (v14.0 , v15.0) didn't help.

any appreciated!

edit:

i resolved problem using following workaround: 

// ... chart.chart.activate(); chart.chart.export(filename, "png", false); using (stream reader = file.openread(filename)) {     image = image.fromstream(stream); } return image;

the documentation copy shows there difference between versions 2003 , 2010.

2003:

void copy(     [in, optional] object before,      [in, optional] object after );

2010:

void copy(     object before,     object after )

as can see, arguments optional in 2003, , mandatory in later version.


Comments

Post a Comment

Popular posts from this blog

How to run C# code using mono without Xamarin in Android? -

-
i want create program uses mono runtime run c# code (binary not application). i copied libmono.so unity app , i'm write code using documentation: http://www.mono-project.com/docs/advanced/embedding/ and it's working have problems references can access classes mscorlib.dll , have problems system.reflection.assembly class throwing exception, when print console see: system.missingmethodexception: method not found: 'system.reflection.assembly.op_inequality' can fix it? can use mono runtime in c binary on android? ps. i'm using android tests. edit: found solution loading libraries, need set environment variable mono_path libraries path. but have still problems assembly class. the system.missingmethodexception error have seems .net profile mismatch error, 1 explained here . can use mono runtime in c binary on android? yes, using ndk guess. there alternatives can use instead of rolling own, such xmadevlab .
Read more

html - grunt SVG to webfont -

-
i'm trying generate webfont svgs using grunt-webfont . the issue need task valid on windows , linux machines. in order achieve need use node engines doesn’t work svg files . i know if there way convert svgs proper svg format supported grunt plugin or alternatively there better grunt plugin/s achieve this i have task able take svgs (created in illustrator) , output webfont files (.eot,.svg,.svg,...) , css file (like icomoon export) thanks. perhaps artboard small. recommend checking have 512pt x 512pt artboard each icon. stumbled upon gem ( https://www.fourdigits.nl/blog/using-a-webfont-to-display-icons ) when grunt-webfont documentation left me alone in forest.
Read more

python - Specify path of savefig with pylab or matplotlib -

-
i struggling on how find correct way specify save path (or repository) when calling function savefig in matplotlib or pylab. i tried several syntaxes, everytime python console returns : filenotfounderror: [errno 2] no such file or directory: '../mydocs/resource/frames/myimage.png' currently, have written following : pylab.savefig('../mydocs/resource/frames/myimage.png') does know how it? thanks in advance! the tilde operator , variable $home entered strings , therefore not function while saving. have provide either relative path (as did) or provide full path. eg. pylab.savefig("/home/username/desktop/myfig.png") .
Read more