Excel File Connector - How to update
Hello,
The excel file connector, which allows us to quickly load an excel file to a Domo Dataset, is quick and easy.
My question is, if you add a row of data to the Excel file how do you quickly update your dataset with that new row of data?
There doesn't appear to be the option to "Run Now" which you see in the wrench menu of some of the other types of connectors.
Is an excel update possible? (Trying to avoid workbench, and using other cloud storage connectors).
Thanks,
Nick
Best Answer
-
Nick,
I would switch to the File Upload connector type. This was the upgrade for csv, xls, xlsx connector types. The File Upload connector type will allow you to "Run Now" from the wrench in the top right of the connector properties and have your Excel files get updated.Hope this helps,
ValiantSpur
**Please mark "Accept as Solution" if this post solves your problem
**Say "Thanks" by clicking the "heart" in the post that helped you.1
Answers
-
Nick,
I would switch to the File Upload connector type. This was the upgrade for csv, xls, xlsx connector types. The File Upload connector type will allow you to "Run Now" from the wrench in the top right of the connector properties and have your Excel files get updated.Hope this helps,
ValiantSpur
**Please mark "Accept as Solution" if this post solves your problem
**Say "Thanks" by clicking the "heart" in the post that helped you.1
Categories
- 10.5K All Categories
- 7 Connect
- 917 Connectors
- 250 Workbench
- 463 Transform
- 1.7K Magic ETL
- 69 SQL DataFlows
- 476 Datasets
- 190 Visualize
- 252 Beast Mode
- 2.1K Charting
- 11 Variables
- 17 Automate
- 354 APIs & Domo Developer
- 89 Apps
- 3 Workflows
- 20 Predict
- 5 Jupyter Workspaces
- 15 R & Python Tiles
- 246 Distribute
- 62 Domo Everywhere
- 243 Scheduled Reports
- 21 Manage
- 42 Governance & Security
- 173 Product Ideas
- 1.2K Ideas Exchange
- 12 Community Forums
- 27 Getting Started
- 14 Community Member Introductions
- 55 Community News
- 4.5K Archive