xlsx2csv icon indicating copy to clipboard operation
xlsx2csv copied to clipboard

With release-0.7: missing percentage convertion and floating convertion

Open charlybonobo opened this issue 10 years ago • 2 comments

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

charlybonobo avatar Aug 27 '15 08:08 charlybonobo

image image change these codes can support percentage value in temporary situation

dooonabe avatar Apr 10 '24 09:04 dooonabe

@dooonabe can you create a pull request?

dilshod avatar Apr 10 '24 15:04 dilshod