After using the append range activity data appended but Column Name is not present in appended sheet

Help Activities
, ,
1

In my project i am trying to append the excel.
After using the append range activity data appended but Column Name is not present in appended sheet,
What could be the possible reason ?
Please help to get that

image
image1918×960 89.8 KB

2

Append range is not adding the headers

For the first Addition (e.g. first row in Excel) use write range and let add the header

3

@Ajinya_jorwekar

append range activity data doesn’t have header

can you check whether the data which your are passing in the append activity is having headers or not

4

HI
append range activity data doesn’t have Add header property

can you check the original data which your are appending is having headers or not otherwise if you have only one data table you can use Write Range activity and add the header

Thank you

5

Actually I am adding the single single row data. in Each Transaction.

image
image1509×703 52.1 KB

6

Hi @Ajinya_jorwekar ,

The Idea suggested was to use Write Range Activity for the First Transaction and then Append Range activity in the next incremental transactions.

Using If activity by Checking the Transaction Number =1, then Write Range (Add Headers enabled) else Append Range activity.

Could you let us know if the above would work for your case ?

7

@Ajinya_jorwekar

its better to use write range for write range activity for the first Transaction

use if activity condition as
TransactionNumber=1

then use writerange activity

else use append range activity

for TransactionNumber you need to create an argument in process and map it

hope this helps