wb = xlrd.open_workbook(/path/myexcelfile.xls) sh = wb.sheet_by_index(0) for i in range(sh.nrows): print sh.row_values(i)

http://scienceoss.com/read-excel-files-from-python/

to read xlsx you can use it as well pen and read an Excel file """ book = xlrd.open_workbook(path) # print number of sheets print book.nsheets # print sheet names print book.sheet_names() # get the first worksheet first_sheet = book.sheet_by_index(0) # read a row print first_sheet.row_values(0) # read a cell cell = first_sheet.cell(0,0) print cell print cell.value # read a row slice print first_sheet.row_slice(rowx=0, start_colx=0, end_colx=2) 07.12.13

http://www.blog.pythonlibrary.org/2014/04/30/reading-excel-spreadsheets-with-python-and-xlrd/

Install into a debian os pip install xlrd to load Excel files with python w = xlrd.open_workbook('e.xls') s = w.sheet_by_index(0) for i in range(s.nrows): print(s.row_values(i)) 07.12.13

https://xlrd.readthedocs.io/en/latest/

• Home
• Notebook
• Contact us

• Privacy Statement
• 

Copyleft ☠ 2024