Convert a Chart Sheet to Image in C#

A chart sheet is a separate worksheet that only contains chart, at some times we may need to convert chart sheet to image. This article is going to elaborates how we can convert a chart sheet to image using Spire.XLS.

Screenshot of the Chart sheet:

Detail steps:

Step 1: Instantiate a Workbook object and load the excel file.

Workbook workbook = new Workbook();
workbook.LoadFromFile("Input.xlsx");

Step 2: Get the first chart sheet.

ChartSheet chartSheet = workbook.Chartsheets[0];

Step 3: Save the chart sheet to image and save the image to disk.

Image image = workbook.SaveChartAsImage(chartSheet);
image.Save("ChartSheet.png", ImageFormat.Png);

Output image:

Convert a Chart Sheet to Image in C#

Full code:

using System.Drawing.Imaging;
namespace Convert
{
    class Program
    {
        static void Main(string[] args)
        {
            //Instantiate a Workbook object
            Workbook workbook = new Workbook();
            //Load the excel file
            workbook.LoadFromFile("Input.xlsx");

            //Get the first chart sheet
            ChartSheet chartSheet = workbook.Chartsheets[0];

            //Save the chart sheet as image
            Image image = workbook.SaveChartAsImage(chartSheet);
            //Save image
            image.Save("ChartSheet.png", ImageFormat.Png);

        }
    }
}

Convert a Chart Sheet to Image in C#

See Also