原文链接:
https://www.cnblogs.com/bretgui/p/10156141.html
1.导入依赖JAR包
<!-- jxl 操作excel --> <dependency> <groupId>org.jxls</groupId> <artifactId>jxls-jexcel</artifactId> <version>1.0.6</version> </dependency>
2.创建工作簿并载入excel文件流
jxl.Workbook wb =null; InputStream is = new FileInputStream("D://G201.xls"); wb = Workbook.getWorkbook(is);
3.通过索引或者名称获取Sheet
wb.getSheet(0);
4.通过行号获取Cell
sheet.getRow(j)
5.示例代码展示
package com.bret.test; import jxl.Cell; import jxl.Sheet; import jxl.Workbook; import jxl.read.biff.BiffException; import org.junit.Test; import java.io.FileInputStream; import java.io.IOException; import java.io.InputStream; public class ExcelUtil { @Test public void test(){ try{ jxl.Workbook wb =null; InputStream is = new FileInputStream("D://G201.xls"); wb = Workbook.getWorkbook(is); int sheetSize = wb.getNumberOfSheets(); Sheet sheet = wb.getSheet(0); int row_total = sheet.getRows(); for (int j = 0; j < row_total; j++) { if(j == 0){ Cell[] cells = sheet.getRow(j); System.out.println(cells[0].getContents()); System.out.println(cells[1].getContents()); System.out.println(cells[2].getContents()); } } }catch (IOException e) { // TODO Auto-generated catch block e.printStackTrace(); } catch (BiffException e){ e.printStackTrace(); } } }