Jan-10-2019, 07:02 PM
I wrote once a very simple function that I think could help you
def fetch_xlsx(filename, maxcols = 10): """Return a list of rows (lists) extracted from an xlsx workbook """ from openpyxl.reader.excel import load_workbook database = [] wb=load_workbook(filename) for sheet in wb.worksheets: for row in sheet.rows: values=[] for i, cell in enumerate(row): if i >= maxcols: break values.append(cell.value) database.append(values) return database