excel-export

excel-export copied to clipboard

Add support for loading "templates" from InputStream

2

WebXlsxExporter needs a constructor ``` WebXlsxExporter(InputStream stream) { ... } ``` to support loading of templates from resources. Right now the work around is: ``` def template =grailsApplication.parentContext.getResource("classpath:ReportTemplate.xlsx").inputStream tempFile =...

strelok1

Error : org.codehaus.groovy.grails.web.pages.exceptions.GroovyPagesException: Error processing GroovyPageView: getOutputStream() has already been called for this response Code: ``` def export() { def list = financialSettlementService.getDietitianList(params) def headers = ['Tax'] def withProperties =...

mikko1986

Example how to convert a result set (not a list of domain objects)

5

Please add an example of how to export a result set (not just list of domain objects)

hansgru

Create Grails 3.x compatible version

4

mansi90

I did it using: ``` getSheet().addMergedRegion(new CellRangeAddress(0,0,0,4)); ``` It could be useful a specific method

bartoleo

I did it using: ``` CellManipulationAbility.getOrCreateCellAt(4, 5, getSheet()).setCellFormula("SUM(A3:D3)") ``` it could be useful a method like putCellValue but for formulas: putCellFormula

bartoleo

Hi, we need to export domain entities with atribute: static hasMany = [ordersClient: OrderClient] The best solution is each item from ordersClient pass at new line... is it possible and...

Manas101

Hello I´m facing the issue when running that sample code package webserver import pl.touk.excel.export.* class ReportingService { ``` static transactional = false def caseReport(cases){ def caseList = cases def withProperties2...

ricardoul

Improve performance

2

Hi, Quick question regarding this awesome plugin. I'm using the following approach: ``` new WebXlsxExporter().with { setResponseHeaders(response) fillHeader(headers) fillRow(["aaa", "bbb", 13, new Date()], 1) save(response.outputStream) } ``` ... but the...

peetersn

images

5

What if I need to put and Image in a certain cell of each row?

tamershahin