Read data in column and compare (Fast)

From previous to topic.

I have question.

If add condition , I want write sheetName ( sheet config) that found APPLAN in Column AG.

and now output show decimal —> I don’t decimal

Remark : I have data 4K , It take time to run.

Now it take time about 10 minute.

It’s probably because of the excel file. You can either change the data format after this process is completed. (alternative: you can also add a ’ before the text when it writes in the cell.)
It is taking time because of its’ dynamic process. It opens and reads the excel file each time, searches the table to get the amount of the particular APPLAN. If we could fix the DataTables; as done in the previous workflow; the process would have been way faster.

2 Likes