Tab to tab movement between two Wdesk files using chains

Udzielono odpowiedzi

Zamów wersję demonstracyjną

1/09/2021 08:36

Hi Team,

I have a requirement to move/copy data from tab1 of Spread sheet1 to tab2 of spread sheet2 using chains, noting down spread sheet1 & 2 have around 200 tabs each. Kindly suggest the suitable way and command for this.

Thanks,

Madhuri Desai.

Komentarze

Komentarze: 1

Jeff Hickey

1/09/2021 17:14
Hi Madhuri, you can get generate a list of Sheets from Spreadsheet1 with List Sheets, iterate over the list to get the data from each Sheet with Get Sheet Data, create a new Sheet in Spreadsheet2 with Create Sheet, finally write the data to the new Sheet with Write Sheet Data.
0

Zaloguj się, aby dodać komentarz.

Wsparcie

Wspólnota

Tab to tab movement between two Wdesk files using chains

Komentarze