> I would like to keep up with the development but would like to know
> which is the repo to follow. The Python-Excel website points to
> https://github.com/python-excel/xlrd, but that one does not have a 0.8.0
> tag (or at least did not have one when I looked a few days ago, and I
> unfortunately can't check now, from work).
Oops, I was very bad... not only did I forget to push the tag (it's annoying that you have to do a "git push --tags" to get tasg pushed) but I actually forgot to commit the final change that stamped on the 0.8.0 version number :-S
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.
> 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:
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:
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.
> 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
