November 8th, 2012, 01:07 PM
Working with Excel
Hello, i have the need to analyze some data that is in an Excel spreadsheet.
i need to look through lines of Excel file data and look for specific elements, and write them to a file, etc.
i know how to do everything except look at the Excel file using Python. Any suggestions?
Thanks very much.
November 8th, 2012, 04:38 PM
I don't think thats directly possible in python (not sure :/)
maybe an extensio library
but can't you just save the file in .csv format and open it with
(not sure long ago I used .csv)
with open('yourfile.csv', 'rb') as csvfile:
data = csv.reader(csvfile)
for row in data:
print( ', '.join(row))
otherwise, google is your friend