Read Excel File Java

While working with diverse datasets in Excel format, whether the legacy XLS files or the modern XLSX format, having a robust Excel reader in Java is essential. In this blog post, we will explore the details of reading Excel files in Java.

Why Excel Files Reader in Java?

Data Accessibility: Excel is a ubiquitous tool for data storage and analysis. Being able to read Excel files programmatically in Java opens the door to a variety of data that can be utilized in various applications.

Legacy Support: Legacy systems often store data in the older XLS format. A capable Excel reader in Java allows you to seamlessly work with these legacy files, ensuring compatibility with a wide range of datasets.

Modern Data Handling: With the prevalence of the XLSX format, modern Excel files can be read effortlessly in Java. This format supports advanced features such as multiple sheets, rich formatting, and improved data storage.

Read Excel File in Java

You can easily read data from Excel worksheets. Simply follow the steps below to read Excel files in Java:

  • Configure Conholdate.Total for Java in your environment.
  • Load the source Excel file with an object of the Workbook class.
  • Access all the worksheets with the Worksheets property.
  • Iterate through each worksheet with a For loop.
  • Iterate each row and extract values in each column.
  • Print the cell value to the console or process it based on your requirements.

The following sample code demonstrates how to read an Excel file in Java:

// Load Excel file
Workbook wb = new Workbook("workbook.xlsx");
// Get all worksheets
WorksheetCollection collection = wb.getWorksheets();
// Loop through all the worksheets
for (int worksheetIndex = 0; worksheetIndex < collection.getCount(); worksheetIndex++) {
// Get worksheet using its index
Worksheet worksheet = collection.get(worksheetIndex);
// Print worksheet name
System.out.print("Worksheet: " + worksheet.getName());
// Get number of rows and columns
int rows = worksheet.getCells().getMaxDataRow();
int cols = worksheet.getCells().getMaxDataColumn();
// Loop through rows
for (int i = 0; i < rows; i++) {
// Loop through each column in selected row
for (int j = 0; j < cols; j++) {
// Pring cell value
System.out.print(worksheet.getCells().get(i, j).getValue() + " | ");
}
// Print line break
System.out.println(" ");
}
}

Parse Data from a Specific Excel Sheet in Java

Sometimes you may need to extract specific data from a worksheet instead of processing the whole Workbook containing multiple sheets. You need to follow the steps below to read data from an Excel file in a particular worksheet using Java:

  • Install Conholdate.Total for Java in your system.
  • Create an instance of the Workbook class.
  • Access any worksheet while specifying its name or zero-based index.
  • Get the last populated row and column with MaxDataRow and MaxDataColumn properties.
  • Loop through each row and column.
  • Get the cell value.

The code snippet below shows how to read data from a specific worksheet in Excel using Java:

// Load Excel file
Workbook wb = new Workbook("workbook.xlsx");
// Get reference of the worksheet
Worksheet worksheet = wb.getWorksheets().get(0);
// Get row and column count
int rows = worksheet.getCells().getMaxDataRow();
int cols = worksheet.getCells().getMaxDataColumn();
// Loop through rows
for (int i = 0; i < rows; i++) {
// Loop through each column in selected row
for (int j = 0; j < cols; j++) {
// Print cell value
System.out.print(worksheet.getCells().get(i, j).getValue() + " | ");
}
// Print line break
System.out.println(" ");
}

Free Evaluation License

You may request a free temporary license to parse Excel files and test all the features without any limitations.

Wrapping Up

This blog post lets you dive into the world of Excel data extraction in Java and empowers your applications with the ability to harness the information stored in Excel XLS XLSX spreadsheets. The steps and the code let you develop the Java program to create an Excel reader in Java that parses all the data or a particular worksheet as per your requirements. Furthermore, if you need to discuss any of your use cases or requirements, then feel free to reach out to us at the forum.

FAQs

How can I read an Excel file in Java?

To read an Excel file in Java, you can use libraries like Conholdate.Total for Java. Follow the steps outlined in the blog post to configure the library, load the Excel file, and extract data from worksheets.

What is the role of the Workbook class in reading Excel files?

The Workbook class implements the common concept of manipulating Excel files in Java. It represents the entire Excel workbook and provides methods to access worksheets, rows, columns, and cell values.

Is there a way to iterate through all rows and columns in an Excel worksheet?

Yes, the blog post outlines a common approach to iterate through all rows and columns in a worksheet. It involves using loops and accessing cell values to process the data as needed.

Can I use the extracted data for further processing in my Java application?

Absolutely! Once you have extracted data from the Excel file using Java, you can use it based on your application’s requirements. This may include storing the data, performing calculations, or displaying it in a user interface.

See Also