With release-0.7: missing percentage convertion and floating convertion
Thanks a lot for your great work. It is really helpful. Depending on the xlsx received, I can see a large mismatch between the xlsx converted into csv by excel and xlsx2csv:
- some percentage in xlsx are converted into floating
- some floating numbers are converted using the python presentation of numbers (i.e. 0.949 is converted in 0.94899999999999995 by xlsx)
Both issues are related. It appears there are missing accuracies in FORMATS table. Here is the part of the table I used: '0' : 'float', '0.00' : 'float', '0.000' : 'float', '0.0000' : 'float', '0.00000' : 'float', '0.000000' : 'float', '0.0000000' : 'float', '#,##0' : 'float', '#,##0.00' : 'float', '0%' : 'percentage', '0.0%' : 'percentage', '0.00%' : 'percentage', '0.000%' : 'percentage', '0.0000%' : 'percentage', '0.00000%' : 'percentage', '0.000000%' : 'percentage', '0.0000000%' : 'percentage',
Do you think you can take into account this accuracy issue with support of percentage ? Thanks in advance for your answer Charlybonobo
change these codes can support percentage value in temporary situation
@dooonabe can you create a pull request?