Delete empty rows

Hello !

I want to delete from this excel the Row(s) that are empty of the column Project. Can you tell me what i`m doing wrong ? Thank you !
Delete Rows.xlsx (8.1 KB)
Main.xaml (8.5 KB)

Hi @Padurariu_Dragos_Vio

I went through your workflow. Everything is fine except few things that wen wrong :slight_smile:

In the assign, using [Project] is null is not going to filter the records because the value in that cell is not actually null, but empty.

So the condition you have to use is ExcelDataTable.Select("[Project] = ''")

Additionally, though you have done the filtering and remove data row in the excel application scope, you are not writing the data to a excel file.

I have a workflow for you which is bit simpler which I have done without excel application scope. I have modified it to suit your requirement. Check it out & it should work for you.
I read from your file, check for empty record, removes it, and writes back to a new excel file.

DeleteDataRow.xaml (6.6 KB)

If this works for you, please mark it as the solution so that it could help others as well :slight_smile:

1 Like

Hi @Lahiru.Fernando

Thanks for the solution !!!

1 Like

This topic was automatically closed 3 days after the last reply. New replies are no longer allowed.