Importing from Excel Files
How to import a Excel file into Mito.
Version requirements: Importing XLSX files is only supported on Python version greater than 3.6, and Pandas version greater than or equal to 1.0.
Importing multiple tabs from a single Excel file
Click on the
Import
button in the Mito toolbar.Select the
Import Files
option that appears in the dropdown.Use the file browser to navigate to the directory and XLSX file you want to import.
Click on the file, and then click the
Import
button. This will open a configuration screen.Configure which tabs you want to import from the Excel file.
Set any additional configuration necessary for your import:
Has Header Row
: Select "Yes" if Mito should set the first non-skipped row as the column headers. Select "No" if Mito should generate column headersNumber of Rows to Skip
: The number of rows at the top of the file to skip when reading data into the dataframe.Decimal Separator
: The character used to separate the decimal places in numbers.
Click
Import Selected Sheets
. For each tab you selected to import, a tab will appear in the mitosheet with this data.
Importing Specific Ranges from a single Excel Sheet
Click on the file, and then click the
Import
button. This will open a configuration screen.Use the file browser to navigate to the directory and XLSX file you want to import.
Select the
Import Files
option that appears in the dropdown.Click on the
Import
button in the Mito toolbar.Select the single sheet you wish to import specific ranges from. An additional option will appear in the taskpane asking if you want to import multiple ranges from this sheet, click this.
Click the
+ Add
button to add additional ranges.
Configure the imported range
Name the dataframe you are importing.
Configure how to locate th start of the dataframe:
Exact Range
: Import based on address like A10:C100, where you give the exact location of the dataframe.Upper Left Corner
: Input the value at the upper left corner of the dataframe. Mito will keep taking columns until an empty cell is hit.
If you selected
Upper Left Corner
, configure how to find the end of the dataframe:First Empty Cell
: Mito will scan the column where theUpper Left Corner
is found until the first empty cell is found. This will determine the end of the dataframe.Bottom Left Corner
: Mito will scan the column where theUpper Left Corner
is found until theBottom Left Corner
value is found.
Click import to read in the specific ranges you have configured above.
Last updated