how to read the data from excel when it opened

[NiranjanK1]

Hi All,

I have an issue one excel always it is opened for edits, i want to read the data from Excel. is there a way can i read the data from excel

Thanks in Advance,

Nivin

[flying008]

Hi, @NiranjanK1 

FYI.

https://community.alteryx.com/t5/Community-Gallery/Input-Opened-Excel/ta-p/1181212 

[NiranjanK1]

@flying008 Thanks a lot for your reply,

In current organization they are not allowing outside macros. Is there a way can i solve it.

Is below logic will work?

Can i create a workflow store data in yxdb, when they are done with changes shall i ask them to refresh the workflow to get the upto date info from excel. I can read data from yxdb file.

Please suggest any other options.

Thanks in Advance

[flying008]

Hi, @NiranjanK1 

You can try it yourself. maybe you directly refresh the data from excel if use version as v2021.