Grails批量导出excel（亲测10W级数据不会GC）

依赖

compile 'org.apache.poi:poi-scratchpad:3.10-FINAL'
compile "org.apache.poi:poi:3.14"
compile "org.apache.poi:poi-scratchpad:3.14"
compile "org.apache.poi:poi-ooxml:3.14"
compile "org.apache.poi:poi-ooxml-schemas:3.14"
compile "org.apache.poi:ooxml-schemas:1.3"

服务类

package com.common

import grails.transaction.Transactional
import org.apache.poi.hssf.usermodel.HSSFCellStyle
import org.apache.poi.hssf.usermodel.HSSFFont
import org.apache.poi.hssf.util.HSSFColor
import org.apache.poi.ss.usermodel.CellStyle
import org.apache.poi.ss.usermodel.Font
import org.apache.poi.ss.usermodel.Sheet
import org.apache.poi.xssf.streaming.SXSSFCell
import org.apache.poi.xssf.streaming.SXSSFRow
import org.apache.poi.xssf.streaming.SXSSFSheet
import org.apache.poi.xssf.streaming.SXSSFWorkbook
import org.apache.poi.xssf.usermodel.XSSFRichTextString

import javax.servlet.http.HttpServletResponse

@Transactional(readOnly = true)
class Exc