Convert Excel Charts to SVG using Java

ConvertExcelChartsToSVG_Java.md

Learn how to convert Excel charts to SVG using Java: https://blog.conholdate.com/2022/01/11/convert-excel-charts-to-svg-using-java/

The following topics are covered in this article:

1. Java API to Convert Excel Charts to SVG
2. Convert Excel Charts to SVG in Java
3. Export Chart and Scale SVG to Fit Viewport

ConvertExcelChartsToSVG_Java_Convert.java

// This code example demonstrates how to convert chart from Excel to SVG
// Load Excel file in workbook object
Workbook workbook = new Workbook("C:\\Files\\Cells\\Sample_Chart.xlsx");

// Access the first worksheet
Worksheet worksheet = workbook.getWorksheets().get(0);

// Access the first chart inside the worksheet
Chart chart = worksheet.getCharts().get(0);

// Save the chart into image in SVG format
ImageOrPrintOptions options = new ImageOrPrintOptions();
options.setSaveFormat(SaveFormat.SVG);

chart.toImage("C:\\Files\\Cells\\Sample_Chart_out.svg", options);

ConvertExcelChartsToSVG_Java_FitToViewPort.java

// This code example demonstrates how to convert chart from Excel to SVG and set it to fit in viewport
// Load Excel file in workbook object
Workbook workbook = new Workbook("C:\\Files\\Cells\\Sample_Chart.xlsx");

// Access the first worksheet
Worksheet worksheet = workbook.getWorksheets().get(0);

// Access the first chart inside the worksheet
Chart chart = worksheet.getCharts().get(0);

// Set image or print options
// with SVGFitToViewPort true
ImageOrPrintOptions options = new ImageOrPrintOptions();
options.setSaveFormat(SaveFormat.SVG);
options.setSVGFitToViewPort(true);

chart.toImage("C:\\Files\\Cells\\Sample_Chart_ViewPort_out.svg", options);