Home  >  Article  >  Java  >  How to read excel table in java

How to read excel table in java

藏色散人
藏色散人Original
2020-05-26 09:43:016029browse

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"

How to read excel table in java

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:

How to read excel table in java

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:

How to read excel table in java

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:

How to read excel table in java

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:

How to read excel table in java

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:

How to read excel table in java

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!

Statement:
The content of this article is voluntarily contributed by netizens, and the copyright belongs to the original author. This site does not assume corresponding legal responsibility. If you find any content suspected of plagiarism or infringement, please contact admin@php.cn