Problem is when I use Append Range Its just printing the rows not able print the heading or if i use Write range Means It will Over Write the Old data…Provide the Solution for this
Hi @Gopikrishna_S ,
Have you enabled Add Headers in the Write Range Activity?
Use that once, and then you can use the Append Range Activity which will add the rows one after the other.
But depending on the scenario, I would compile the the entire dataset and just use a Write Range Activity.
Kind Regards,
Ashwin A.K
I enabled Write range, Scenario is For the first day of the month I would print heading and append one row and for remaining days of the month i just want to append row of each day transaction for rest of the day…The real challenge is If i get the first day of the month transaction means I would use if condition But sometime I would get only few days of the Month like 3rd day next 7th day 25th day randomly i would get. so that Bot have to create heading initialy and then print values for 3rd 7th 25th
Hi @Gopikrishna_S ,
Could you try reading the Excel Data, append a DataRow with the required set of data and then write it back to Excel?
Keeping Headers enabled of course.
Kind Regards,
Ashwin A.K
I think it will be better if you append all data you need in Data Base then and select according what you want and add the whole table in excel one time this way is more better is specially if you will add large amount of data