读取excel

来源:互联网 发布:我太孤独 知乎 编辑:程序博客网 时间:2024/05/16 11:03
public class ExcelUtil {public static void main(String[] args) {ExcelUtil eu = new ExcelUtil();eu.run("1.xls");}private void run(String filename) {try {InputStream is = new FileInputStream(filename);// 得到文件流jxl.Workbook rwb = Workbook.getWorkbook(is);// 工作表jxl.Sheet rs = rwb.getSheet(1); // 读取第一个工作表的数据 sheetint num = rs.getRows();// 得到此excel有多少行..for (int i = 0; i < num; i++) {Cell[] cell = rs.getRow(i);// 得到第i行的数据..返回cell数组for (int j = 0; j < cell.length; j++) {System.out.print(cell[j].getContents() + " ");}System.out.println();}} catch (Exception ex) {ex.printStackTrace();} finally {}}}