Fetching value of formulated cell whose dependent values are filled through Alteryx

[sehgalsanchit92]

Hi All,

I have an excel where cell C1 has formula A1+B1. Through one branch i updated the values of cell A1 and B1. Now I want to read the updated C1 value from same file without user opening the file.

I need to upload the workflow on server, so vbscript or vba macro wont work on server as per org restrictions.

Can anyone please help in reading the updated values of formulated cell (C1)?

Note: creating the formulas in Alteryx is quite complex and would be difficult.

THANKS IN ADVANCE!!

[KGT]

So, you want to write data to an xlsx file, then execute the formulas in that, and then read the results. Without vba?

You could use the python tool to execute the formulas. I'm not sure on the method, but if it can be done in vba, someone will have done it in Python. You may have the same issue with executing on the server though unless you can build it using the base python packages included in Alteryx.

I think (without knowing for sure) that the better solution, and quicker, is probably going to be recreating those formulas in Alteryx.