Append multiple Data Tables in to an existing Excel file starting from a specific column

Help Something Else
, , , ,
1

Hi all and happy new year :slight_smile:

I need to be able to append multiple data tables into a single excel file, however, it needs to start from a specific column, for example B2, after the first dt is appended, it should keep appending the rest DataTables into Column B, how could I achieve this?

Thank you for all the help in advance.

2

@Sidney_Vogel

Please try with append range which would append the data in the excel…

So for the first table use write range and form the second you can use append range

Cheers

1 Like
3

Hi @Sidney_Vogel ,

If all the data tables follow the same data structure(at least same number of columns), I would suggest to merge the data tables first using Merge Data Table activity and then write to a specific cell using Write Range.

1 Like
4

Hi @Balaji_Murugan, your solution worked perfectly, thank you very much for the information and help :slight_smile:

5

Thank you for the information @Anil_G, I appreciate your help.

1 Like
6

This topic was automatically closed 3 days after the last reply. New replies are no longer allowed.