I need write two different data table to one Excel file. For now, I am using write range activity and give two different starting cell parameter (one started from A6, another started form J6), but the second data table will overwrite the first one.
I have used like this sometime back and it didn’t overwrite for me,have use tried write range under workbook instead of using write range under excel.
It won’t overwrite The reason is you have any how specified the cell start like A6 and J6
But make sure that you don’t have more than J with first datatable
Only then it will overwrite the next time when you are writing from J6
So it should be fine
And we can do this with simple WRITE RANGE activity itself
It should work if you have only 9 columns in the first data table because if you have more than 9 columns in a first data table that comes under J6 also and if again you try to write the data using the second data table from J6 it will over right only those data of first data table which comes under J6 column.
So try to look at your column of the first data table and then create a dynamic range for your Second data table to write
Thanks
Both of them only have 3 columns, and actually I have already created dynamic range for both data table to write. In my case, the second data table always overwrite the first one (which is on the left side of Excel).
I have set a break point when first data table was written. It looks fine, but after continue write second data table and open the file again, a part of left side, which is the first data table’s content, is gone.
For example, If dt 1 contains 30 rows and dt 2 contains 15 rows, after write range dt 2, the 1st row ~ 15th row of dt 1 will be disappear.
Hi @Astor
If possible could you please share the sample files with us as i am able to simulate your scenario and its working fine for me .
Please find the attached screen shot Dt2
I finally tried to change activity from write range “under workbook” to “under excel”, and… it works…
It still confuse me, I even did not modify any parameter… but, finally, I can move to next step. Thank you for your time and kindly reply.