excel文件中信息上传到数据库
<form action="Excel.action" enctype="multipart/form-data" method="post">
<input type="file" name="excelFile">
<input type="submit" value="导入Excel文件">
</form>
//这个filez中name属性excelFile必须与action中的File名字一模一样
private File excelFile;
private String excelFileContentType;
private String excelFileFileName;
核心代码如下
InputStream is = new FileInputStream(this.excelFile);
Workbook wbk = Workbook.getWorkbook(is);
Sheet sheet1 = wbk.getSheet(0);
for(int i =0;i<sheet1.getRows();i++){
for(int j=0;j<sheet1.getColumns();j++){
Cell cell = sheet1.getCell(j, i);
//这个地方就可以把数据提取出来了
System.out.print(cell.getContents()+"\t");
} System.out.println();
}
wbk.close();
is.close();