package com.db;
import jxl.Sheet;
import jxl.Workbook;
import java.io.File;
import java.io.FileInputStream;
import java.io.InputStream;
/**
* Created by IntelliJ IDEA.
* User: haoshihai
* Date: 12-9-18
* Time: 下午6:08
* To change this template use File | Settings | File Templates.
*/
public class ReadExcel {
Workbook book = null;
private static final String fileName="D:\\云转码统计\\top500成品时长统计\\上传top500筛选单子.xls";
private static final int Column=1;
public void openExcel() {
try {
InputStream is = new FileInputStream(new File(fileName));
book = Workbook.getWorkbook(is);
Sheet sheet=book.getSheet(0);
int rsColumns = sheet.getColumns();
int rsRows = sheet.getRows();
System.out.print("mid:"+sheet.getCell(Column,1).getContents());
}
catch (Exception e) {
e.printStackTrace();
}
}
public static void main(String args[]){
new ReadExcel().openExcel();
}
}
JXL 读取 Excel
最新推荐文章于 2022-06-19 20:38:33 发布