i need to insert header in this below table how…
Header name is “Monthly report”
for use this table
| date | aaa | bbb | ccc | ddd | eee | fff | ggg |
|---|---|---|---|---|---|---|---|
| 1-3 | 12 | 54 | 25 | 13 | 51 | 56 | 33 |
| 3-7 | 9 | 3 | 3 | 20 | 4 | ||
| Total | 21 | 54 | 28 | 16 | 71 | 60 | 33 |
→ Use the Excel Process scope activity inside of it insert the Use Excel file activity and give the path of the excel file.
→ Inside Use excel file activity insert the Insert rows activity to insert at start of the excel.
→ In Insert rows activity give the range in the In what table or range field, Give 1 in Number of rows field, uncheck the add headers and Select the start from where dropdown.
→ After insert rows activity insert the write cell activity to write the Monthly Report as header.
Check the below workflow for better understanding,
Input -
Output -
Hope it helps!!
check it