{"text_format":"3","workbook":"xlsx","n_sheets":4,"sheets":["开始","源数据","数据透视表结构","示例数据透视表"],"not_rendered":{"defined_names":4,"pivot_tables":2},"read":"whole","date_system":"1900"}

{"sheet":"开始","index":0,"n_rows":9,"n_cols":2,"rows_kept":9}
[null,"模板简介"]
[null,"使用此工作簿试验数据透视表报表。"]
[null,"使用数据透视表结构工作表中源数据工作表和报表模板的示例数据创建示例数据透视表报表。 "]
[null,"在示例数据透视表工作表中创建示例列表，可以按任何类别或项目进行排序。 "]
[null,"还可以使用切片器来筛选数据。若要向数据透视表添加切片器，请在“数据透视表工具”下“分析”功能区上的“筛选”组中选择“插入切片器”。"]
[null,"数据透视表报表是 Excel 最出色的工具之一，用于从大型、详细数据集中提取其含义。数据以列表格式排列，类似于查询返回数据库记录的方式：每列包含类似的数据，列的第一行中有标题，列表不会被任何空行或列中断。  "]
[null,"注意： "]
[null,"“源数据”和“数据透视表结构”工作表的单元格 A1、A2 和 A4 以及“示例数据透视表”工作表中的单元格 A1、A2、A4 和 A12 中提供了附加说明。已故意隐藏此文本。要删除文本，请选择列 A 或单元格 A1，然后选择“删除”。要取消隐藏文本，请选择列 A 或单元格 A1，然后更改字体颜色。"]
[null,"若要了解有关表格的详细信息，请在表格内按 Shift + F10，选择“表格”选项，然后选择“替换文本”。对于数据透视表，请在表格内按 SHIFT+F10，选择“数据透视表”选项，然后选择“替换文本”选项卡。"]

{"sheet":"源数据","index":1,"n_rows":9,"n_cols":7,"rows_kept":9}
["使用此工作表中从单元格 B4 开始的源数据表的示例数据创建示例数据透视表报表。此示例数据是销售额以及产品和客户详细信息的季度总和。它还包含一个辅助列，其中包含一个返回日期的公式。此列可用于数据透视表报表中的日程表工具来筛选数据。"]
[null,"源数据"]
[]
[null,"产品","客户","年","季度","金额","时间线"]
[null,"产品 1","客户 1",{"$f":"YEAR(TODAY())+1","v":2023},2,{"v":702,"d":"¥702.00"},{"$f":"DATE(SourceData[[#This Row],[年]],SourceData[[#This Row],[季度]]*4,1)","v":"2023-08-01"}]
[null,"产品 2","客户 2",{"$f":"YEAR(TODAY())+1","v":2023},1,{"v":312,"d":"¥312.00"},{"$f":"DATE(SourceData[[#This Row],[年]],SourceData[[#This Row],[季度]]*4,1)","v":"2023-04-01"}]
[null,"产品 3","客户 3",2023,4,{"v":1170,"d":"¥1,170.00"},{"$f":"DATE(SourceData[[#This Row],[年]],SourceData[[#This Row],[季度]]*4,1)","v":"2024-04-01"}]
[null,"产品 4","客户 4",2023,1,{"v":1170,"d":"¥1,170.00"},{"$f":"DATE(SourceData[[#This Row],[年]],SourceData[[#This Row],[季度]]*4,1)","v":"2023-04-01"}]
[null,"产品 5","客户 5",2023,1,{"v":3730.3500000000004,"d":"¥3,730.35"},{"$f":"DATE(SourceData[[#This Row],[年]],SourceData[[#This Row],[季度]]*4,1)","v":"2023-04-01"}]

{"sheet":"数据透视表结构","index":2,"n_rows":2,"n_cols":2,"rows_kept":2}
[]
[null,"数据透视表报表"]

{"sheet":"示例数据透视表","index":3,"n_rows":16,"n_cols":7,"rows_kept":16,"merged":[[3,9,10,13],[11,9,18,13]]}
[]
[null,"数据透视表报表示例"]
[]
[null,"金额 ",null,"年","季度"]
[{"$nulls":3},2023,null,null,"2023 Total"]
[null,"客户","产品",1,2,4]
[null,"客户 1",null,null,{"v":702,"d":"¥702.00"},null,{"v":702,"d":"¥702.00"}]
[null,null,"产品 1",null,{"v":702,"d":"¥702.00"},null,{"v":702,"d":"¥702.00"}]
[null,"客户 2",null,{"v":312,"d":"¥312.00"},null,null,{"v":312,"d":"¥312.00"}]
[null,null,"产品 2",{"v":312,"d":"¥312.00"},null,null,{"v":312,"d":"¥312.00"}]
[null,"客户 3",{"$nulls":3},{"v":1170,"d":"¥1,170.00"},{"v":1170,"d":"¥1,170.00"}]
[null,null,"产品 3",null,null,{"v":1170,"d":"¥1,170.00"},{"v":1170,"d":"¥1,170.00"}]
[null,"客户 4",null,{"v":1170,"d":"¥1,170.00"},null,null,{"v":1170,"d":"¥1,170.00"}]
[null,null,"产品 4",{"v":1170,"d":"¥1,170.00"},null,null,{"v":1170,"d":"¥1,170.00"}]
[null,"客户 5",null,{"v":3730.3500000000004,"d":"¥3,730.35"},null,null,{"v":3730.3500000000004,"d":"¥3,730.35"}]
[null,null,"产品 5",{"v":3730.3500000000004,"d":"¥3,730.35"},null,null,{"v":3730.3500000000004,"d":"¥3,730.35"}]