import java.io.FileInputStream;
import java.io.InputStream;
import jxl.Cell;
import jxl.Sheet;
import jxl.Workbook;
public class demoAgent {
public static void main(String[] args) {
try {
InputStream is = new FileInputStream(Thread.currentThread()
.getContextClassLoader().getResource("wiwj0-65000.xls")
.getPath());
Workbook rwb = Workbook.getWorkbook(is);
Sheet rs = rwb.getSheet(0);// 参数设置读文件的第几页
int rsRows = rs.getRows(); // 获取Sheet表中所包含的总行数
for (int i = 0; i < rsRows; i++) {
Cell[] row = rs.getRow(i);
// 全称
String jid = row[2].getContents().trim();
}
} catch (Exception e) {
e.printStackTrace();
}
}
}
需要jar包jxl
百度网盘下载地址:链接: https://pan.baidu.com/s/1H548zLykb6Ahj-CjYSPppA 密码: wxqr