Anyone can help me to delete 1st row in excel using IF condition. in My source files sometime the 1st row is empty & sometimes not. If the 1st row is empty, then i need to delete the row . If not i leave it as it. And i need to maintains the files since it have other info in other sheets.
Read Cell and store the value in string variable and then check-in if the condition output of Read cell is empty
Example : String.IsNullOrEmpty(varOPReadCell) - write this in if condition
The use step suggested by @NIVED_NAMBIAR to remove the first row.
Just select Remove in action and pass 1 as number of rows deleted and then 1 as row to delete on position…
Note : This activity(Insert/Delete Rows) needs to be used in Excel Scope