JXL 读取 Excel

来源:互联网 发布:python 压缩文件 zip 编辑:程序博客网 时间:2024/05/18 10:24
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();    }}