Format data the same as input template

[thornjad]

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]

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.