Convert Excel to Image, CSV, HTML, XPS and XML in Java

 Introduction

This blog introduces how to convert Excel files by using a Free Excel API – Free Spire.XLS for Java.

 

Free Spire.XLS for Java is a free and independent Java API that supports converting Excel files including Excel 97-2003, Excel 2007, Excel 2010, Excel 2013 etc.) to a batch of other file formats such as PDF, Image, HTML, XPS, XML, CSV, PCL, ODS and PostScript. In the following example, I will show you how to convert Excel to Image, CSV, HTML, XPS and XML by using this API.

 

Add dependencies

First of all, you need to add needed dependencies for including Free Spire.XLS 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>e-iceblue</groupId> 

            <artifactId>spire.xls.free</artifactId> 

            <version>2.2.0</version> 

        </dependency> 

    </dependencies> 

For non-maven projects, 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.

 

Example code
import com.spire.xls.FileFormat;
import com.spire.xls.Workbook;
import com.spire.xls.Worksheet;

public class ConvertExcel {
    public static void main(String[] args) throws Exception {
        //load an Excel file
        Workbook wb = new Workbook();
        wb.loadFromFile("Test.xlsx");

        //get the first worksheet
        Worksheet sheet = wb.getWorksheets().get(0);

        //save the worksheet as image
        sheet.saveToImage("output/ToImg.png");
        //save a particular cell range in the worksheet to image
        //sheet.saveToImage("ToImg2.png",8,1,30,7);

        //save the worksheet as html
        sheet.saveToHtml("output/ToHtml.html");

        //save the worksheet as xps
        sheet.saveToFile("output/ToXPS.xps", String.valueOf(FileFormat.XPS));

        //save the worksheet as csv
        sheet.saveToFile("output/ToCSV.csv", String.valueOf(FileFormat.CSV));

        //save the worksheet as xml
        sheet.saveToFile("output/ToXML.xml", String.valueOf(FileFormat.XML));
    }
} 

Output: