How to delete old data in the excel before run the workflow

Help Studio
, ,
1

Hi All,

I have excel workbook where i am going to read and write the data. When i run every time the previous data should be cleared/delete before run the workflow.

Example:-
Sheet1 is going to read the data,
Sheet2 is going write the data in the B column (from B1 to B36)
I need to clear Sheet2 “B” column data.

Please help me on this.

Thank you- Raghu

2

Try to remove data column and then again add column using add data columnwith empty data

3

Hi @Raghu_km - You can achieve this using Delete Range activity. Check the below workflow

DataTable_Manipulation.zip (9.4 KB)

Provide the range that you want to delete and sheet name

Output
Output728×540 13.7 KB

1 Like
4

Hi @Raghu_km

  1. Drag and drop the “Clear Range” activity inside the Excel Application Scope.
  2. In the Properties panel of the Clear Range activity, set the following properties:
  • Range: “B1:B36” to specify the range of cells to clear.
  • SheetName: “Sheet2” to specify the sheet name where you want to clear the data.

Hope it helps.

1 Like
5

This topic was automatically closed 3 days after the last reply. New replies are no longer allowed.