Convert to Image | Documents for Excel, Java Edition Documentation

Convert to Image

In This Topic

GcExcel allows you to convert a worksheet, any specified range and various shape types to images. Hence, making it convenient to use the converted images directly in other documents, like Word, PDF or a PPT document. The supported image formats for conversion are PNG, JPG/JPEG, SVG, EMF, GIF and WMF.

Note: To convert images with transparency, PNG like image format should be used as JPG/JPEG format doesn't support image transparency. In JDK1.6, if a GIF is exported from shape, it will have black background because of the limitation of java platform. For transparent background, the version of jdk must be higher than 1.6

Convert Worksheet to Image

A worksheet can be converted to image using the toImage method of IWorksheet interface. The converted image displays the rectangular area of the worksheet enclosed under cell A1 and the last cell where any data or shape is present. For eg, if a worksheet contains a shape or data in the range D5:F9, the converted image will display the area under the range A1:F9.

A blank worksheet cannot be converted to image.

Refer to the following example code to convert a worksheet to image.

Java	Copy Code
Workbook workbook = new Workbook(); IWorksheet worksheet = workbook.getWorksheets().get(0); //Add data worksheet.getRange("S50").setValue(10); //Save worksheet to image worksheet.toImage("ConvertWorksheetToImage.png");

Java

Copy Code

Workbook workbook = new Workbook();
IWorksheet worksheet = workbook.getWorksheets().get(0);
//Add data 
worksheet.getRange("S50").setValue(10);
 //Save worksheet to image
worksheet.toImage("ConvertWorksheetToImage.png");

Refer to the following example code to convert a worksheet to image from existing file.

Java	Copy Code
// create a png file stream FileOutputStream outputStream = new FileOutputStream("ConvertWorksheetToImage.png"); // create a new workbook Workbook workbook = new Workbook(); FileInputStream fileStream = new FileInputStream("Worksheet.xlsx"); // Open a xlsx file contains a group shape workbook.open(fileStream); IWorksheet worksheet = workbook.getWorksheets().get(0); // Export the shape to image worksheet.toImage(outputStream, ImageType.PNG); // close the image stream outputStream.close();

Java

Copy Code

// create a png file stream
FileOutputStream outputStream = new FileOutputStream("ConvertWorksheetToImage.png");
// create a new workbook
Workbook workbook = new Workbook();
FileInputStream fileStream = new FileInputStream("Worksheet.xlsx");

// Open a xlsx file contains a group shape
workbook.open(fileStream);
IWorksheet worksheet = workbook.getWorksheets().get(0);
// Export the shape to image
worksheet.toImage(outputStream, ImageType.PNG);
        
// close the image stream
outputStream.close();

Convert Range to Image

A specific range in a worksheet can be converted to image using the toImage method of the IRange interface. The resulting image displays the rectangular area of the worksheet enclosed under the specified range.

Refer to the following example code to convert a specified range to image.

Java	Copy Code
Workbook workbook = new Workbook(); IWorksheet worksheet = workbook.getWorksheets().get(0); //Add data worksheet.getRange("D10:F14").setValue(new Object[][] {{ "Device", "Quantity", "Unit Price" },{ "T540p", 12, 9850 }, { "T570", 5, 7460 }, { "Y460", 6, 5400 }, { "Y460F", 8, 6240 }}); IRange range = worksheet.getRange("D10:F14"); //Save range to image range.toImage("ConvertRangeToImage.png");

Java

Copy Code

Workbook workbook = new Workbook();
IWorksheet worksheet = workbook.getWorksheets().get(0);

//Add data
worksheet.getRange("D10:F14").setValue(new Object[][] {{ "Device", "Quantity", "Unit Price" },{ "T540p", 12, 9850 },
    { "T570", 5, 7460 },
     { "Y460", 6, 5400 },
     { "Y460F", 8, 6240 }});

IRange range = worksheet.getRange("D10:F14");
    
//Save range to image
range.toImage("ConvertRangeToImage.png");

Refer to the following example code to convert a specified range to image from an existing file.

Java	Copy Code
// create a png file stream FileOutputStream outputStream = new FileOutputStream("ConvertRangeToImage.png"); // create a new workbook Workbook workbook = new Workbook(); FileInputStream fileStream = new FileInputStream("RangeWorkbook.xlsx"); // Open a xlsx file contains a group shape workbook.open(fileStream); IWorksheet worksheet = workbook.getWorksheets().get(0); // Export the shape to image worksheet.getRange("A1:C5").toImage(outputStream, ImageType.PNG); // close the image stream outputStream.close();

Java

Copy Code

// create a png file stream
FileOutputStream outputStream = new FileOutputStream("ConvertRangeToImage.png");
// create a new workbook
Workbook workbook = new Workbook();
FileInputStream fileStream = new FileInputStream("RangeWorkbook.xlsx");

// Open a xlsx file contains a group shape
workbook.open(fileStream);
IWorksheet worksheet = workbook.getWorksheets().get(0);
// Export the shape to image
worksheet.getRange("A1:C5").toImage(outputStream, ImageType.PNG);
// close the image stream
outputStream.close();

Convert Shape to Image

GcExcel allows you to convert various shape types to image using the toImage method of the IShape interface. The shape types include shapes like picture, slicer, chart and autoshape. The resulting image displays the rectangular area of the worksheet enclosed under the shape.

Refer to the following example code to convert an autoshape to image.

Java	Copy Code
Workbook workbook = new Workbook(); IWorksheet worksheet = workbook.getWorksheets().get(0); //Add an oval IShape shape = worksheet.getShapes().addShape(AutoShapeType.Oval, 20, 20, 200, 100); //Save oval to image shape.toImage("ConvertShapeToImage.png");

Java

Copy Code

Workbook workbook = new Workbook();
IWorksheet worksheet = workbook.getWorksheets().get(0);

//Add an oval
IShape shape = worksheet.getShapes().addShape(AutoShapeType.Oval, 20, 20, 200, 100);
       
//Save oval to image
shape.toImage("ConvertShapeToImage.png");

Refer to the following example code to convert an autoshape to image from an existing file.

Java	Copy Code
// create a png file stream FileOutputStream outputStream = new FileOutputStream("ConvertShapeToImage.png"); // create a new workbook Workbook workbook = new Workbook(); FileInputStream fileStream = new FileInputStream("ShapeWorkbook.xlsx"); // Open a xlsx file contains a group shape workbook.open(fileStream); IWorksheet worksheet = workbook.getWorksheets().get(0); // Export the shape to image worksheet.getShapes().get(0).toImage(outputStream, ImageType.PNG); // close the image stream outputStream.close();

Java

Copy Code

// create a png file stream
FileOutputStream outputStream = new FileOutputStream("ConvertShapeToImage.png");
// create a new workbook
Workbook workbook = new Workbook();
FileInputStream fileStream = new FileInputStream("ShapeWorkbook.xlsx");

// Open a xlsx file contains a group shape
workbook.open(fileStream);
IWorksheet worksheet = workbook.getWorksheets().get(0);
// Export the shape to image
worksheet.getShapes().get(0).toImage(outputStream, ImageType.PNG);
// close the image stream
outputStream.close();

Refer to the following example code to convert a chart to image.

C#	Copy Code
// create a new workbook Workbook workbook = new Workbook(); IWorksheet worksheet = workbook.getWorksheets().get(0); // Prepare data for chart worksheet.getRange("A1:D4") .setValue(new Object[][] { { null, "Q1", "Q2", "Q3" }, { "Mobile Phones", 1330, 2345, 3493 }, { "Laptops", 2032, 3632, 2197 }, { "Tablets", 6233, 3270, 2030 } }); worksheet.getRange("A:D").getColumns().autoFit(); // Add Area Chart IShape shape = worksheet.getShapes().addChart(ChartType.Area, 250, 20, 360, 230); // Add series to SeriesCollection shape.getChart().getSeriesCollection().add(worksheet.getRange("A1:D4"), RowCol.Columns, true, true); // Configure Chart Title shape.getChart().getChartTitle().getTextFrame().getTextRange().getParagraphs().add("Annual Sales Record"); // Save chart to image shape.toImage("ConvertChartToImage.png");

Copy Code

// create a new workbook
 Workbook workbook = new Workbook();
 IWorksheet worksheet = workbook.getWorksheets().get(0);

 // Prepare data for chart
 worksheet.getRange("A1:D4")
         .setValue(new Object[][] { { null, "Q1", "Q2", "Q3" }, { "Mobile Phones", 1330, 2345, 3493 },
                 { "Laptops", 2032, 3632, 2197 }, { "Tablets", 6233, 3270, 2030 } });

 worksheet.getRange("A:D").getColumns().autoFit();

 // Add Area Chart
 IShape shape = worksheet.getShapes().addChart(ChartType.Area, 250, 20, 360, 230);

 // Add series to SeriesCollection
 shape.getChart().getSeriesCollection().add(worksheet.getRange("A1:D4"), RowCol.Columns, true, true);

 // Configure Chart Title
 shape.getChart().getChartTitle().getTextFrame().getTextRange().getParagraphs().add("Annual Sales Record");

 // Save chart to image
 shape.toImage("ConvertChartToImage.png");

Refer to the following example code to convert a chart to image from existing file.

C#	Copy Code
// create a png file stream FileOutputStream outputStream = new FileOutputStream("ConvertChartToImage.png"); // create a new workbook Workbook workbook = new Workbook(); FileInputStream fileStream = new FileInputStream("scatterchart.xlsx"); // Open a xlsx file contains a chart workbook.open(fileStream); IWorksheet worksheet = workbook.getWorksheets().get(0); // Export the chart to image worksheet.getShapes().get(0).toImage(outputStream, ImageType.PNG);

Copy Code

// create a png file stream
  FileOutputStream outputStream = new
  FileOutputStream("ConvertChartToImage.png");
  
  // create a new workbook 
  Workbook workbook = new Workbook();
  
  FileInputStream fileStream = new FileInputStream("scatterchart.xlsx");
  
  // Open a xlsx file contains a chart 
  workbook.open(fileStream); 
  IWorksheet worksheet = workbook.getWorksheets().get(0);
  
  // Export the chart to image
  worksheet.getShapes().get(0).toImage(outputStream, ImageType.PNG);

Product Support Forum | Print this page