UiPath.Excel.ExcelException: The source data has no rows or columns

I get this error every new day I login and run my automation. This is fixed by manually editing the ‘extract table data’ activity by selecting the rows & columns from the source data (Chrome browser). Is there a way to fix this?

Using StudioX Community 2024.

Hi @Tejas_Chavan

Compare the previous day extract data tale selector and Current selector find the where the selector is exactly changing based on that you keep the common selector maybe ID, aaname like that you can choose.

Regards,
Gowtham K

Hi @Gowtham_K115 ,

Would you be able to answer a few questions to help us understand a bit more about the issue you are facing?

  • What error are you getting when running the automation?
  • What version of UIAutomation are you using?
  • Are you extracting data from a Data Table using the activities? If so, is there anything changing in the ui from one day to the other?

Many thanks,
Raluca

Hi @Gowtham_K115 , would you be able to help us investigate this further by providing a bit more details around the use case you are automating:

  • What error are you getting when running the automation?
  • What version of UIAutomation are you using?
  • Are you extracting data from a Data Table using the activities? If so, is there anything changing in the ui from one day to the other?

Many thanks,
Raluca

This topic was automatically closed after 2 days. New replies are no longer allowed.