java - 我可以在 Google 电子表格中存储多少个单元格？

Question

我正在编写一个java程序，用于存储和读取谷歌电子表格中的数据。我想知道是否有人有过这样的性能限制和数据大小限制的经验，例如，在 API 不允许我添加任何新单元格之前，我可以在电子表格中存储多少个单元格？是否存在一定数量的单元之后 API 变得太慢并且性能成为问题？

Answer 1

Spreadsheets: Up to 5 million cells for spreadsheets that are created in or converted to Google Sheets.

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

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

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

• 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.

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