easypoi 生成excel .

lisztli

于 2020-09-11 11:00:06 发布

阅读量259

点赞数

分类专栏： java

本文链接：https://blog.csdn.net/lisztli/article/details/108530046

版权

本文介绍了如何利用easypoi库高效地生成Excel文件，包括设置工作簿、工作表、单元格样式等内容，适合Java开发者进行数据导出操作。

摘要由CSDN通过智能技术生成

public static void main(String args[]) throws Exception
	{
   
		  List<ExcelExportEntity> colList = new ArrayList<ExcelExportEntity>();
          ExcelExportEntity colEntity = new ExcelExportEntity("商品名称", "title");
          colEntity.setNeedMerge(true);
         
          colList.add(colEntity);

          colEntity = new ExcelExportEntity("供应商", "supplier");
          colEntity.setNeedMerge(true);
          colList.add(colEntity);

          ExcelExportEntity deliColGroup = new ExcelExportEntity("得力", "deli");
          List<ExcelExportEntity> deliColList = new ArrayList<ExcelExportEntity>();
          deliColList.add(new ExcelExportEntity("市场价", "orgPrice"));
          deliColList.add(new ExcelExportEntity("专区价", "salePrice"));
          deliColGroup.setList(deliColList);
          colList.add(deliColGroup);

          ExcelExportEntity jdColGroup = new ExcelExportEntity("京东", "jd");
          List<ExcelExportEntity> jdColList = new ArrayList<ExcelExportEntity>();
          jdColList.add(new ExcelExportEntity("市场价", "orgPrice"));
          jdColList.add(new ExcelExportEntity("专区价", "salePrice"