java POI读取Excel文件
发布时间:2020-12-14 23:53:23 所属栏目:Java 来源:网络整理
导读:今天PHP站长网 52php.cn把收集自互联网的代码分享给大家,仅供参考。 import java.io.File;import java.io.FileInputStream;import java.io.FileNotFoundException;import java.io.FileOutputStream;import java.io.IOExc
以下代码由PHP站长网 52php.cn收集自互联网 现在PHP站长网小编把它分享给大家,仅供参考 import java.io.File; import java.io.FileInputStream; import java.io.FileNotFoundException; import java.io.FileOutputStream; import java.io.IOException; import java.util.ArrayList; import java.util.Iterator; import java.util.List; import java.util.Map; import org.apache.commons.logging.Log; import org.apache.commons.logging.LogFactory; import org.apache.poi.hssf.usermodel.HSSFCell; import org.apache.poi.hssf.usermodel.HSSFRow; import org.apache.poi.hssf.usermodel.HSSFSheet; import org.apache.poi.hssf.usermodel.HSSFWorkbook; import org.apache.poi.poifs.filesystem.POIFSFileSystem; import com.neusoft.counter.vo.LoginIdStaffNo; public class ExcelDemo { private static final Log log = LogFactory.getLog(ExcelDemo.class); public List parseExcel(File in) { List arrayList = new ArrayList(); FileInputStream fis = null; POIFSFileSystem fs = null; try { fis = new FileInputStream(in); fs = new POIFSFileSystem(fis); HSSFWorkbook wb = new HSSFWorkbook(fs); // first sheet HSSFSheet sheet = wb.getSheetAt(0); int lastRow = sheet.getLastRowNum(); HSSFRow row = null; HSSFCell cell = null; int columnNum = row.getLastCellNum(); String data[] = new String[2]; // 读取Excel表格 for (int i = 1; i <= lastRow; i++) { // 行循环 row = sheet.getRow(i); for (int j = 0; j < columnNum; j++) { // 列循环 cell = row.getCell((short) j); if (cell != null && cell.getCellType() != HSSFCell.CELL_TYPE_BLANK) { data[j] = cell.getStringCellValue().trim(); } } // TODO add to List } } catch (FileNotFoundException e) { log.error(e); } catch (IOException e) { log.error(e); } return arrayList; } public void writeToExcel(Map map,File outFile) throws IOException { if (map == null) { log.info("没有输出到excel的数据!"); return; } HSSFWorkbook wb = new HSSFWorkbook(); HSSFSheet sheet = wb.createSheet(); // 标题 HSSFRow title = sheet.createRow(0); HSSFCell userCell = title.createCell((short) 0),staffCell = title .createCell((short) 1),_infoCell = title.createCell((short) 2); userCell.setEncoding(HSSFCell.ENCODING_UTF_16); userCell.setCellValue("后台用户"); staffCell.setEncoding(HSSFCell.ENCODING_UTF_16); staffCell.setCellValue("柜员号"); _infoCell.setEncoding(HSSFCell.ENCODING_UTF_16); _infoCell.setCellValue("失败原因"); for (Iterator itr = map.keySet().iterator(); itr.hasNext();) { String key = (String) itr.next(); List list = (List) map.get(key); String info = ""; if ("1".equals(key)) info = "后台用户不存在"; else if ("2".equals(key)) info = "柜员号重复"; else if ("3".equals(key)) info = "插入数据库出错"; appendToSheet(sheet,list,info); } FileOutputStream fos = new FileOutputStream(outFile); wb.write(fos); fos.close(); } private void appendToSheet(HSSFSheet sheet,List datas,String info) { if (datas == null) return; int offset = sheet.getLastRowNum(); int size = datas.size(); for (int i = 0; i < size; i++) { LoginIdStaffNo ls = (LoginIdStaffNo) datas.get(i); HSSFRow row = sheet.createRow(offset + i + 1); row.createCell((short) 0).setCellValue(ls.getUserLoginId()); row.createCell((short) 1).setCellValue(ls.getStaffNo()); HSSFCell infoCell = row.createCell((short) 2); infoCell.setEncoding(HSSFCell.ENCODING_UTF_16); infoCell.setCellValue(info); } } } 以上内容由PHP站长网【52php.cn】收集整理供大家参考研究 如果以上内容对您有帮助,欢迎收藏、点赞、推荐、分享。 (编辑:李大同) 【声明】本站内容均来自网络,其相关言论仅代表作者个人观点,不代表本站立场。若无意侵犯到您的权利,请及时与联系站长删除相关内容! |