POI3.8 导出大数据excel

今天项目需要导出站点对应的频道展示，导出时使用的poi3.8中的HSSFWorkbook workBook =new HSSFWorkbook()；来创建workBook，但是在循环样式的时候，会报：

java.lang.IllegalStateException: The maximum number of cell styles was exceeded. You can define up to 4000 styles in a .xls workbook

详情见：

报错解决办法

SXSSFWorkbook workBook =new SXSSFWorkbook();

  
  
  

   
   
      @RequestMapping(value="/api/uploadExcelByPoi",method=RequestMethod.GET)

  
  
  
    public void uploadExcelByPoi(@RequestParam(value="chSiteId", required=true) Integer chSiteId,HttpServletRequest request,HttpServletResponse response){
		//查询需要的集合
    	List<FocChannel> list = focChannelsService.uploadExcelByPoi(chSiteId);
    	 //3.创建workbook  
    	SXSSFWorkbook workBook =new SXSSFWorkbook();
        //根据workBook创建sheet  
        Sheet sheet = workBook.createSheet("站点频道展示");
        //根据sheet创建行  
        Row rowHead = sheet.createRow(0);  
        //创建excel的头部标题行,及标题行的样式的设置
        createTitleCell(workBook,rowHead,sheet); 
        //创建主题内容
       buildMainbody(list, workBo