Converting Chart to Image in Ruby

Aspose.Cells - Converting Chart to Image

To convert Chart to Image using Aspose.Cells for Java in Ruby, simply invoke Converter module.

Ruby Code

 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   

Download Running Code

Download Converting Chart to Image (Aspose.Cells) from any of the below mentioned social coding sites:

• GitHub