Open pravinfullstack opened 1 year ago
await sheet.insertDimension('COLUMNS', {
startIndex: currentCol,
endIndex: headers.length,
});
You can you this. If you want to insert ROWS, just replace 'COLUMNS' by 'ROWS'
currently insertDimension just inserts empty rows/columns. There is not functionality to insert a row at a specific index like I can see you are trying to do. This would be possible but would take some work.
I am using
insertDimension
to insert row on top on my sheet, but unable to comprehendrange
in the documentation. An example would be appreciated. Thanks This is what I am trying to do