excel-export icon indicating copy to clipboard operation
excel-export copied to clipboard

Published 20 hours ago • verified publisher icon TouK

Format data the same as input template

Open thornjad opened this issue 8 years ago • 1 comments

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 avatar Jun 15 '17 19:06 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.

thornjad avatar Jun 16 '17 16:06 thornjad