I have an Excel file in which the first sheet of the Excel file is Chart Sheet. This special sheet does not contain rows, columns, or cells, just a chart, like this:
When trying to get the range from the associated table on the second sheet (named “Dados”), UiPath returns an Exception:
After many attempts to understand why this happens, I have discovered that if the first sheet of the Excel file is a Chart Sheet (with no columns, no rows, no cells) UIPath gives the error.
If I change the file, and move the Chart Sheet to be second in order, then UIPath can execute the “Get Table Range” activity with no errors. So the problem here is when the first sheet is a special chart.
Does everybody has the same error behaviour?
(I am wondering if this is an issue of UIPath or my old Excel 2007).
If so, is it possible to change the order of the sheets in the Excel file?
I am attaching the Workflow and Excel file for you to simulate it.
ChartExcel.zip (15.1 KB)