Grafico in Immagine
Contents
[
Hide
]
Rendering di grafici
Le API di Aspose.Cells supportano la conversione dei grafici di Excel in formati di immagine senza richiedere strumenti o applicazioni aggiuntive. Al fine di fornire supporto alla visualizzazione, la classe Chart ha esposto ToImage metodi con una varietà di sovraccarichi per soddisfare al meglio i requisiti dell’applicazione.
Rendering di grafici in immagini
Il metodo Chart.ToImage ha una varietà di sovraccarichi per supportare sia il rendering semplice che avanzato. Se il requisito dell’applicazione è quello di visualizzare il grafico nelle sue dimensioni predefinite, ti suggeriamo di utilizzare il metodo Chart.ToImage come segue.
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); |
È anche possibile renderizzare i grafici in immagini con impostazioni avanzate. Le API di Aspose.Cells hanno esposto una versione sovraccaricata del metodo Chart.ToImage che potrebbe accettare un’istanza di ImageOrPrintOptions, consentendo di specificare parametri come risoluzione, modalità di smussatura, formato dell’immagine e così via.
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); |
Tipi di grafico supportati per il rendering
Ci sono alcuni tipi di grafico attualmente non supportati per il rendering. Tali tipi di grafico contengono N nella colonna Supportato della tabella sottostante.
| Tipo grafico | Sottotipo grafico | Supportato |
|---|---|---|
| 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 |
Nel caso in cui si tenti di rendere i tipi di grafico non supportati in immagine o PDF, si potrebbe ottenere immagini di dimensioni 0 o PDF vuoti.