Conversion de graphique en image en Ruby
Contents
[
Hide
]
Aspose.Cells - Conversion du graphique en image
Pour convertir un graphique en image en utilisant Aspose.Cells for Java en Ruby, il suffit d’invoquer le module Convertisseur.
Code Ruby
def chart_to_image()
# Create a new Workbook.
workbook = Rjb::import('com.aspose.cells.Workbook').new
# Get the first worksheet.
sheet = workbook.getWorksheets().get(0)
# Set the name of worksheet
sheet.setName("Data")
# Get the cells collection in the sheet.
cells = workbook.getWorksheets().get(0).getCells()
# Put some values into a cells of the Data sheet.
cells.get("A1").setValue("Region")
cells.get("A2").setValue("France")
cells.get("A3").setValue("Germany")
cells.get("A4").setValue("England")
cells.get("A5").setValue("Sweden")
cells.get("A6").setValue("Italy")
cells.get("A7").setValue("Spain")
cells.get("A8").setValue("Portugal")
cells.get("B1").setValue("Sale")
cells.get("B2").setValue(70000)
cells.get("B3").setValue(55000)
cells.get("B4").setValue(30000)
cells.get("B5").setValue(40000)
cells.get("B6").setValue(35000)
cells.get("B7").setValue(32000)
cells.get("B8").setValue(10000)
# Create chart
chart_type = Rjb::import('com.aspose.cells.ChartType')
chart_index = sheet.getCharts().add(chart_type.COLUMN, 12, 1, 33, 12)
chart = sheet.getCharts().get(chart_index)
# Set properties of chart title
chart.getTitle().setText("Sales By Region")
chart.getTitle().getFont().setBold(true)
chart.getTitle().getFont().setSize(12)
# Set properties of nseries
chart.getNSeries().add("Data!B2:B8", true)
chart.getNSeries().setCategoryData("Data!A2:A8")
# Set the fill colors for the series's data points (France - Portugal(7 points))
chart_points = chart.getNSeries().get(0).getPoints()
color = Rjb::import('com.aspose.cells.Color')
point = chart_points.get(0)
point.getArea().setForegroundColor(color.getCyan())
point = chart_points.get(1)
point.getArea().setForegroundColor(color.getBlue())
point = chart_points.get(2)
point.getArea().setForegroundColor(color.getYellow())
point = chart_points.get(3)
point.getArea().setForegroundColor(color.getRed())
point = chart_points.get(4)
point.getArea().setForegroundColor(color.getBlack())
point = chart_points.get(5)
point.getArea().setForegroundColor(color.getGreen())
point = chart_points.get(6)
point.getArea().setForegroundColor(color.getMaroon())
# Set the legend invisible
chart.setShowLegend(false)
# Get the Chart image
img_opts = Rjb::import('com.aspose.cells.ImageOrPrintOptions').new
image_format = Rjb::import('com.aspose.cells.ImageFormat')
img_opts.setImageFormat(image_format.getPng())
# Save the chart image file.
chart.toImage(@data_dir + "MyChartImage.png", img_opts)
# Print message
puts "Convert chart to image successfully."
end Télécharger le code en cours d’exécution
Télécharger Conversion du graphique en image (Aspose.Cells) de l’un des sites de codage social mentionnés ci-dessous :