poi创建数据透视表_如何创建数据透视表样式

poi创建数据透视表

You don't have to stick with the default formats for your pivot tables. You can create a pivot table style with your own colours, and other formatting options that you like. Here's how to get started, and a video with a simple formatting change that you can make.

您不必遵守数据透视表的默认格式。 您可以使用自己的颜色和所需的其他格式设置选项创建数据透视表样式 。 这是入门方法，以及可以对格式进行简单更改的视频。

内置样式 (Built-In Styles)

There is a big collection of pivot table styles, and you might be satisfied with something from that collection.

数据透视表样式有很多，您可能会对其中的一些内容感到满意。

For example, I like "Pivot Style Light 8", so I'll apply it to my pivot table.

例如，我喜欢“数据透视样式灯8”，因此将其应用于数据透视表。

调整内置样式 (Tweak the Built-In Styles)

The style you apply might be almost perfect, but maybe you'd like to make a little tweak to it.

您应用的样式可能几乎是完美的，但也许您想对其进行一些调整。

If I'm printing this pivot table, the grey shading on the subheading rows will make them hard to read. I'd like to get rid of that shading.