Update XLS File via Java

Modify XLS spreadsheets via your Java based applications without installing Microsoft Office^®.

For a developer, who is trying to update XLS files in any Java application. Aspose.Total for Java API can help to automate the updating process. It’s a full package of various Java APIs dealing multiple formats including Microsoft Excel documents. Aspose.Cells for Java API that is part of Aspose.Total for Java package makes this modifying process easy. Process of updating the XLS document is simple by firstly accessing the sheet and then update cell value in excel using java.

How to Update XLS File in Java

Create new Workbook class object having the source XLS file as parameter
Access of relevant Worksheet and relevant cell using getWorksheets().get(index).getCells().get(column) method
Insert new data in the accessed cell using getCells().get(indexValue).setValue(data) method
Save the file as .xls file using save() method by passing the file with path as the parameter

Modification Requirements

For XLS modification, Microsoft Windows or a compatible OS with Java Runtime Environment for JSP/JSF Application and Desktop Applications.
J2SE 6.0 (1.6), J2SE 7.0 (1.7), or above.
Get latest API version directly from Downloads

Code - Update XLS File in Java

Explore File Editor Options with Java

Edit CSV (Comma Seperated Values)

Edit TSV (Tab-separated Values)

Edit XLS (Microsoft Excel Binary Format)

Edit XLSB (Excel Binary Workbook)

Edit XLSM (Macro-enabled Spreadsheet)

Edit XLSX (Open XML Workbook)

Edit XLT (Excel 97 - 2003 Template)

Edit XLTM (Excel Macro-Enabled Template)

Edit XLTX (Excel Template)

What is XLS File Format?

The Excel XLS file format is a widely used and well-known file format for storing spreadsheet data. It is associated with Microsoft Excel, which is one of the most popular spreadsheet software applications. XLS stands for “Excel Spreadsheet” and has been a standard file format for Excel since its early versions.

The XLS file format is binary-based, meaning that it stores data in binary form rather than using XML or text-based formatting. This makes it more efficient for storing and processing large amounts of data. XLS files can contain multiple worksheets, each consisting of cells organized in rows and columns. These cells can hold various types of data, including text, numbers, dates, formulas, and formatting.

Excel provides a wide range of features and functionalities within the XLS file format. Users can perform complex calculations using formulas, apply formatting options to enhance the visual appearance of data, create charts and graphs, and utilize various data analysis tools. Additionally, Excel supports macros, which are scripts that automate repetitive tasks or perform custom operations within the spreadsheet.

Over the years, Microsoft has introduced newer file formats like XLSX, which is based on XML and offers enhanced features and compatibility. However, the XLS format continues to be supported by Excel and can be opened and edited by newer versions of the software.

The XLS file format has become an industry standard, widely used in businesses, educational institutions, and personal applications for data analysis, reporting, financial modeling, and more. Its widespread adoption and compatibility make it a reliable choice for storing and sharing spreadsheet data.