I need to delete certain number of rows in an excel. The scenario is, open an excel, delete first 20 rows and save the result in new excel sheet. Here, the number 20 is dynamic (i.e.)it may vary on each run.
Requesting your help in finding the solution.
another option could be to set the range offset to a downer row e.g. A21 when readin the excel
The scenario is, open an excel, delete first 20 rows and save the result in new excel sheet. Here, the number 20 is dynamic (i.e.)it may vary on each run.
Hope you know all columns and count is constant.
If yes then use
Delete Range activity inside Excel Application Scope activity and pass below parameters to it.
SheetName: "Excel SheetName"
Select ShiftCells checkbox and ShiptOptions as ShiftUp
L with ending column in your Input Excel file.
This solution worked. Thank you.
Hi Lakshman, Thanks for your response. Got the solution now.
This topic was automatically closed 3 days after the last reply. New replies are no longer allowed.