parseFormatPivotTableSet provides a function to validate pivot table properties.
(opts *PivotTableOptions)
| 195 | // parseFormatPivotTableSet provides a function to validate pivot table |
| 196 | // properties. |
| 197 | func (f *File) parseFormatPivotTableSet(opts *PivotTableOptions) (*xlsxWorksheet, string, error) { |
| 198 | if opts == nil { |
| 199 | return nil, "", ErrParameterRequired |
| 200 | } |
| 201 | pivotTableSheetName, _, err := f.adjustRange(opts.PivotTableRange) |
| 202 | if err != nil { |
| 203 | return nil, "", newPivotTableRangeError(err.Error()) |
| 204 | } |
| 205 | if countUTF16String(opts.Name) > MaxFieldLength { |
| 206 | return nil, "", ErrNameLength |
| 207 | } |
| 208 | opts.pivotSheetName = pivotTableSheetName |
| 209 | if err = f.getPivotTableDataRange(opts); err != nil { |
| 210 | return nil, "", err |
| 211 | } |
| 212 | dataSheetName, _, err := f.adjustRange(opts.pivotDataRange) |
| 213 | if err != nil { |
| 214 | return nil, "", newPivotTableDataRangeError(err.Error()) |
| 215 | } |
| 216 | dataSheet, err := f.workSheetReader(dataSheetName) |
| 217 | if err != nil { |
| 218 | return dataSheet, "", err |
| 219 | } |
| 220 | pivotTableSheetPath, ok := f.getSheetXMLPath(pivotTableSheetName) |
| 221 | if !ok { |
| 222 | return dataSheet, pivotTableSheetPath, ErrSheetNotExist{pivotTableSheetName} |
| 223 | } |
| 224 | if opts.CompactData && opts.ClassicLayout { |
| 225 | return nil, "", ErrPivotTableClassicLayout |
| 226 | } |
| 227 | return dataSheet, pivotTableSheetPath, err |
| 228 | } |
| 229 | |
| 230 | // adjustRange adjust range, for example: adjust Sheet1!$E$31:$A$1 to Sheet1!$A$1:$E$31 |
| 231 | func (f *File) adjustRange(rangeStr string) (string, []int, error) { |