我可以在Google电子表格中存储多少个单元格? [英] How many cells can I store in google spreadsheets?

问题描述

我正在编写一个Java程序，用于存储和读取Google电子表格中的数据.我想知道是否有人对性能限制和数据大小限制有经验，例如在API不允许我添加任何新单元之前，我可以在电子表格中存储多少个单元?并且是否有许多单元格会导致API变得太慢而导致性能出现问题?

I am writing a java program that stores and reads data from a google spreadsheet. I am wondering if anyone has an experience with the performance limitations and the data size limitations of this, like, how many cells can I store in the spreadsheet before the API doesn't allow me to add any new cells? and is there a number of cells after which the API becomes too slow and performance becomes a problem?

推荐答案

电子表格:在Google表格中创建或转换为电子表格的电子表格最多可容纳500万个单元格.

复杂度也是一个因素，因为工作表可能会超时.来自 Jeff Herb :

Complexity is also a factor as the sheet may just time out. From Jeff Herb:

Google共享一些专门导致工作表复杂性的公式，这些公式如下:

Google shares a few formulas that specifically contribute to the complexity of your sheet, they are the following:

• VLOOKUP，QUERY，SUMIF和范围较大的类似公式 单元格作为输入.

• VLOOKUP, QUERY, SUMIF, and similar formulas that take a large range of cells as input.

易失性公式(例如NOW，RAND，OFFSET和INDIRECT)为 每次修改电子表格时都会重新计算.如果有 依赖于具有易失性公式的单元格的大量公式， 他们将在每次编辑时重新计算，这可能会减慢 电子表格.

Volatile formulas (for example, NOW, RAND, OFFSET, INDIRECT) are recalculated every time the spreadsheet is modified. If there are a large number of formulas that depend on cells with volatile formulas, they will be recalculated on each edit, which may slow down a spreadsheet.

基于导入的公式(例如IMPORTRANGE)被重新计算 定期增加复杂性.

Import-based formulas (e.g., IMPORTRANGE) are recalculated periodically and increase complexity.

这篇关于我可以在Google电子表格中存储多少个单元格?的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！