在asp.net页面中导出excel图表 [英] Export excel charts in asp.net pages

问题描述

大家好，



我需要从不同excel文件的数百个图中检索数据和特征（轴，图例等系列等），商店数据库中的所有内容，然后使用.net 4.0图表对象在asp.net页面中显示这些图形。用户可以通过网络表格修改与这些图表相关的数据;因此，图表必须以交互方式构建。



在恢复阶段，我可以访问excel对象图表以获取和查看数据的数据。每张图表的属性。由于图表太多，不知道哪些属性会有用，哪些不是，我会存储所有图形的属性，然后它们将可用于Web端。



有一种简单的方法来检索所有excel图的属性？是否可以将图表的对象序列化为xml？



TIA

Alder

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

推荐答案

如果我理解你，你需要从Excel图表的属性中检索任何内容。您只需要导入数据，然后创建图表并绑定数据。



请参阅：

使用入门 [ ^ ]

使用图表控件 [ ^ ]

数据绑定和操作 [ ^ ]

Microsoft图表控件的示例环境 [ ^ ]

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[^]

这篇关于在asp.net页面中导出excel图表的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！