poi使用问题总结
poi是由apache开发的分析微软office文档的工具包,其中比较常用的是excel组件。以下总结遇到的几个问题。
1.兼容07和03时的bug
public static Workbook getWorkbook(InputStream is) { Workbook wb = null; try { // 2007 wb = new XSSFWorkbook(is); } catch (Exception e) { // 2003 try { wb = new HSSFWorkbook(is); } catch (Exception ex) { ex.printStackTrace(); } } return wb; }
java.io.IOException: Read error
public static Workbook getWorkbook(byte[] data) { Workbook wb = null; try { // 2007 wb = new XSSFWorkbook(new ByteArrayInputStream(data)); } catch (Exception e) { // 2003 try { wb = new HSSFWorkbook(new ByteArrayInputStream(data)); } catch (Exception ex) { ex.printStackTrace(); } } return wb; }
for(Row row : sheet) {}
nameCell=row.getCell(0);pwdCell=row.getCell(1);nicknameCell=row.getCell(2);genderCell=row.getCell(3);