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:

Convert a Chart Sheet to Image in C#

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:

//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);