PivotTable.GetValues

GetValues(<Area>)Type: SpreadsheetDocumentRange.
Area for which values are set.Type: Structure; Undefined.
If the area passed does not belong to any summary table, Undefined value is returned; otherwise - Structure is returned. A field name is a key in the structure, and the field's value represents the structure's value. Depending on location of the area in a summary table the structure may contain various fields.

• If the area passed is located at the intersection of lines and columns, the structure will contain names of string dimensions and column dimensions whose intersection the area is located at, and values of all resources.
• If the area is located at a strings' header area or a strings' total area, the structure will contain names of string dimensions and values of resources.
• If the area is located at a columns' header area or a columns' title area, the structure will contain names of column dimensions and values of resources.
• If the area is located at an area of grand totals, only values of resources will be returned.

Obtains values of all fields for the spreadsheet document area.
Server, thick client, external connection.Regardless of what area is passed in the parameter, only the left upper cell of that area will be processed.

---