pyexcel.get_records

pyexcel.get_records(name_columns_by_row=0, **keywords)

Obtain a list of records from an excel source

It accepts the same parameters as get_sheet() but return a list of dictionary(records) instead.

Specifically: :param name_columns_by_row: specify a row to be a dictionary key. It is default to 0 or first row.

If you would use a column index 0 instead, you should do:

get_records(name_columns_by_row=-1, name_rows_by_column=0)