How to work on unstructured data in excel using UiPath?

Learn Academy Feedback
1

How to work on unstructured data in excel using UiPath? This excel contains formulas and macros in background? I Used Generate Table to get unstructured data from excel but, I am not able to get that data from excel? what might be the solution for this kind of situations?
Can some one respond with sample example.

2

Is there any sample data?? What is input and what is expected output??

3

Hi @johns,

A workaround is to create named Ranges in your Excel file and then use it in the Range Property when working with excel activities.

Happy Automating!

Regards,
PD

4

any success on this, john?