【poi第六节】poi操作excel合并单元格,java合并excel单元格

x33g5p2x  于2021-12-28 转载在 其他  
字(0.8k)|赞(0)|评价(0)|浏览(460)

poi操作excel合并单元格,java合并excel单元格

  1. import org.apache.poi.hssf.usermodel.HSSFWorkbook;
  2. import org.apache.poi.ss.usermodel.Cell;
  3. import org.apache.poi.ss.usermodel.Row;
  4. import org.apache.poi.ss.usermodel.Sheet;
  5. import org.apache.poi.ss.usermodel.Workbook;
  6. import org.apache.poi.ss.util.CellRangeAddress;
  7. import java.io.FileNotFoundException;
  8. import java.io.FileOutputStream;
  9. /**
  10. * @ClassName 类名:ExcelDemo6
  11. * @Author作者: hzh
  12. * @Date时间:2018/12/4 14:56
  13. * 合并单元格
  14. **/
  15. public class ExcelDemo6 {
  16. public static void main(String[] args) throws Exception {
  17. Workbook wb = new HSSFWorkbook();
  18. Sheet sheet = wb.createSheet("hi sheet");
  19. Row row = sheet.createRow(1);
  20. Cell cell = row.createCell(1);
  21. cell.setCellValue("测试合并单元格");
  22. sheet.addMergedRegion(new CellRangeAddress(1, 2, 1, 3));
  23. FileOutputStream fileOutputStream = new FileOutputStream("D://file//合并.xls");
  24. wb.write(fileOutputStream);
  25. wb.close();
  26. }
  27. }

相关文章