Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

Is there a way to set the datatypes of columns/cells in excel other than general or string #43

Open
ssjman opened this issue Feb 3, 2016 · 2 comments

Comments

@ssjman
Copy link
Contributor

ssjman commented Feb 3, 2016

Where I am using this plugin I am exporting records with Currency values using a CurrencyGetter. In the excel file every column/cell is formatted to a string. This means the when the user attempts to auto sum a column that should be a money value they cannot. Is there a way to set the actual datatype of columns to things such as date, number, etc using this plugin? I know I can do it using POI.

@thornjad
Copy link

thornjad commented Jun 15, 2017

Has this issue been addressed? I was able to set the format to number for some numbers, but numbers come out as general, and I can't get percentages to work.

@thornjad
Copy link

There is a way to format them using the Apache API directly, but it's a little more low-level than having it done automatically by this plugin. See #52

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
None yet
Projects
None yet
Development

No branches or pull requests

2 participants