Excel files and filter data

Help Studio
, ,
1

Excel Application Scope: The source contains no DataRows.
what the error please explain me
thank you,

2

Hey @UJJVAL_BHAGAT
It might occur if the data in the Excel is missing. You can verify if the path, sheet name, etc., are passed correctly.

3

@UJJVAL_BHAGAT

As per error either excel is empty

Or

The cell or range you are giving is not having data

Or

You are giving a cell number to start read from but the data does not start from there

Cheers

4

Hi @UJJVAL_BHAGAT

This error could happen if the Excel file is empty, if you specified the wrong sheet or range, or if the data is not formatted correctly

Regards,

5

@UJJVAL_BHAGAT

1.Ensure that the DataTable you are working with contains data. If you are reading from an Excel file, make sure the file is not empty and that the specified range in the Read Range activity is correct.
2.If you are filtering the DataTable based on certain conditions, verify that there are rows in the DataTable that match the specified criteria.

Cheers!!

6

Hi @UJJVAL_BHAGAT

Ensure that the file is in a format that UiPath can handle. UiPath supports various Excel file formats, including .xls and .xlsx. If your file is in a different format, consider converting it to a supported format.

7

Hi @UJJVAL_BHAGAT,

Please try to count number of rows in your DataTable first then perform any operation on it.

dt_Test.RowCount.ToString

image
image1920×1018 89.6 KB

8

@UJJVAL_BHAGAT

-The Excel file you are reading might be empty, or the specified sheet within the Excel file does not contain any data.
-Ensure that you are specifying the correct sheet name in the Excel Application Scope. If the sheet name is misspelled or doesn’t exist in the Excel file, it won’t find any rows.
-If you are using activities like Read Range or Write Range, make sure that the specified range covers the actual data in the Excel sheet. If the range is set to a region where there are no data rows, it will result in an empty DataTable.