floating errors about xlsx2csv HOT 2 CLOSED

it should be fixed
1fd32ec

from xlsx2csv.

I'm having issues with Excel storing unrepresentable numbers in sheet1.xml in the following way:

3.4000000000000004
7.3999999999999995

The above are displayed in Excel as 3.4 and 7.4 regardless of display precision: when set to 20 decimals, the first is displayed as 3.40000000000000000000

Your fix to #28 is the following on line 330:

                    elif format_type == 'float' and ('E' in self.data or 'e' in self.data):
                        self.data = ("%f" %(float(self.data))).rstrip('0').rstrip('.')

My problem seems ot be solved by removing the test for Exponential notation and applying the conversion regardless, in effect changing your code to:

                    elif format_type == 'float' and :
                        self.data = ("%f" %(float(self.data))).rstrip('0').rstrip('.')

I'm not sure this wouldn't break anything, but I would appreciate to see it incorporated, maybe as an optional flag to your code, which by the way, is great!

Thanks

from xlsx2csv.