Grails：如何将grails列表导出到Microsoft Excel？

我有一个包含信息的列表,我想将其导出到Excel.
我该怎么做？

“出口插件”有什么好处吗？我想我刚才看到将文件导出到Excel但我再也找不到了.

解决方法

编辑：更新了我的示例以在控制器中执行此操作.从结构上来说,将它分解一点会更有意义,但这只是为了举例.

import jxl.*
import jxl.write.*

class SomeController {

    def report = {
        def file = createReport(MyDomain.list())

        response.setHeader('Content-disposition','attachment;filename=Report.xls')
        response.setHeader('Content-length',"${file.size()}")

        OutputStream out = new BufferedOutputStream(response.outputStream)

        try {
            out.write(file.bytes)

        } finally {
            out.close()
            return false
        }
    }

    private File createReport(def list) {
        WorkbookSettings workbookSettings = new WorkbookSettings()
        workbookSettings.locale = Locale.default

        def file = File.createTempFile('myExcelDocument','.xls')
        file.deleteOnExit()

        WritableWorkbook workbook = Workbook.createWorkbook(file,workbookSettings)

        WritableFont font = new WritableFont(WritableFont.ARIAL,12)
        WritableCellFormat format = new WritableCellFormat(font)

        def row = 0
        WritableSheet sheet = workbook.createSheet('MySheet',0)

        list.each {
            // if list contains objects with 'foo' and 'bar' properties,this will
            // output one row per list item,with column A containing foo and column
            // B containing bar
            sheet.addCell(new Label(0,row,it.foo,format))
            sheet.addCell(new Label(1,row++,it.bar,format))
        }
    }
}

使用此库可以执行格式化,使用多个工作表等操作.

（编辑：青岛站长网）

【声明】本站内容均来自网络，其相关言论仅代表作者个人观点，不代表本站立场。若无意侵犯到您的权利，请及时与联系站长删除相关内容!