对excle进行解析

package com.casit.cdms.test1;import java.io.File; import java.io.FileInputStream; import java.io.FileNotFoundException; import java.io.IOException; import java.io.InputStream;

import com.casit.json.JsonO;import com.casit.suwen.datatool.DB3;

import jxl.Sheet; import jxl.Workbook; import jxl.read.biff.BiffException; public class GetExcleInfo { public static void main(String[] args) { GetExcleInfo2 obj = new GetExcleInfo2(); // 此处为创建Excel路径 File file = new File("D:\\123.xls"); obj.readExcel(file); } // 去读Excel的方法readExcel，该方法的入口参数为一个File对象 public void readExcel(File file) { try { // 创建输入流，读取Excel InputStream is = new FileInputStream(file.getAbsolutePath()); // jxl提供的Workbook类 Workbook wb = Workbook.getWorkbook(is); // Excel的页签数量 int sheet_size = wb.getNumberOfSheets(); for (int index = 0; index < sheet_size; index++) { // 每个页签创建一个Sheet对象 Sheet sheet = wb.getSheet(index); // sheet.getRows()返回该页的总行数 System.out.println("++++++++++"+sheet.getRows()); for (int i =1 ; i <sheet.getRows(); i++) { JsonO jsonO = new JsonO(); // jsonO.putQuoted("ORGANIZATIONID", ORGANIZATIONID); // sheet.getColumns()返回该页的总列数 for (int j = 0; j < sheet.getColumns(); j++) { String cellinfo = sheet.getCell(j, i).getContents(); if(j==0) { jsonO.putQuoted("INNERPHONE", cellinfo); } if(j==1) { jsonO.putQuoted("SHORTNAME", cellinfo); jsonO.putQuoted("FULLNAME", cellinfo); } } System.out.println(jsonO); DB3.saveJsonOToDB(jsonO, "cdms_organization", "ORGANIZATIONID", "ORGANIZATIONID"); } } } catch (FileNotFoundException e) { e.printStackTrace(); } catch (BiffException e) { e.printStackTrace(); } catch (IOException e) { e.printStackTrace(); } } }

转载于:https://www.cnblogs.com/HP-huoshaoxiu/p/9634019.html

相关资源：JAVA上百实例源码以及开源项目