How to read excel table in java

#How to read excel table in java?

The first step is to find the excel table to be read on our computer. The version read here is excel in xls format, which is the 2003 version, as shown in the figure below:

Recommended: "java learning"

The second step is to open the eclipse software, create a new java project and a class, and add the jxl.jar package, as shown in the following figure:

The third step is through Workbook.getWorkbook(new File("E://excel.xls") );The code obtains the excel table file to be read, book.getSheet(0); obtains the first worksheet information in the table, as shown below:

The fourth step is to obtain each cell information of each row in the worksheet through the while loop, which is implemented through the sheet.getCell(0,i); code, and finally print out the table cell information through the cell1.getContents() code. As shown in the figure below:

In the fifth step, we run the java project, and we can see that the excel table information has been successfully printed on the console, as shown in the figure below:

In the sixth step, we can also read the contents of the excel table through poi. Poi can read the 2003 and 2007 versions of the excel table, as shown in the figure below:

The above is the detailed content of How to read excel table in java. For more information, please follow other related articles on the PHP Chinese website!