Skip to main content

Convert Excel to Image (PNG, JPEG, TIFF and SVG) in Java

 

In this article, I will show you how to convert Excel to common image formats such as PNG, JPEG, TIFF and SVG programmatically in Java application. The article will be divided into the following three parts for demonstration:

  • Convert Excel to Image (PNG, JPEG)
  • Convert Excel to TIFF
  • Convert Excel to SVG

Add dependencies

Free Spire.XLS for Java library is used to implement this task. If you use maven, you need to specify the following dependencies for Free Spire.XLS for Java library in your project’s pom.xml file.

1
2
3
4
5
6
7
8
9
10
11
12
13
14
<repositories>   
    <repository>   
        <id>com.e-iceblue</id>   
        <name>e-iceblue</name>   
        <url>http://repo.e-iceblue.com/nexus/content/groups/public/</url>   
    </repository>   
</repositories>   
<dependencies>   
    <dependency>   
        <groupId> e-iceblue </groupId>   
        <artifactId>spire.xls.free</artifactId>   
        <version>3.9.1</version>   
    </dependency>   
</dependencies>

For non-maven projects, you can download Free Spire.XLS for Java pack from this website and add Spire.Xls.jar in the lib folder into your project as a dependency.

The input Excel file

Input Excel

Convert Excel to Image (PNG, JPEG)

1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
import com.spire.xls.Workbook;
import com.spire.xls.Worksheet;
 
import javax.imageio.ImageIO;
import java.awt.image.BufferedImage;
import java.io.File;
 
public class ExcelToImage {
    public static void main(String []args) throws Exception {
        //Load the Excel file
        Workbook workbook = new Workbook();
        workbook.loadFromFile("Input.xlsx");
 
        //Loop through worksheets
        for (int i = 0; i < workbook.getWorksheets().size(); i++) {
            //Convert worksheet to image
            Worksheet sheet = workbook.getWorksheets().get(i);
            BufferedImage bufferedImage = sheet.toImage(sheet.getFirstRow(), sheet.getFirstColumn(), sheet.getLastRow(), sheet.getLastColumn());
            ImageIO.write(bufferedImage,"PNG",new File("image/SheetToImage"+i+".png"));
        }
    }
}

Output:

Convert Excel To Image

Convert Excel to TIFF

1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
import com.spire.xls.Workbook;
import com.spire.xls.Worksheet;
 
public class ExcelToTiff {
    public static void main(String []args) throws Exception {
        //Load the Excel file
        Workbook workbook = new Workbook();
        workbook.loadFromFile("Input.xlsx");
 
        //Loop through worksheets
        for (int i = 0; i < workbook.getWorksheets().size(); i++) {
            //Convert worksheet to tiff
            Worksheet sheet = workbook.getWorksheets().get(i);
            //Save the first worksheet to tiff
            sheet.saveToTiff("tiff/SheetToTiff" + i + ".tif");
        }
    }
}

Output:

Convert Excel to Tiff

Convert Excel to SVG

1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
import com.spire.xls.Workbook;
import com.spire.xls.Worksheet;
 
import java.io.FileOutputStream;
 
public class ExcelToSvg {
    public static void main(String []args) throws Exception {
        //Open xls document
        Workbook workbook = new Workbook();
        workbook.loadFromFile("Input.xlsx");
        //Traverse worksheets
        for (int i = 0; i < workbook.getWorksheets().size(); i++) {
            FileOutputStream stream = new FileOutputStream("svg/sheet" + i + ".svg");
            //Convert worksheet to svg file
            Worksheet sheet = workbook.getWorksheets().get(i);
            sheet.toSVGStream(stream, sheet.getFirstRow(), sheet.getFirstColumn(), sheet.getLastRow(), sheet.getLastColumn());
            stream.flush();
            stream.close();
        }
    }
}

Output:

Labels:

Comments

Post a Comment

Popular posts from this blog

3 Ways to Generate Word Documents from Templates in Java

A template is a document with pre-applied formatting like styles, tabs, line spacing and so on. You can quickly generate a batch of documents with the same structure based on the template. In this article, I am going to show you the different ways to generate Word documents from templates programmatically in Java using Free Spire.Doc for Java library. Prerequisite First of all, you need to add needed dependencies for including Free Spire.Doc for Java into your Java project. There are two ways to do that. If you use maven, you need to add the following code to your project’s pom.xml file. <repositories>               <repository>                   <id>com.e-iceblue</id>                   <name>e-iceblue</name>                   <url>http: //repo.e-iceblue.com/nexus/content/groups/public/</url>                </repository>       </repositories>       <dependencies>           <dependency>               <g
Post a Comment
Read more

Simple Java Code to Convert Excel to PDF in Java

This article demonstrates a simple solution to convert an Excel file to PDF in Java by using free Excel API – Free Spire.XLS for Java . The following examples illustrate two possibilities to convert Excel to PDF:      Convert the whole Excel file to PDF     Convert a particular Excel Worksheet to PDF Before start with coding, you need to Download Free Spire.XLS for Java package , unzip it and import Spire.Xls.jar file from the lib folder in your project as a denpendency. 1. Convert the whole Excel file to PDF Spire.XLS for Java provides saveToFile method in Workbook class that enables us to easily save a whole Excel file to PDF. import com.spire.xls.FileFormat; import com.spire.xls.Workbook; public class ExcelToPDF {     public static void main(String[] args){         //Create a Workbook         Workbook workbook = new Workbook();         workbook.loadFromFile( "Sample.xlsx" );         //Fit to page         workbook.getConverterSetting().setShee
Post a Comment
Read more

Insert and Extract OLE objects in Word in Java

You can use OLE (Object Linking and Embedding) to include content from other programs, such as another Word document, an Excel or PowerPoint document to an existing Word document. This article demonstrates how to insert and extract embedded OLE objects in a Word document in Java by using Free Spire.Doc for Java API.   Add dependencies First of all, you need to add needed dependencies for including Free Spire.Doc for Java into your Java project. There are two ways to do that. If you use maven, you need to add the following code to your project’s pom.xml file.     <repositories>               <repository>                   <id>com.e-iceblue</id>                   <name>e-iceblue</name>                   <url>http://repo.e-iceblue.com/nexus/content/groups/public/</url>               </repository>       </repositories>       <dependencies>           <dependency>               <groupId>
Post a Comment
Read more