Maven文件如下:
<dependency>
<groupId>net.sourceforge.jexcelapi</groupId>
<artifactId>jxl</artifactId>
<version>2.6.10</version>
</dependency>
Demo代码如下
package Java_Excel;
import jxl.*;
import jxl.read.biff.BiffException;
import java.io.*;
import jxl.write.*;
import jxl.write.biff.RowsExceededException;
public class DemoRun {
public static void main(String[] args) throws RowsExceededException, WriteException, IOException, BiffException {
// 打开文件
Workbook book = Workbook.getWorkbook(new File("C:\\Users\\kakasan\\Desktop\\公司list\\demo.xls"));
// book = Workbook.getWorkbook(new File("demo.xlsx"));
// 获得第一个工作表对象
// Sheet sheet = book.getSheet("总表Industry");
Sheet sheet = book.getSheet(0);
// System.out.print(getData(sheet, 5, 6));
// 6是segment
// 循环读取数据,一行一行读数据
for (int i = 3 + 1; i <= 52 + 1; i++) {// 行
if (getData(sheet, i, 6).equals("CMS / Tools")) {
System.out.println(getRecord(sheet, i));
}
}
}
/**
* 获取单元格数据
*
* @param sheet
* @param rowNum
* @param colNum
* @return
*/
public static String getData(Sheet sheet, int rowNum, int colNum) {
return sheet.getCell(colNum, rowNum).getContents();
}
/**
* 获取一行的数据
*
* @param sheet
* @param rowNum
* @return
*/
public static String getRecord(Sheet sheet, int rowNum) {
// 循环读取数据,一行一行读数据
String temp = "";
// if (getData(sheet, rowNum, 6).equals("CMS / Tools")) {
for (int j = 0; j < sheet.getColumns(); j++) {
temp = temp + getData(sheet, rowNum, j) + "("+j+")、";
}
// }
return temp;
}
}