Hello, Can anyone please help me understand why datatable returns blank output for zero records. I was expecting it to return “0” FOR DT.ROWS.COUNT but my message box is displaying blank value. I don’t have any idea as to why it is blank. As per my code, it should return zero as there are no rows …

Tested a few instances with Read Range inside Excel Application Scope and it is working fine for me. Can you check if the dt is not empty? i mean if the excel was not read properly? Maybe share a bit of insight or screenshots on how the dt is getting populated.

Hello @kaderms , Actually I am comparing two excel files. Download an excel attachment and read/store it as dt1 - Success Copy data from citrix app and paste it in another excel which is dt2 - Success Filter dt2 based on certain condition and store it in dt3 - Success Compare both dt1 and dt2. …

I tried filtering empty rows but in vain. that resulted in error as well. Column1 doesn’t exist/invalid column name

I was playing around with your scenario but am not able to replicate your issue the same way. Even if I read a sheet which has all empty cells and not even a header, I still get the dt.rows.count as 1 (might be an issue. Planning to initiate a new topic with proper details. Waiting for this thread …

To be on the same page, hope you too are using Read Range activity within Excel Application Scope. Also am trying this on .xlsx file, with Excel 2016. Not sure if that matters. Just in case…

You mean to say, even without any records or headers in Excel sheet, does the row count return as 1? Moreover what is the difference between having two separate excel application scope under a sequence and one excel application scope inside the other? The variable have scopes have been declared at …

[image] Selvasathappan: even without any records or headers in Excel sheet, does the row count return as 1? Yes… This is what I tried. [image]

[image] Selvasathappan: Moreover what is the difference between having two separate excel application scope under a sequence and one excel application scope inside the other? The variable have scopes have been declared at the global level Excel Application Scope is more of a container like a…

Can you please check your variable scope. May be two variable with same name have been declared, One in Global Scope and one in Excel Application Scope. If So, then delete the variable declared in Excel Application Scope. It should work.

Sure. Will have a look into it. Thanks for your response @Santan_Barnwal , @kaderms

Datatable.rows.count returns blank output

Help

Selvasathappan (Selva) August 7, 2018, 12:45pm 14

@Santan_Barnwal @kaderms - Guys, can you help me with the below post?

Topic		Replies	Views
Excel is Empty but DataTable output is blank when queried for rows count Help	15	5678	August 16, 2018
Datatable.rows.count is not returning anything Help studio	5	922	July 23, 2019
Datatable.rows.count not matching Help	9	2443	September 8, 2019
Read range Excel Help excel , activities , question	14	3266	October 23, 2020
Excel - Finding data rows count Help datatable , excel , activities	3	4192	October 8, 2018

Datatable.rows.count returns blank output

Related topics