Add empty row to datatable


#1

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:

  1. Read in
  2. Delete first row
  3. Add a empty row (Empty strings)
  4. Overwrite the workbook

I have not figured out part 3. Can someone help me or propose another strategy of finishing this task?

Thank you.


#2

There is actually an activity called “Remove Data Row” to perform this, but you need to convert the Google Sheet into DataTable variables to use this feature

  1. Read in (Google Sheet to a DataTable variable)
  2. Use Remove Data Row (RowIndex 0) to remove the first row
  3. Write back (updated same DataTable to Google Sheet)

Hope this was what you were looking for!


#3

@Nicolas_Vermeulen: If these ABC are the headers then you can use Write range and uncheck the Add Headers property and you will be writing from D E F