且构网

分享程序员开发的那些事...
且构网 - 分享程序员编程开发的那些事

如何在具有值的最后一行之后插入行?

更新时间:2022-12-12 15:16:35

v4 API无法询问数据的最后一行是什么",因为它是与Apps Script API不同的API样式.您可以通过请求数据并计算从第一个请求的行到最后返回的行的偏移​​量来推断最后一行.

The v4 API has no way to ask "what is the last row with data", as it's a different style of API than the Apps Script API. You can infer the last row yourself by requesting the data and counting the offset from your first requested row to the last returned row.