Re: ANNOUNCE: xlrd 0.5.2 -- extract data from Excel spreadsheets

2006-03-30 Thread curt
the 2nd url seems to be a dead link? -- http://mail.python.org/mailman/listinfo/python-list

Re: ANNOUNCE: xlrd 0.5.2 -- extract data from Excel spreadsheets

2006-03-20 Thread Felipe Almeida Lessa
Em Seg, 2006-03-20 às 23:01 +1100, John Machin escreveu: > *ALL* [ho ho chuckle chuckle] > you need to do is step through the tokens and do something with the ones > that contain references. And contribute back the code? =) -- Felipe. -- http://mail.python.org/mailman/listinfo/python-list

Re: ANNOUNCE: xlrd 0.5.2 -- extract data from Excel spreadsheets

2006-03-20 Thread John Machin
On 20/03/2006 10:37 PM, jcmendez wrote: > Exactly. Yes, your requirement is exactly that, a list of references. > Once I get the formulas, I can do a weak parsing of them and > find the references. > A formula is not stored as input e.g. "(A1+A2)*3.0+$Z$29"; it's kept as an RPN stream of var

Re: ANNOUNCE: xlrd 0.5.2 -- extract data from Excel spreadsheets

2006-03-20 Thread jcmendez
Exactly. Once I get the formulas, I can do a weak parsing of them and find the references. -- http://mail.python.org/mailman/listinfo/python-list

Re: ANNOUNCE: xlrd 0.5.2 -- extract data from Excel spreadsheets

2006-03-20 Thread John Machin
On 20/03/2006 10:00 PM, jcmendez wrote: > Hi John > > I'd like to create a dependency graph and plot it with Graphviz. I've > played a bit with exporting the sheet in XML format, and parsing the > XML. That somehow works, but it would be much better if the users > wouldn't need to save as the sh

Re: ANNOUNCE: xlrd 0.5.2 -- extract data from Excel spreadsheets

2006-03-20 Thread jcmendez
Hi John I'd like to create a dependency graph and plot it with Graphviz. I've played a bit with exporting the sheet in XML format, and parsing the XML. That somehow works, but it would be much better if the users wouldn't need to save as the sheets, just put them is a shared directory where I ca

Re: ANNOUNCE: xlrd 0.5.2 -- extract data from Excel spreadsheets

2006-03-20 Thread John Machin
On 20/03/2006 9:28 PM, jcmendez wrote: > John > > Thanks for walking us through the comparison. On the xlrd website I > saw that it does not import formulas from the Excel files, which is > what I'm looking for. Any suggestions? > > Juan C. > Juan, what do you want to do with the formulas afte

Re: ANNOUNCE: xlrd 0.5.2 -- extract data from Excel spreadsheets

2006-03-20 Thread jcmendez
John Thanks for walking us through the comparison. On the xlrd website I saw that it does not import formulas from the Excel files, which is what I'm looking for. Any suggestions? Juan C. -- http://mail.python.org/mailman/listinfo/python-list

Re: ANNOUNCE: xlrd 0.5.2 -- extract data from Excel spreadsheets

2006-03-19 Thread Scott David Daniels
Kent Johnson wrote: > John Machin wrote: >> * Herewith the biased comparison: > > Thank you! Thank you (John) as well. I realize you are a bit reluctant to toot your own horn, but it is just this kind of biased comparison that let's us know whether to investigate further. It also helps th

Re: ANNOUNCE: xlrd 0.5.2 -- extract data from Excel spreadsheets

2006-03-19 Thread Kent Johnson
John Machin wrote: > On 19/03/2006 2:30 PM, Kent Johnson wrote: >>That didn't shed much light. I'm interested in your biased opinion, >>certainly you must have had a reason to write a new package. > > * It's not new. First public release was on 2005-05-15. When I started > writing it, there was

Re: ANNOUNCE: xlrd 0.5.2 -- extract data from Excel spreadsheets

2006-03-19 Thread John Machin
On 19/03/2006 2:30 PM, Kent Johnson wrote: > John Machin wrote: > >> On 19/03/2006 8:31 AM, Kent Johnson wrote: >> >>> How does xlrd compare with pyexcelerator? At a glance they look >>> pretty similar. >>> >> >> I have an obvious bias, so I'll just leave you with a not-very-PC >> analogy to thi

Re: ANNOUNCE: xlrd 0.5.2 -- extract data from Excel spreadsheets

2006-03-18 Thread Kent Johnson
John Machin wrote: > On 19/03/2006 8:31 AM, Kent Johnson wrote: >>How does xlrd compare with pyexcelerator? At a glance they look pretty >>similar. >> > > I have an obvious bias, so I'll just leave you with a not-very-PC > analogy to think about: > > Depending on the ambient light and the quant

Re: ANNOUNCE: xlrd 0.5.2 -- extract data from Excel spreadsheets

2006-03-18 Thread Waldemar Osuch
- xlrd seems to be focused on extracting data. - pyexcelerator can also generate Excel files. -- http://mail.python.org/mailman/listinfo/python-list

Re: ANNOUNCE: xlrd 0.5.2 -- extract data from Excel spreadsheets

2006-03-18 Thread John Machin
On 19/03/2006 8:31 AM, Kent Johnson wrote: > John Machin wrote: > >> I am pleased to announce a new general release (0.5.2) of xlrd, a Python >> package for extracting data from Microsoft Excel spreadsheets. > > > How does xlrd compare with pyexcelerator? At a glance they look pretty > similar.

Re: ANNOUNCE: xlrd 0.5.2 -- extract data from Excel spreadsheets

2006-03-18 Thread Kent Johnson
John Machin wrote: > I am pleased to announce a new general release (0.5.2) of xlrd, a Python > package for extracting data from Microsoft Excel spreadsheets. How does xlrd compare with pyexcelerator? At a glance they look pretty similar. Thanks, Kent -- http://mail.python.org/mailman/listinfo/

ANNOUNCE: xlrd 0.5.2 -- extract data from Excel spreadsheets

2006-03-18 Thread John Machin
I am pleased to announce a new general release (0.5.2) of xlrd, a Python package for extracting data from Microsoft Excel spreadsheets. CHANGES: * Book and sheet objects can now be pickled and unpickled. Instead of reading a large spreadsheet multiple times, consider pickling it once and loading