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(); }}