Hxuening的博客

maven版本 <dependency> <groupId>org.apache.poi</groupId> <artifactId>poi</artifactId> <version>3.15</version> </dependency> 包 import org.apache.poi.ss.usermodel.Cell;

例如 我合并第一的1 2 3 列 CellRangeAddress callRangeAddress = new CellRangeAddress(0,0,1,3);//起始行,结束行,起始列,结束列 sheet.addMergedRegion(callRangeAddress); 在合并4 5 列 CellRangeAddress callRangeAddress = new CellRangeAddress(0,0,4,5);//起始行,结束行,起始列,结束列 sheet.addMer

java导入导出excel表格 一.导出 public void poiExport(Long[] ids, HttpServletRequest request, HttpServletResponse response) { String orderBatchSn = ""; // 创建HSSFWorkbook对象(excel的文档对象) HSSFWorkbook wb = new HSSFWorkbook(); // 建立新的sh