XLS and XLSX files are immensely used for storing small or large-sized data. Also, you can process and manipulate data by performing various operations. However, in certain cases, you have to transform the Excel data into JSON format, such as in web applications. To perform this conversion programmatically, this article shows how to convert an Excel XLS or XLSX file to JSON in Java.
Java API for XLS to JSON Conversion
To convert Excel XLS or XLSX files to JSON format, we will use Aspose.Cells for Java. It is a powerful API with an amazing set of features for creating and processing spreadsheet documents. In addition, it provides high-quality conversion of spreadsheet documents to other formats. You can download its JAR or install it directly using the following Maven configurations.
<repository> <id>AsposeJavaAPI</id> <name>Aspose Java API</name> <url>https://repository.aspose.com/repo/</url> </repository>
<dependency> <groupId>com.aspose</groupId> <artifactId>aspose-cells</artifactId> <version>22.6</version> </dependency>
Convert an XLS File to JSON in Java
Aspose.Cells for Java makes it quite easier for you to convert an Excel file to JSON format. For this, you only need to load the XLS or XLSX file and save it in JSON format. The following are the steps to convert an XLS file to JSON in Java.
The following code sample shows how to save an XLS file as JSON in Java.
Get a Free License
You can get a free temporary license to use Aspose.Cells for Java without evaluation limitations.
In this article, you have learned how to convert XLS or XLSX files to JSON programmatically in Java. The code sample has demonstrated how you can integrate XLS or XLSX to JSON conversion in your Java applications. In addition, you can visit the documentation to explore other features of Aspose.Cells for Java. Also, you can share your questions or queries with us via our forum.