Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

dingtalk xlsx file cannot GetPivotTables #1954

Open
ShowerBandV opened this issue Jul 17, 2024 · 0 comments
Open

dingtalk xlsx file cannot GetPivotTables #1954

ShowerBandV opened this issue Jul 17, 2024 · 0 comments
Labels
enhancement New feature or request

Comments

@ShowerBandV
Copy link
Contributor

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 xuri added the enhancement New feature or request label Jul 17, 2024
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
enhancement New feature or request
Projects
None yet
Development

No branches or pull requests

2 participants