Java Excel 导入导出

关于Excel的导入：

public static void main(String[] args) {
  //创建集合存储得来的数据
  ArrayList<stu> list = new ArrayList<stu>();
  try {
   jxl.Workbook readwb = null;
   // 构建Workbook对象, 只读Workbook对象
   // 直接从本地文件创建Workbook
   InputStream instream = new FileInputStream("D:/NOWORK/31.xls");
   readwb = Workbook.getWorkbook(instream);
   // Sheet的下标是从0开始
   // 获取第一张Sheet表
   Sheet readsheet = readwb.getSheet(0);
   // 获取Sheet表中所包含的总列数
   int rsColumns = readsheet.getColumns();
   // 获取Sheet表中所包含的总行数
   int rsRows = readsheet.getRows();
   // 获取指定单元格的对象引用
   String name = "";
   String card = "";
   for (int i = 0; i < rsRows; i++) {
    for (int j = 0; j < rsColumns; j++) {
     Cell cell = readsheet.getCell( j, i);
     System.out.print(cell.getContents() + "      ");
     //得到第一行第I列的值  其中I表示从0-i
     Cell c00 = readsheet.getCell(0, i);
     String strc00 = c00.getContents();
     //得到第二行第I列的值  其中I表示从0-i
     Cell c01 = readsheet.getCell(4, i);
     String strc01 = c01.getContents();
     name = strc00;
     card = strc01;
    }
    stu stu = new stu();
    stu.setName(name);
    stu.setCard(card);
    list.add(stu);
    System.out.println();
   }
  } catch (Exception e) {
   e.printStackTrace();
  }
 }

关于Excel的导出：

public static void main(String[] args) {
  
  try {
   //jxl.write.WritableWorkbook wwb = Workbook.createWorkbook(new File("d:/show.xls"));
   //Method 2：将WritableWorkbook直接写入到输出流
   /*
       OutputStream os = new FileOutputStream(targetfile);
       jxl.write.WritableWorkbook wwb = Workbook.createWorkbook(os);
   */
   OutputStream os = new FileOutputStream(new File("d:/show.xls"));
    //创建工作薄
         WritableWorkbook workbook = Workbook.createWorkbook(os);
         //创建新的一页
         WritableSheet sheet = workbook.createSheet("First Sheet",0);
         //创建要显示的内容,创建一个单元格，第一个参数为列坐标，第二个参数为行坐标，第三个参数为内容
         Label xuexiao = new Label(0,0,"学校");
         sheet.addCell(xuexiao);
         Label zhuanye = new Label(1,0,"专业");
         sheet.addCell(zhuanye);
         Label jingzhengli = new Label(2,0,"专业竞争力");
         sheet.addCell(jingzhengli);
        
         Label qinghua = new Label(0,1,"清华大学");
         sheet.addCell(qinghua);
         Label jisuanji = new Label(1,1,"计算机专业");
         sheet.addCell(jisuanji);
         Label gao = new Label(2,1,"高");
         sheet.addCell(gao);
        
         Label beida = new Label(0,2,"北京大学");
         sheet.addCell(beida);
         Label falv = new Label(1,2,"法律专业");
         sheet.addCell(falv);
         Label zhong = new Label(2,2,"中");
         sheet.addCell(zhong);
        
         Label ligong = new Label(0,3,"北京理工大学");
         sheet.addCell(ligong);
         Label hangkong = new Label(1,3,"航空专业");
         sheet.addCell(hangkong);
         Label di = new Label(2,3,"低");
         sheet.addCell(di);
        
         //把创建的内容写入到输出流中，并关闭输出流
         workbook.write();
         workbook.close();
         os.close();

  } catch (Exception e) {
   e.printStackTrace();
  }
 }

注意：

其中有不分内容是在网上找到的。

在写Excel的导入导出的时候务必不要忘记添加：

jxl.jar包