Excel is Empty but DataTable output is blank when queried for rows count

[Selvasathappan (Selva)]

@hemanth_chinna @rajsekhar - Thanks for your response. Am still working on that issue but then I also have another issue and can u please advise me on this? I know to add a new column with default value but how do I handle the below scenario

Datatable - Retain values for daily run

Hello Everyone, I have an excel sheet as shown below [image] But I am looking to modify it as shown below [image] As you can see, I am trying to add a new column(“View”) to the datatable and each row of column view has a set of values which will repeat every day when I run the script. Please note that I will be running this script daily to append data. So currently the screenshots has 3 rows for today, but tomorrow it will be 6 rows [image] How can I do this? I can add a new column wit…