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
Thanks for the solution !!!
This topic was automatically closed 3 days after the last reply. New replies are no longer allowed.