-
-
Notifications
You must be signed in to change notification settings - Fork 133
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
issue with parsing to String value that is Double or BigInteger #318
Comments
Thank you for contributing to Poiji! Feel free to create a PR If you want to contribute directly :) |
Hi @dashayakubovich , Hmm interesting... could you share your excel file with me, if you don't mind? |
example.xlsx |
Apparently, in your excel file, you have predefined special formats for numbers in your cells. The problematic format number that your excel is using by default is 165. We need to remove that format from the style table using the following approach in Poiji:
I hope it helps your problem. You can check how to modify number formats in your excels at https://github.com/ozlerhakan/poiji?tab=readme-ov-file#modify-cells-formats |
@ozlerhakan |
You can check what format number each cell is using with https://github.com/ozlerhakan/poiji?tab=readme-ov-file#debug-cells-formats and once you have the number, you can update it accordingly. |
Hi! @ozlerhakan
![image](https://private-user-images.githubusercontent.com/170344873/332113603-83e500a1-a1f8-469b-82d3-ee6b1cdb5885.png?jwt=eyJhbGciOiJIUzI1NiIsInR5cCI6IkpXVCJ9.eyJpc3MiOiJnaXRodWIuY29tIiwiYXVkIjoicmF3LmdpdGh1YnVzZXJjb250ZW50LmNvbSIsImtleSI6ImtleTUiLCJleHAiOjE3MjA4ODg3ODMsIm5iZiI6MTcyMDg4ODQ4MywicGF0aCI6Ii8xNzAzNDQ4NzMvMzMyMTEzNjAzLTgzZTUwMGExLWExZjgtNDY5Yi04MmQzLWVlNmIxY2RiNTg4NS5wbmc_WC1BbXotQWxnb3JpdGhtPUFXUzQtSE1BQy1TSEEyNTYmWC1BbXotQ3JlZGVudGlhbD1BS0lBVkNPRFlMU0E1M1BRSzRaQSUyRjIwMjQwNzEzJTJGdXMtZWFzdC0xJTJGczMlMkZhd3M0X3JlcXVlc3QmWC1BbXotRGF0ZT0yMDI0MDcxM1QxNjM0NDNaJlgtQW16LUV4cGlyZXM9MzAwJlgtQW16LVNpZ25hdHVyZT1hNDJhZjAxNTU3NDBhY2I0YWM3Njg3NzBiMjI4N2E3Y2ZmNzE4NDdlY2Q5NjE5ZGNkNzE3NjgwM2Q5Njk0ZjI4JlgtQW16LVNpZ25lZEhlYWRlcnM9aG9zdCZhY3Rvcl9pZD0wJmtleV9pZD0wJnJlcG9faWQ9MCJ9.GzShvPxLvWry37-ymkfkV1JCaIWK9xmpWl_TRkbsoPU)
![image](https://private-user-images.githubusercontent.com/170344873/332113691-4c57ca30-8be4-4f0a-861a-0bd42ac8a624.png?jwt=eyJhbGciOiJIUzI1NiIsInR5cCI6IkpXVCJ9.eyJpc3MiOiJnaXRodWIuY29tIiwiYXVkIjoicmF3LmdpdGh1YnVzZXJjb250ZW50LmNvbSIsImtleSI6ImtleTUiLCJleHAiOjE3MjA4ODg3ODMsIm5iZiI6MTcyMDg4ODQ4MywicGF0aCI6Ii8xNzAzNDQ4NzMvMzMyMTEzNjkxLTRjNTdjYTMwLThiZTQtNGYwYS04NjFhLTBiZDQyYWM4YTYyNC5wbmc_WC1BbXotQWxnb3JpdGhtPUFXUzQtSE1BQy1TSEEyNTYmWC1BbXotQ3JlZGVudGlhbD1BS0lBVkNPRFlMU0E1M1BRSzRaQSUyRjIwMjQwNzEzJTJGdXMtZWFzdC0xJTJGczMlMkZhd3M0X3JlcXVlc3QmWC1BbXotRGF0ZT0yMDI0MDcxM1QxNjM0NDNaJlgtQW16LUV4cGlyZXM9MzAwJlgtQW16LVNpZ25hdHVyZT05NzhjMjgzZTI1MGU0Y2EzNDQzOWQzMDRiNmU1YzljYjRkOWM1ZTk5NzkzZjE4NTZhM2IzMzczY2NhZGIxMGI1JlgtQW16LVNpZ25lZEhlYWRlcnM9aG9zdCZhY3Rvcl9pZD0wJmtleV9pZD0wJnJlcG9faWQ9MCJ9.VpFrCy9hJZE53olaRXFE2dBtgjlLPHo4NGjFF3ppgkI)
![image](https://private-user-images.githubusercontent.com/170344873/332113996-8e47f2b1-4971-449c-8bf4-cf545ed5b4c2.png?jwt=eyJhbGciOiJIUzI1NiIsInR5cCI6IkpXVCJ9.eyJpc3MiOiJnaXRodWIuY29tIiwiYXVkIjoicmF3LmdpdGh1YnVzZXJjb250ZW50LmNvbSIsImtleSI6ImtleTUiLCJleHAiOjE3MjA4ODg3ODMsIm5iZiI6MTcyMDg4ODQ4MywicGF0aCI6Ii8xNzAzNDQ4NzMvMzMyMTEzOTk2LThlNDdmMmIxLTQ5NzEtNDQ5Yy04YmY0LWNmNTQ1ZWQ1YjRjMi5wbmc_WC1BbXotQWxnb3JpdGhtPUFXUzQtSE1BQy1TSEEyNTYmWC1BbXotQ3JlZGVudGlhbD1BS0lBVkNPRFlMU0E1M1BRSzRaQSUyRjIwMjQwNzEzJTJGdXMtZWFzdC0xJTJGczMlMkZhd3M0X3JlcXVlc3QmWC1BbXotRGF0ZT0yMDI0MDcxM1QxNjM0NDNaJlgtQW16LUV4cGlyZXM9MzAwJlgtQW16LVNpZ25hdHVyZT02NDRiNThjMGNmZTIwYjY5MDMwOGE3Nzg5OTI5Y2QxZTcwN2ExMTJkYzcyODQwOTg5NjQzYzdmYzFhZTdmYzNkJlgtQW16LVNpZ25lZEhlYWRlcnM9aG9zdCZhY3Rvcl9pZD0wJmtleV9pZD0wJnJlcG9faWQ9MCJ9.Qgv3xUpJOisgCMHSwXuw-eV-4arEdsgQG1x4_V590cA)
I use poiji and faced with the following issue:
can't parse to java String
but xlsx file has the following values
Can you help me understand what I am doing incorrectly?
The text was updated successfully, but these errors were encountered: