java jxl解析excel_Java通过jxl读取Excel

最新推荐文章于 2021-02-28 08:25:32 发布

谷臻故事工场

最新推荐文章于 2021-02-28 08:25:32 发布

阅读量83

点赞数

文章标签： java jxl解析excel

本文链接：https://blog.csdn.net/weixin_36149595/article/details/114196845

版权

packagecom.hd.all.test.testjava;importjava.io.File;importjava.io.IOException;importjava.util.regex.Matcher;importjava.util.regex.Pattern;importjxl.Cell;importjxl.Sheet;importjxl.Workbook;importjxl.read.biff.BiffException;importjxl.write.Label;importjxl.write.WritableSheet;importjxl.write.WritableWorkbook;importjxl.write.WriteException;public classReadExcelJXL {public static void main(String[] args) throwsBiffException, IOException {//Exception in thread "main" jxl.read.biff.BiffException: Unable to recognize OLE stream//1.不能读取2007版本的Excel；2.java生成的也不能读取//File file = new File("E:/students2017-10-19_10_55_55.xls");

/*** 读Excel内容*/File file= new File("C:\\Users\\Administrator\\Desktop\\新建文件夹\\1.xls");

Workbook wb=Workbook.getWorkbook(file);

Sheet s= wb.getSheet("Sheet1");/*** 写Excel内容*/WritableWorkbook book= Workbook.createWorkbook(new File("C:\\Users\\Administrator\\Desktop\\新建文件夹\\2.xls"));

WritableSheet sheet= book.createSheet("Sheet1", 0);

String reg= "1[0-9][A-Z]{2,3}[0-9]{5,6}";//匹配15KF111111

Pattern p =Pattern.compile(reg);

String reg1= "100[0-9]{5}";//匹配10011111

Pattern p1 =Pattern.compile(reg1);

String reg2= "2[0-9]{11}-{0,1}[0-9]{0,1}";//匹配211111111111(-n)-->211111111111-2

Pattern p2 =Pattern.compile(reg2);

Cell c= null;int i = 1;while(true){

c= s.getCell(0,i);//第i行第二列，0是第一列

Matcher m = p.matcher(c.getContents());//匹配15KF111111

Matcher m1 = p1.matcher(c.getContents());//匹配10011111

Matcher m2 = p2.matcher(c.getContents());//匹配211111111111