search

qax-os / excelize

Go language library for reading and writing Microsoft Excel™ (XLAM / XLSM / XLSX / XLTM / XLTX) spreadsheets
https://xuri.me/excelize
BSD 3-Clause "New" or "Revised" License
17.72k stars 1.69k forks source link

Outline form or Tabular form pivot tables #1785

Open longphee opened 6 months ago

longphee commented 6 months ago

Description I need to show pivot data in outline form or tabular form, but now only support compact, may we also support setting outline and tabular ?

Describe the results you received: image

Describe the results you expected: image

Output of go version: go version go1.18.3 darwin/arm64

Excelize version or commit ID: 2.6.1

xuri commented 6 months ago

Thanks for your issue. Please specify the Outline value as true in each PivotTableField field, for example:

Filter: []excelize.PivotTableField{{Data: "FieldName", Outline: true}},
longphee commented 6 months ago

Thanks for your issue. Please specify the Outline value as true in each PivotTableField field, for example:

Filter: []excelize.PivotTableField{{Data: "FieldName", Outline: true}},

Thanks for your reply. It doesn't work.

'行标签' is automatically generated for the first row. However, I prefer using its specific column name, which is feasible with the tabular form layout https://www.contextures.com/excelpivottablereportlayout.html