Dear reader
The purpose of this request is to read a datatable from Workbook (Google Sheet) and overwrite the same Workbook with this datatable minus its first row.
So in Google Sheets:
A B C
D E F
G H I
Should become
D E F
G H I
(First row deleted, second row becomes first one, third row becomes the second one, …)
Please note that only the following 2 workbook activities can be used: Read and Write (I am using a API with Google Sheets, other activities have not been installed)
My idea was to do the following:
- Read in
- Delete first row
- Add a empty row (Empty strings)
- Overwrite the workbook
I have not figured out part 3. Can someone help me or propose another strategy of finishing this task?
Thank you.