how to set pivot column format

[xinliangliang1]

Description
Sheet A I have these data
A B C
1 10% eth
2 20% eth
3. 30% btc
4. 40% btc

Sheet B is a pivot view of sheet A
eth 30%
btc 70%

however it only show like this
eth 0.3
btc 0.7

what to do to slove the problem

[xuri]

Thanks for your issue. This issue was duplicated with #720. I just added a new NumFmt field in the PivotTableField data type, now you can set and get built-in number format of the pivot table data filed cells. For example:

package main

import (
    "fmt"

    "github.com/xuri/excelize/v2"
)

func main() {
    f := excelize.NewFile()
    defer func() {
        if err := f.Close(); err != nil {
            fmt.Println(err)
        }
    }()
    for idx, row := range [][]interface{}{
        {"Val", "Cat"},
        {0.1, "eth"},
        {0.2, "eth"},
        {0.3, "btc"},
        {0.4, "btc"},
    } {
        cell, err := excelize.CoordinatesToCellName(1, idx+1)
        if err != nil {
            fmt.Println(err)
            return
        }
        if err := f.SetSheetRow("Sheet1", cell, &row); err != nil {
            fmt.Println(err)
            return
        }
    }
    if err := f.AddPivotTable(&excelize.PivotTableOptions{
        DataRange:       "Sheet1!A1:B5",
        PivotTableRange: "Sheet1!G3:H6",
        Rows:            []excelize.PivotTableField{{Data: "Cat"}},
        Data:            []excelize.PivotTableField{{Data: "Val", Name: "Sum of Val", Subtotal: "Sum", NumFmt: 9}},
        RowGrandTotals:  true,
        ColGrandTotals:  true,
        ShowRowHeaders:  true,
        ShowColHeaders:  true,
        ShowLastColumn:  true,
    }); err != nil {
        fmt.Println(err)
        return
    }
    // Save spreadsheet by the given path.
    if err := f.SaveAs("Book1.xlsx"); err != nil {
        fmt.Println(err)
    }
}

Please upgrade to the master branch code by go get -u github.com/xuri/excelize/v2@master, and this feature will be released in the next version.