XLS is an old but widely used Microsoft Excel format. It is a binary file format and known as Binary Interchange File Format (BIFF). Microsoft Excel still supports XLS format for backward compatibility but since it is an old format, many new features are not supported inside it. For that reason, XLS format is often converted to XLSX format which is a newer Open Office XML-based format and supports all new features of Microsoft Excel.
You can convert XLS to XLSX manually using Microsoft Excel 2007 or later versions e.g. Microsoft Excel 2016 etc. or programmatically using Aspose.Cells for Java API with few lines of code. In order to perform its operations, Aspose.Cells does not depend on Microsoft Excel or on any sort of Microsoft Office Automation, VBA (Visual Basic for Applications), VSTO (Visual Studio Tools for Office) etc.
The purpose of this article is to explain how developers can convert Microsoft Excel XLS to XLSX format in Java.
Maximum Number of Columns and Rows in XLS and XLSX
XLS format supports
- 65,536 Rows.
- 256 Columns.
XLSX format supports
- 1,048,576 Rows.
- 16,384 Columns.
Sample Input Microsoft Excel XLS Document
You can convert any XLS document to XLSX using Aspose.Cells API. For illustration, we will use the following sample input Microsoft Excel XLS document that contains textual and numerical formatted data about some companies. Whenever, you will open XLS document in Microsoft Excel, it will show Compatibility Mode as indicated by Red Arrow in the following snapshot.
The following sample code converts XLS to XLSX by performing these steps.
- Load the input Microsoft Excel XLS document in com.aspose.cells.Workbook object.
- Save the com.aspose.cells.Workbook object in XLSX format.
Output Microsoft Excel XLSX by Aspose.Cells
The following snapshot shows the Converted or Output Microsoft Excel XLSX file by Aspose.Cells with the code given above. As you can see, the output XLSX file is exactly similar to XLS file. Similarly, you can convert any XLS file to XLSX with Aspose.Cells API easily.