larray.read_excel

larray.read_excel(filepath, sheetname=0, nb_index=None, index_col=None, fill_value=nan, na=nan, sort_rows=False, sort_columns=False, engine=None, **kwargs)

Reads excel file from sheet name and returns an LArray with the contents

Parameters:

filepath : str

Path where the Excel file has to be read.

sheetname : str, Group or int, optional

Name or index of the Excel sheet containing the array to be read. By default the array is read from the first sheet.

nb_index : int, optional

Number of leading index columns (ex. 4). Defaults to 1.

index_col : list, optional

List of columns for the index (ex. [0, 1, 2, 3]). Default to [0].

fill_value : scalar or LArray, optional

Value used to fill cells corresponding to label combinations which are not present in the input. Defaults to NaN.

sort_rows : bool, optional

Whether or not to sort the rows alphabetically (sorting is more efficient than not sorting). Defaults to False.

sort_columns : bool, optional

Whether or not to sort the columns alphabetically (sorting is more efficient than not sorting). Defaults to False.

engine : {‘xlrd’, ‘xlwings’}, optional

Engine to use to read the Excel file. If None (default), it will use ‘xlwings’ by default if the module is installed and relies on Pandas default reader otherwise.

**kwargs