Excel File Connector - How to update

Nick_Bertz

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

BlueRooster

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.

 

https://knowledge.domo.com/Connect/Connecting_to_Data_with_Connectors/Configuring_Each_Connector/File_Upload_Connector

 

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.

BlueRooster

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.

 

https://knowledge.domo.com/Connect/Connecting_to_Data_with_Connectors/Configuring_Each_Connector/File_Upload_Connector

 

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.