Export excel charts in asp.net pages

Question

0.00/5 (No votes)

See more:

Hi All,

I need to retrieve data and characteristics (axis, legends, etc. series etc.) from hundreds of graphs from different excel files, store everything in a database, and then show these graphs in asp.net pages using .net 4.0 chart object. Data related to these graphs will be modified by users via web forms; so, charts must therefore be constructed interactively.

In recovery phase I'm able to access to excel object chart to get the data from and to "see" each chart's property. Since charts are so many, not knowing what properties will be helpful and which are not, I would store all graph's properties, then they will be available for web side.

There is a simple way to retrieve all excel graph's properties? Is it possible to serialize chart's object to xml?

TIA
Alder

Posted 11-Nov-13 6:11am

ALDER_MORIGGI

Add a Solution

1 solution

Add a Solution

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

Maciej Los · Answer 1 · 2013-11-11T09:21:00

Solution 1

If i understand you well, you need to retrieve nothing from Excel graph's properties. All you need is to import data, then to create chart and bind data.

Please, see:
Getting Started[^]
Using Chart Controls[^]
Data Binding and Manipulation[^]
Samples Environment for Microsoft Chart Controls[^]

Posted 11-Nov-13 9:21am

Maciej Los

Comments

ALDER_MORIGGI 12-Nov-13 2:44am

No, My problem is how to retrieve and store Excel graph's information in a database.
I've also to import data and rebuild graph on asp.net page like excel graph.

Maciej Los 12-Nov-13 16:57pm

What have you tried till now? Where are you stuck? What kind of database?

Export excel charts in asp.net pages

1 solution

Solution 1

Add your solution here

Preview 0

Export excel charts in asp.net pages

1 solution

Solution 1

Add your solution here

Preview 0

Existing Members

...or Join us