HSSFWorkbook导入数据

HSSFWorkbook workbook = new HSSFWorkbook(stream);

HSSFSheet sheet = workbook.getSheetAt(0);

DataCell[] cells = new DataCell[] {

new DataCell("code", "A", DataCell.TYPE_STRING),

new DataCell("province", "B", DataCell.TYPE_STRING),

new DataCell("city", "C", DataCell.TYPE_STRING),

new DataCell("area", "D", DataCell.TYPE_STRING),

new DataCell("cityType", "E", DataCell.TYPE_STRING)

};

List<Map<String, Object>> list = PoiUtils.getRowDataset(sheet, 1, 0, cells);