excel & charts (retrieving all chart-values automatically)
I have the following problem:
We have to create excel charts automatically, based on some "templates" made
by the user, who has the possibility to define how some charts should look
like.
I want to open the template automatically, read all properties of the
existing chart-objects and recreate them based on some new data fetched from
a webservice; especially based on one chart I have to create let's say 100
similar charts with other data.
But I cannot manage to read all properties of an excel-chart automatically
without fetching each property explicitely. If I could do so, I could save
all the chart's properties in an XML-file and assign these properties again
when creating the new charts == I even cannot manage to assign all
properties automatically, how is this done??
Thanks in advance
Greetings
Stefan
|