Create one row before the headers

Help Studio
1

My requirement is I had table now I need to add onvalue before the headers as per image of second table

1736430104394304017951444553709
17364301043943040179514445537091920×2550 656 KB

2

Hello @kavitimoulika135

You can use the Excel activity Insert Rows and define 1 row to insert at a specific index (1).

image
image548×681 15.1 KB

Afterwards you can populate it with data by defining the index like:

dt_Datatable(int_Index)("ColumnName")="Value to insert"

Regards
Soren

3

hey @kavitimoulika135 you can use insert rows activity in both if you are working with modern activity or in Classic activity.this activity will resolve your query

This image shows an Excel automation process workflow in which a new row is inserted at the first position in "Sheet1" of an Excel file named "challenge.xlsx," and the cell A1 is written with the text "Employee Details." (Captioned by AI)
This image shows an Excel automation process workflow in which a new row is inserted at the first position in "Sheet1" of an Excel file named "challenge.xlsx," and the cell A1 is written with the text "Employee Details." (Captioned by AI)555×459 17.9 KB

This image shows a workflow for working with an Excel file, specifically opening "challenge.xlsx" and inserting a row into "Sheet2". (Captioned by AI)
This image shows a workflow for working with an Excel file, specifically opening "challenge.xlsx" and inserting a row into "Sheet2". (Captioned by AI)516×412 15.2 KB

PS;engore this waring sign and uncheck header option if your data has header on first row
cheers Happy Automation