• excel导出


    package webber.gshdsb.util;

    import java.io.File;
    import java.io.IOException;
    import jxl.Cell;
    import jxl.Sheet;
    import jxl.Workbook;
    import jxl.read.biff.BiffException;

    public class ExcelImport {

    public static String dealData(String filepath) {

    File xlsFile = new File(filepath);
    Workbook workbook;

    try {
    workbook = Workbook.getWorkbook(xlsFile);
    Sheet sheet = workbook.getSheet(0);


    for (int i = 0; i < sheet.getRows(); i++) {
    Cell[] row = sheet.getRow(i);

    for (int j = 0; j < row.length; j++) {

    String enrolevel = row[j].getContents().trim();
    System.out.print(enrolevel);
    }

    }
    workbook.close();
    } catch (IOException e) {
    // TODO Auto-generated catch block
    e.printStackTrace();
    } catch (BiffException e) {
    // TODO Auto-generated catch block
    e.printStackTrace();
    }
    return "";

    }

    public static void main(String[] args) {
    dealData("C:/Users/Administrator/Desktop/资料/燕京学堂/燕京学堂功能模块计划.xls");
    }

    }

  • 相关阅读:
    可怕的用户习惯
    编程5年了,养成的臭脾气
    从5楼到9楼
    Google(10|9)大黄金定律
    如果我们也有Lab
    心情有点烦乱
    [zz]万能类型boost::any
    [zz]GDB调试精粹及使用实例
    [zz]sqlalchemy使用
    sqlalchemy实际使用
  • 原文地址:https://www.cnblogs.com/zzl0916/p/10932279.html
Copyright © 2020-2023  润新知