I used ReadRange, then watched the value of dt and noticed a difference between dt and dt.Rows(). item1 is missing in dt.Rows() value. Could you please help explain this? <a class="lightbox" href="https://global.discourse-cdn.com/uipath/original/4X/1/6/7/1679d8921291cdad1ef983c230f1b709eb114694.png" data-download-href="/uploads/short-url/3cPyBy7Vk4lWwRMT759aCA7oJ0M.png?dl=1" title="The image shows the debugging interface of UiPath Studio, where a "Read Range Workbook" activity reads data from an Excel file, and the "Watch" panel displays the values of variables 'dt' and 'dt.Rows()'. (Captioned by AI)" rel="noopener nofollow ugc">[The image shows the debugging interface of UiPath Studio, where a "Read Range Workbook" activity reads data from an Excel file…

Missing item in DataTable

Anonymous_iL (Ivan) October 28, 2024, 5:30pm 7

Thanks @AkshaySandhu @Anil_G
I solved it by removing Add header checkbox of Read Range activity.

2 Likes

Forum Engagement Daily Reports

Topic		Replies	Views
Read Range misses a Column Studio studio , read-range , excelreadcolumn	3	1712	September 12, 2021
Problem with read range activity in excel Help	5	10510	October 29, 2018
Variant following the Read Range - Headers Help datatable , excel , studio	5	1971	September 16, 2019
Skipping header line Studio studio , question , activities_panel	6	2353	June 7, 2021
Handling Excel Column Headers Not in the First Row for 'Select' Queries in UiPath Activities datatable , excel , activities , studio , question	2	671	January 12, 2024