利用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