如何将图表从Excel导出为图形 [英] How do I export charts from Excel as graphics

问题描述

我有一系列Excel电子表格，每个Excel电子表格至少有一页数据和一页从数据创建的图表。我需要捕获（不从数据重新生成）现有图表作为网络友好的图像。这可能通过Java或.Net？我知道POI的东西（Java）不会这样做（或者我被告知，还没有尝试过）。

I've got a series of Excel spreadsheets, each with at least one page of data and one page of a chart created from the data. I need to capture ( not regenerate from the data ) the existing chart as a web friendly image. Is this possible via Java or .Net? I know the POI stuff (Java) won't do it (or so I'm told, haven't tried it myself).

推荐答案

您是否尝试使用Chart.Export方法？

Have you tried using the Chart.Export Method?

帮助中的示例是：

Worksheets("Sheet1").ChartObjects(1).Chart. Export _
FileName:="current_sales.gif", FilterName:="GIF"

从内存，我想你也可以导出到PNG。

From memory, I think you can export to PNG as well.

这篇关于如何将图表从Excel导出为图形的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！