sheetquery
sheetquery copied to clipboard
vlucas
Query Builder/ORM for Google Sheets
Hi! Inserting rows is really slow (3 Minutes for 640 entries :-/ ). Do you see any way to increase performance of insertRows? I really like the simplicity of sheetquery...
Added patchRows and patchRow methods. They are similar to updateRows/updateRow, but patchRow() only updates cells which was changed. So functions in some other cells will be safe. Only drawbacks are...
Not sure if intended for simplicity, but currently `updateRows()` overwrites the formula in a cell with the value it outputs instead of leaving the old formula. Would be cool if...
I couldn't manage to use LockService API, i had no idea how to mock that. :-( The new implementation for insertRows() inserts empty Rows and sets the values for the...
Looks like the `this.columnNames` [array](https://github.com/vlucas/sheetquery/blob/main/dist/index.js#L16C10-L16C21) is not taken into account to return only the selected column names (it is not used at all in the code).
