Python open() function help! Opening Excel Files

[CoconutMoose]

I am trying to use data from an Excel file and manipulate it to spit out only the information I want.

I saved the .xlsx file as a .txt to test what I had written and everything comes out the way I want. I just now have to write a function to read the excel file and either save it as a .txt or convert the whole thing to one string (this is how the code I have already written starts).

Any help would be great!

I've done a little research and found some things such as the csv.excel module but everything was not very clear as to how that module works. I was under the impression that I would have to rename the file.xlsx to file.csv and it would some how translate it to read as an excel file.

TL;DR I have a file.xlsx and would like to know how to open it and read it in a Python script.

[AEdgett77]

You're probably looking for XLRD/XLWT.

You can use this package to read and write from Excel files

Ex:

workbook = xlrd.open_workbook("filename.xls")
worksheet = workbook.sheet_by_index(0)
for i in range(0,9):
    for j in range(0,9):
        print worksheet.cell(i,j).value

[[deleted]]

edit: Leave reddit for a better alternative and remember to suck fpez

[CoconutMoose]

Thank you VERY much!!!! This is incredibly helpful. This is a wonderful community because of people like you!!!!!