How can I delete rows in an excel file if for example column A is empty

[goncalo.rocha]

Hello all,
I am developing an automation in which i have some data and then i need to clear the rows in which column A is empty.

Which basically makes that the formulas without any values enter in conflict with some other formulas that I have that calculate the sum of the entire column.

I already have that in a data table but I don’t know how I can use them since it is a template file and even if I went to paste the data table the empty rows on the template would still be there

[Palaniyappan (Forum Leader)]

Hi

There is Another thread with discussion on similar query
Would recommend to have a view on it and see whether it solves ur scenario

How to delete entire Row if a specific column has empty cells

Hello Everyone, I have the following datatabel [1] I need to filter the red marked column. The condition is if the Column has any “Empty” or “Blank” cell then that entire row must be deleted. At the moment i m being able to do it using VB Script. Now the challange is that the table does not always have “Empty” or “Blank” cell, so at that moment the VB Script is throwing error ofcourse. I tried to use the Filter Datatable activity but its only removing the rows based on “Empty”…

Cheers @goncalo.rocha

[goncalo.rocha]

Hello @Palaniyappan my issue is not having that data filtered in the data table, the filtered data table I have, what I need to do is remove them from the excel directly, since the lines without data are making my template throw an error when trying to sum all the values of the column. thank you