Does anyone know the reason why when I use a read range activity to read an entire Excel spreadsheet, the datatable that is generated in UiPath does not have a consistent format?
What is happening is that I have for example, 2 Excel spreadsheets with the same template. The first row and first column in the spreadsheet is empty, for example. However, when I read range those two Excel spreadsheets with the same formatting, the datatable that is produced in UiPath is not the same. One datatable will have an empty first column, but the other one seemed to remove the empty column automatically.
Any clue why this is happening? It is messing up with my automation logic.