是否有.getBackgrounds()的API版本，例如Values.Get()与getValues() [英] Is there a API version of .getBackgrounds() such as Values.Get() vs getValues()

问题描述

在社区的一些支持下，我最近了解到Values.Get()与getValues()相比要快多少.我一直在升级我的项目代码之一，以使用这些新命令.当我尝试更改所有读/写命令时，发现使用.getBackgrounds().我一直无法找到等效的API命令来获取背景色.我认为它不存在，我需要继续使用.getBackgrounds().只是想确保我没有错过任何东西.

With some community support I recently learned how much faster Values.Get() is versus getValues(). I've been upgrading one of my projects code to use these new commands. As I go through and try to change over all of my read/write commands I've found that I use .getBackgrounds(). I haven't been able to find the equivalent API command to get the background colors. I presume it doesn't exist and that I'll need to continue to use .getBackgrounds(). Just wanted to make sure I wasn't missing anything.

谢谢！

推荐答案

有 Sheets.Spreadsheets.get ，它为您提供了电子表格json .背景将位于

sheets[].data[].rowData[].values[].cellData.effectiveFormat.backgroundColor

这篇关于是否有.getBackgrounds()的API版本，例如Values.Get()与getValues()的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！