Excel实战之JXL解析

来源:互联网 发布:淘宝店铺三个月未经营 编辑:程序博客网 时间:2024/05/17 02:09
package webdemo;import java.io.File;import java.io.IOException;import jxl.Cell;import jxl.Sheet;import jxl.Workbook;import jxl.read.biff.BiffException;/** *  * @author hejin *JXL读取解析Excel */public class JxlReadExcel {public static void main(String[] args) {try {//获取WorkbookWorkbook workbook = Workbook.getWorkbook(new File("e:/jxl_test.xls"));//获取sheetSheet 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();}} catch (Exception e) {e.printStackTrace();}}}

0 0