is it possible for you to share the excel file ?
1 Like
I cannot share my Excel file because it includes kinda personal info.
But it is like this, i share you.
This info count always change by which i mean now is 61datas but maybe next time is 76âŚlike this. So always chage first place to put new datas.
SO i want to put new datas to new place always and also donât want to overwrite previous datas as well.
Is it make sense for you?
Itâs okay.
Is it fine if data get added at the end So for example if there are 10 rows then new data get added from 11th row.
1 Like
AppendData.zip (10.0 KB)
Steps to do this:
1 - I have used Build activity just remove it with your activity where you are reading new data and putting in data table
2 - Pass file path where you want data to be appeneded
3 - Install package for Interop code.
If this wasnât work letâs connect on teams or zoom, if thatâs possible for you.
Thanks.
Just try to run the process i have shared as it is for your understanding and then make changes accordingly.
1 Like
Thank you for shareing valuable information.
I tried them but it didnât work for me, maybe i did wrong or missing something.Can you check it, please?
1.
I already had data table, so i guess it is fine.
2.
3.
Still cannot get your point(2 and 3), sorry about that.
Thank you.
For point 2 - You have to pass your excel file path to in_FilePath Argument shown in screenshot before.
For Point 3 - You have to install this package otherwise invoke code will give error.
Install Microsoft.Office.Interop.Excel package.
1 Like
I guess i solvedmy ploblem.
Thank you for helping me all the time.
1 Like
Great!, how you have done that finally 
?
I used Filter Data Table to sloved my ploblem.
When i add it, it did not overwrite and it works i guess.
But actually now my boss is checking so i am not sure.
1 Like