[pyxl] xlrd-0.8.0 .xlsx formatting_info=True not implemented

[Albert-Jan Roskam]

Hi,

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.
http://cran.r-project.org/web/packages/XLConnect/vignettes/XLConnect.pdf
This is another package I just saw for the first time

http://cran.r-project.org/web/packages/xlsx/xlsx.pdf

 
Regards,
Albert-Jan


~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
All right, but apart from the sanitation, the medicine, education, wine, public order, irrigation, roads, a 
fresh water system, and public health, what have the Romans ever done for us?
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~ 


>________________________________
> From: "python-excel at raf.org" <python-excel at raf.org>
>To: python-excel at googlegroups.com; Python List <python-list at python.org> 
>Sent: Thursday, August 30, 2012 4:57 AM
>Subject: Re: [pyxl] xlrd-0.8.0 .xlsx formatting_info=True not implemented
> 
>John Yeung wrote:
>
>> > is there any other way to tell how many digits excel would round to
>> > when displaying a floating point number? that's my only reason for
>> > needing formatting_info=True.
>> 
>> I have not personally used it, but OpenPyXL is another option for
>> working with .xlsx files, and it might provide the formatting info you
>> need:
>> 
>>  http://packages.python.org/openpyxl/index.html
>>  http://pypi.python.org/pypi/openpyxl/1.5.8
>> 
>> John Y.
>
>thanks but openpyxl doesn't work well enough.
>most of the spreadsheets i need to read contain
>dropdown lists with data validation using a named
>formula like: OFFSET(Data!$K$2,0,0,COUNTA(Data!$K:$K),1)
>which causes openpyxl to throw a NamedRangeException.
>i don't even care about the named objects. i just want
>to know what's in the cell, not what other possible
>values the cell might have had. :-)
>
>apart from that, it does give access to number formats
>so your suggestion would work for simpler spreadsheets.
>
>hopefully the intention that xlrd not support formats in xlsx
>files will change one day into an intention to support them. :-)
>
>until then my users can keep manually saving xlsx files they
>receive as xls before importing them. :-(
>
>maybe i need to investigate some perl modules or pyuno instead.
>perl's Spreadsheet::XSLX module handles formats. it gets the
>date formats a bit wrong but it's workaroundable.
>
>cheers,
>raf
>
>-- 
>You received this message because you are subscribed to the Google Groups "python-excel" group.
>To post to this group, send an email to python-excel at googlegroups.com.
>To unsubscribe from this group, send email to python-excel+unsubscribe at googlegroups.com.
>For more options, visit this group at http://groups.google.com/group/python-excel?hl=en-GB.
>
>
>
>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://mail.python.org/pipermail/python-list/attachments/20120831/2b15f778/attachment.html>