Diagramm als Bild
Contents
[
Hide
]
Diagramme darstellen
Aspose.Cells APIs unterstützen die Konvertierung der Excel-Diagramme in Bildformate, ohne zusätzliche Tools oder Anwendungen zu benötigen. Um Renderunterstützung bereitzustellen, hat die Chart Klasse ToImage Methoden mit einer Vielzahl von Überladungen freigelegt, um den Anforderungen der Anwendung am besten zu entsprechen.
Grafiken in Bilder umwandeln
Die Chart.ToImage-Methode verfügt über eine Vielzahl von Überladungen, um sowohl einfache als auch erweiterte Renderings zu unterstützen. Wenn die Anforderung der Anwendung darin besteht, das Diagramm in seinen Standardabmessungen zu rendern, empfehlen wir die Verwendung der Chart.ToImage-Methode, wie im Folgenden gezeigt.
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| // For complete examples and data files, please go to https://github.com/aspose-cells/Aspose.Cells-for-.NET | |
| // The path to the documents directory. | |
| string dataDir = RunExamples.GetDataDir(System.Reflection.MethodBase.GetCurrentMethod().DeclaringType); | |
| // Instantiating a Workbook object | |
| Workbook workbook = new Workbook(); | |
| // Adding a new worksheet to the Workbook | |
| int sheetIndex = workbook.Worksheets.Add(); | |
| // Obtaining the reference of the newly added worksheet by passing its index to WorksheetCollection | |
| Worksheet worksheet = workbook.Worksheets[sheetIndex]; | |
| // Adding sample values to cells | |
| worksheet.Cells["A1"].PutValue(50); | |
| worksheet.Cells["A2"].PutValue(100); | |
| worksheet.Cells["A3"].PutValue(150); | |
| worksheet.Cells["B1"].PutValue(4); | |
| worksheet.Cells["B2"].PutValue(20); | |
| worksheet.Cells["B3"].PutValue(50); | |
| // Adding a chart to the worksheet | |
| int chartIndex = worksheet.Charts.Add(Aspose.Cells.Charts.ChartType.Column, 5, 0, 15, 5); | |
| // Accessing the instance of the newly added chart | |
| Aspose.Cells.Charts.Chart chart = worksheet.Charts[chartIndex]; | |
| // Adding Series Collection (chart data source) to the chart ranging from "A1" cell to "B3" | |
| chart.NSeries.Add("A1:B3", true); | |
| // Converting chart to image | |
| chart.ToImage(dataDir + "chartEMF_out.emf", ImageType.Emf); | |
| // Converting chart to Bitmap | |
| System.Drawing.Bitmap bitmap = chart.ToImage(); | |
| bitmap.Save(dataDir + "chartBMP_out.bmp", System.Drawing.Imaging.ImageFormat.Bmp); |
Es ist auch möglich, die Diagramme mit erweiterten Einstellungen als Bilder zu rendern. Aspose.Cells APIs haben eine Überladungsversion der Chart.ToImage-Methode freigelegt, die eine Instanz von ImageOrPrintOptions akzeptieren und gleichzeitig Parameter wie Auflösung, Glättungsmodus, Bildformat usw. festlegen kann.
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| // For complete examples and data files, please go to https://github.com/aspose-cells/Aspose.Cells-for-.NET | |
| // The path to the documents directory. | |
| string dataDir = RunExamples.GetDataDir(System.Reflection.MethodBase.GetCurrentMethod().DeclaringType); | |
| // Instantiating a Workbook object | |
| Workbook workbook = new Workbook(); | |
| // Adding a new worksheet to the Workbook | |
| int sheetIndex = workbook.Worksheets.Add(); | |
| // Obtaining the reference of the newly added worksheet by passing its index to WorksheetCollection | |
| Worksheet worksheet = workbook.Worksheets[sheetIndex]; | |
| // Adding sample values to cells | |
| worksheet.Cells["A1"].PutValue(50); | |
| worksheet.Cells["A2"].PutValue(100); | |
| worksheet.Cells["A3"].PutValue(150); | |
| worksheet.Cells["B1"].PutValue(4); | |
| worksheet.Cells["B2"].PutValue(20); | |
| worksheet.Cells["B3"].PutValue(50); | |
| // Adding a chart to the worksheet | |
| int chartIndex = worksheet.Charts.Add(Aspose.Cells.Charts.ChartType.Column, 5, 0, 15, 5); | |
| // Accessing the instance of the newly added chart | |
| Aspose.Cells.Charts.Chart chart = worksheet.Charts[chartIndex]; | |
| // Adding Series Collection (chart data source) to the chart ranging from "A1" cell to "B3" | |
| chart.NSeries.Add("A1:B3", true); | |
| // Create an instance of ImageOrPrintOptions and set a few properties | |
| ImageOrPrintOptions options = new ImageOrPrintOptions() | |
| { | |
| VerticalResolution = 300, | |
| HorizontalResolution = 300, | |
| SmoothingMode = System.Drawing.Drawing2D.SmoothingMode.AntiAlias | |
| }; | |
| // Convert chart to image with additional settings | |
| chart.ToImage(dataDir + "chartPNG_out.png", options); |
Unterstützte Diagrammtypen für die Darstellung
Einige Diagrammtypen werden derzeit nicht für die Darstellung unterstützt. Solche Diagrammtypen enthalten ein N in der Unterstützt-Spalte der unten stehenden Tabelle.
| Diagrammtyp | Diagramm-Subtyp | Unterstützt |
|---|---|---|
| Column | Column | Y |
| ColumnStacked | Y | |
| Column100PercentStacked | Y | |
| Column3DClustered | Y | |
| Column3DStacked | Y | |
| Column3D100PercentStacked | Y | |
| Column3D | Y | |
| Bar | Bar | Y |
| BarStacked | Y | |
| Bar100PercentStacked | Y | |
| Bar3DClustered | Y | |
| Bar3DStacked | Y | |
| Bar3D100PercentStacked | Y | |
| Line | Line | Y |
| LineStacked | Y | |
| Line100PercentStacked | Y | |
| LineWithDataMarkers | Y | |
| LineStackedWithDataMarkers | Y | |
| Line100PercentStackedWithDataMarkers | Y | |
| Line3D | Y | |
| Pie | Pie | Y |
| Pie3D | Y | |
| PiePie | Y | |
| PieExploded | Y | |
| Pie3DExploded | Y | |
| PieBar | Y | |
| Scatter | Scatter | Y |
| ScatterConnectedByCurvesWithDataMarker | Y | |
| ScatterConnectedByCurvesWithoutDataMarker | Y | |
| ScatterConnectedByLinesWithDataMarker | Y | |
| ScatterConnectedByLinesWithoutDataMarker | Y | |
| Area | Area | Y |
| AreaStacked | Y | |
| Area100PercentStacked | Y | |
| Area3D | Y | |
| Area3DStacked | Y | |
| Area3D100PercentStacked | Y | |
| Doughnut | Doughnut | Y |
| DoughnutExploded | Y | |
| Radar | Radar | Y |
| RadarWithDataMarkers | Y | |
| RadarFilled | Y | |
| Surface | Surface3D | N |
| SurfaceWireframe3D | N | |
| SurfaceContour | N | |
| SurfaceContourWireframe | N | |
| Bubble | Bubble | Y |
| Bubble3D | N | |
| Stock | StockHighLowClose | Y |
| StockOpenHighLowClose | Y | |
| StockVolumeHighLowClose | Y | |
| StockVolumeOpenHighLowClose | Y | |
| Cylinder | Cylinder | Y |
| CylinderStacked | Y | |
| Cylinder100PercentStacked | Y | |
| CylindricalBar | Y | |
| CylindricalBarStacked | Y | |
| CylindricalBar100PercentStacked | Y | |
| CylindricalColumn3D | Y | |
| Cone | Cone | Y |
| ConeStacked | Y | |
| Cone100PercentStacked | Y | |
| ConicalBar | Y | |
| ConicalBarStacked | Y | |
| ConicalBar100PercentStacked | Y | |
| ConicalColumn3D | Y | |
| Pyramid | Pyramid | Y |
| PyramidStacked | Y | |
| Pyramid100PercentStacked | Y | |
| PyramidBar | Y | |
| PyramidBarStacked | Y | |
| PyramidBar100PercentStacked | Y | |
| PyramidColumn3D | Y | |
| BoxWhisker | BoxWhisker | Y |
| Funnel | Funnel | Y |
| ParetoLine | ParetoLine | Y |
| Sunburst | Sunburst | Y |
| Treemap | Treemap | Y |
| Waterfall | Waterfall | Y |
| Histogram | Histogram | Y |
| Map | Map | N |
Wenn Sie versuchen, die nicht unterstützten Diagrammtypen als Bild oder PDF darzustellen, erhalten Sie möglicherweise Bilder mit der Größe 0 oder leere PDFs.