Menu

#3 Reading fractional numbers not working

open
nobody
None
5
2007-07-19
2007-07-19
Jon Cage
No

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

Discussion


Log in to post a comment.

MongoDB Logo MongoDB