<DIV>Danny and John,</DIV>
<DIV> </DIV>
<DIV>Thanks for the pointers. As I am leaving the project where I need to do this tomorrow, I don't think I will have time to do this, but thanks for the help anyway.</DIV>
<DIV> </DIV>
<DIV>David<BR><BR><B><I>Danny Yoo <dyoo@hkn.eecs.berkeley.edu></I></B> wrote:</DIV>
<BLOCKQUOTE class=replbq style="PADDING-LEFT: 5px; MARGIN-LEFT: 5px; BORDER-LEFT: #1010ff 2px solid"><BR><BR>On Wed, 27 Jul 2005, David Holland wrote:<BR><BR>> I know how to open files in python, however what I want to do is select<BR>> some information from an excel spreadsheet and save it as a .dat file.<BR><BR>Hi David,<BR><BR>Excel spreadsheets are a bit more difficult to work with. They're not<BR>plain text files, but have their own internal binary format, so you'll<BR>probably need a library to deal with them. Many people deal with Excel by<BR>either converting the files to something plain-textish, like the 'csv'<BR>format, or they get Python to talk to Excel directly.<BR><BR>If you can output your excel spreadsheet in 'csv' format, then Python's<BR>'csv' module should be useful:<BR><BR>http://www.python.org/doc/lib/module-csv.html<BR><BR>and doing the selection should just be a matter of skipping enough rows,<BR>in the file, and then paying attention to the particular
column you want.<BR><BR><BR>But if you want to go another route --- to talk closely with Excel ---<BR>that might take some more involvement, since it's so tightly bound with<BR>Windows programming. The book "Python Programming on Win32" has a<BR>chapter on how to talk to Excel through Python:<BR><BR>http://www.oreilly.com/catalog/pythonwin32/<BR><BR>and if you're interested in this approach, you may want to talk with the<BR>python-win32 folks:<BR><BR>http://mail.python.org/mailman/listinfo/python-win32<BR><BR><BR>Hope this helps!<BR><BR></BLOCKQUOTE><p>
<hr size=1><font face="Arial" size="2">How much free photo storage do you get? Store your holiday snaps for FREE with Yahoo! Photos. <a href="http://us.rd.yahoo.com/mail/uk/taglines/default/photos/*http://uk.photos.yahoo.com/"><b>Get Yahoo!
Photos</b></a></font>