We are using Smartbear TestComplete but tried Ranorex as well. It is capturing some parts of data but because the data is constantly changing the script is failing as it couldn't find that particular field. We then need to export this data to excel.
Is the dynamic data occurring in a web table? In that case, we can use the column headers as keys and fetch all elements inside the table and assign into a list/collection and then iterate them to find the data we require. It's regardless of tools, its just logic we build as a business with reusables.