Use XLSReadWriteII to generate a PivotTable report. Why do the subitems of each item display all the data?
This is an Excel picture
Export PivotTable
Why didn't you filter it? So is your example
How to solve it?
Search found 3 matches
- Tue Dec 27, 2022 1:31 am
- Forum: XLSReadWritwII 6
- Topic: About PivotTable
- Replies: 0
- Views: 3110
- Wed Dec 21, 2022 12:28 pm
- Forum: XLSReadWritwII 6
- Topic: 关于数据透视表问题
- Replies: 2
- Views: 2177
- Wed Dec 21, 2022 12:25 pm
- Forum: XLSReadWritwII 6
- Topic: 关于数据透视表问题
- Replies: 2
- Views: 2177
关于数据透视表问题
用 XLSReadWriteII 生成数据透视表 为什么每一项的子项都显示的是全部数据
比如
A1 A2
A 1
A 2
B 3
导出到Excel会变成
A 1
2
3
B 1
2
3
比如
A1 A2
A 1
A 2
B 3
导出到Excel会变成
A 1
2
3
B 1
2
3