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)
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)
I went through your workflow. Everything is fine except few things that wen wrong
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
This topic was automatically closed 3 days after the last reply. New replies are no longer allowed.