Converting Chart to Image in Ruby

Aspose.Cells - Converting Chart to Image

To convert a chart to an image using Aspose.Cells for Java in Ruby, simply invoke the 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 the worksheet  
    sheet.setName("Data")  

    # Get the cells collection in the sheet.  
    cells = workbook.getWorksheets().get(0).getCells()  

    # Put some values into 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 the 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' 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())  

    # Make 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