SpreadJS - 如何使用樞紐分析表

快速提取和分析您 JavaScript 應用程式中的大量資料。
6月 25, 2021
新聞快訊

A pivot table is a powerful tool that that makes seemingly endless data more manageable to analyze. Microsoft Excel pivot tables allow users to summarize their data tables in a more meaningful way by allowing them to “pivot” (or rotate) data in tables to, for example, compare totals between different products, sort, summarize, group, and much more.

With the v14.1.0 release of SpreadJS, GrapeCity added support for pivot tables as an additional add-on feature. Users who purchase the pivot table add-on license can leverage the pivot table feature for deep customization and quick data analysis. In this blog, Mackenzie Albitz takes you through the process of how to use SpreadJS’s Pivot Table add-on feature, its application, setting utilization, and how to use the different layout options to view and analyze data seamlessly. Topics include:

  • Add Data
  • Add a Pivot Table
  • Add a Pivot Table Side Panel
  • Set Pivot Table Sections
  • Pivot Table Filters and Sorting
  • Pivot Table Collapse and Grouping

View the GrapeCity blog and learn these powerful techniques.

SpreadJS v14.1 includes optional Pivot Table Add-on

SpreadJS

用於 JavaScript 應用程式的完整試算表解決方案。

有任何疑問嗎?

Live Chat現在與我們的MESCIUS (formerly GrapeCity) 專家即時聊天詢問。