dingtalk xlsx file cannot GetPivotTables

[ShowerBandV]

Description
The dingtalk file has a pivot table, and the field year (Chinese character) of this pivot table is not in the source data. This field is generated by DingTalk based on year (English character), but excelize cannot read this field. After reading the code, I found that there may be a problem with the logic of obtaining the pivot table cacheField. I don't quite understand why we don't directly use cacheField but instead obtain it by parsing pivot Data Range.

here is demo xlsx file
Book1.xlsx

[xuri]

Thanks for your issue. This issue has been fixed, please upgrade to the master branch code by following command, this patch will be released on the next version.

go get -u github.com/xuri/excelize/v2@master