Reading fractional numbers not working
Status: Beta
Brought to you by:
yadra
Try making a new .xls file with some numbers in that contain fractions. If they're 'general'ly formatted, reading them with the PyXLReader (v1.3) script reads them as whole numbers.
If you have a formula which literally consists of '=A1' where the cell A1 contains a fractional number such as 0.15 it works fine and reports the value accurately.
I'm using Python 2.5 and Microsoft Excel 2000 (9.0.3821 SR-1).
Not sure if this project is still supported, but if anyone knows how to get this to work without some dodgy hacking of the spreadsheet I'd be very grateful to hear from you!
Cheers,
Jon