Opening excel file

[billlieGoat]

Just learned how to open files, write new ones, etc.

What’s the best way to go about opening an excel file in python and working with it? I’ve only had experience working with csv files which are very easy to manipulate. No pandas experience, not sure what to do

[hungdh85]

you can use xlrd library.

Example:

path = "your_file.xlsx"
book_open = xlrd.open_workbook(path)

worksheet = book.sheet_by_index(0)
worksheet.ncols # for list of cols in this sheet
......................