getPivotTable use wrong sheetName

[ShowerBandV]

Description Reading a cross sheet pivot table, it was found that the pivot table data source was obtained but not used, using the current sheetName

func (f *File) getPivotTable(sheet, pivotTableXML, pivotCacheRels string) (PivotTableOptions, error) {
    ...
    opts = PivotTableOptions{
        pivotTableXML:   pivotTableXML,
        pivotCacheXML:   pivotCacheXML,
        pivotSheetName:  sheet,
                //sheet is currentsheet,but dataRange need pc.CacheSource.WorksheetSource.Sheet
        DataRange:       fmt.Sprintf("%s!%s", sheet, pc.CacheSource.WorksheetSource.Ref),
        PivotTableRange: fmt.Sprintf("%s!%s", sheet, pt.Location.Ref),
        Name:            pt.Name,
    }
    ...
}

here is demo code and a xlsx file:

func TestGetPivotTable(t *testing.T) {
    file, err := excelize.OpenFile("Book1.xlsx")
    if err != nil {
        panic(err)
    }
    tables, err := file.GetPivotTables("Sheet2")
    if err != nil {
        panic(err)
    }
    fmt.Println(tables)
}

Book1.xlsx

[xuri]

Hi @ShowerBandV, thanks for your issue. Would you like to create a pull request to help us fix that?