<html><body><div style="color:#000; background-color:#fff; font-family:times new roman, new york, times, serif;font-size:12pt">Hi,<br><br>As a work-around, you could use the CRAN R package XLConnect, using RPy or RPy2, to do what you want. IIRC it's based on Java, so it's not extremely fast.<br>http://cran.r-project.org/web/packages/XLConnect/vignettes/XLConnect.pdf<br>This is another package I just saw for the first time<br><div><span>http://cran.r-project.org/web/packages/xlsx/xlsx.pdf<br></span></div><div> </div><div>Regards,<br>Albert-Jan<br><br></div><div>~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~<br>All right, but apart from the sanitation, the medicine, education, wine, public order, irrigation, roads, a <br>fresh water system, and public health, what have the Romans ever done for us?<br>~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~ <br> <blockquote style="border-left: 2px solid
rgb(16, 16, 255); margin-left: 5px; margin-top: 5px; padding-left: 5px;"> <div style="font-family: times new roman, new york, times, serif; font-size: 12pt;"> <div style="font-family: times new roman, new york, times, serif; font-size: 12pt;"> <div dir="ltr"> <font face="Arial" size="2"> <hr size="1"> <b><span style="font-weight:bold;">From:</span></b> "python-excel@raf.org" <python-excel@raf.org><br> <b><span style="font-weight: bold;">To:</span></b> python-excel@googlegroups.com; Python List <python-list@python.org> <br> <b><span style="font-weight: bold;">Sent:</span></b> Thursday, August 30, 2012 4:57 AM<br> <b><span style="font-weight: bold;">Subject:</span></b> Re: [pyxl] xlrd-0.8.0 .xlsx formatting_info=True not implemented<br> </font> </div> <br>John Yeung wrote:<br><br>> > is there any other way to tell how many digits excel would round to<br>> > when displaying a floating point number? that's my only reason
for<br>> > needing formatting_info=True.<br>> <br>> I have not personally used it, but OpenPyXL is another option for<br>> working with .xlsx files, and it might provide the formatting info you<br>> need:<br>> <br>> <a href="http://packages.python.org/openpyxl/index.html" target="_blank">http://packages.python.org/openpyxl/index.html</a><br>> <a href="http://pypi.python.org/pypi/openpyxl/1.5.8" target="_blank">http://pypi.python.org/pypi/openpyxl/1.5.8</a><br>> <br>> John Y.<br><br>thanks but openpyxl doesn't work well enough.<br>most of the spreadsheets i need to read contain<br>dropdown lists with data validation using a named<br>formula like: OFFSET(Data!$K$2,0,0,COUNTA(Data!$K:$K),1)<br>which causes openpyxl to throw a NamedRangeException.<br>i don't even care about the named objects. i just want<br>to know what's in the cell, not what other possible<br>values the cell might have had. :-)<br><br>apart
from that, it does give access to number formats<br>so your suggestion would work for simpler spreadsheets.<br><br>hopefully the intention that xlrd not support formats in xlsx<br>files will change one day into an intention to support them. :-)<br><br>until then my users can keep manually saving xlsx files they<br>receive as xls before importing them. :-(<br><br>maybe i need to investigate some perl modules or pyuno instead.<br>perl's Spreadsheet::XSLX module handles formats. it gets the<br>date formats a bit wrong but it's workaroundable.<br><br>cheers,<br>raf<br><br>-- <br>You received this message because you are subscribed to the Google Groups "python-excel" group.<br>To post to this group, send an email to <a ymailto="mailto:python-excel@googlegroups.com" href="mailto:python-excel@googlegroups.com">python-excel@googlegroups.com</a>.<br>To unsubscribe from this group, send email to python-excel+<a ymailto="mailto:unsubscribe@googlegroups.com"
href="mailto:unsubscribe@googlegroups.com">unsubscribe@googlegroups.com</a>.<br>For more options, visit this group at <a href="http://groups.google.com/group/python-excel?hl=en-GB" target="_blank">http://groups.google.com/group/python-excel?hl=en-GB</a>.<br><br><br><br> </div> </div> </blockquote> </div></div></body></html>