What is the best approach for working with Excel in UiPath? In VBA you create an instance of Excel, Workbook, Worksheets, Sheets, Ranges, etc. then loop through the collection. UiPath seem to want to return the data in the file into a datatable, which requires you to work with the data outside of Excel. UiPath seems to assume you know the layout of the file.
For my current project I really need to work with the data directly in Excel since the files aren’t uniform in the number of sheets and structure of the data. I need to loop through the sheets and data within each sheet to find what I am looking for and update the data accordingly.
Is this approach plausible in UiPath?