pyexcel_io.get_data

pyexcel_io.get_data(afile, file_type=None, streaming=False, **keywords)[source]

Get data from an excel file source

Parameters:
  • filename – actual 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
  • keywords – any other parameters
Returns:

an array if it is a single sheet, an ordered dictionary otherwise