Refresh Excel Data in Excel Operation

Dear ETL Support,

Is there a function or a way to refresh an excel file? I have a connection embedded in the excel file and want to have refresh automation.

I have explored Excel Operation but it doesn't have that option. There is only Add sheet function.

Thanks.

Not sure I understand the question.

I assume you have an ODBC connection embedded into an excel file?

Hi admin,

Yes correct , there is an ODBC connection embedded into the excel file. Instead of opening the excel file and manually press the 'Refresh' button , in ETL Tools , is there a way to automatically refresh that excel file.


Thanks.

Thank you for your clarification

Our software will not refresh the excel file for you it can however pull the data from ODBC and update the file.

I found this article which you may find useful
community.spiceworks.com/topic/2129785-e...-with-task-scheduler