pyexcel_io.get_data

pyexcel_io.get_data(afile, file_type=None, streaming=None, **keywords)

Get data from an excel file source

Parameters:

• afile – a file name, a file stream or actual content
• sheet_name – the name of the sheet to be loaded
• sheet_index – the index of the sheet to be loaded
• file_type – used only when filename is not a physial file name
• streaming – toggles the type of returned data. The values of the returned dictionary remain as generator if it is set to True. Default is False.
• library – explicitly name a library for use. e.g. library=’pyexcel-ods’
• auto_detect_float – defaults to True
• auto_detect_int – defaults to True
• auto_detect_datetime – defaults to True
• ignore_infinity – defaults to True
• keywords – any other library specific parameters

Returns:

an ordered dictionary