xlrd-0.8.0 .xlsx formatting_info=True not imlemented
hi, i just tried xlrd-0.8.0 so as to be able to read xlsx files only to discover: NotImplementedError: formatting_info=True not yet implemented there's a post from 2009 stating that the current intention is to not support formatting_info: https://groups.google.com/forum/?fromgroups=#!topic/python-excel/Thso62fdiSk is that still the current intention? if so, 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. cheers, raf -- http://mail.python.org/mailman/listinfo/python-list
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 -- http://mail.python.org/mailman/listinfo/python-list
Re: [pyxl] xlrd-0.8.0 .xlsx formatting_info=True not implemented
Albert-Jan Roskam wrote: > 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 hi, many thanks for the suggestions but i've already implemented an alternative using perl and its Spreadsheet::XLSX module. cheers, raf -- http://mail.python.org/mailman/listinfo/python-list
Re: [pyxl] xlrd 0.7.2 released!
Chris Withers wrote: > Hi All, > > I'm pleased to announce the release of xlrd 0.7.2. This release, > like the xlwt release, is long overdue and has been over 2.5 years > in the making! > [...snip...] > > I've currently only put up .tar.gz sdists, if anyone requires > anything else, please explain why and I'll be happy to add! hi, a windows installer exe would be good for the same reasons it was good for previous versions. two reasons that spring to mind immediately are: - it makes it much easier to tell what version is installed - it makes it much easier to uninstall the package i know that both of these are things that the python community does not yet seem to find useful but everyone else seems to. for instance, if i just install the new versions of these packages on windows, it will replace the python-specific files that were associated with the previous version but it will have no impact on the system's list of installed software so if i look at the add/remove software control panel, it will happily tell me that i still have the previous versions. on the other hand, if the new versions were installed with windows installers, they would be able to properly replace the old versions with the new versions and make it clear that it has done do. knowing this, i will of course uninstall the old versions before installing the new versions so at least windows won't be forced to lie to me about what versions are installed. of course, i might be wrong about all of this and setup.py may manage the windows installed software list properly and do a proper upgrade. if so, sorry for wasting time. cheers, raf -- http://mail.python.org/mailman/listinfo/python-list
Re: [pyxl] xlrd 0.7.2 released!
Chris Withers wrote: > On 22/02/2012 00:37, python-ex...@raf.org wrote: > >was good for previous versions. two reasons that spring to mind > >immediately are: > > > > - it makes it much easier to tell what version is installed > > - it makes it much easier to uninstall the package > > > >i know that both of these are things that the python community > >does not yet seem to find useful but everyone else seems to. > > That's because it's no longer best practice to polute the global > python installation by installing packages directly into it. > > The recommended wisdom nowadays is to use a virtualenv and then pip > install the package. > > I believe that will give you everything you need, please explain if > it doesn't. > > cheers, > > Chris thanks. i'm sure that'll do nicely. cheers, raf -- http://mail.python.org/mailman/listinfo/python-list
