Hi,
I want to delete first few rows from an excel file regardless of the data it contains. Can anyone suggest me a solution please. Thanks
-
Read data from excel assign output to datatable.
-
use foreach row on that datatable.
-
Take if condition and check the row number is less then ur value. If it is less use delete datatable row to delete row else do nothing.
-
after for loop write datatable to excel
Hi @Manjuts90,
Thanks for your answer. If you don’t mind, can you post a sample workflow please. Thank you.
@suwalruchan365 try below xaml file and find sample excel file.
del-------------.xaml (9.0 KB)
sh2.xlsx (8.5 KB)
Hi @Manjuts90,
I used your workflow but it’s not working as I wanted. I have attached my sample excel file herewith where I want to delete all the contents up to row 11. Can you help me with this please. Any help would be much appreciated. Thank you.
Sample.xlsx (10.3 KB)