[Tutor] converting xls to csv
burgess.nick at gmail.com
Sun May 31 11:09:11 CEST 2009
Thank you for your response and my apologies for the non-useful
output. After searching again this task has been done by
pyExcelerator, the tool xls2csv-gerry.py does this great. I am now
trying to parse through the csv's and return the rows containing the
matching strings. Python is looking for string or buffer, this method
worked from a text search script, I am stumped on this for now.
pattern = re.compile(r'10\.229\.127\.255')
spamReader = csv.reader(open('MasterIPList.csv'), delimiter=' ', quotechar='|')
for row in spamReader:
print ', '.join(row)
Traceback (most recent call last):
File "F:\python\MastIPparse.py", line 9, in <module>
TypeError: expected string or buffer
When I comment out line 9 it returns all of the rows, so I now its reading OK..
Thanks for your time,
On Sun, May 31, 2009 at 3:57 AM, Alan Gauld <alan.gauld at btinternet.com> wrote:
> "Nick Burgess" <burgess.nick at gmail.com> wrote
>> I am trying to make this code work. I don't have any experience with
>> defining things and this is my second program. The error returmed is
>> "SyntaxError: invalid syntax"
> Please post the whole error message, much of the useful stufff - like the
> location of the problem! - is in the earlier lines.
> However taking a wild guess - are you using Python v3?
>> print "------ beginning to convert XLS to CSV ------"
> If so print is now a function so you need to surround the string with ()
> But if you are not using v3, then please send the fuill error text.
> Alan Gauld
> Author of the Learn to Program web site
> Tutor maillist - Tutor at python.org
More information about the Tutor