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

Boolean values do not round-trip through Xlsx #351

Open
ajparsons opened this issue May 15, 2020 · 1 comment
Open

Boolean values do not round-trip through Xlsx #351

ajparsons opened this issue May 15, 2020 · 1 comment

Comments

@ajparsons
Copy link
Contributor

Something I ran into trying to round-trip BODS data was that if the JSON originally had a boolean value, putting this into and then out of XLSX converted it to a string (true > 'true'). It looks good in the XLSX, so I think this is happening when it is converted back.

@jpmckinney
Copy link
Contributor

jpmckinney commented Aug 12, 2020

@ajparsons I'm curious about your use case for round-tripping? In my experience, publishers might prepare data in tabular format, then convert to JSON; or users might download JSON data, then convert to CSV. I haven't actually heard a real use case for round-tripping (except some internal development needs, though I know round-tripping is a main feature/constraint of Flatten Tool), so I'm curious to hear more.

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