欢迎您访问程序员文章站本站旨在为大家提供分享程序员计算机编程知识!
您现在的位置是: 首页  >  数据库

利用jxl把.xls文件导入到数据库

程序员文章站 2022-05-27 20:01:55
...

Workbook wb = Workbook.getWorkbook(new File(E:\\lt.xls)); SimpleDateFormat df = new SimpleDateFormat(yyyyMMdd); Sheet sheet = wb.getSheet(0);// Cell cell = sheet.getCell(2,4); int hang = sheet.getRows(); int lie = sheet.getColumns(); ListH

Workbook wb = Workbook.getWorkbook(new File("E:\\lt.xls")); SimpleDateFormat df = new SimpleDateFormat("yyyyMMdd"); Sheet sheet = wb.getSheet(0); // Cell cell = sheet.getCell(2,4); int hang = sheet.getRows(); int lie = sheet.getColumns(); List list = new ArrayList(); for(int x=1;x

for(int x=0;x