search

TouK / excel-export

excel-export grails plugin
58 stars 32 forks source link

Format data the same as input template #52

Open thornjad opened 7 years ago

thornjad commented 7 years ago

The data I'm putting into Excel files is coming from SQL queries, and a few columns are percentages comparing other columns. To get them to come out formatted as percentages, I pass in a template which has the correct columns formatted that way. However, the file which comes out of excel-export leaves these as 'general'.

Is there some way to format them correctly? Is this a bug or missing feature?

thornjad commented 7 years ago

I've since found some methods in the Apache API on how to change the cell formats. As such, I suppose I'm turning this to a feature request. I'd like to be able to input an Excel template, with the columns formatted the way I want, then have the output Excel have the same formats.