How to save an excel chart to image

I want to save an excel chart to image by Aspose.Excel, so that I can insert the image to pdf document. Please help me.

Thanks.

Unfortunately Aspose.Excel doesn’t support this feature. It’s too complex and we haven’t found documentation on this conversion.

@thienan,

Aspose.Cells (has been renamed from Aspose.Excel) supported to convert the Excel Charts to images PDF formats without requiring any additional tools or applications. The feature has become more robust and efficient. In order to provide rendering support, the Chart class has exposed ToImage & ToPdf methods with a verity of overloads to best suit the application requirements.

See the following sample code for your reference:
e.g
Sample code:

    // 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("chartPNG_out.png", options);

See the document for your further reference:

You may also download the up-to-date examples/demos here.