统计摘要
摘要统计数据可以帮助人们快速理解数据集并做出明智的决策。许多有趣的数据集都存储在电子表格文件中。
¥Summary statistics help people quickly understand datasets and make informed decisions. Many interesting datasets are stored in spreadsheet files.
SheetJS 是一个用于从电子表格读取和写入数据的 JavaScript 库。
¥SheetJS is a JavaScript library for reading and writing data from spreadsheets.
该演示使用 SheetJS 处理电子表格中的数据。我们将探讨如何提取电子表格数据以及如何计算简单的汇总统计数据。该演示将重点关注两种通用数据表示形式:
¥This demo uses SheetJS to process data in spreadsheets. We'll explore how to extract spreadsheet data and how to compute simple summary statistics. This demo will focus on two general data representations:
-
"对象数组" 通过从 SheetJS 数据模型转换为更惯用的数据结构来简化处理。
¥"Arrays of Objects" simplifies processing by translating from the SheetJS data model to a more idiomatic data structure.
-
"密集的工作表" 直接分析 SheetJS 工作表。
¥"Dense Worksheets" directly analyzes SheetJS worksheets.
导入教程 是从工作簿中提取数据的指导示例。强烈建议先查看教程。
¥The Import Tutorial is a guided example of extracting data from a workbook. It is strongly recommended to review the tutorial first.
该浏览器演示在以下环境中进行了测试:
¥This browser demo was tested in the following environments:
浏览器 | 日期 |
---|---|
Chromium 133 | 2025-03-30 |
Safari 18.3 | 2025-03-30 |
Konqueror 22 | 2025-04-23 |