java解析xls表格
有一张这个表格,路径是 H:/Desk/web/tt.xls
现在要用java解析这样的表格,先来开下效果,最后输出如下
好了,现在来进行读取白哦个内容吧!
先下载jxl.jar这个jar包
下面是下载地址
https://download.****.net/download/qq_40881680/10701483
导入这个jar包
导入之后如下java代码,运行就可以了
import java.io.File;
import jxl.Cell;
import jxl.Sheet;
import jxl.Workbook;
public class XLS{
public static void main(String[] args) {
try {
//创建workbook
Workbook workbook = Workbook.getWorkbook(new File("H:/Desk/web/tt.xls"));
//获取第一个工作表sheet
Sheet sheet = workbook.getSheet(0);
for (int i = 0; i <sheet.getRows(); i++) {
for (int j = 0; j < sheet.getColumns(); j++) {
Cell cell = sheet.getCell(j, i);
System.out.print(cell.getContents()+" ");
}
System.out.println();
}
workbook.close();
} catch (Exception e) {
// TODO Auto-generated catch block
e.printStackTrace();
}
}
}