atomica.excel.read_dataframes

atomica.excel.read_dataframes(worksheet, merge=False)[source]

Read dataframes from sheet

This function operates similarly to read_tables except it returns Dataframes instead of cells. This enables the dataframes to be constructed more quickly, at the expense of being able to track the cell references and row numbers. These are shown for databooks (via read_tables) but not for frameworks (which go via read_dataframes)

Parameters:

  • worksheet – An openpyxl worksheet

  • merge – If False (default) then blank rows will be used to split the dataframes. If True, only one DataFrame will be returned

Return type:

list

Returns:

A list of DataFrames