Re: Excel (XML): how retrieve contents of cell

"T. Peter Herndon" <[email protected]>
Newsgroups gmane.comp.python.xml
Message-ID <[email protected]>
On Jun 3, 2005, at 4:50 PM, Leon Stevens wrote:

> 1. I'm comparatively new to Python, very new to XML
> 2. Running Python 2.3, with pyXML.
> 3. Using dom, and following example in "Python in a Nutshell", I've  
> coded a
> successfully running parse of a worksheet.
> 4. How do I access the contents of a cell (say, C3) from the XML  
> tree? The
> next question will then be to access the formula of that cell.
>
> I'm willing to read. What book(s)?
>

"Python Programming on Win32" by Hammond and Robinson, from  
O'Reilly.  At least, if you don't need XML.  Instead, use win32com  
automation to get the data directly from Excel.  If using XML is a  
requirement, I defer to others' experience, but I think you might be  
using the wrong tool for the job.

Also, I'd suggest Fredrik Lundh's ElementTree as a much friendlier  
XML toolkit.

HTH,

---Peter Herndon



_______________________________________________
XML-SIG maillist  -  [email protected]
http://mail.python.org/mailman/listinfo/xml-sig
lmpx.com only provides a reader for public news (NNTP) servers. It is not affiliated with the servers or forums shown here and is not responsible for the content of articles, which is written by their respective authors.