Can Mitto get the data from multiple sheets in an excel spreadsheet automatically (ie don’t have to specify the sheet name - it just goes through and adds a table for each sheet)?
The use case:
You have an Excel workbook with multiple tabs.
Is the end goal:
The end goal for the Excel workbook with multiple tabs is one database table that unions the data from each tab. Please add the feature request.
If I can get the client to split up their multiple-sheet excel file into separate sheets, could I use an Rclone Job to download the individual excel files from a cloud file service (ie onedrive), and then use the Regex Job to union all of these files together into a single DB table?
The original Excel file with tabs can be manually split into multiple Excel files or delimited files (csv, etc) or this could be done programatically.
Here’s a Stack Overflow thread on splitting an Excel workbook into multiple files with Python using pandas: python - splitting an Excel workbook into multiple excel files - Stack Overflow
After creating the Python script you can automate it with a Mitto Python job.