github.com/yaegashi/msgraph.go@v0.1.4/beta/ActionWorkbook.go (about) 1 // Code generated by msgraph.go/gen DO NOT EDIT. 2 3 package msgraph 4 5 import ( 6 "context" 7 "encoding/json" 8 "fmt" 9 "io/ioutil" 10 "net/http" 11 12 "github.com/yaegashi/msgraph.go/jsonx" 13 ) 14 15 // WorkbookChartCollectionAddRequestParameter undocumented 16 type WorkbookChartCollectionAddRequestParameter struct { 17 // Type undocumented 18 Type *string `json:"type,omitempty"` 19 // SourceData undocumented 20 SourceData json.RawMessage `json:"sourceData,omitempty"` 21 // SeriesBy undocumented 22 SeriesBy *string `json:"seriesBy,omitempty"` 23 } 24 25 // WorkbookNamedItemCollectionAddRequestParameter undocumented 26 type WorkbookNamedItemCollectionAddRequestParameter struct { 27 // Name undocumented 28 Name *string `json:"name,omitempty"` 29 // Reference undocumented 30 Reference json.RawMessage `json:"reference,omitempty"` 31 // Comment undocumented 32 Comment *string `json:"comment,omitempty"` 33 } 34 35 // WorkbookNamedItemCollectionAddFormulaLocalRequestParameter undocumented 36 type WorkbookNamedItemCollectionAddFormulaLocalRequestParameter struct { 37 // Name undocumented 38 Name *string `json:"name,omitempty"` 39 // Formula undocumented 40 Formula *string `json:"formula,omitempty"` 41 // Comment undocumented 42 Comment *string `json:"comment,omitempty"` 43 } 44 45 // WorkbookPivotTableCollectionRefreshAllRequestParameter undocumented 46 type WorkbookPivotTableCollectionRefreshAllRequestParameter struct { 47 } 48 49 // WorkbookTableCollectionAddRequestParameter undocumented 50 type WorkbookTableCollectionAddRequestParameter struct { 51 // Address undocumented 52 Address *string `json:"address,omitempty"` 53 // HasHeaders undocumented 54 HasHeaders *bool `json:"hasHeaders,omitempty"` 55 } 56 57 // WorkbookTableColumnCollectionAddRequestParameter undocumented 58 type WorkbookTableColumnCollectionAddRequestParameter struct { 59 // Index undocumented 60 Index *int `json:"index,omitempty"` 61 // Values undocumented 62 Values json.RawMessage `json:"values,omitempty"` 63 // Name undocumented 64 Name *string `json:"name,omitempty"` 65 } 66 67 // WorkbookTableRowCollectionAddRequestParameter undocumented 68 type WorkbookTableRowCollectionAddRequestParameter struct { 69 // Index undocumented 70 Index *int `json:"index,omitempty"` 71 // Values undocumented 72 Values json.RawMessage `json:"values,omitempty"` 73 } 74 75 // WorkbookWorksheetCollectionAddRequestParameter undocumented 76 type WorkbookWorksheetCollectionAddRequestParameter struct { 77 // Name undocumented 78 Name *string `json:"name,omitempty"` 79 } 80 81 // WorkbookCreateSessionRequestParameter undocumented 82 type WorkbookCreateSessionRequestParameter struct { 83 // PersistChanges undocumented 84 PersistChanges *bool `json:"persistChanges,omitempty"` 85 } 86 87 // WorkbookCloseSessionRequestParameter undocumented 88 type WorkbookCloseSessionRequestParameter struct { 89 } 90 91 // WorkbookRefreshSessionRequestParameter undocumented 92 type WorkbookRefreshSessionRequestParameter struct { 93 } 94 95 // WorkbookApplicationCalculateRequestParameter undocumented 96 type WorkbookApplicationCalculateRequestParameter struct { 97 // CalculationType undocumented 98 CalculationType *string `json:"calculationType,omitempty"` 99 } 100 101 // WorkbookChartSetDataRequestParameter undocumented 102 type WorkbookChartSetDataRequestParameter struct { 103 // SourceData undocumented 104 SourceData json.RawMessage `json:"sourceData,omitempty"` 105 // SeriesBy undocumented 106 SeriesBy *string `json:"seriesBy,omitempty"` 107 } 108 109 // WorkbookChartSetPositionRequestParameter undocumented 110 type WorkbookChartSetPositionRequestParameter struct { 111 // StartCell undocumented 112 StartCell json.RawMessage `json:"startCell,omitempty"` 113 // EndCell undocumented 114 EndCell json.RawMessage `json:"endCell,omitempty"` 115 } 116 117 // WorkbookChartFillClearRequestParameter undocumented 118 type WorkbookChartFillClearRequestParameter struct { 119 } 120 121 // WorkbookChartFillSetSolidColorRequestParameter undocumented 122 type WorkbookChartFillSetSolidColorRequestParameter struct { 123 // Color undocumented 124 Color *string `json:"color,omitempty"` 125 } 126 127 // WorkbookChartLineFormatClearRequestParameter undocumented 128 type WorkbookChartLineFormatClearRequestParameter struct { 129 } 130 131 // WorkbookFilterApplyRequestParameter undocumented 132 type WorkbookFilterApplyRequestParameter struct { 133 // Criteria undocumented 134 Criteria *WorkbookFilterCriteria `json:"criteria,omitempty"` 135 } 136 137 // WorkbookFilterApplyBottomItemsFilterRequestParameter undocumented 138 type WorkbookFilterApplyBottomItemsFilterRequestParameter struct { 139 // Count undocumented 140 Count *int `json:"count,omitempty"` 141 } 142 143 // WorkbookFilterApplyBottomPercentFilterRequestParameter undocumented 144 type WorkbookFilterApplyBottomPercentFilterRequestParameter struct { 145 // Percent undocumented 146 Percent *int `json:"percent,omitempty"` 147 } 148 149 // WorkbookFilterApplyCellColorFilterRequestParameter undocumented 150 type WorkbookFilterApplyCellColorFilterRequestParameter struct { 151 // Color undocumented 152 Color *string `json:"color,omitempty"` 153 } 154 155 // WorkbookFilterApplyCustomFilterRequestParameter undocumented 156 type WorkbookFilterApplyCustomFilterRequestParameter struct { 157 // Criteria1 undocumented 158 Criteria1 *string `json:"criteria1,omitempty"` 159 // Criteria2 undocumented 160 Criteria2 *string `json:"criteria2,omitempty"` 161 // Oper undocumented 162 Oper *string `json:"oper,omitempty"` 163 } 164 165 // WorkbookFilterApplyDynamicFilterRequestParameter undocumented 166 type WorkbookFilterApplyDynamicFilterRequestParameter struct { 167 // Criteria undocumented 168 Criteria *string `json:"criteria,omitempty"` 169 } 170 171 // WorkbookFilterApplyFontColorFilterRequestParameter undocumented 172 type WorkbookFilterApplyFontColorFilterRequestParameter struct { 173 // Color undocumented 174 Color *string `json:"color,omitempty"` 175 } 176 177 // WorkbookFilterApplyIconFilterRequestParameter undocumented 178 type WorkbookFilterApplyIconFilterRequestParameter struct { 179 // Icon undocumented 180 Icon *WorkbookIcon `json:"icon,omitempty"` 181 } 182 183 // WorkbookFilterApplyTopItemsFilterRequestParameter undocumented 184 type WorkbookFilterApplyTopItemsFilterRequestParameter struct { 185 // Count undocumented 186 Count *int `json:"count,omitempty"` 187 } 188 189 // WorkbookFilterApplyTopPercentFilterRequestParameter undocumented 190 type WorkbookFilterApplyTopPercentFilterRequestParameter struct { 191 // Percent undocumented 192 Percent *int `json:"percent,omitempty"` 193 } 194 195 // WorkbookFilterApplyValuesFilterRequestParameter undocumented 196 type WorkbookFilterApplyValuesFilterRequestParameter struct { 197 // Values undocumented 198 Values json.RawMessage `json:"values,omitempty"` 199 } 200 201 // WorkbookFilterClearRequestParameter undocumented 202 type WorkbookFilterClearRequestParameter struct { 203 } 204 205 // WorkbookFunctionsAbsRequestParameter undocumented 206 type WorkbookFunctionsAbsRequestParameter struct { 207 // Number undocumented 208 Number json.RawMessage `json:"number,omitempty"` 209 } 210 211 // WorkbookFunctionsAccrIntRequestParameter undocumented 212 type WorkbookFunctionsAccrIntRequestParameter struct { 213 // Issue undocumented 214 Issue json.RawMessage `json:"issue,omitempty"` 215 // FirstInterest undocumented 216 FirstInterest json.RawMessage `json:"firstInterest,omitempty"` 217 // Settlement undocumented 218 Settlement json.RawMessage `json:"settlement,omitempty"` 219 // Rate undocumented 220 Rate json.RawMessage `json:"rate,omitempty"` 221 // Par undocumented 222 Par json.RawMessage `json:"par,omitempty"` 223 // Frequency undocumented 224 Frequency json.RawMessage `json:"frequency,omitempty"` 225 // Basis undocumented 226 Basis json.RawMessage `json:"basis,omitempty"` 227 // CalcMethod undocumented 228 CalcMethod json.RawMessage `json:"calcMethod,omitempty"` 229 } 230 231 // WorkbookFunctionsAccrIntMRequestParameter undocumented 232 type WorkbookFunctionsAccrIntMRequestParameter struct { 233 // Issue undocumented 234 Issue json.RawMessage `json:"issue,omitempty"` 235 // Settlement undocumented 236 Settlement json.RawMessage `json:"settlement,omitempty"` 237 // Rate undocumented 238 Rate json.RawMessage `json:"rate,omitempty"` 239 // Par undocumented 240 Par json.RawMessage `json:"par,omitempty"` 241 // Basis undocumented 242 Basis json.RawMessage `json:"basis,omitempty"` 243 } 244 245 // WorkbookFunctionsAcosRequestParameter undocumented 246 type WorkbookFunctionsAcosRequestParameter struct { 247 // Number undocumented 248 Number json.RawMessage `json:"number,omitempty"` 249 } 250 251 // WorkbookFunctionsAcoshRequestParameter undocumented 252 type WorkbookFunctionsAcoshRequestParameter struct { 253 // Number undocumented 254 Number json.RawMessage `json:"number,omitempty"` 255 } 256 257 // WorkbookFunctionsAcotRequestParameter undocumented 258 type WorkbookFunctionsAcotRequestParameter struct { 259 // Number undocumented 260 Number json.RawMessage `json:"number,omitempty"` 261 } 262 263 // WorkbookFunctionsAcothRequestParameter undocumented 264 type WorkbookFunctionsAcothRequestParameter struct { 265 // Number undocumented 266 Number json.RawMessage `json:"number,omitempty"` 267 } 268 269 // WorkbookFunctionsAmorDegrcRequestParameter undocumented 270 type WorkbookFunctionsAmorDegrcRequestParameter struct { 271 // Cost undocumented 272 Cost json.RawMessage `json:"cost,omitempty"` 273 // DatePurchased undocumented 274 DatePurchased json.RawMessage `json:"datePurchased,omitempty"` 275 // FirstPeriod undocumented 276 FirstPeriod json.RawMessage `json:"firstPeriod,omitempty"` 277 // Salvage undocumented 278 Salvage json.RawMessage `json:"salvage,omitempty"` 279 // Period undocumented 280 Period json.RawMessage `json:"period,omitempty"` 281 // Rate undocumented 282 Rate json.RawMessage `json:"rate,omitempty"` 283 // Basis undocumented 284 Basis json.RawMessage `json:"basis,omitempty"` 285 } 286 287 // WorkbookFunctionsAmorLincRequestParameter undocumented 288 type WorkbookFunctionsAmorLincRequestParameter struct { 289 // Cost undocumented 290 Cost json.RawMessage `json:"cost,omitempty"` 291 // DatePurchased undocumented 292 DatePurchased json.RawMessage `json:"datePurchased,omitempty"` 293 // FirstPeriod undocumented 294 FirstPeriod json.RawMessage `json:"firstPeriod,omitempty"` 295 // Salvage undocumented 296 Salvage json.RawMessage `json:"salvage,omitempty"` 297 // Period undocumented 298 Period json.RawMessage `json:"period,omitempty"` 299 // Rate undocumented 300 Rate json.RawMessage `json:"rate,omitempty"` 301 // Basis undocumented 302 Basis json.RawMessage `json:"basis,omitempty"` 303 } 304 305 // WorkbookFunctionsAndRequestParameter undocumented 306 type WorkbookFunctionsAndRequestParameter struct { 307 // Values undocumented 308 Values json.RawMessage `json:"values,omitempty"` 309 } 310 311 // WorkbookFunctionsArabicRequestParameter undocumented 312 type WorkbookFunctionsArabicRequestParameter struct { 313 // Text undocumented 314 Text json.RawMessage `json:"text,omitempty"` 315 } 316 317 // WorkbookFunctionsAreasRequestParameter undocumented 318 type WorkbookFunctionsAreasRequestParameter struct { 319 // Reference undocumented 320 Reference json.RawMessage `json:"reference,omitempty"` 321 } 322 323 // WorkbookFunctionsAscRequestParameter undocumented 324 type WorkbookFunctionsAscRequestParameter struct { 325 // Text undocumented 326 Text json.RawMessage `json:"text,omitempty"` 327 } 328 329 // WorkbookFunctionsAsinRequestParameter undocumented 330 type WorkbookFunctionsAsinRequestParameter struct { 331 // Number undocumented 332 Number json.RawMessage `json:"number,omitempty"` 333 } 334 335 // WorkbookFunctionsAsinhRequestParameter undocumented 336 type WorkbookFunctionsAsinhRequestParameter struct { 337 // Number undocumented 338 Number json.RawMessage `json:"number,omitempty"` 339 } 340 341 // WorkbookFunctionsAtanRequestParameter undocumented 342 type WorkbookFunctionsAtanRequestParameter struct { 343 // Number undocumented 344 Number json.RawMessage `json:"number,omitempty"` 345 } 346 347 // WorkbookFunctionsAtan2RequestParameter undocumented 348 type WorkbookFunctionsAtan2RequestParameter struct { 349 // XNum undocumented 350 XNum json.RawMessage `json:"xNum,omitempty"` 351 // YNum undocumented 352 YNum json.RawMessage `json:"yNum,omitempty"` 353 } 354 355 // WorkbookFunctionsAtanhRequestParameter undocumented 356 type WorkbookFunctionsAtanhRequestParameter struct { 357 // Number undocumented 358 Number json.RawMessage `json:"number,omitempty"` 359 } 360 361 // WorkbookFunctionsAveDevRequestParameter undocumented 362 type WorkbookFunctionsAveDevRequestParameter struct { 363 // Values undocumented 364 Values json.RawMessage `json:"values,omitempty"` 365 } 366 367 // WorkbookFunctionsAverageRequestParameter undocumented 368 type WorkbookFunctionsAverageRequestParameter struct { 369 // Values undocumented 370 Values json.RawMessage `json:"values,omitempty"` 371 } 372 373 // WorkbookFunctionsAverageARequestParameter undocumented 374 type WorkbookFunctionsAverageARequestParameter struct { 375 // Values undocumented 376 Values json.RawMessage `json:"values,omitempty"` 377 } 378 379 // WorkbookFunctionsAverageIfRequestParameter undocumented 380 type WorkbookFunctionsAverageIfRequestParameter struct { 381 // Range undocumented 382 Range json.RawMessage `json:"range,omitempty"` 383 // Criteria undocumented 384 Criteria json.RawMessage `json:"criteria,omitempty"` 385 // AverageRange undocumented 386 AverageRange json.RawMessage `json:"averageRange,omitempty"` 387 } 388 389 // WorkbookFunctionsAverageIfsRequestParameter undocumented 390 type WorkbookFunctionsAverageIfsRequestParameter struct { 391 // AverageRange undocumented 392 AverageRange json.RawMessage `json:"averageRange,omitempty"` 393 // Values undocumented 394 Values json.RawMessage `json:"values,omitempty"` 395 } 396 397 // WorkbookFunctionsBahtTextRequestParameter undocumented 398 type WorkbookFunctionsBahtTextRequestParameter struct { 399 // Number undocumented 400 Number json.RawMessage `json:"number,omitempty"` 401 } 402 403 // WorkbookFunctionsBaseRequestParameter undocumented 404 type WorkbookFunctionsBaseRequestParameter struct { 405 // Number undocumented 406 Number json.RawMessage `json:"number,omitempty"` 407 // Radix undocumented 408 Radix json.RawMessage `json:"radix,omitempty"` 409 // MinLength undocumented 410 MinLength json.RawMessage `json:"minLength,omitempty"` 411 } 412 413 // WorkbookFunctionsBesselIRequestParameter undocumented 414 type WorkbookFunctionsBesselIRequestParameter struct { 415 // X undocumented 416 X json.RawMessage `json:"x,omitempty"` 417 // N undocumented 418 N json.RawMessage `json:"n,omitempty"` 419 } 420 421 // WorkbookFunctionsBesselJRequestParameter undocumented 422 type WorkbookFunctionsBesselJRequestParameter struct { 423 // X undocumented 424 X json.RawMessage `json:"x,omitempty"` 425 // N undocumented 426 N json.RawMessage `json:"n,omitempty"` 427 } 428 429 // WorkbookFunctionsBesselKRequestParameter undocumented 430 type WorkbookFunctionsBesselKRequestParameter struct { 431 // X undocumented 432 X json.RawMessage `json:"x,omitempty"` 433 // N undocumented 434 N json.RawMessage `json:"n,omitempty"` 435 } 436 437 // WorkbookFunctionsBesselYRequestParameter undocumented 438 type WorkbookFunctionsBesselYRequestParameter struct { 439 // X undocumented 440 X json.RawMessage `json:"x,omitempty"` 441 // N undocumented 442 N json.RawMessage `json:"n,omitempty"` 443 } 444 445 // WorkbookFunctionsBeta_DistRequestParameter undocumented 446 type WorkbookFunctionsBeta_DistRequestParameter struct { 447 // X undocumented 448 X json.RawMessage `json:"x,omitempty"` 449 // Alpha undocumented 450 Alpha json.RawMessage `json:"alpha,omitempty"` 451 // Beta undocumented 452 Beta json.RawMessage `json:"beta,omitempty"` 453 // Cumulative undocumented 454 Cumulative json.RawMessage `json:"cumulative,omitempty"` 455 // A undocumented 456 A json.RawMessage `json:"A,omitempty"` 457 // B undocumented 458 B json.RawMessage `json:"B,omitempty"` 459 } 460 461 // WorkbookFunctionsBeta_InvRequestParameter undocumented 462 type WorkbookFunctionsBeta_InvRequestParameter struct { 463 // Probability undocumented 464 Probability json.RawMessage `json:"probability,omitempty"` 465 // Alpha undocumented 466 Alpha json.RawMessage `json:"alpha,omitempty"` 467 // Beta undocumented 468 Beta json.RawMessage `json:"beta,omitempty"` 469 // A undocumented 470 A json.RawMessage `json:"A,omitempty"` 471 // B undocumented 472 B json.RawMessage `json:"B,omitempty"` 473 } 474 475 // WorkbookFunctionsBin2DecRequestParameter undocumented 476 type WorkbookFunctionsBin2DecRequestParameter struct { 477 // Number undocumented 478 Number json.RawMessage `json:"number,omitempty"` 479 } 480 481 // WorkbookFunctionsBin2HexRequestParameter undocumented 482 type WorkbookFunctionsBin2HexRequestParameter struct { 483 // Number undocumented 484 Number json.RawMessage `json:"number,omitempty"` 485 // Places undocumented 486 Places json.RawMessage `json:"places,omitempty"` 487 } 488 489 // WorkbookFunctionsBin2OctRequestParameter undocumented 490 type WorkbookFunctionsBin2OctRequestParameter struct { 491 // Number undocumented 492 Number json.RawMessage `json:"number,omitempty"` 493 // Places undocumented 494 Places json.RawMessage `json:"places,omitempty"` 495 } 496 497 // WorkbookFunctionsBinom_DistRequestParameter undocumented 498 type WorkbookFunctionsBinom_DistRequestParameter struct { 499 // NumberS undocumented 500 NumberS json.RawMessage `json:"numberS,omitempty"` 501 // Trials undocumented 502 Trials json.RawMessage `json:"trials,omitempty"` 503 // ProbabilityS undocumented 504 ProbabilityS json.RawMessage `json:"probabilityS,omitempty"` 505 // Cumulative undocumented 506 Cumulative json.RawMessage `json:"cumulative,omitempty"` 507 } 508 509 // WorkbookFunctionsBinom_Dist_RangeRequestParameter undocumented 510 type WorkbookFunctionsBinom_Dist_RangeRequestParameter struct { 511 // Trials undocumented 512 Trials json.RawMessage `json:"trials,omitempty"` 513 // ProbabilityS undocumented 514 ProbabilityS json.RawMessage `json:"probabilityS,omitempty"` 515 // NumberS undocumented 516 NumberS json.RawMessage `json:"numberS,omitempty"` 517 // NumberS2 undocumented 518 NumberS2 json.RawMessage `json:"numberS2,omitempty"` 519 } 520 521 // WorkbookFunctionsBinom_InvRequestParameter undocumented 522 type WorkbookFunctionsBinom_InvRequestParameter struct { 523 // Trials undocumented 524 Trials json.RawMessage `json:"trials,omitempty"` 525 // ProbabilityS undocumented 526 ProbabilityS json.RawMessage `json:"probabilityS,omitempty"` 527 // Alpha undocumented 528 Alpha json.RawMessage `json:"alpha,omitempty"` 529 } 530 531 // WorkbookFunctionsBitandRequestParameter undocumented 532 type WorkbookFunctionsBitandRequestParameter struct { 533 // Number1 undocumented 534 Number1 json.RawMessage `json:"number1,omitempty"` 535 // Number2 undocumented 536 Number2 json.RawMessage `json:"number2,omitempty"` 537 } 538 539 // WorkbookFunctionsBitlshiftRequestParameter undocumented 540 type WorkbookFunctionsBitlshiftRequestParameter struct { 541 // Number undocumented 542 Number json.RawMessage `json:"number,omitempty"` 543 // ShiftAmount undocumented 544 ShiftAmount json.RawMessage `json:"shiftAmount,omitempty"` 545 } 546 547 // WorkbookFunctionsBitorRequestParameter undocumented 548 type WorkbookFunctionsBitorRequestParameter struct { 549 // Number1 undocumented 550 Number1 json.RawMessage `json:"number1,omitempty"` 551 // Number2 undocumented 552 Number2 json.RawMessage `json:"number2,omitempty"` 553 } 554 555 // WorkbookFunctionsBitrshiftRequestParameter undocumented 556 type WorkbookFunctionsBitrshiftRequestParameter struct { 557 // Number undocumented 558 Number json.RawMessage `json:"number,omitempty"` 559 // ShiftAmount undocumented 560 ShiftAmount json.RawMessage `json:"shiftAmount,omitempty"` 561 } 562 563 // WorkbookFunctionsBitxorRequestParameter undocumented 564 type WorkbookFunctionsBitxorRequestParameter struct { 565 // Number1 undocumented 566 Number1 json.RawMessage `json:"number1,omitempty"` 567 // Number2 undocumented 568 Number2 json.RawMessage `json:"number2,omitempty"` 569 } 570 571 // WorkbookFunctionsCeiling_MathRequestParameter undocumented 572 type WorkbookFunctionsCeiling_MathRequestParameter struct { 573 // Number undocumented 574 Number json.RawMessage `json:"number,omitempty"` 575 // Significance undocumented 576 Significance json.RawMessage `json:"significance,omitempty"` 577 // Mode undocumented 578 Mode json.RawMessage `json:"mode,omitempty"` 579 } 580 581 // WorkbookFunctionsCeiling_PreciseRequestParameter undocumented 582 type WorkbookFunctionsCeiling_PreciseRequestParameter struct { 583 // Number undocumented 584 Number json.RawMessage `json:"number,omitempty"` 585 // Significance undocumented 586 Significance json.RawMessage `json:"significance,omitempty"` 587 } 588 589 // WorkbookFunctionsCharRequestParameter undocumented 590 type WorkbookFunctionsCharRequestParameter struct { 591 // Number undocumented 592 Number json.RawMessage `json:"number,omitempty"` 593 } 594 595 // WorkbookFunctionsChiSq_DistRequestParameter undocumented 596 type WorkbookFunctionsChiSq_DistRequestParameter struct { 597 // X undocumented 598 X json.RawMessage `json:"x,omitempty"` 599 // DegFreedom undocumented 600 DegFreedom json.RawMessage `json:"degFreedom,omitempty"` 601 // Cumulative undocumented 602 Cumulative json.RawMessage `json:"cumulative,omitempty"` 603 } 604 605 // WorkbookFunctionsChiSq_Dist_RTRequestParameter undocumented 606 type WorkbookFunctionsChiSq_Dist_RTRequestParameter struct { 607 // X undocumented 608 X json.RawMessage `json:"x,omitempty"` 609 // DegFreedom undocumented 610 DegFreedom json.RawMessage `json:"degFreedom,omitempty"` 611 } 612 613 // WorkbookFunctionsChiSq_InvRequestParameter undocumented 614 type WorkbookFunctionsChiSq_InvRequestParameter struct { 615 // Probability undocumented 616 Probability json.RawMessage `json:"probability,omitempty"` 617 // DegFreedom undocumented 618 DegFreedom json.RawMessage `json:"degFreedom,omitempty"` 619 } 620 621 // WorkbookFunctionsChiSq_Inv_RTRequestParameter undocumented 622 type WorkbookFunctionsChiSq_Inv_RTRequestParameter struct { 623 // Probability undocumented 624 Probability json.RawMessage `json:"probability,omitempty"` 625 // DegFreedom undocumented 626 DegFreedom json.RawMessage `json:"degFreedom,omitempty"` 627 } 628 629 // WorkbookFunctionsChooseRequestParameter undocumented 630 type WorkbookFunctionsChooseRequestParameter struct { 631 // IndexNum undocumented 632 IndexNum json.RawMessage `json:"indexNum,omitempty"` 633 // Values undocumented 634 Values json.RawMessage `json:"values,omitempty"` 635 } 636 637 // WorkbookFunctionsCleanRequestParameter undocumented 638 type WorkbookFunctionsCleanRequestParameter struct { 639 // Text undocumented 640 Text json.RawMessage `json:"text,omitempty"` 641 } 642 643 // WorkbookFunctionsCodeRequestParameter undocumented 644 type WorkbookFunctionsCodeRequestParameter struct { 645 // Text undocumented 646 Text json.RawMessage `json:"text,omitempty"` 647 } 648 649 // WorkbookFunctionsColumnsRequestParameter undocumented 650 type WorkbookFunctionsColumnsRequestParameter struct { 651 // Array undocumented 652 Array json.RawMessage `json:"array,omitempty"` 653 } 654 655 // WorkbookFunctionsCombinRequestParameter undocumented 656 type WorkbookFunctionsCombinRequestParameter struct { 657 // Number undocumented 658 Number json.RawMessage `json:"number,omitempty"` 659 // NumberChosen undocumented 660 NumberChosen json.RawMessage `json:"numberChosen,omitempty"` 661 } 662 663 // WorkbookFunctionsCombinaRequestParameter undocumented 664 type WorkbookFunctionsCombinaRequestParameter struct { 665 // Number undocumented 666 Number json.RawMessage `json:"number,omitempty"` 667 // NumberChosen undocumented 668 NumberChosen json.RawMessage `json:"numberChosen,omitempty"` 669 } 670 671 // WorkbookFunctionsComplexRequestParameter undocumented 672 type WorkbookFunctionsComplexRequestParameter struct { 673 // RealNum undocumented 674 RealNum json.RawMessage `json:"realNum,omitempty"` 675 // INum undocumented 676 INum json.RawMessage `json:"iNum,omitempty"` 677 // Suffix undocumented 678 Suffix json.RawMessage `json:"suffix,omitempty"` 679 } 680 681 // WorkbookFunctionsConcatenateRequestParameter undocumented 682 type WorkbookFunctionsConcatenateRequestParameter struct { 683 // Values undocumented 684 Values json.RawMessage `json:"values,omitempty"` 685 } 686 687 // WorkbookFunctionsConfidence_NormRequestParameter undocumented 688 type WorkbookFunctionsConfidence_NormRequestParameter struct { 689 // Alpha undocumented 690 Alpha json.RawMessage `json:"alpha,omitempty"` 691 // StandardDev undocumented 692 StandardDev json.RawMessage `json:"standardDev,omitempty"` 693 // Size undocumented 694 Size json.RawMessage `json:"size,omitempty"` 695 } 696 697 // WorkbookFunctionsConfidence_TRequestParameter undocumented 698 type WorkbookFunctionsConfidence_TRequestParameter struct { 699 // Alpha undocumented 700 Alpha json.RawMessage `json:"alpha,omitempty"` 701 // StandardDev undocumented 702 StandardDev json.RawMessage `json:"standardDev,omitempty"` 703 // Size undocumented 704 Size json.RawMessage `json:"size,omitempty"` 705 } 706 707 // WorkbookFunctionsConvertRequestParameter undocumented 708 type WorkbookFunctionsConvertRequestParameter struct { 709 // Number undocumented 710 Number json.RawMessage `json:"number,omitempty"` 711 // FromUnit undocumented 712 FromUnit json.RawMessage `json:"fromUnit,omitempty"` 713 // ToUnit undocumented 714 ToUnit json.RawMessage `json:"toUnit,omitempty"` 715 } 716 717 // WorkbookFunctionsCosRequestParameter undocumented 718 type WorkbookFunctionsCosRequestParameter struct { 719 // Number undocumented 720 Number json.RawMessage `json:"number,omitempty"` 721 } 722 723 // WorkbookFunctionsCoshRequestParameter undocumented 724 type WorkbookFunctionsCoshRequestParameter struct { 725 // Number undocumented 726 Number json.RawMessage `json:"number,omitempty"` 727 } 728 729 // WorkbookFunctionsCotRequestParameter undocumented 730 type WorkbookFunctionsCotRequestParameter struct { 731 // Number undocumented 732 Number json.RawMessage `json:"number,omitempty"` 733 } 734 735 // WorkbookFunctionsCothRequestParameter undocumented 736 type WorkbookFunctionsCothRequestParameter struct { 737 // Number undocumented 738 Number json.RawMessage `json:"number,omitempty"` 739 } 740 741 // WorkbookFunctionsCountRequestParameter undocumented 742 type WorkbookFunctionsCountRequestParameter struct { 743 // Values undocumented 744 Values json.RawMessage `json:"values,omitempty"` 745 } 746 747 // WorkbookFunctionsCountARequestParameter undocumented 748 type WorkbookFunctionsCountARequestParameter struct { 749 // Values undocumented 750 Values json.RawMessage `json:"values,omitempty"` 751 } 752 753 // WorkbookFunctionsCountBlankRequestParameter undocumented 754 type WorkbookFunctionsCountBlankRequestParameter struct { 755 // Range undocumented 756 Range json.RawMessage `json:"range,omitempty"` 757 } 758 759 // WorkbookFunctionsCountIfRequestParameter undocumented 760 type WorkbookFunctionsCountIfRequestParameter struct { 761 // Range undocumented 762 Range json.RawMessage `json:"range,omitempty"` 763 // Criteria undocumented 764 Criteria json.RawMessage `json:"criteria,omitempty"` 765 } 766 767 // WorkbookFunctionsCountIfsRequestParameter undocumented 768 type WorkbookFunctionsCountIfsRequestParameter struct { 769 // Values undocumented 770 Values json.RawMessage `json:"values,omitempty"` 771 } 772 773 // WorkbookFunctionsCoupDayBsRequestParameter undocumented 774 type WorkbookFunctionsCoupDayBsRequestParameter struct { 775 // Settlement undocumented 776 Settlement json.RawMessage `json:"settlement,omitempty"` 777 // Maturity undocumented 778 Maturity json.RawMessage `json:"maturity,omitempty"` 779 // Frequency undocumented 780 Frequency json.RawMessage `json:"frequency,omitempty"` 781 // Basis undocumented 782 Basis json.RawMessage `json:"basis,omitempty"` 783 } 784 785 // WorkbookFunctionsCoupDaysRequestParameter undocumented 786 type WorkbookFunctionsCoupDaysRequestParameter struct { 787 // Settlement undocumented 788 Settlement json.RawMessage `json:"settlement,omitempty"` 789 // Maturity undocumented 790 Maturity json.RawMessage `json:"maturity,omitempty"` 791 // Frequency undocumented 792 Frequency json.RawMessage `json:"frequency,omitempty"` 793 // Basis undocumented 794 Basis json.RawMessage `json:"basis,omitempty"` 795 } 796 797 // WorkbookFunctionsCoupDaysNcRequestParameter undocumented 798 type WorkbookFunctionsCoupDaysNcRequestParameter struct { 799 // Settlement undocumented 800 Settlement json.RawMessage `json:"settlement,omitempty"` 801 // Maturity undocumented 802 Maturity json.RawMessage `json:"maturity,omitempty"` 803 // Frequency undocumented 804 Frequency json.RawMessage `json:"frequency,omitempty"` 805 // Basis undocumented 806 Basis json.RawMessage `json:"basis,omitempty"` 807 } 808 809 // WorkbookFunctionsCoupNcdRequestParameter undocumented 810 type WorkbookFunctionsCoupNcdRequestParameter struct { 811 // Settlement undocumented 812 Settlement json.RawMessage `json:"settlement,omitempty"` 813 // Maturity undocumented 814 Maturity json.RawMessage `json:"maturity,omitempty"` 815 // Frequency undocumented 816 Frequency json.RawMessage `json:"frequency,omitempty"` 817 // Basis undocumented 818 Basis json.RawMessage `json:"basis,omitempty"` 819 } 820 821 // WorkbookFunctionsCoupNumRequestParameter undocumented 822 type WorkbookFunctionsCoupNumRequestParameter struct { 823 // Settlement undocumented 824 Settlement json.RawMessage `json:"settlement,omitempty"` 825 // Maturity undocumented 826 Maturity json.RawMessage `json:"maturity,omitempty"` 827 // Frequency undocumented 828 Frequency json.RawMessage `json:"frequency,omitempty"` 829 // Basis undocumented 830 Basis json.RawMessage `json:"basis,omitempty"` 831 } 832 833 // WorkbookFunctionsCoupPcdRequestParameter undocumented 834 type WorkbookFunctionsCoupPcdRequestParameter struct { 835 // Settlement undocumented 836 Settlement json.RawMessage `json:"settlement,omitempty"` 837 // Maturity undocumented 838 Maturity json.RawMessage `json:"maturity,omitempty"` 839 // Frequency undocumented 840 Frequency json.RawMessage `json:"frequency,omitempty"` 841 // Basis undocumented 842 Basis json.RawMessage `json:"basis,omitempty"` 843 } 844 845 // WorkbookFunctionsCscRequestParameter undocumented 846 type WorkbookFunctionsCscRequestParameter struct { 847 // Number undocumented 848 Number json.RawMessage `json:"number,omitempty"` 849 } 850 851 // WorkbookFunctionsCschRequestParameter undocumented 852 type WorkbookFunctionsCschRequestParameter struct { 853 // Number undocumented 854 Number json.RawMessage `json:"number,omitempty"` 855 } 856 857 // WorkbookFunctionsCumIPmtRequestParameter undocumented 858 type WorkbookFunctionsCumIPmtRequestParameter struct { 859 // Rate undocumented 860 Rate json.RawMessage `json:"rate,omitempty"` 861 // Nper undocumented 862 Nper json.RawMessage `json:"nper,omitempty"` 863 // Pv undocumented 864 Pv json.RawMessage `json:"pv,omitempty"` 865 // StartPeriod undocumented 866 StartPeriod json.RawMessage `json:"startPeriod,omitempty"` 867 // EndPeriod undocumented 868 EndPeriod json.RawMessage `json:"endPeriod,omitempty"` 869 // Type undocumented 870 Type json.RawMessage `json:"type,omitempty"` 871 } 872 873 // WorkbookFunctionsCumPrincRequestParameter undocumented 874 type WorkbookFunctionsCumPrincRequestParameter struct { 875 // Rate undocumented 876 Rate json.RawMessage `json:"rate,omitempty"` 877 // Nper undocumented 878 Nper json.RawMessage `json:"nper,omitempty"` 879 // Pv undocumented 880 Pv json.RawMessage `json:"pv,omitempty"` 881 // StartPeriod undocumented 882 StartPeriod json.RawMessage `json:"startPeriod,omitempty"` 883 // EndPeriod undocumented 884 EndPeriod json.RawMessage `json:"endPeriod,omitempty"` 885 // Type undocumented 886 Type json.RawMessage `json:"type,omitempty"` 887 } 888 889 // WorkbookFunctionsDaverageRequestParameter undocumented 890 type WorkbookFunctionsDaverageRequestParameter struct { 891 // Database undocumented 892 Database json.RawMessage `json:"database,omitempty"` 893 // Field undocumented 894 Field json.RawMessage `json:"field,omitempty"` 895 // Criteria undocumented 896 Criteria json.RawMessage `json:"criteria,omitempty"` 897 } 898 899 // WorkbookFunctionsDcountRequestParameter undocumented 900 type WorkbookFunctionsDcountRequestParameter struct { 901 // Database undocumented 902 Database json.RawMessage `json:"database,omitempty"` 903 // Field undocumented 904 Field json.RawMessage `json:"field,omitempty"` 905 // Criteria undocumented 906 Criteria json.RawMessage `json:"criteria,omitempty"` 907 } 908 909 // WorkbookFunctionsDcountARequestParameter undocumented 910 type WorkbookFunctionsDcountARequestParameter struct { 911 // Database undocumented 912 Database json.RawMessage `json:"database,omitempty"` 913 // Field undocumented 914 Field json.RawMessage `json:"field,omitempty"` 915 // Criteria undocumented 916 Criteria json.RawMessage `json:"criteria,omitempty"` 917 } 918 919 // WorkbookFunctionsDgetRequestParameter undocumented 920 type WorkbookFunctionsDgetRequestParameter struct { 921 // Database undocumented 922 Database json.RawMessage `json:"database,omitempty"` 923 // Field undocumented 924 Field json.RawMessage `json:"field,omitempty"` 925 // Criteria undocumented 926 Criteria json.RawMessage `json:"criteria,omitempty"` 927 } 928 929 // WorkbookFunctionsDmaxRequestParameter undocumented 930 type WorkbookFunctionsDmaxRequestParameter struct { 931 // Database undocumented 932 Database json.RawMessage `json:"database,omitempty"` 933 // Field undocumented 934 Field json.RawMessage `json:"field,omitempty"` 935 // Criteria undocumented 936 Criteria json.RawMessage `json:"criteria,omitempty"` 937 } 938 939 // WorkbookFunctionsDminRequestParameter undocumented 940 type WorkbookFunctionsDminRequestParameter struct { 941 // Database undocumented 942 Database json.RawMessage `json:"database,omitempty"` 943 // Field undocumented 944 Field json.RawMessage `json:"field,omitempty"` 945 // Criteria undocumented 946 Criteria json.RawMessage `json:"criteria,omitempty"` 947 } 948 949 // WorkbookFunctionsDproductRequestParameter undocumented 950 type WorkbookFunctionsDproductRequestParameter struct { 951 // Database undocumented 952 Database json.RawMessage `json:"database,omitempty"` 953 // Field undocumented 954 Field json.RawMessage `json:"field,omitempty"` 955 // Criteria undocumented 956 Criteria json.RawMessage `json:"criteria,omitempty"` 957 } 958 959 // WorkbookFunctionsDstDevRequestParameter undocumented 960 type WorkbookFunctionsDstDevRequestParameter struct { 961 // Database undocumented 962 Database json.RawMessage `json:"database,omitempty"` 963 // Field undocumented 964 Field json.RawMessage `json:"field,omitempty"` 965 // Criteria undocumented 966 Criteria json.RawMessage `json:"criteria,omitempty"` 967 } 968 969 // WorkbookFunctionsDstDevPRequestParameter undocumented 970 type WorkbookFunctionsDstDevPRequestParameter struct { 971 // Database undocumented 972 Database json.RawMessage `json:"database,omitempty"` 973 // Field undocumented 974 Field json.RawMessage `json:"field,omitempty"` 975 // Criteria undocumented 976 Criteria json.RawMessage `json:"criteria,omitempty"` 977 } 978 979 // WorkbookFunctionsDsumRequestParameter undocumented 980 type WorkbookFunctionsDsumRequestParameter struct { 981 // Database undocumented 982 Database json.RawMessage `json:"database,omitempty"` 983 // Field undocumented 984 Field json.RawMessage `json:"field,omitempty"` 985 // Criteria undocumented 986 Criteria json.RawMessage `json:"criteria,omitempty"` 987 } 988 989 // WorkbookFunctionsDvarRequestParameter undocumented 990 type WorkbookFunctionsDvarRequestParameter struct { 991 // Database undocumented 992 Database json.RawMessage `json:"database,omitempty"` 993 // Field undocumented 994 Field json.RawMessage `json:"field,omitempty"` 995 // Criteria undocumented 996 Criteria json.RawMessage `json:"criteria,omitempty"` 997 } 998 999 // WorkbookFunctionsDvarPRequestParameter undocumented 1000 type WorkbookFunctionsDvarPRequestParameter struct { 1001 // Database undocumented 1002 Database json.RawMessage `json:"database,omitempty"` 1003 // Field undocumented 1004 Field json.RawMessage `json:"field,omitempty"` 1005 // Criteria undocumented 1006 Criteria json.RawMessage `json:"criteria,omitempty"` 1007 } 1008 1009 // WorkbookFunctionsDateRequestParameter undocumented 1010 type WorkbookFunctionsDateRequestParameter struct { 1011 // Year undocumented 1012 Year json.RawMessage `json:"year,omitempty"` 1013 // Month undocumented 1014 Month json.RawMessage `json:"month,omitempty"` 1015 // Day undocumented 1016 Day json.RawMessage `json:"day,omitempty"` 1017 } 1018 1019 // WorkbookFunctionsDatevalueRequestParameter undocumented 1020 type WorkbookFunctionsDatevalueRequestParameter struct { 1021 // DateText undocumented 1022 DateText json.RawMessage `json:"dateText,omitempty"` 1023 } 1024 1025 // WorkbookFunctionsDayRequestParameter undocumented 1026 type WorkbookFunctionsDayRequestParameter struct { 1027 // SerialNumber undocumented 1028 SerialNumber json.RawMessage `json:"serialNumber,omitempty"` 1029 } 1030 1031 // WorkbookFunctionsDaysRequestParameter undocumented 1032 type WorkbookFunctionsDaysRequestParameter struct { 1033 // EndDate undocumented 1034 EndDate json.RawMessage `json:"endDate,omitempty"` 1035 // StartDate undocumented 1036 StartDate json.RawMessage `json:"startDate,omitempty"` 1037 } 1038 1039 // WorkbookFunctionsDays360RequestParameter undocumented 1040 type WorkbookFunctionsDays360RequestParameter struct { 1041 // StartDate undocumented 1042 StartDate json.RawMessage `json:"startDate,omitempty"` 1043 // EndDate undocumented 1044 EndDate json.RawMessage `json:"endDate,omitempty"` 1045 // Method undocumented 1046 Method json.RawMessage `json:"method,omitempty"` 1047 } 1048 1049 // WorkbookFunctionsDbRequestParameter undocumented 1050 type WorkbookFunctionsDbRequestParameter struct { 1051 // Cost undocumented 1052 Cost json.RawMessage `json:"cost,omitempty"` 1053 // Salvage undocumented 1054 Salvage json.RawMessage `json:"salvage,omitempty"` 1055 // Life undocumented 1056 Life json.RawMessage `json:"life,omitempty"` 1057 // Period undocumented 1058 Period json.RawMessage `json:"period,omitempty"` 1059 // Month undocumented 1060 Month json.RawMessage `json:"month,omitempty"` 1061 } 1062 1063 // WorkbookFunctionsDbcsRequestParameter undocumented 1064 type WorkbookFunctionsDbcsRequestParameter struct { 1065 // Text undocumented 1066 Text json.RawMessage `json:"text,omitempty"` 1067 } 1068 1069 // WorkbookFunctionsDdbRequestParameter undocumented 1070 type WorkbookFunctionsDdbRequestParameter struct { 1071 // Cost undocumented 1072 Cost json.RawMessage `json:"cost,omitempty"` 1073 // Salvage undocumented 1074 Salvage json.RawMessage `json:"salvage,omitempty"` 1075 // Life undocumented 1076 Life json.RawMessage `json:"life,omitempty"` 1077 // Period undocumented 1078 Period json.RawMessage `json:"period,omitempty"` 1079 // Factor undocumented 1080 Factor json.RawMessage `json:"factor,omitempty"` 1081 } 1082 1083 // WorkbookFunctionsDec2BinRequestParameter undocumented 1084 type WorkbookFunctionsDec2BinRequestParameter struct { 1085 // Number undocumented 1086 Number json.RawMessage `json:"number,omitempty"` 1087 // Places undocumented 1088 Places json.RawMessage `json:"places,omitempty"` 1089 } 1090 1091 // WorkbookFunctionsDec2HexRequestParameter undocumented 1092 type WorkbookFunctionsDec2HexRequestParameter struct { 1093 // Number undocumented 1094 Number json.RawMessage `json:"number,omitempty"` 1095 // Places undocumented 1096 Places json.RawMessage `json:"places,omitempty"` 1097 } 1098 1099 // WorkbookFunctionsDec2OctRequestParameter undocumented 1100 type WorkbookFunctionsDec2OctRequestParameter struct { 1101 // Number undocumented 1102 Number json.RawMessage `json:"number,omitempty"` 1103 // Places undocumented 1104 Places json.RawMessage `json:"places,omitempty"` 1105 } 1106 1107 // WorkbookFunctionsDecimalRequestParameter undocumented 1108 type WorkbookFunctionsDecimalRequestParameter struct { 1109 // Number undocumented 1110 Number json.RawMessage `json:"number,omitempty"` 1111 // Radix undocumented 1112 Radix json.RawMessage `json:"radix,omitempty"` 1113 } 1114 1115 // WorkbookFunctionsDegreesRequestParameter undocumented 1116 type WorkbookFunctionsDegreesRequestParameter struct { 1117 // Angle undocumented 1118 Angle json.RawMessage `json:"angle,omitempty"` 1119 } 1120 1121 // WorkbookFunctionsDeltaRequestParameter undocumented 1122 type WorkbookFunctionsDeltaRequestParameter struct { 1123 // Number1 undocumented 1124 Number1 json.RawMessage `json:"number1,omitempty"` 1125 // Number2 undocumented 1126 Number2 json.RawMessage `json:"number2,omitempty"` 1127 } 1128 1129 // WorkbookFunctionsDevSqRequestParameter undocumented 1130 type WorkbookFunctionsDevSqRequestParameter struct { 1131 // Values undocumented 1132 Values json.RawMessage `json:"values,omitempty"` 1133 } 1134 1135 // WorkbookFunctionsDiscRequestParameter undocumented 1136 type WorkbookFunctionsDiscRequestParameter struct { 1137 // Settlement undocumented 1138 Settlement json.RawMessage `json:"settlement,omitempty"` 1139 // Maturity undocumented 1140 Maturity json.RawMessage `json:"maturity,omitempty"` 1141 // Pr undocumented 1142 Pr json.RawMessage `json:"pr,omitempty"` 1143 // Redemption undocumented 1144 Redemption json.RawMessage `json:"redemption,omitempty"` 1145 // Basis undocumented 1146 Basis json.RawMessage `json:"basis,omitempty"` 1147 } 1148 1149 // WorkbookFunctionsDollarRequestParameter undocumented 1150 type WorkbookFunctionsDollarRequestParameter struct { 1151 // Number undocumented 1152 Number json.RawMessage `json:"number,omitempty"` 1153 // Decimals undocumented 1154 Decimals json.RawMessage `json:"decimals,omitempty"` 1155 } 1156 1157 // WorkbookFunctionsDollarDeRequestParameter undocumented 1158 type WorkbookFunctionsDollarDeRequestParameter struct { 1159 // FractionalDollar undocumented 1160 FractionalDollar json.RawMessage `json:"fractionalDollar,omitempty"` 1161 // Fraction undocumented 1162 Fraction json.RawMessage `json:"fraction,omitempty"` 1163 } 1164 1165 // WorkbookFunctionsDollarFrRequestParameter undocumented 1166 type WorkbookFunctionsDollarFrRequestParameter struct { 1167 // DecimalDollar undocumented 1168 DecimalDollar json.RawMessage `json:"decimalDollar,omitempty"` 1169 // Fraction undocumented 1170 Fraction json.RawMessage `json:"fraction,omitempty"` 1171 } 1172 1173 // WorkbookFunctionsDurationRequestParameter undocumented 1174 type WorkbookFunctionsDurationRequestParameter struct { 1175 // Settlement undocumented 1176 Settlement json.RawMessage `json:"settlement,omitempty"` 1177 // Maturity undocumented 1178 Maturity json.RawMessage `json:"maturity,omitempty"` 1179 // Coupon undocumented 1180 Coupon json.RawMessage `json:"coupon,omitempty"` 1181 // Yld undocumented 1182 Yld json.RawMessage `json:"yld,omitempty"` 1183 // Frequency undocumented 1184 Frequency json.RawMessage `json:"frequency,omitempty"` 1185 // Basis undocumented 1186 Basis json.RawMessage `json:"basis,omitempty"` 1187 } 1188 1189 // WorkbookFunctionsEcma_CeilingRequestParameter undocumented 1190 type WorkbookFunctionsEcma_CeilingRequestParameter struct { 1191 // Number undocumented 1192 Number json.RawMessage `json:"number,omitempty"` 1193 // Significance undocumented 1194 Significance json.RawMessage `json:"significance,omitempty"` 1195 } 1196 1197 // WorkbookFunctionsEdateRequestParameter undocumented 1198 type WorkbookFunctionsEdateRequestParameter struct { 1199 // StartDate undocumented 1200 StartDate json.RawMessage `json:"startDate,omitempty"` 1201 // Months undocumented 1202 Months json.RawMessage `json:"months,omitempty"` 1203 } 1204 1205 // WorkbookFunctionsEffectRequestParameter undocumented 1206 type WorkbookFunctionsEffectRequestParameter struct { 1207 // NominalRate undocumented 1208 NominalRate json.RawMessage `json:"nominalRate,omitempty"` 1209 // Npery undocumented 1210 Npery json.RawMessage `json:"npery,omitempty"` 1211 } 1212 1213 // WorkbookFunctionsEoMonthRequestParameter undocumented 1214 type WorkbookFunctionsEoMonthRequestParameter struct { 1215 // StartDate undocumented 1216 StartDate json.RawMessage `json:"startDate,omitempty"` 1217 // Months undocumented 1218 Months json.RawMessage `json:"months,omitempty"` 1219 } 1220 1221 // WorkbookFunctionsErfRequestParameter undocumented 1222 type WorkbookFunctionsErfRequestParameter struct { 1223 // LowerLimit undocumented 1224 LowerLimit json.RawMessage `json:"lowerLimit,omitempty"` 1225 // UpperLimit undocumented 1226 UpperLimit json.RawMessage `json:"upperLimit,omitempty"` 1227 } 1228 1229 // WorkbookFunctionsErfCRequestParameter undocumented 1230 type WorkbookFunctionsErfCRequestParameter struct { 1231 // X undocumented 1232 X json.RawMessage `json:"x,omitempty"` 1233 } 1234 1235 // WorkbookFunctionsErfC_PreciseRequestParameter undocumented 1236 type WorkbookFunctionsErfC_PreciseRequestParameter struct { 1237 // X undocumented 1238 X json.RawMessage `json:"X,omitempty"` 1239 } 1240 1241 // WorkbookFunctionsErf_PreciseRequestParameter undocumented 1242 type WorkbookFunctionsErf_PreciseRequestParameter struct { 1243 // X undocumented 1244 X json.RawMessage `json:"X,omitempty"` 1245 } 1246 1247 // WorkbookFunctionsError_TypeRequestParameter undocumented 1248 type WorkbookFunctionsError_TypeRequestParameter struct { 1249 // ErrorVal undocumented 1250 ErrorVal json.RawMessage `json:"errorVal,omitempty"` 1251 } 1252 1253 // WorkbookFunctionsEvenRequestParameter undocumented 1254 type WorkbookFunctionsEvenRequestParameter struct { 1255 // Number undocumented 1256 Number json.RawMessage `json:"number,omitempty"` 1257 } 1258 1259 // WorkbookFunctionsExactRequestParameter undocumented 1260 type WorkbookFunctionsExactRequestParameter struct { 1261 // Text1 undocumented 1262 Text1 json.RawMessage `json:"text1,omitempty"` 1263 // Text2 undocumented 1264 Text2 json.RawMessage `json:"text2,omitempty"` 1265 } 1266 1267 // WorkbookFunctionsExpRequestParameter undocumented 1268 type WorkbookFunctionsExpRequestParameter struct { 1269 // Number undocumented 1270 Number json.RawMessage `json:"number,omitempty"` 1271 } 1272 1273 // WorkbookFunctionsExpon_DistRequestParameter undocumented 1274 type WorkbookFunctionsExpon_DistRequestParameter struct { 1275 // X undocumented 1276 X json.RawMessage `json:"x,omitempty"` 1277 // Lambda undocumented 1278 Lambda json.RawMessage `json:"lambda,omitempty"` 1279 // Cumulative undocumented 1280 Cumulative json.RawMessage `json:"cumulative,omitempty"` 1281 } 1282 1283 // WorkbookFunctionsFvscheduleRequestParameter undocumented 1284 type WorkbookFunctionsFvscheduleRequestParameter struct { 1285 // Principal undocumented 1286 Principal json.RawMessage `json:"principal,omitempty"` 1287 // Schedule undocumented 1288 Schedule json.RawMessage `json:"schedule,omitempty"` 1289 } 1290 1291 // WorkbookFunctionsF_DistRequestParameter undocumented 1292 type WorkbookFunctionsF_DistRequestParameter struct { 1293 // X undocumented 1294 X json.RawMessage `json:"x,omitempty"` 1295 // DegFreedom1 undocumented 1296 DegFreedom1 json.RawMessage `json:"degFreedom1,omitempty"` 1297 // DegFreedom2 undocumented 1298 DegFreedom2 json.RawMessage `json:"degFreedom2,omitempty"` 1299 // Cumulative undocumented 1300 Cumulative json.RawMessage `json:"cumulative,omitempty"` 1301 } 1302 1303 // WorkbookFunctionsF_Dist_RTRequestParameter undocumented 1304 type WorkbookFunctionsF_Dist_RTRequestParameter struct { 1305 // X undocumented 1306 X json.RawMessage `json:"x,omitempty"` 1307 // DegFreedom1 undocumented 1308 DegFreedom1 json.RawMessage `json:"degFreedom1,omitempty"` 1309 // DegFreedom2 undocumented 1310 DegFreedom2 json.RawMessage `json:"degFreedom2,omitempty"` 1311 } 1312 1313 // WorkbookFunctionsF_InvRequestParameter undocumented 1314 type WorkbookFunctionsF_InvRequestParameter struct { 1315 // Probability undocumented 1316 Probability json.RawMessage `json:"probability,omitempty"` 1317 // DegFreedom1 undocumented 1318 DegFreedom1 json.RawMessage `json:"degFreedom1,omitempty"` 1319 // DegFreedom2 undocumented 1320 DegFreedom2 json.RawMessage `json:"degFreedom2,omitempty"` 1321 } 1322 1323 // WorkbookFunctionsF_Inv_RTRequestParameter undocumented 1324 type WorkbookFunctionsF_Inv_RTRequestParameter struct { 1325 // Probability undocumented 1326 Probability json.RawMessage `json:"probability,omitempty"` 1327 // DegFreedom1 undocumented 1328 DegFreedom1 json.RawMessage `json:"degFreedom1,omitempty"` 1329 // DegFreedom2 undocumented 1330 DegFreedom2 json.RawMessage `json:"degFreedom2,omitempty"` 1331 } 1332 1333 // WorkbookFunctionsFactRequestParameter undocumented 1334 type WorkbookFunctionsFactRequestParameter struct { 1335 // Number undocumented 1336 Number json.RawMessage `json:"number,omitempty"` 1337 } 1338 1339 // WorkbookFunctionsFactDoubleRequestParameter undocumented 1340 type WorkbookFunctionsFactDoubleRequestParameter struct { 1341 // Number undocumented 1342 Number json.RawMessage `json:"number,omitempty"` 1343 } 1344 1345 // WorkbookFunctionsFalseRequestParameter undocumented 1346 type WorkbookFunctionsFalseRequestParameter struct { 1347 } 1348 1349 // WorkbookFunctionsFindRequestParameter undocumented 1350 type WorkbookFunctionsFindRequestParameter struct { 1351 // FindText undocumented 1352 FindText json.RawMessage `json:"findText,omitempty"` 1353 // WithinText undocumented 1354 WithinText json.RawMessage `json:"withinText,omitempty"` 1355 // StartNum undocumented 1356 StartNum json.RawMessage `json:"startNum,omitempty"` 1357 } 1358 1359 // WorkbookFunctionsFindBRequestParameter undocumented 1360 type WorkbookFunctionsFindBRequestParameter struct { 1361 // FindText undocumented 1362 FindText json.RawMessage `json:"findText,omitempty"` 1363 // WithinText undocumented 1364 WithinText json.RawMessage `json:"withinText,omitempty"` 1365 // StartNum undocumented 1366 StartNum json.RawMessage `json:"startNum,omitempty"` 1367 } 1368 1369 // WorkbookFunctionsFisherRequestParameter undocumented 1370 type WorkbookFunctionsFisherRequestParameter struct { 1371 // X undocumented 1372 X json.RawMessage `json:"x,omitempty"` 1373 } 1374 1375 // WorkbookFunctionsFisherInvRequestParameter undocumented 1376 type WorkbookFunctionsFisherInvRequestParameter struct { 1377 // Y undocumented 1378 Y json.RawMessage `json:"y,omitempty"` 1379 } 1380 1381 // WorkbookFunctionsFixedRequestParameter undocumented 1382 type WorkbookFunctionsFixedRequestParameter struct { 1383 // Number undocumented 1384 Number json.RawMessage `json:"number,omitempty"` 1385 // Decimals undocumented 1386 Decimals json.RawMessage `json:"decimals,omitempty"` 1387 // NoCommas undocumented 1388 NoCommas json.RawMessage `json:"noCommas,omitempty"` 1389 } 1390 1391 // WorkbookFunctionsFloor_MathRequestParameter undocumented 1392 type WorkbookFunctionsFloor_MathRequestParameter struct { 1393 // Number undocumented 1394 Number json.RawMessage `json:"number,omitempty"` 1395 // Significance undocumented 1396 Significance json.RawMessage `json:"significance,omitempty"` 1397 // Mode undocumented 1398 Mode json.RawMessage `json:"mode,omitempty"` 1399 } 1400 1401 // WorkbookFunctionsFloor_PreciseRequestParameter undocumented 1402 type WorkbookFunctionsFloor_PreciseRequestParameter struct { 1403 // Number undocumented 1404 Number json.RawMessage `json:"number,omitempty"` 1405 // Significance undocumented 1406 Significance json.RawMessage `json:"significance,omitempty"` 1407 } 1408 1409 // WorkbookFunctionsFvRequestParameter undocumented 1410 type WorkbookFunctionsFvRequestParameter struct { 1411 // Rate undocumented 1412 Rate json.RawMessage `json:"rate,omitempty"` 1413 // Nper undocumented 1414 Nper json.RawMessage `json:"nper,omitempty"` 1415 // Pmt undocumented 1416 Pmt json.RawMessage `json:"pmt,omitempty"` 1417 // Pv undocumented 1418 Pv json.RawMessage `json:"pv,omitempty"` 1419 // Type undocumented 1420 Type json.RawMessage `json:"type,omitempty"` 1421 } 1422 1423 // WorkbookFunctionsGammaRequestParameter undocumented 1424 type WorkbookFunctionsGammaRequestParameter struct { 1425 // X undocumented 1426 X json.RawMessage `json:"x,omitempty"` 1427 } 1428 1429 // WorkbookFunctionsGammaLnRequestParameter undocumented 1430 type WorkbookFunctionsGammaLnRequestParameter struct { 1431 // X undocumented 1432 X json.RawMessage `json:"x,omitempty"` 1433 } 1434 1435 // WorkbookFunctionsGammaLn_PreciseRequestParameter undocumented 1436 type WorkbookFunctionsGammaLn_PreciseRequestParameter struct { 1437 // X undocumented 1438 X json.RawMessage `json:"x,omitempty"` 1439 } 1440 1441 // WorkbookFunctionsGamma_DistRequestParameter undocumented 1442 type WorkbookFunctionsGamma_DistRequestParameter struct { 1443 // X undocumented 1444 X json.RawMessage `json:"x,omitempty"` 1445 // Alpha undocumented 1446 Alpha json.RawMessage `json:"alpha,omitempty"` 1447 // Beta undocumented 1448 Beta json.RawMessage `json:"beta,omitempty"` 1449 // Cumulative undocumented 1450 Cumulative json.RawMessage `json:"cumulative,omitempty"` 1451 } 1452 1453 // WorkbookFunctionsGamma_InvRequestParameter undocumented 1454 type WorkbookFunctionsGamma_InvRequestParameter struct { 1455 // Probability undocumented 1456 Probability json.RawMessage `json:"probability,omitempty"` 1457 // Alpha undocumented 1458 Alpha json.RawMessage `json:"alpha,omitempty"` 1459 // Beta undocumented 1460 Beta json.RawMessage `json:"beta,omitempty"` 1461 } 1462 1463 // WorkbookFunctionsGaussRequestParameter undocumented 1464 type WorkbookFunctionsGaussRequestParameter struct { 1465 // X undocumented 1466 X json.RawMessage `json:"x,omitempty"` 1467 } 1468 1469 // WorkbookFunctionsGcdRequestParameter undocumented 1470 type WorkbookFunctionsGcdRequestParameter struct { 1471 // Values undocumented 1472 Values json.RawMessage `json:"values,omitempty"` 1473 } 1474 1475 // WorkbookFunctionsGeStepRequestParameter undocumented 1476 type WorkbookFunctionsGeStepRequestParameter struct { 1477 // Number undocumented 1478 Number json.RawMessage `json:"number,omitempty"` 1479 // Step undocumented 1480 Step json.RawMessage `json:"step,omitempty"` 1481 } 1482 1483 // WorkbookFunctionsGeoMeanRequestParameter undocumented 1484 type WorkbookFunctionsGeoMeanRequestParameter struct { 1485 // Values undocumented 1486 Values json.RawMessage `json:"values,omitempty"` 1487 } 1488 1489 // WorkbookFunctionsHlookupRequestParameter undocumented 1490 type WorkbookFunctionsHlookupRequestParameter struct { 1491 // LookupValue undocumented 1492 LookupValue json.RawMessage `json:"lookupValue,omitempty"` 1493 // TableArray undocumented 1494 TableArray json.RawMessage `json:"tableArray,omitempty"` 1495 // RowIndexNum undocumented 1496 RowIndexNum json.RawMessage `json:"rowIndexNum,omitempty"` 1497 // RangeLookup undocumented 1498 RangeLookup json.RawMessage `json:"rangeLookup,omitempty"` 1499 } 1500 1501 // WorkbookFunctionsHarMeanRequestParameter undocumented 1502 type WorkbookFunctionsHarMeanRequestParameter struct { 1503 // Values undocumented 1504 Values json.RawMessage `json:"values,omitempty"` 1505 } 1506 1507 // WorkbookFunctionsHex2BinRequestParameter undocumented 1508 type WorkbookFunctionsHex2BinRequestParameter struct { 1509 // Number undocumented 1510 Number json.RawMessage `json:"number,omitempty"` 1511 // Places undocumented 1512 Places json.RawMessage `json:"places,omitempty"` 1513 } 1514 1515 // WorkbookFunctionsHex2DecRequestParameter undocumented 1516 type WorkbookFunctionsHex2DecRequestParameter struct { 1517 // Number undocumented 1518 Number json.RawMessage `json:"number,omitempty"` 1519 } 1520 1521 // WorkbookFunctionsHex2OctRequestParameter undocumented 1522 type WorkbookFunctionsHex2OctRequestParameter struct { 1523 // Number undocumented 1524 Number json.RawMessage `json:"number,omitempty"` 1525 // Places undocumented 1526 Places json.RawMessage `json:"places,omitempty"` 1527 } 1528 1529 // WorkbookFunctionsHourRequestParameter undocumented 1530 type WorkbookFunctionsHourRequestParameter struct { 1531 // SerialNumber undocumented 1532 SerialNumber json.RawMessage `json:"serialNumber,omitempty"` 1533 } 1534 1535 // WorkbookFunctionsHypGeom_DistRequestParameter undocumented 1536 type WorkbookFunctionsHypGeom_DistRequestParameter struct { 1537 // SampleS undocumented 1538 SampleS json.RawMessage `json:"sampleS,omitempty"` 1539 // NumberSample undocumented 1540 NumberSample json.RawMessage `json:"numberSample,omitempty"` 1541 // PopulationS undocumented 1542 PopulationS json.RawMessage `json:"populationS,omitempty"` 1543 // NumberPop undocumented 1544 NumberPop json.RawMessage `json:"numberPop,omitempty"` 1545 // Cumulative undocumented 1546 Cumulative json.RawMessage `json:"cumulative,omitempty"` 1547 } 1548 1549 // WorkbookFunctionsHyperlinkRequestParameter undocumented 1550 type WorkbookFunctionsHyperlinkRequestParameter struct { 1551 // LinkLocation undocumented 1552 LinkLocation json.RawMessage `json:"linkLocation,omitempty"` 1553 // FriendlyName undocumented 1554 FriendlyName json.RawMessage `json:"friendlyName,omitempty"` 1555 } 1556 1557 // WorkbookFunctionsIso_CeilingRequestParameter undocumented 1558 type WorkbookFunctionsIso_CeilingRequestParameter struct { 1559 // Number undocumented 1560 Number json.RawMessage `json:"number,omitempty"` 1561 // Significance undocumented 1562 Significance json.RawMessage `json:"significance,omitempty"` 1563 } 1564 1565 // WorkbookFunctionsIfRequestParameter undocumented 1566 type WorkbookFunctionsIfRequestParameter struct { 1567 // LogicalTest undocumented 1568 LogicalTest json.RawMessage `json:"logicalTest,omitempty"` 1569 // ValueIfTrue undocumented 1570 ValueIfTrue json.RawMessage `json:"valueIfTrue,omitempty"` 1571 // ValueIfFalse undocumented 1572 ValueIfFalse json.RawMessage `json:"valueIfFalse,omitempty"` 1573 } 1574 1575 // WorkbookFunctionsImAbsRequestParameter undocumented 1576 type WorkbookFunctionsImAbsRequestParameter struct { 1577 // Inumber undocumented 1578 Inumber json.RawMessage `json:"inumber,omitempty"` 1579 } 1580 1581 // WorkbookFunctionsImArgumentRequestParameter undocumented 1582 type WorkbookFunctionsImArgumentRequestParameter struct { 1583 // Inumber undocumented 1584 Inumber json.RawMessage `json:"inumber,omitempty"` 1585 } 1586 1587 // WorkbookFunctionsImConjugateRequestParameter undocumented 1588 type WorkbookFunctionsImConjugateRequestParameter struct { 1589 // Inumber undocumented 1590 Inumber json.RawMessage `json:"inumber,omitempty"` 1591 } 1592 1593 // WorkbookFunctionsImCosRequestParameter undocumented 1594 type WorkbookFunctionsImCosRequestParameter struct { 1595 // Inumber undocumented 1596 Inumber json.RawMessage `json:"inumber,omitempty"` 1597 } 1598 1599 // WorkbookFunctionsImCoshRequestParameter undocumented 1600 type WorkbookFunctionsImCoshRequestParameter struct { 1601 // Inumber undocumented 1602 Inumber json.RawMessage `json:"inumber,omitempty"` 1603 } 1604 1605 // WorkbookFunctionsImCotRequestParameter undocumented 1606 type WorkbookFunctionsImCotRequestParameter struct { 1607 // Inumber undocumented 1608 Inumber json.RawMessage `json:"inumber,omitempty"` 1609 } 1610 1611 // WorkbookFunctionsImCscRequestParameter undocumented 1612 type WorkbookFunctionsImCscRequestParameter struct { 1613 // Inumber undocumented 1614 Inumber json.RawMessage `json:"inumber,omitempty"` 1615 } 1616 1617 // WorkbookFunctionsImCschRequestParameter undocumented 1618 type WorkbookFunctionsImCschRequestParameter struct { 1619 // Inumber undocumented 1620 Inumber json.RawMessage `json:"inumber,omitempty"` 1621 } 1622 1623 // WorkbookFunctionsImDivRequestParameter undocumented 1624 type WorkbookFunctionsImDivRequestParameter struct { 1625 // Inumber1 undocumented 1626 Inumber1 json.RawMessage `json:"inumber1,omitempty"` 1627 // Inumber2 undocumented 1628 Inumber2 json.RawMessage `json:"inumber2,omitempty"` 1629 } 1630 1631 // WorkbookFunctionsImExpRequestParameter undocumented 1632 type WorkbookFunctionsImExpRequestParameter struct { 1633 // Inumber undocumented 1634 Inumber json.RawMessage `json:"inumber,omitempty"` 1635 } 1636 1637 // WorkbookFunctionsImLnRequestParameter undocumented 1638 type WorkbookFunctionsImLnRequestParameter struct { 1639 // Inumber undocumented 1640 Inumber json.RawMessage `json:"inumber,omitempty"` 1641 } 1642 1643 // WorkbookFunctionsImLog10RequestParameter undocumented 1644 type WorkbookFunctionsImLog10RequestParameter struct { 1645 // Inumber undocumented 1646 Inumber json.RawMessage `json:"inumber,omitempty"` 1647 } 1648 1649 // WorkbookFunctionsImLog2RequestParameter undocumented 1650 type WorkbookFunctionsImLog2RequestParameter struct { 1651 // Inumber undocumented 1652 Inumber json.RawMessage `json:"inumber,omitempty"` 1653 } 1654 1655 // WorkbookFunctionsImPowerRequestParameter undocumented 1656 type WorkbookFunctionsImPowerRequestParameter struct { 1657 // Inumber undocumented 1658 Inumber json.RawMessage `json:"inumber,omitempty"` 1659 // Number undocumented 1660 Number json.RawMessage `json:"number,omitempty"` 1661 } 1662 1663 // WorkbookFunctionsImProductRequestParameter undocumented 1664 type WorkbookFunctionsImProductRequestParameter struct { 1665 // Values undocumented 1666 Values json.RawMessage `json:"values,omitempty"` 1667 } 1668 1669 // WorkbookFunctionsImRealRequestParameter undocumented 1670 type WorkbookFunctionsImRealRequestParameter struct { 1671 // Inumber undocumented 1672 Inumber json.RawMessage `json:"inumber,omitempty"` 1673 } 1674 1675 // WorkbookFunctionsImSecRequestParameter undocumented 1676 type WorkbookFunctionsImSecRequestParameter struct { 1677 // Inumber undocumented 1678 Inumber json.RawMessage `json:"inumber,omitempty"` 1679 } 1680 1681 // WorkbookFunctionsImSechRequestParameter undocumented 1682 type WorkbookFunctionsImSechRequestParameter struct { 1683 // Inumber undocumented 1684 Inumber json.RawMessage `json:"inumber,omitempty"` 1685 } 1686 1687 // WorkbookFunctionsImSinRequestParameter undocumented 1688 type WorkbookFunctionsImSinRequestParameter struct { 1689 // Inumber undocumented 1690 Inumber json.RawMessage `json:"inumber,omitempty"` 1691 } 1692 1693 // WorkbookFunctionsImSinhRequestParameter undocumented 1694 type WorkbookFunctionsImSinhRequestParameter struct { 1695 // Inumber undocumented 1696 Inumber json.RawMessage `json:"inumber,omitempty"` 1697 } 1698 1699 // WorkbookFunctionsImSqrtRequestParameter undocumented 1700 type WorkbookFunctionsImSqrtRequestParameter struct { 1701 // Inumber undocumented 1702 Inumber json.RawMessage `json:"inumber,omitempty"` 1703 } 1704 1705 // WorkbookFunctionsImSubRequestParameter undocumented 1706 type WorkbookFunctionsImSubRequestParameter struct { 1707 // Inumber1 undocumented 1708 Inumber1 json.RawMessage `json:"inumber1,omitempty"` 1709 // Inumber2 undocumented 1710 Inumber2 json.RawMessage `json:"inumber2,omitempty"` 1711 } 1712 1713 // WorkbookFunctionsImSumRequestParameter undocumented 1714 type WorkbookFunctionsImSumRequestParameter struct { 1715 // Values undocumented 1716 Values json.RawMessage `json:"values,omitempty"` 1717 } 1718 1719 // WorkbookFunctionsImTanRequestParameter undocumented 1720 type WorkbookFunctionsImTanRequestParameter struct { 1721 // Inumber undocumented 1722 Inumber json.RawMessage `json:"inumber,omitempty"` 1723 } 1724 1725 // WorkbookFunctionsImaginaryRequestParameter undocumented 1726 type WorkbookFunctionsImaginaryRequestParameter struct { 1727 // Inumber undocumented 1728 Inumber json.RawMessage `json:"inumber,omitempty"` 1729 } 1730 1731 // WorkbookFunctionsIntRequestParameter undocumented 1732 type WorkbookFunctionsIntRequestParameter struct { 1733 // Number undocumented 1734 Number json.RawMessage `json:"number,omitempty"` 1735 } 1736 1737 // WorkbookFunctionsIntRateRequestParameter undocumented 1738 type WorkbookFunctionsIntRateRequestParameter struct { 1739 // Settlement undocumented 1740 Settlement json.RawMessage `json:"settlement,omitempty"` 1741 // Maturity undocumented 1742 Maturity json.RawMessage `json:"maturity,omitempty"` 1743 // Investment undocumented 1744 Investment json.RawMessage `json:"investment,omitempty"` 1745 // Redemption undocumented 1746 Redemption json.RawMessage `json:"redemption,omitempty"` 1747 // Basis undocumented 1748 Basis json.RawMessage `json:"basis,omitempty"` 1749 } 1750 1751 // WorkbookFunctionsIpmtRequestParameter undocumented 1752 type WorkbookFunctionsIpmtRequestParameter struct { 1753 // Rate undocumented 1754 Rate json.RawMessage `json:"rate,omitempty"` 1755 // Per undocumented 1756 Per json.RawMessage `json:"per,omitempty"` 1757 // Nper undocumented 1758 Nper json.RawMessage `json:"nper,omitempty"` 1759 // Pv undocumented 1760 Pv json.RawMessage `json:"pv,omitempty"` 1761 // Fv undocumented 1762 Fv json.RawMessage `json:"fv,omitempty"` 1763 // Type undocumented 1764 Type json.RawMessage `json:"type,omitempty"` 1765 } 1766 1767 // WorkbookFunctionsIrrRequestParameter undocumented 1768 type WorkbookFunctionsIrrRequestParameter struct { 1769 // Values undocumented 1770 Values json.RawMessage `json:"values,omitempty"` 1771 // Guess undocumented 1772 Guess json.RawMessage `json:"guess,omitempty"` 1773 } 1774 1775 // WorkbookFunctionsIsErrRequestParameter undocumented 1776 type WorkbookFunctionsIsErrRequestParameter struct { 1777 // Value undocumented 1778 Value json.RawMessage `json:"value,omitempty"` 1779 } 1780 1781 // WorkbookFunctionsIsErrorRequestParameter undocumented 1782 type WorkbookFunctionsIsErrorRequestParameter struct { 1783 // Value undocumented 1784 Value json.RawMessage `json:"value,omitempty"` 1785 } 1786 1787 // WorkbookFunctionsIsEvenRequestParameter undocumented 1788 type WorkbookFunctionsIsEvenRequestParameter struct { 1789 // Number undocumented 1790 Number json.RawMessage `json:"number,omitempty"` 1791 } 1792 1793 // WorkbookFunctionsIsFormulaRequestParameter undocumented 1794 type WorkbookFunctionsIsFormulaRequestParameter struct { 1795 // Reference undocumented 1796 Reference json.RawMessage `json:"reference,omitempty"` 1797 } 1798 1799 // WorkbookFunctionsIsLogicalRequestParameter undocumented 1800 type WorkbookFunctionsIsLogicalRequestParameter struct { 1801 // Value undocumented 1802 Value json.RawMessage `json:"value,omitempty"` 1803 } 1804 1805 // WorkbookFunctionsIsNARequestParameter undocumented 1806 type WorkbookFunctionsIsNARequestParameter struct { 1807 // Value undocumented 1808 Value json.RawMessage `json:"value,omitempty"` 1809 } 1810 1811 // WorkbookFunctionsIsNonTextRequestParameter undocumented 1812 type WorkbookFunctionsIsNonTextRequestParameter struct { 1813 // Value undocumented 1814 Value json.RawMessage `json:"value,omitempty"` 1815 } 1816 1817 // WorkbookFunctionsIsNumberRequestParameter undocumented 1818 type WorkbookFunctionsIsNumberRequestParameter struct { 1819 // Value undocumented 1820 Value json.RawMessage `json:"value,omitempty"` 1821 } 1822 1823 // WorkbookFunctionsIsOddRequestParameter undocumented 1824 type WorkbookFunctionsIsOddRequestParameter struct { 1825 // Number undocumented 1826 Number json.RawMessage `json:"number,omitempty"` 1827 } 1828 1829 // WorkbookFunctionsIsTextRequestParameter undocumented 1830 type WorkbookFunctionsIsTextRequestParameter struct { 1831 // Value undocumented 1832 Value json.RawMessage `json:"value,omitempty"` 1833 } 1834 1835 // WorkbookFunctionsIsoWeekNumRequestParameter undocumented 1836 type WorkbookFunctionsIsoWeekNumRequestParameter struct { 1837 // Date undocumented 1838 Date json.RawMessage `json:"date,omitempty"` 1839 } 1840 1841 // WorkbookFunctionsIspmtRequestParameter undocumented 1842 type WorkbookFunctionsIspmtRequestParameter struct { 1843 // Rate undocumented 1844 Rate json.RawMessage `json:"rate,omitempty"` 1845 // Per undocumented 1846 Per json.RawMessage `json:"per,omitempty"` 1847 // Nper undocumented 1848 Nper json.RawMessage `json:"nper,omitempty"` 1849 // Pv undocumented 1850 Pv json.RawMessage `json:"pv,omitempty"` 1851 } 1852 1853 // WorkbookFunctionsIsrefRequestParameter undocumented 1854 type WorkbookFunctionsIsrefRequestParameter struct { 1855 // Value undocumented 1856 Value json.RawMessage `json:"value,omitempty"` 1857 } 1858 1859 // WorkbookFunctionsKurtRequestParameter undocumented 1860 type WorkbookFunctionsKurtRequestParameter struct { 1861 // Values undocumented 1862 Values json.RawMessage `json:"values,omitempty"` 1863 } 1864 1865 // WorkbookFunctionsLargeRequestParameter undocumented 1866 type WorkbookFunctionsLargeRequestParameter struct { 1867 // Array undocumented 1868 Array json.RawMessage `json:"array,omitempty"` 1869 // K undocumented 1870 K json.RawMessage `json:"k,omitempty"` 1871 } 1872 1873 // WorkbookFunctionsLcmRequestParameter undocumented 1874 type WorkbookFunctionsLcmRequestParameter struct { 1875 // Values undocumented 1876 Values json.RawMessage `json:"values,omitempty"` 1877 } 1878 1879 // WorkbookFunctionsLeftRequestParameter undocumented 1880 type WorkbookFunctionsLeftRequestParameter struct { 1881 // Text undocumented 1882 Text json.RawMessage `json:"text,omitempty"` 1883 // NumChars undocumented 1884 NumChars json.RawMessage `json:"numChars,omitempty"` 1885 } 1886 1887 // WorkbookFunctionsLeftbRequestParameter undocumented 1888 type WorkbookFunctionsLeftbRequestParameter struct { 1889 // Text undocumented 1890 Text json.RawMessage `json:"text,omitempty"` 1891 // NumBytes undocumented 1892 NumBytes json.RawMessage `json:"numBytes,omitempty"` 1893 } 1894 1895 // WorkbookFunctionsLenRequestParameter undocumented 1896 type WorkbookFunctionsLenRequestParameter struct { 1897 // Text undocumented 1898 Text json.RawMessage `json:"text,omitempty"` 1899 } 1900 1901 // WorkbookFunctionsLenbRequestParameter undocumented 1902 type WorkbookFunctionsLenbRequestParameter struct { 1903 // Text undocumented 1904 Text json.RawMessage `json:"text,omitempty"` 1905 } 1906 1907 // WorkbookFunctionsLnRequestParameter undocumented 1908 type WorkbookFunctionsLnRequestParameter struct { 1909 // Number undocumented 1910 Number json.RawMessage `json:"number,omitempty"` 1911 } 1912 1913 // WorkbookFunctionsLogRequestParameter undocumented 1914 type WorkbookFunctionsLogRequestParameter struct { 1915 // Number undocumented 1916 Number json.RawMessage `json:"number,omitempty"` 1917 // Base undocumented 1918 Base json.RawMessage `json:"base,omitempty"` 1919 } 1920 1921 // WorkbookFunctionsLog10RequestParameter undocumented 1922 type WorkbookFunctionsLog10RequestParameter struct { 1923 // Number undocumented 1924 Number json.RawMessage `json:"number,omitempty"` 1925 } 1926 1927 // WorkbookFunctionsLogNorm_DistRequestParameter undocumented 1928 type WorkbookFunctionsLogNorm_DistRequestParameter struct { 1929 // X undocumented 1930 X json.RawMessage `json:"x,omitempty"` 1931 // Mean undocumented 1932 Mean json.RawMessage `json:"mean,omitempty"` 1933 // StandardDev undocumented 1934 StandardDev json.RawMessage `json:"standardDev,omitempty"` 1935 // Cumulative undocumented 1936 Cumulative json.RawMessage `json:"cumulative,omitempty"` 1937 } 1938 1939 // WorkbookFunctionsLogNorm_InvRequestParameter undocumented 1940 type WorkbookFunctionsLogNorm_InvRequestParameter struct { 1941 // Probability undocumented 1942 Probability json.RawMessage `json:"probability,omitempty"` 1943 // Mean undocumented 1944 Mean json.RawMessage `json:"mean,omitempty"` 1945 // StandardDev undocumented 1946 StandardDev json.RawMessage `json:"standardDev,omitempty"` 1947 } 1948 1949 // WorkbookFunctionsLookupRequestParameter undocumented 1950 type WorkbookFunctionsLookupRequestParameter struct { 1951 // LookupValue undocumented 1952 LookupValue json.RawMessage `json:"lookupValue,omitempty"` 1953 // LookupVector undocumented 1954 LookupVector json.RawMessage `json:"lookupVector,omitempty"` 1955 // ResultVector undocumented 1956 ResultVector json.RawMessage `json:"resultVector,omitempty"` 1957 } 1958 1959 // WorkbookFunctionsLowerRequestParameter undocumented 1960 type WorkbookFunctionsLowerRequestParameter struct { 1961 // Text undocumented 1962 Text json.RawMessage `json:"text,omitempty"` 1963 } 1964 1965 // WorkbookFunctionsMdurationRequestParameter undocumented 1966 type WorkbookFunctionsMdurationRequestParameter struct { 1967 // Settlement undocumented 1968 Settlement json.RawMessage `json:"settlement,omitempty"` 1969 // Maturity undocumented 1970 Maturity json.RawMessage `json:"maturity,omitempty"` 1971 // Coupon undocumented 1972 Coupon json.RawMessage `json:"coupon,omitempty"` 1973 // Yld undocumented 1974 Yld json.RawMessage `json:"yld,omitempty"` 1975 // Frequency undocumented 1976 Frequency json.RawMessage `json:"frequency,omitempty"` 1977 // Basis undocumented 1978 Basis json.RawMessage `json:"basis,omitempty"` 1979 } 1980 1981 // WorkbookFunctionsMirrRequestParameter undocumented 1982 type WorkbookFunctionsMirrRequestParameter struct { 1983 // Values undocumented 1984 Values json.RawMessage `json:"values,omitempty"` 1985 // FinanceRate undocumented 1986 FinanceRate json.RawMessage `json:"financeRate,omitempty"` 1987 // ReinvestRate undocumented 1988 ReinvestRate json.RawMessage `json:"reinvestRate,omitempty"` 1989 } 1990 1991 // WorkbookFunctionsMroundRequestParameter undocumented 1992 type WorkbookFunctionsMroundRequestParameter struct { 1993 // Number undocumented 1994 Number json.RawMessage `json:"number,omitempty"` 1995 // Multiple undocumented 1996 Multiple json.RawMessage `json:"multiple,omitempty"` 1997 } 1998 1999 // WorkbookFunctionsMatchRequestParameter undocumented 2000 type WorkbookFunctionsMatchRequestParameter struct { 2001 // LookupValue undocumented 2002 LookupValue json.RawMessage `json:"lookupValue,omitempty"` 2003 // LookupArray undocumented 2004 LookupArray json.RawMessage `json:"lookupArray,omitempty"` 2005 // MatchType undocumented 2006 MatchType json.RawMessage `json:"matchType,omitempty"` 2007 } 2008 2009 // WorkbookFunctionsMaxRequestParameter undocumented 2010 type WorkbookFunctionsMaxRequestParameter struct { 2011 // Values undocumented 2012 Values json.RawMessage `json:"values,omitempty"` 2013 } 2014 2015 // WorkbookFunctionsMaxARequestParameter undocumented 2016 type WorkbookFunctionsMaxARequestParameter struct { 2017 // Values undocumented 2018 Values json.RawMessage `json:"values,omitempty"` 2019 } 2020 2021 // WorkbookFunctionsMedianRequestParameter undocumented 2022 type WorkbookFunctionsMedianRequestParameter struct { 2023 // Values undocumented 2024 Values json.RawMessage `json:"values,omitempty"` 2025 } 2026 2027 // WorkbookFunctionsMidRequestParameter undocumented 2028 type WorkbookFunctionsMidRequestParameter struct { 2029 // Text undocumented 2030 Text json.RawMessage `json:"text,omitempty"` 2031 // StartNum undocumented 2032 StartNum json.RawMessage `json:"startNum,omitempty"` 2033 // NumChars undocumented 2034 NumChars json.RawMessage `json:"numChars,omitempty"` 2035 } 2036 2037 // WorkbookFunctionsMidbRequestParameter undocumented 2038 type WorkbookFunctionsMidbRequestParameter struct { 2039 // Text undocumented 2040 Text json.RawMessage `json:"text,omitempty"` 2041 // StartNum undocumented 2042 StartNum json.RawMessage `json:"startNum,omitempty"` 2043 // NumBytes undocumented 2044 NumBytes json.RawMessage `json:"numBytes,omitempty"` 2045 } 2046 2047 // WorkbookFunctionsMinRequestParameter undocumented 2048 type WorkbookFunctionsMinRequestParameter struct { 2049 // Values undocumented 2050 Values json.RawMessage `json:"values,omitempty"` 2051 } 2052 2053 // WorkbookFunctionsMinARequestParameter undocumented 2054 type WorkbookFunctionsMinARequestParameter struct { 2055 // Values undocumented 2056 Values json.RawMessage `json:"values,omitempty"` 2057 } 2058 2059 // WorkbookFunctionsMinuteRequestParameter undocumented 2060 type WorkbookFunctionsMinuteRequestParameter struct { 2061 // SerialNumber undocumented 2062 SerialNumber json.RawMessage `json:"serialNumber,omitempty"` 2063 } 2064 2065 // WorkbookFunctionsModRequestParameter undocumented 2066 type WorkbookFunctionsModRequestParameter struct { 2067 // Number undocumented 2068 Number json.RawMessage `json:"number,omitempty"` 2069 // Divisor undocumented 2070 Divisor json.RawMessage `json:"divisor,omitempty"` 2071 } 2072 2073 // WorkbookFunctionsMonthRequestParameter undocumented 2074 type WorkbookFunctionsMonthRequestParameter struct { 2075 // SerialNumber undocumented 2076 SerialNumber json.RawMessage `json:"serialNumber,omitempty"` 2077 } 2078 2079 // WorkbookFunctionsMultiNomialRequestParameter undocumented 2080 type WorkbookFunctionsMultiNomialRequestParameter struct { 2081 // Values undocumented 2082 Values json.RawMessage `json:"values,omitempty"` 2083 } 2084 2085 // WorkbookFunctionsNRequestParameter undocumented 2086 type WorkbookFunctionsNRequestParameter struct { 2087 // Value undocumented 2088 Value json.RawMessage `json:"value,omitempty"` 2089 } 2090 2091 // WorkbookFunctionsNperRequestParameter undocumented 2092 type WorkbookFunctionsNperRequestParameter struct { 2093 // Rate undocumented 2094 Rate json.RawMessage `json:"rate,omitempty"` 2095 // Pmt undocumented 2096 Pmt json.RawMessage `json:"pmt,omitempty"` 2097 // Pv undocumented 2098 Pv json.RawMessage `json:"pv,omitempty"` 2099 // Fv undocumented 2100 Fv json.RawMessage `json:"fv,omitempty"` 2101 // Type undocumented 2102 Type json.RawMessage `json:"type,omitempty"` 2103 } 2104 2105 // WorkbookFunctionsNaRequestParameter undocumented 2106 type WorkbookFunctionsNaRequestParameter struct { 2107 } 2108 2109 // WorkbookFunctionsNegBinom_DistRequestParameter undocumented 2110 type WorkbookFunctionsNegBinom_DistRequestParameter struct { 2111 // NumberF undocumented 2112 NumberF json.RawMessage `json:"numberF,omitempty"` 2113 // NumberS undocumented 2114 NumberS json.RawMessage `json:"numberS,omitempty"` 2115 // ProbabilityS undocumented 2116 ProbabilityS json.RawMessage `json:"probabilityS,omitempty"` 2117 // Cumulative undocumented 2118 Cumulative json.RawMessage `json:"cumulative,omitempty"` 2119 } 2120 2121 // WorkbookFunctionsNetworkDaysRequestParameter undocumented 2122 type WorkbookFunctionsNetworkDaysRequestParameter struct { 2123 // StartDate undocumented 2124 StartDate json.RawMessage `json:"startDate,omitempty"` 2125 // EndDate undocumented 2126 EndDate json.RawMessage `json:"endDate,omitempty"` 2127 // Holidays undocumented 2128 Holidays json.RawMessage `json:"holidays,omitempty"` 2129 } 2130 2131 // WorkbookFunctionsNetworkDays_IntlRequestParameter undocumented 2132 type WorkbookFunctionsNetworkDays_IntlRequestParameter struct { 2133 // StartDate undocumented 2134 StartDate json.RawMessage `json:"startDate,omitempty"` 2135 // EndDate undocumented 2136 EndDate json.RawMessage `json:"endDate,omitempty"` 2137 // Weekend undocumented 2138 Weekend json.RawMessage `json:"weekend,omitempty"` 2139 // Holidays undocumented 2140 Holidays json.RawMessage `json:"holidays,omitempty"` 2141 } 2142 2143 // WorkbookFunctionsNominalRequestParameter undocumented 2144 type WorkbookFunctionsNominalRequestParameter struct { 2145 // EffectRate undocumented 2146 EffectRate json.RawMessage `json:"effectRate,omitempty"` 2147 // Npery undocumented 2148 Npery json.RawMessage `json:"npery,omitempty"` 2149 } 2150 2151 // WorkbookFunctionsNorm_DistRequestParameter undocumented 2152 type WorkbookFunctionsNorm_DistRequestParameter struct { 2153 // X undocumented 2154 X json.RawMessage `json:"x,omitempty"` 2155 // Mean undocumented 2156 Mean json.RawMessage `json:"mean,omitempty"` 2157 // StandardDev undocumented 2158 StandardDev json.RawMessage `json:"standardDev,omitempty"` 2159 // Cumulative undocumented 2160 Cumulative json.RawMessage `json:"cumulative,omitempty"` 2161 } 2162 2163 // WorkbookFunctionsNorm_InvRequestParameter undocumented 2164 type WorkbookFunctionsNorm_InvRequestParameter struct { 2165 // Probability undocumented 2166 Probability json.RawMessage `json:"probability,omitempty"` 2167 // Mean undocumented 2168 Mean json.RawMessage `json:"mean,omitempty"` 2169 // StandardDev undocumented 2170 StandardDev json.RawMessage `json:"standardDev,omitempty"` 2171 } 2172 2173 // WorkbookFunctionsNorm_S_DistRequestParameter undocumented 2174 type WorkbookFunctionsNorm_S_DistRequestParameter struct { 2175 // Z undocumented 2176 Z json.RawMessage `json:"z,omitempty"` 2177 // Cumulative undocumented 2178 Cumulative json.RawMessage `json:"cumulative,omitempty"` 2179 } 2180 2181 // WorkbookFunctionsNorm_S_InvRequestParameter undocumented 2182 type WorkbookFunctionsNorm_S_InvRequestParameter struct { 2183 // Probability undocumented 2184 Probability json.RawMessage `json:"probability,omitempty"` 2185 } 2186 2187 // WorkbookFunctionsNotRequestParameter undocumented 2188 type WorkbookFunctionsNotRequestParameter struct { 2189 // Logical undocumented 2190 Logical json.RawMessage `json:"logical,omitempty"` 2191 } 2192 2193 // WorkbookFunctionsNowRequestParameter undocumented 2194 type WorkbookFunctionsNowRequestParameter struct { 2195 } 2196 2197 // WorkbookFunctionsNpvRequestParameter undocumented 2198 type WorkbookFunctionsNpvRequestParameter struct { 2199 // Rate undocumented 2200 Rate json.RawMessage `json:"rate,omitempty"` 2201 // Values undocumented 2202 Values json.RawMessage `json:"values,omitempty"` 2203 } 2204 2205 // WorkbookFunctionsNumberValueRequestParameter undocumented 2206 type WorkbookFunctionsNumberValueRequestParameter struct { 2207 // Text undocumented 2208 Text json.RawMessage `json:"text,omitempty"` 2209 // DecimalSeparator undocumented 2210 DecimalSeparator json.RawMessage `json:"decimalSeparator,omitempty"` 2211 // GroupSeparator undocumented 2212 GroupSeparator json.RawMessage `json:"groupSeparator,omitempty"` 2213 } 2214 2215 // WorkbookFunctionsOct2BinRequestParameter undocumented 2216 type WorkbookFunctionsOct2BinRequestParameter struct { 2217 // Number undocumented 2218 Number json.RawMessage `json:"number,omitempty"` 2219 // Places undocumented 2220 Places json.RawMessage `json:"places,omitempty"` 2221 } 2222 2223 // WorkbookFunctionsOct2DecRequestParameter undocumented 2224 type WorkbookFunctionsOct2DecRequestParameter struct { 2225 // Number undocumented 2226 Number json.RawMessage `json:"number,omitempty"` 2227 } 2228 2229 // WorkbookFunctionsOct2HexRequestParameter undocumented 2230 type WorkbookFunctionsOct2HexRequestParameter struct { 2231 // Number undocumented 2232 Number json.RawMessage `json:"number,omitempty"` 2233 // Places undocumented 2234 Places json.RawMessage `json:"places,omitempty"` 2235 } 2236 2237 // WorkbookFunctionsOddRequestParameter undocumented 2238 type WorkbookFunctionsOddRequestParameter struct { 2239 // Number undocumented 2240 Number json.RawMessage `json:"number,omitempty"` 2241 } 2242 2243 // WorkbookFunctionsOddFPriceRequestParameter undocumented 2244 type WorkbookFunctionsOddFPriceRequestParameter struct { 2245 // Settlement undocumented 2246 Settlement json.RawMessage `json:"settlement,omitempty"` 2247 // Maturity undocumented 2248 Maturity json.RawMessage `json:"maturity,omitempty"` 2249 // Issue undocumented 2250 Issue json.RawMessage `json:"issue,omitempty"` 2251 // FirstCoupon undocumented 2252 FirstCoupon json.RawMessage `json:"firstCoupon,omitempty"` 2253 // Rate undocumented 2254 Rate json.RawMessage `json:"rate,omitempty"` 2255 // Yld undocumented 2256 Yld json.RawMessage `json:"yld,omitempty"` 2257 // Redemption undocumented 2258 Redemption json.RawMessage `json:"redemption,omitempty"` 2259 // Frequency undocumented 2260 Frequency json.RawMessage `json:"frequency,omitempty"` 2261 // Basis undocumented 2262 Basis json.RawMessage `json:"basis,omitempty"` 2263 } 2264 2265 // WorkbookFunctionsOddFYieldRequestParameter undocumented 2266 type WorkbookFunctionsOddFYieldRequestParameter struct { 2267 // Settlement undocumented 2268 Settlement json.RawMessage `json:"settlement,omitempty"` 2269 // Maturity undocumented 2270 Maturity json.RawMessage `json:"maturity,omitempty"` 2271 // Issue undocumented 2272 Issue json.RawMessage `json:"issue,omitempty"` 2273 // FirstCoupon undocumented 2274 FirstCoupon json.RawMessage `json:"firstCoupon,omitempty"` 2275 // Rate undocumented 2276 Rate json.RawMessage `json:"rate,omitempty"` 2277 // Pr undocumented 2278 Pr json.RawMessage `json:"pr,omitempty"` 2279 // Redemption undocumented 2280 Redemption json.RawMessage `json:"redemption,omitempty"` 2281 // Frequency undocumented 2282 Frequency json.RawMessage `json:"frequency,omitempty"` 2283 // Basis undocumented 2284 Basis json.RawMessage `json:"basis,omitempty"` 2285 } 2286 2287 // WorkbookFunctionsOddLPriceRequestParameter undocumented 2288 type WorkbookFunctionsOddLPriceRequestParameter struct { 2289 // Settlement undocumented 2290 Settlement json.RawMessage `json:"settlement,omitempty"` 2291 // Maturity undocumented 2292 Maturity json.RawMessage `json:"maturity,omitempty"` 2293 // LastInterest undocumented 2294 LastInterest json.RawMessage `json:"lastInterest,omitempty"` 2295 // Rate undocumented 2296 Rate json.RawMessage `json:"rate,omitempty"` 2297 // Yld undocumented 2298 Yld json.RawMessage `json:"yld,omitempty"` 2299 // Redemption undocumented 2300 Redemption json.RawMessage `json:"redemption,omitempty"` 2301 // Frequency undocumented 2302 Frequency json.RawMessage `json:"frequency,omitempty"` 2303 // Basis undocumented 2304 Basis json.RawMessage `json:"basis,omitempty"` 2305 } 2306 2307 // WorkbookFunctionsOddLYieldRequestParameter undocumented 2308 type WorkbookFunctionsOddLYieldRequestParameter struct { 2309 // Settlement undocumented 2310 Settlement json.RawMessage `json:"settlement,omitempty"` 2311 // Maturity undocumented 2312 Maturity json.RawMessage `json:"maturity,omitempty"` 2313 // LastInterest undocumented 2314 LastInterest json.RawMessage `json:"lastInterest,omitempty"` 2315 // Rate undocumented 2316 Rate json.RawMessage `json:"rate,omitempty"` 2317 // Pr undocumented 2318 Pr json.RawMessage `json:"pr,omitempty"` 2319 // Redemption undocumented 2320 Redemption json.RawMessage `json:"redemption,omitempty"` 2321 // Frequency undocumented 2322 Frequency json.RawMessage `json:"frequency,omitempty"` 2323 // Basis undocumented 2324 Basis json.RawMessage `json:"basis,omitempty"` 2325 } 2326 2327 // WorkbookFunctionsOrRequestParameter undocumented 2328 type WorkbookFunctionsOrRequestParameter struct { 2329 // Values undocumented 2330 Values json.RawMessage `json:"values,omitempty"` 2331 } 2332 2333 // WorkbookFunctionsPdurationRequestParameter undocumented 2334 type WorkbookFunctionsPdurationRequestParameter struct { 2335 // Rate undocumented 2336 Rate json.RawMessage `json:"rate,omitempty"` 2337 // Pv undocumented 2338 Pv json.RawMessage `json:"pv,omitempty"` 2339 // Fv undocumented 2340 Fv json.RawMessage `json:"fv,omitempty"` 2341 } 2342 2343 // WorkbookFunctionsPercentRank_ExcRequestParameter undocumented 2344 type WorkbookFunctionsPercentRank_ExcRequestParameter struct { 2345 // Array undocumented 2346 Array json.RawMessage `json:"array,omitempty"` 2347 // X undocumented 2348 X json.RawMessage `json:"x,omitempty"` 2349 // Significance undocumented 2350 Significance json.RawMessage `json:"significance,omitempty"` 2351 } 2352 2353 // WorkbookFunctionsPercentRank_IncRequestParameter undocumented 2354 type WorkbookFunctionsPercentRank_IncRequestParameter struct { 2355 // Array undocumented 2356 Array json.RawMessage `json:"array,omitempty"` 2357 // X undocumented 2358 X json.RawMessage `json:"x,omitempty"` 2359 // Significance undocumented 2360 Significance json.RawMessage `json:"significance,omitempty"` 2361 } 2362 2363 // WorkbookFunctionsPercentile_ExcRequestParameter undocumented 2364 type WorkbookFunctionsPercentile_ExcRequestParameter struct { 2365 // Array undocumented 2366 Array json.RawMessage `json:"array,omitempty"` 2367 // K undocumented 2368 K json.RawMessage `json:"k,omitempty"` 2369 } 2370 2371 // WorkbookFunctionsPercentile_IncRequestParameter undocumented 2372 type WorkbookFunctionsPercentile_IncRequestParameter struct { 2373 // Array undocumented 2374 Array json.RawMessage `json:"array,omitempty"` 2375 // K undocumented 2376 K json.RawMessage `json:"k,omitempty"` 2377 } 2378 2379 // WorkbookFunctionsPermutRequestParameter undocumented 2380 type WorkbookFunctionsPermutRequestParameter struct { 2381 // Number undocumented 2382 Number json.RawMessage `json:"number,omitempty"` 2383 // NumberChosen undocumented 2384 NumberChosen json.RawMessage `json:"numberChosen,omitempty"` 2385 } 2386 2387 // WorkbookFunctionsPermutationaRequestParameter undocumented 2388 type WorkbookFunctionsPermutationaRequestParameter struct { 2389 // Number undocumented 2390 Number json.RawMessage `json:"number,omitempty"` 2391 // NumberChosen undocumented 2392 NumberChosen json.RawMessage `json:"numberChosen,omitempty"` 2393 } 2394 2395 // WorkbookFunctionsPhiRequestParameter undocumented 2396 type WorkbookFunctionsPhiRequestParameter struct { 2397 // X undocumented 2398 X json.RawMessage `json:"x,omitempty"` 2399 } 2400 2401 // WorkbookFunctionsPiRequestParameter undocumented 2402 type WorkbookFunctionsPiRequestParameter struct { 2403 } 2404 2405 // WorkbookFunctionsPmtRequestParameter undocumented 2406 type WorkbookFunctionsPmtRequestParameter struct { 2407 // Rate undocumented 2408 Rate json.RawMessage `json:"rate,omitempty"` 2409 // Nper undocumented 2410 Nper json.RawMessage `json:"nper,omitempty"` 2411 // Pv undocumented 2412 Pv json.RawMessage `json:"pv,omitempty"` 2413 // Fv undocumented 2414 Fv json.RawMessage `json:"fv,omitempty"` 2415 // Type undocumented 2416 Type json.RawMessage `json:"type,omitempty"` 2417 } 2418 2419 // WorkbookFunctionsPoisson_DistRequestParameter undocumented 2420 type WorkbookFunctionsPoisson_DistRequestParameter struct { 2421 // X undocumented 2422 X json.RawMessage `json:"x,omitempty"` 2423 // Mean undocumented 2424 Mean json.RawMessage `json:"mean,omitempty"` 2425 // Cumulative undocumented 2426 Cumulative json.RawMessage `json:"cumulative,omitempty"` 2427 } 2428 2429 // WorkbookFunctionsPowerRequestParameter undocumented 2430 type WorkbookFunctionsPowerRequestParameter struct { 2431 // Number undocumented 2432 Number json.RawMessage `json:"number,omitempty"` 2433 // Power undocumented 2434 Power json.RawMessage `json:"power,omitempty"` 2435 } 2436 2437 // WorkbookFunctionsPpmtRequestParameter undocumented 2438 type WorkbookFunctionsPpmtRequestParameter struct { 2439 // Rate undocumented 2440 Rate json.RawMessage `json:"rate,omitempty"` 2441 // Per undocumented 2442 Per json.RawMessage `json:"per,omitempty"` 2443 // Nper undocumented 2444 Nper json.RawMessage `json:"nper,omitempty"` 2445 // Pv undocumented 2446 Pv json.RawMessage `json:"pv,omitempty"` 2447 // Fv undocumented 2448 Fv json.RawMessage `json:"fv,omitempty"` 2449 // Type undocumented 2450 Type json.RawMessage `json:"type,omitempty"` 2451 } 2452 2453 // WorkbookFunctionsPriceRequestParameter undocumented 2454 type WorkbookFunctionsPriceRequestParameter struct { 2455 // Settlement undocumented 2456 Settlement json.RawMessage `json:"settlement,omitempty"` 2457 // Maturity undocumented 2458 Maturity json.RawMessage `json:"maturity,omitempty"` 2459 // Rate undocumented 2460 Rate json.RawMessage `json:"rate,omitempty"` 2461 // Yld undocumented 2462 Yld json.RawMessage `json:"yld,omitempty"` 2463 // Redemption undocumented 2464 Redemption json.RawMessage `json:"redemption,omitempty"` 2465 // Frequency undocumented 2466 Frequency json.RawMessage `json:"frequency,omitempty"` 2467 // Basis undocumented 2468 Basis json.RawMessage `json:"basis,omitempty"` 2469 } 2470 2471 // WorkbookFunctionsPriceDiscRequestParameter undocumented 2472 type WorkbookFunctionsPriceDiscRequestParameter struct { 2473 // Settlement undocumented 2474 Settlement json.RawMessage `json:"settlement,omitempty"` 2475 // Maturity undocumented 2476 Maturity json.RawMessage `json:"maturity,omitempty"` 2477 // Discount undocumented 2478 Discount json.RawMessage `json:"discount,omitempty"` 2479 // Redemption undocumented 2480 Redemption json.RawMessage `json:"redemption,omitempty"` 2481 // Basis undocumented 2482 Basis json.RawMessage `json:"basis,omitempty"` 2483 } 2484 2485 // WorkbookFunctionsPriceMatRequestParameter undocumented 2486 type WorkbookFunctionsPriceMatRequestParameter struct { 2487 // Settlement undocumented 2488 Settlement json.RawMessage `json:"settlement,omitempty"` 2489 // Maturity undocumented 2490 Maturity json.RawMessage `json:"maturity,omitempty"` 2491 // Issue undocumented 2492 Issue json.RawMessage `json:"issue,omitempty"` 2493 // Rate undocumented 2494 Rate json.RawMessage `json:"rate,omitempty"` 2495 // Yld undocumented 2496 Yld json.RawMessage `json:"yld,omitempty"` 2497 // Basis undocumented 2498 Basis json.RawMessage `json:"basis,omitempty"` 2499 } 2500 2501 // WorkbookFunctionsProductRequestParameter undocumented 2502 type WorkbookFunctionsProductRequestParameter struct { 2503 // Values undocumented 2504 Values json.RawMessage `json:"values,omitempty"` 2505 } 2506 2507 // WorkbookFunctionsProperRequestParameter undocumented 2508 type WorkbookFunctionsProperRequestParameter struct { 2509 // Text undocumented 2510 Text json.RawMessage `json:"text,omitempty"` 2511 } 2512 2513 // WorkbookFunctionsPvRequestParameter undocumented 2514 type WorkbookFunctionsPvRequestParameter struct { 2515 // Rate undocumented 2516 Rate json.RawMessage `json:"rate,omitempty"` 2517 // Nper undocumented 2518 Nper json.RawMessage `json:"nper,omitempty"` 2519 // Pmt undocumented 2520 Pmt json.RawMessage `json:"pmt,omitempty"` 2521 // Fv undocumented 2522 Fv json.RawMessage `json:"fv,omitempty"` 2523 // Type undocumented 2524 Type json.RawMessage `json:"type,omitempty"` 2525 } 2526 2527 // WorkbookFunctionsQuartile_ExcRequestParameter undocumented 2528 type WorkbookFunctionsQuartile_ExcRequestParameter struct { 2529 // Array undocumented 2530 Array json.RawMessage `json:"array,omitempty"` 2531 // Quart undocumented 2532 Quart json.RawMessage `json:"quart,omitempty"` 2533 } 2534 2535 // WorkbookFunctionsQuartile_IncRequestParameter undocumented 2536 type WorkbookFunctionsQuartile_IncRequestParameter struct { 2537 // Array undocumented 2538 Array json.RawMessage `json:"array,omitempty"` 2539 // Quart undocumented 2540 Quart json.RawMessage `json:"quart,omitempty"` 2541 } 2542 2543 // WorkbookFunctionsQuotientRequestParameter undocumented 2544 type WorkbookFunctionsQuotientRequestParameter struct { 2545 // Numerator undocumented 2546 Numerator json.RawMessage `json:"numerator,omitempty"` 2547 // Denominator undocumented 2548 Denominator json.RawMessage `json:"denominator,omitempty"` 2549 } 2550 2551 // WorkbookFunctionsRadiansRequestParameter undocumented 2552 type WorkbookFunctionsRadiansRequestParameter struct { 2553 // Angle undocumented 2554 Angle json.RawMessage `json:"angle,omitempty"` 2555 } 2556 2557 // WorkbookFunctionsRandRequestParameter undocumented 2558 type WorkbookFunctionsRandRequestParameter struct { 2559 } 2560 2561 // WorkbookFunctionsRandBetweenRequestParameter undocumented 2562 type WorkbookFunctionsRandBetweenRequestParameter struct { 2563 // Bottom undocumented 2564 Bottom json.RawMessage `json:"bottom,omitempty"` 2565 // Top undocumented 2566 Top json.RawMessage `json:"top,omitempty"` 2567 } 2568 2569 // WorkbookFunctionsRank_AvgRequestParameter undocumented 2570 type WorkbookFunctionsRank_AvgRequestParameter struct { 2571 // Number undocumented 2572 Number json.RawMessage `json:"number,omitempty"` 2573 // Ref undocumented 2574 Ref json.RawMessage `json:"ref,omitempty"` 2575 // Order undocumented 2576 Order json.RawMessage `json:"order,omitempty"` 2577 } 2578 2579 // WorkbookFunctionsRank_EqRequestParameter undocumented 2580 type WorkbookFunctionsRank_EqRequestParameter struct { 2581 // Number undocumented 2582 Number json.RawMessage `json:"number,omitempty"` 2583 // Ref undocumented 2584 Ref json.RawMessage `json:"ref,omitempty"` 2585 // Order undocumented 2586 Order json.RawMessage `json:"order,omitempty"` 2587 } 2588 2589 // WorkbookFunctionsRateRequestParameter undocumented 2590 type WorkbookFunctionsRateRequestParameter struct { 2591 // Nper undocumented 2592 Nper json.RawMessage `json:"nper,omitempty"` 2593 // Pmt undocumented 2594 Pmt json.RawMessage `json:"pmt,omitempty"` 2595 // Pv undocumented 2596 Pv json.RawMessage `json:"pv,omitempty"` 2597 // Fv undocumented 2598 Fv json.RawMessage `json:"fv,omitempty"` 2599 // Type undocumented 2600 Type json.RawMessage `json:"type,omitempty"` 2601 // Guess undocumented 2602 Guess json.RawMessage `json:"guess,omitempty"` 2603 } 2604 2605 // WorkbookFunctionsReceivedRequestParameter undocumented 2606 type WorkbookFunctionsReceivedRequestParameter struct { 2607 // Settlement undocumented 2608 Settlement json.RawMessage `json:"settlement,omitempty"` 2609 // Maturity undocumented 2610 Maturity json.RawMessage `json:"maturity,omitempty"` 2611 // Investment undocumented 2612 Investment json.RawMessage `json:"investment,omitempty"` 2613 // Discount undocumented 2614 Discount json.RawMessage `json:"discount,omitempty"` 2615 // Basis undocumented 2616 Basis json.RawMessage `json:"basis,omitempty"` 2617 } 2618 2619 // WorkbookFunctionsReplaceRequestParameter undocumented 2620 type WorkbookFunctionsReplaceRequestParameter struct { 2621 // OldText undocumented 2622 OldText json.RawMessage `json:"oldText,omitempty"` 2623 // StartNum undocumented 2624 StartNum json.RawMessage `json:"startNum,omitempty"` 2625 // NumChars undocumented 2626 NumChars json.RawMessage `json:"numChars,omitempty"` 2627 // NewText undocumented 2628 NewText json.RawMessage `json:"newText,omitempty"` 2629 } 2630 2631 // WorkbookFunctionsReplaceBRequestParameter undocumented 2632 type WorkbookFunctionsReplaceBRequestParameter struct { 2633 // OldText undocumented 2634 OldText json.RawMessage `json:"oldText,omitempty"` 2635 // StartNum undocumented 2636 StartNum json.RawMessage `json:"startNum,omitempty"` 2637 // NumBytes undocumented 2638 NumBytes json.RawMessage `json:"numBytes,omitempty"` 2639 // NewText undocumented 2640 NewText json.RawMessage `json:"newText,omitempty"` 2641 } 2642 2643 // WorkbookFunctionsReptRequestParameter undocumented 2644 type WorkbookFunctionsReptRequestParameter struct { 2645 // Text undocumented 2646 Text json.RawMessage `json:"text,omitempty"` 2647 // NumberTimes undocumented 2648 NumberTimes json.RawMessage `json:"numberTimes,omitempty"` 2649 } 2650 2651 // WorkbookFunctionsRightRequestParameter undocumented 2652 type WorkbookFunctionsRightRequestParameter struct { 2653 // Text undocumented 2654 Text json.RawMessage `json:"text,omitempty"` 2655 // NumChars undocumented 2656 NumChars json.RawMessage `json:"numChars,omitempty"` 2657 } 2658 2659 // WorkbookFunctionsRightbRequestParameter undocumented 2660 type WorkbookFunctionsRightbRequestParameter struct { 2661 // Text undocumented 2662 Text json.RawMessage `json:"text,omitempty"` 2663 // NumBytes undocumented 2664 NumBytes json.RawMessage `json:"numBytes,omitempty"` 2665 } 2666 2667 // WorkbookFunctionsRomanRequestParameter undocumented 2668 type WorkbookFunctionsRomanRequestParameter struct { 2669 // Number undocumented 2670 Number json.RawMessage `json:"number,omitempty"` 2671 // Form undocumented 2672 Form json.RawMessage `json:"form,omitempty"` 2673 } 2674 2675 // WorkbookFunctionsRoundRequestParameter undocumented 2676 type WorkbookFunctionsRoundRequestParameter struct { 2677 // Number undocumented 2678 Number json.RawMessage `json:"number,omitempty"` 2679 // NumDigits undocumented 2680 NumDigits json.RawMessage `json:"numDigits,omitempty"` 2681 } 2682 2683 // WorkbookFunctionsRoundDownRequestParameter undocumented 2684 type WorkbookFunctionsRoundDownRequestParameter struct { 2685 // Number undocumented 2686 Number json.RawMessage `json:"number,omitempty"` 2687 // NumDigits undocumented 2688 NumDigits json.RawMessage `json:"numDigits,omitempty"` 2689 } 2690 2691 // WorkbookFunctionsRoundUpRequestParameter undocumented 2692 type WorkbookFunctionsRoundUpRequestParameter struct { 2693 // Number undocumented 2694 Number json.RawMessage `json:"number,omitempty"` 2695 // NumDigits undocumented 2696 NumDigits json.RawMessage `json:"numDigits,omitempty"` 2697 } 2698 2699 // WorkbookFunctionsRowsRequestParameter undocumented 2700 type WorkbookFunctionsRowsRequestParameter struct { 2701 // Array undocumented 2702 Array json.RawMessage `json:"array,omitempty"` 2703 } 2704 2705 // WorkbookFunctionsRriRequestParameter undocumented 2706 type WorkbookFunctionsRriRequestParameter struct { 2707 // Nper undocumented 2708 Nper json.RawMessage `json:"nper,omitempty"` 2709 // Pv undocumented 2710 Pv json.RawMessage `json:"pv,omitempty"` 2711 // Fv undocumented 2712 Fv json.RawMessage `json:"fv,omitempty"` 2713 } 2714 2715 // WorkbookFunctionsSecRequestParameter undocumented 2716 type WorkbookFunctionsSecRequestParameter struct { 2717 // Number undocumented 2718 Number json.RawMessage `json:"number,omitempty"` 2719 } 2720 2721 // WorkbookFunctionsSechRequestParameter undocumented 2722 type WorkbookFunctionsSechRequestParameter struct { 2723 // Number undocumented 2724 Number json.RawMessage `json:"number,omitempty"` 2725 } 2726 2727 // WorkbookFunctionsSecondRequestParameter undocumented 2728 type WorkbookFunctionsSecondRequestParameter struct { 2729 // SerialNumber undocumented 2730 SerialNumber json.RawMessage `json:"serialNumber,omitempty"` 2731 } 2732 2733 // WorkbookFunctionsSeriesSumRequestParameter undocumented 2734 type WorkbookFunctionsSeriesSumRequestParameter struct { 2735 // X undocumented 2736 X json.RawMessage `json:"x,omitempty"` 2737 // N undocumented 2738 N json.RawMessage `json:"n,omitempty"` 2739 // M undocumented 2740 M json.RawMessage `json:"m,omitempty"` 2741 // Coefficients undocumented 2742 Coefficients json.RawMessage `json:"coefficients,omitempty"` 2743 } 2744 2745 // WorkbookFunctionsSheetRequestParameter undocumented 2746 type WorkbookFunctionsSheetRequestParameter struct { 2747 // Value undocumented 2748 Value json.RawMessage `json:"value,omitempty"` 2749 } 2750 2751 // WorkbookFunctionsSheetsRequestParameter undocumented 2752 type WorkbookFunctionsSheetsRequestParameter struct { 2753 // Reference undocumented 2754 Reference json.RawMessage `json:"reference,omitempty"` 2755 } 2756 2757 // WorkbookFunctionsSignRequestParameter undocumented 2758 type WorkbookFunctionsSignRequestParameter struct { 2759 // Number undocumented 2760 Number json.RawMessage `json:"number,omitempty"` 2761 } 2762 2763 // WorkbookFunctionsSinRequestParameter undocumented 2764 type WorkbookFunctionsSinRequestParameter struct { 2765 // Number undocumented 2766 Number json.RawMessage `json:"number,omitempty"` 2767 } 2768 2769 // WorkbookFunctionsSinhRequestParameter undocumented 2770 type WorkbookFunctionsSinhRequestParameter struct { 2771 // Number undocumented 2772 Number json.RawMessage `json:"number,omitempty"` 2773 } 2774 2775 // WorkbookFunctionsSkewRequestParameter undocumented 2776 type WorkbookFunctionsSkewRequestParameter struct { 2777 // Values undocumented 2778 Values json.RawMessage `json:"values,omitempty"` 2779 } 2780 2781 // WorkbookFunctionsSkew_pRequestParameter undocumented 2782 type WorkbookFunctionsSkew_pRequestParameter struct { 2783 // Values undocumented 2784 Values json.RawMessage `json:"values,omitempty"` 2785 } 2786 2787 // WorkbookFunctionsSlnRequestParameter undocumented 2788 type WorkbookFunctionsSlnRequestParameter struct { 2789 // Cost undocumented 2790 Cost json.RawMessage `json:"cost,omitempty"` 2791 // Salvage undocumented 2792 Salvage json.RawMessage `json:"salvage,omitempty"` 2793 // Life undocumented 2794 Life json.RawMessage `json:"life,omitempty"` 2795 } 2796 2797 // WorkbookFunctionsSmallRequestParameter undocumented 2798 type WorkbookFunctionsSmallRequestParameter struct { 2799 // Array undocumented 2800 Array json.RawMessage `json:"array,omitempty"` 2801 // K undocumented 2802 K json.RawMessage `json:"k,omitempty"` 2803 } 2804 2805 // WorkbookFunctionsSqrtRequestParameter undocumented 2806 type WorkbookFunctionsSqrtRequestParameter struct { 2807 // Number undocumented 2808 Number json.RawMessage `json:"number,omitempty"` 2809 } 2810 2811 // WorkbookFunctionsSqrtPiRequestParameter undocumented 2812 type WorkbookFunctionsSqrtPiRequestParameter struct { 2813 // Number undocumented 2814 Number json.RawMessage `json:"number,omitempty"` 2815 } 2816 2817 // WorkbookFunctionsStDevARequestParameter undocumented 2818 type WorkbookFunctionsStDevARequestParameter struct { 2819 // Values undocumented 2820 Values json.RawMessage `json:"values,omitempty"` 2821 } 2822 2823 // WorkbookFunctionsStDevPARequestParameter undocumented 2824 type WorkbookFunctionsStDevPARequestParameter struct { 2825 // Values undocumented 2826 Values json.RawMessage `json:"values,omitempty"` 2827 } 2828 2829 // WorkbookFunctionsStDev_PRequestParameter undocumented 2830 type WorkbookFunctionsStDev_PRequestParameter struct { 2831 // Values undocumented 2832 Values json.RawMessage `json:"values,omitempty"` 2833 } 2834 2835 // WorkbookFunctionsStDev_SRequestParameter undocumented 2836 type WorkbookFunctionsStDev_SRequestParameter struct { 2837 // Values undocumented 2838 Values json.RawMessage `json:"values,omitempty"` 2839 } 2840 2841 // WorkbookFunctionsStandardizeRequestParameter undocumented 2842 type WorkbookFunctionsStandardizeRequestParameter struct { 2843 // X undocumented 2844 X json.RawMessage `json:"x,omitempty"` 2845 // Mean undocumented 2846 Mean json.RawMessage `json:"mean,omitempty"` 2847 // StandardDev undocumented 2848 StandardDev json.RawMessage `json:"standardDev,omitempty"` 2849 } 2850 2851 // WorkbookFunctionsSubstituteRequestParameter undocumented 2852 type WorkbookFunctionsSubstituteRequestParameter struct { 2853 // Text undocumented 2854 Text json.RawMessage `json:"text,omitempty"` 2855 // OldText undocumented 2856 OldText json.RawMessage `json:"oldText,omitempty"` 2857 // NewText undocumented 2858 NewText json.RawMessage `json:"newText,omitempty"` 2859 // InstanceNum undocumented 2860 InstanceNum json.RawMessage `json:"instanceNum,omitempty"` 2861 } 2862 2863 // WorkbookFunctionsSubtotalRequestParameter undocumented 2864 type WorkbookFunctionsSubtotalRequestParameter struct { 2865 // FunctionNum undocumented 2866 FunctionNum json.RawMessage `json:"functionNum,omitempty"` 2867 // Values undocumented 2868 Values json.RawMessage `json:"values,omitempty"` 2869 } 2870 2871 // WorkbookFunctionsSumRequestParameter undocumented 2872 type WorkbookFunctionsSumRequestParameter struct { 2873 // Values undocumented 2874 Values json.RawMessage `json:"values,omitempty"` 2875 } 2876 2877 // WorkbookFunctionsSumIfRequestParameter undocumented 2878 type WorkbookFunctionsSumIfRequestParameter struct { 2879 // Range undocumented 2880 Range json.RawMessage `json:"range,omitempty"` 2881 // Criteria undocumented 2882 Criteria json.RawMessage `json:"criteria,omitempty"` 2883 // SumRange undocumented 2884 SumRange json.RawMessage `json:"sumRange,omitempty"` 2885 } 2886 2887 // WorkbookFunctionsSumIfsRequestParameter undocumented 2888 type WorkbookFunctionsSumIfsRequestParameter struct { 2889 // SumRange undocumented 2890 SumRange json.RawMessage `json:"sumRange,omitempty"` 2891 // Values undocumented 2892 Values json.RawMessage `json:"values,omitempty"` 2893 } 2894 2895 // WorkbookFunctionsSumSqRequestParameter undocumented 2896 type WorkbookFunctionsSumSqRequestParameter struct { 2897 // Values undocumented 2898 Values json.RawMessage `json:"values,omitempty"` 2899 } 2900 2901 // WorkbookFunctionsSydRequestParameter undocumented 2902 type WorkbookFunctionsSydRequestParameter struct { 2903 // Cost undocumented 2904 Cost json.RawMessage `json:"cost,omitempty"` 2905 // Salvage undocumented 2906 Salvage json.RawMessage `json:"salvage,omitempty"` 2907 // Life undocumented 2908 Life json.RawMessage `json:"life,omitempty"` 2909 // Per undocumented 2910 Per json.RawMessage `json:"per,omitempty"` 2911 } 2912 2913 // WorkbookFunctionsTRequestParameter undocumented 2914 type WorkbookFunctionsTRequestParameter struct { 2915 // Value undocumented 2916 Value json.RawMessage `json:"value,omitempty"` 2917 } 2918 2919 // WorkbookFunctionsTbillEqRequestParameter undocumented 2920 type WorkbookFunctionsTbillEqRequestParameter struct { 2921 // Settlement undocumented 2922 Settlement json.RawMessage `json:"settlement,omitempty"` 2923 // Maturity undocumented 2924 Maturity json.RawMessage `json:"maturity,omitempty"` 2925 // Discount undocumented 2926 Discount json.RawMessage `json:"discount,omitempty"` 2927 } 2928 2929 // WorkbookFunctionsTbillPriceRequestParameter undocumented 2930 type WorkbookFunctionsTbillPriceRequestParameter struct { 2931 // Settlement undocumented 2932 Settlement json.RawMessage `json:"settlement,omitempty"` 2933 // Maturity undocumented 2934 Maturity json.RawMessage `json:"maturity,omitempty"` 2935 // Discount undocumented 2936 Discount json.RawMessage `json:"discount,omitempty"` 2937 } 2938 2939 // WorkbookFunctionsTbillYieldRequestParameter undocumented 2940 type WorkbookFunctionsTbillYieldRequestParameter struct { 2941 // Settlement undocumented 2942 Settlement json.RawMessage `json:"settlement,omitempty"` 2943 // Maturity undocumented 2944 Maturity json.RawMessage `json:"maturity,omitempty"` 2945 // Pr undocumented 2946 Pr json.RawMessage `json:"pr,omitempty"` 2947 } 2948 2949 // WorkbookFunctionsT_DistRequestParameter undocumented 2950 type WorkbookFunctionsT_DistRequestParameter struct { 2951 // X undocumented 2952 X json.RawMessage `json:"x,omitempty"` 2953 // DegFreedom undocumented 2954 DegFreedom json.RawMessage `json:"degFreedom,omitempty"` 2955 // Cumulative undocumented 2956 Cumulative json.RawMessage `json:"cumulative,omitempty"` 2957 } 2958 2959 // WorkbookFunctionsT_Dist_2TRequestParameter undocumented 2960 type WorkbookFunctionsT_Dist_2TRequestParameter struct { 2961 // X undocumented 2962 X json.RawMessage `json:"x,omitempty"` 2963 // DegFreedom undocumented 2964 DegFreedom json.RawMessage `json:"degFreedom,omitempty"` 2965 } 2966 2967 // WorkbookFunctionsT_Dist_RTRequestParameter undocumented 2968 type WorkbookFunctionsT_Dist_RTRequestParameter struct { 2969 // X undocumented 2970 X json.RawMessage `json:"x,omitempty"` 2971 // DegFreedom undocumented 2972 DegFreedom json.RawMessage `json:"degFreedom,omitempty"` 2973 } 2974 2975 // WorkbookFunctionsT_InvRequestParameter undocumented 2976 type WorkbookFunctionsT_InvRequestParameter struct { 2977 // Probability undocumented 2978 Probability json.RawMessage `json:"probability,omitempty"` 2979 // DegFreedom undocumented 2980 DegFreedom json.RawMessage `json:"degFreedom,omitempty"` 2981 } 2982 2983 // WorkbookFunctionsT_Inv_2TRequestParameter undocumented 2984 type WorkbookFunctionsT_Inv_2TRequestParameter struct { 2985 // Probability undocumented 2986 Probability json.RawMessage `json:"probability,omitempty"` 2987 // DegFreedom undocumented 2988 DegFreedom json.RawMessage `json:"degFreedom,omitempty"` 2989 } 2990 2991 // WorkbookFunctionsTanRequestParameter undocumented 2992 type WorkbookFunctionsTanRequestParameter struct { 2993 // Number undocumented 2994 Number json.RawMessage `json:"number,omitempty"` 2995 } 2996 2997 // WorkbookFunctionsTanhRequestParameter undocumented 2998 type WorkbookFunctionsTanhRequestParameter struct { 2999 // Number undocumented 3000 Number json.RawMessage `json:"number,omitempty"` 3001 } 3002 3003 // WorkbookFunctionsTextRequestParameter undocumented 3004 type WorkbookFunctionsTextRequestParameter struct { 3005 // Value undocumented 3006 Value json.RawMessage `json:"value,omitempty"` 3007 // FormatText undocumented 3008 FormatText json.RawMessage `json:"formatText,omitempty"` 3009 } 3010 3011 // WorkbookFunctionsTimeRequestParameter undocumented 3012 type WorkbookFunctionsTimeRequestParameter struct { 3013 // Hour undocumented 3014 Hour json.RawMessage `json:"hour,omitempty"` 3015 // Minute undocumented 3016 Minute json.RawMessage `json:"minute,omitempty"` 3017 // Second undocumented 3018 Second json.RawMessage `json:"second,omitempty"` 3019 } 3020 3021 // WorkbookFunctionsTimevalueRequestParameter undocumented 3022 type WorkbookFunctionsTimevalueRequestParameter struct { 3023 // TimeText undocumented 3024 TimeText json.RawMessage `json:"timeText,omitempty"` 3025 } 3026 3027 // WorkbookFunctionsTodayRequestParameter undocumented 3028 type WorkbookFunctionsTodayRequestParameter struct { 3029 } 3030 3031 // WorkbookFunctionsTrimRequestParameter undocumented 3032 type WorkbookFunctionsTrimRequestParameter struct { 3033 // Text undocumented 3034 Text json.RawMessage `json:"text,omitempty"` 3035 } 3036 3037 // WorkbookFunctionsTrimMeanRequestParameter undocumented 3038 type WorkbookFunctionsTrimMeanRequestParameter struct { 3039 // Array undocumented 3040 Array json.RawMessage `json:"array,omitempty"` 3041 // Percent undocumented 3042 Percent json.RawMessage `json:"percent,omitempty"` 3043 } 3044 3045 // WorkbookFunctionsTrueRequestParameter undocumented 3046 type WorkbookFunctionsTrueRequestParameter struct { 3047 } 3048 3049 // WorkbookFunctionsTruncRequestParameter undocumented 3050 type WorkbookFunctionsTruncRequestParameter struct { 3051 // Number undocumented 3052 Number json.RawMessage `json:"number,omitempty"` 3053 // NumDigits undocumented 3054 NumDigits json.RawMessage `json:"numDigits,omitempty"` 3055 } 3056 3057 // WorkbookFunctionsTypeRequestParameter undocumented 3058 type WorkbookFunctionsTypeRequestParameter struct { 3059 // Value undocumented 3060 Value json.RawMessage `json:"value,omitempty"` 3061 } 3062 3063 // WorkbookFunctionsUsdollarRequestParameter undocumented 3064 type WorkbookFunctionsUsdollarRequestParameter struct { 3065 // Number undocumented 3066 Number json.RawMessage `json:"number,omitempty"` 3067 // Decimals undocumented 3068 Decimals json.RawMessage `json:"decimals,omitempty"` 3069 } 3070 3071 // WorkbookFunctionsUnicharRequestParameter undocumented 3072 type WorkbookFunctionsUnicharRequestParameter struct { 3073 // Number undocumented 3074 Number json.RawMessage `json:"number,omitempty"` 3075 } 3076 3077 // WorkbookFunctionsUnicodeRequestParameter undocumented 3078 type WorkbookFunctionsUnicodeRequestParameter struct { 3079 // Text undocumented 3080 Text json.RawMessage `json:"text,omitempty"` 3081 } 3082 3083 // WorkbookFunctionsUpperRequestParameter undocumented 3084 type WorkbookFunctionsUpperRequestParameter struct { 3085 // Text undocumented 3086 Text json.RawMessage `json:"text,omitempty"` 3087 } 3088 3089 // WorkbookFunctionsVlookupRequestParameter undocumented 3090 type WorkbookFunctionsVlookupRequestParameter struct { 3091 // LookupValue undocumented 3092 LookupValue json.RawMessage `json:"lookupValue,omitempty"` 3093 // TableArray undocumented 3094 TableArray json.RawMessage `json:"tableArray,omitempty"` 3095 // ColIndexNum undocumented 3096 ColIndexNum json.RawMessage `json:"colIndexNum,omitempty"` 3097 // RangeLookup undocumented 3098 RangeLookup json.RawMessage `json:"rangeLookup,omitempty"` 3099 } 3100 3101 // WorkbookFunctionsValueRequestParameter undocumented 3102 type WorkbookFunctionsValueRequestParameter struct { 3103 // Text undocumented 3104 Text json.RawMessage `json:"text,omitempty"` 3105 } 3106 3107 // WorkbookFunctionsVarARequestParameter undocumented 3108 type WorkbookFunctionsVarARequestParameter struct { 3109 // Values undocumented 3110 Values json.RawMessage `json:"values,omitempty"` 3111 } 3112 3113 // WorkbookFunctionsVarPARequestParameter undocumented 3114 type WorkbookFunctionsVarPARequestParameter struct { 3115 // Values undocumented 3116 Values json.RawMessage `json:"values,omitempty"` 3117 } 3118 3119 // WorkbookFunctionsVar_PRequestParameter undocumented 3120 type WorkbookFunctionsVar_PRequestParameter struct { 3121 // Values undocumented 3122 Values json.RawMessage `json:"values,omitempty"` 3123 } 3124 3125 // WorkbookFunctionsVar_SRequestParameter undocumented 3126 type WorkbookFunctionsVar_SRequestParameter struct { 3127 // Values undocumented 3128 Values json.RawMessage `json:"values,omitempty"` 3129 } 3130 3131 // WorkbookFunctionsVdbRequestParameter undocumented 3132 type WorkbookFunctionsVdbRequestParameter struct { 3133 // Cost undocumented 3134 Cost json.RawMessage `json:"cost,omitempty"` 3135 // Salvage undocumented 3136 Salvage json.RawMessage `json:"salvage,omitempty"` 3137 // Life undocumented 3138 Life json.RawMessage `json:"life,omitempty"` 3139 // StartPeriod undocumented 3140 StartPeriod json.RawMessage `json:"startPeriod,omitempty"` 3141 // EndPeriod undocumented 3142 EndPeriod json.RawMessage `json:"endPeriod,omitempty"` 3143 // Factor undocumented 3144 Factor json.RawMessage `json:"factor,omitempty"` 3145 // NoSwitch undocumented 3146 NoSwitch json.RawMessage `json:"noSwitch,omitempty"` 3147 } 3148 3149 // WorkbookFunctionsWeekNumRequestParameter undocumented 3150 type WorkbookFunctionsWeekNumRequestParameter struct { 3151 // SerialNumber undocumented 3152 SerialNumber json.RawMessage `json:"serialNumber,omitempty"` 3153 // ReturnType undocumented 3154 ReturnType json.RawMessage `json:"returnType,omitempty"` 3155 } 3156 3157 // WorkbookFunctionsWeekdayRequestParameter undocumented 3158 type WorkbookFunctionsWeekdayRequestParameter struct { 3159 // SerialNumber undocumented 3160 SerialNumber json.RawMessage `json:"serialNumber,omitempty"` 3161 // ReturnType undocumented 3162 ReturnType json.RawMessage `json:"returnType,omitempty"` 3163 } 3164 3165 // WorkbookFunctionsWeibull_DistRequestParameter undocumented 3166 type WorkbookFunctionsWeibull_DistRequestParameter struct { 3167 // X undocumented 3168 X json.RawMessage `json:"x,omitempty"` 3169 // Alpha undocumented 3170 Alpha json.RawMessage `json:"alpha,omitempty"` 3171 // Beta undocumented 3172 Beta json.RawMessage `json:"beta,omitempty"` 3173 // Cumulative undocumented 3174 Cumulative json.RawMessage `json:"cumulative,omitempty"` 3175 } 3176 3177 // WorkbookFunctionsWorkDayRequestParameter undocumented 3178 type WorkbookFunctionsWorkDayRequestParameter struct { 3179 // StartDate undocumented 3180 StartDate json.RawMessage `json:"startDate,omitempty"` 3181 // Days undocumented 3182 Days json.RawMessage `json:"days,omitempty"` 3183 // Holidays undocumented 3184 Holidays json.RawMessage `json:"holidays,omitempty"` 3185 } 3186 3187 // WorkbookFunctionsWorkDay_IntlRequestParameter undocumented 3188 type WorkbookFunctionsWorkDay_IntlRequestParameter struct { 3189 // StartDate undocumented 3190 StartDate json.RawMessage `json:"startDate,omitempty"` 3191 // Days undocumented 3192 Days json.RawMessage `json:"days,omitempty"` 3193 // Weekend undocumented 3194 Weekend json.RawMessage `json:"weekend,omitempty"` 3195 // Holidays undocumented 3196 Holidays json.RawMessage `json:"holidays,omitempty"` 3197 } 3198 3199 // WorkbookFunctionsXirrRequestParameter undocumented 3200 type WorkbookFunctionsXirrRequestParameter struct { 3201 // Values undocumented 3202 Values json.RawMessage `json:"values,omitempty"` 3203 // Dates undocumented 3204 Dates json.RawMessage `json:"dates,omitempty"` 3205 // Guess undocumented 3206 Guess json.RawMessage `json:"guess,omitempty"` 3207 } 3208 3209 // WorkbookFunctionsXnpvRequestParameter undocumented 3210 type WorkbookFunctionsXnpvRequestParameter struct { 3211 // Rate undocumented 3212 Rate json.RawMessage `json:"rate,omitempty"` 3213 // Values undocumented 3214 Values json.RawMessage `json:"values,omitempty"` 3215 // Dates undocumented 3216 Dates json.RawMessage `json:"dates,omitempty"` 3217 } 3218 3219 // WorkbookFunctionsXorRequestParameter undocumented 3220 type WorkbookFunctionsXorRequestParameter struct { 3221 // Values undocumented 3222 Values json.RawMessage `json:"values,omitempty"` 3223 } 3224 3225 // WorkbookFunctionsYearRequestParameter undocumented 3226 type WorkbookFunctionsYearRequestParameter struct { 3227 // SerialNumber undocumented 3228 SerialNumber json.RawMessage `json:"serialNumber,omitempty"` 3229 } 3230 3231 // WorkbookFunctionsYearFracRequestParameter undocumented 3232 type WorkbookFunctionsYearFracRequestParameter struct { 3233 // StartDate undocumented 3234 StartDate json.RawMessage `json:"startDate,omitempty"` 3235 // EndDate undocumented 3236 EndDate json.RawMessage `json:"endDate,omitempty"` 3237 // Basis undocumented 3238 Basis json.RawMessage `json:"basis,omitempty"` 3239 } 3240 3241 // WorkbookFunctionsYieldRequestParameter undocumented 3242 type WorkbookFunctionsYieldRequestParameter struct { 3243 // Settlement undocumented 3244 Settlement json.RawMessage `json:"settlement,omitempty"` 3245 // Maturity undocumented 3246 Maturity json.RawMessage `json:"maturity,omitempty"` 3247 // Rate undocumented 3248 Rate json.RawMessage `json:"rate,omitempty"` 3249 // Pr undocumented 3250 Pr json.RawMessage `json:"pr,omitempty"` 3251 // Redemption undocumented 3252 Redemption json.RawMessage `json:"redemption,omitempty"` 3253 // Frequency undocumented 3254 Frequency json.RawMessage `json:"frequency,omitempty"` 3255 // Basis undocumented 3256 Basis json.RawMessage `json:"basis,omitempty"` 3257 } 3258 3259 // WorkbookFunctionsYieldDiscRequestParameter undocumented 3260 type WorkbookFunctionsYieldDiscRequestParameter struct { 3261 // Settlement undocumented 3262 Settlement json.RawMessage `json:"settlement,omitempty"` 3263 // Maturity undocumented 3264 Maturity json.RawMessage `json:"maturity,omitempty"` 3265 // Pr undocumented 3266 Pr json.RawMessage `json:"pr,omitempty"` 3267 // Redemption undocumented 3268 Redemption json.RawMessage `json:"redemption,omitempty"` 3269 // Basis undocumented 3270 Basis json.RawMessage `json:"basis,omitempty"` 3271 } 3272 3273 // WorkbookFunctionsYieldMatRequestParameter undocumented 3274 type WorkbookFunctionsYieldMatRequestParameter struct { 3275 // Settlement undocumented 3276 Settlement json.RawMessage `json:"settlement,omitempty"` 3277 // Maturity undocumented 3278 Maturity json.RawMessage `json:"maturity,omitempty"` 3279 // Issue undocumented 3280 Issue json.RawMessage `json:"issue,omitempty"` 3281 // Rate undocumented 3282 Rate json.RawMessage `json:"rate,omitempty"` 3283 // Pr undocumented 3284 Pr json.RawMessage `json:"pr,omitempty"` 3285 // Basis undocumented 3286 Basis json.RawMessage `json:"basis,omitempty"` 3287 } 3288 3289 // WorkbookFunctionsZ_TestRequestParameter undocumented 3290 type WorkbookFunctionsZ_TestRequestParameter struct { 3291 // Array undocumented 3292 Array json.RawMessage `json:"array,omitempty"` 3293 // X undocumented 3294 X json.RawMessage `json:"x,omitempty"` 3295 // Sigma undocumented 3296 Sigma json.RawMessage `json:"sigma,omitempty"` 3297 } 3298 3299 // WorkbookPivotTableRefreshRequestParameter undocumented 3300 type WorkbookPivotTableRefreshRequestParameter struct { 3301 } 3302 3303 // WorkbookRangeClearRequestParameter undocumented 3304 type WorkbookRangeClearRequestParameter struct { 3305 // ApplyTo undocumented 3306 ApplyTo *string `json:"applyTo,omitempty"` 3307 } 3308 3309 // WorkbookRangeDeleteRequestParameter undocumented 3310 type WorkbookRangeDeleteRequestParameter struct { 3311 // Shift undocumented 3312 Shift *string `json:"shift,omitempty"` 3313 } 3314 3315 // WorkbookRangeInsertRequestParameter undocumented 3316 type WorkbookRangeInsertRequestParameter struct { 3317 // Shift undocumented 3318 Shift *string `json:"shift,omitempty"` 3319 } 3320 3321 // WorkbookRangeMergeRequestParameter undocumented 3322 type WorkbookRangeMergeRequestParameter struct { 3323 // Across undocumented 3324 Across *bool `json:"across,omitempty"` 3325 } 3326 3327 // WorkbookRangeUnmergeRequestParameter undocumented 3328 type WorkbookRangeUnmergeRequestParameter struct { 3329 } 3330 3331 // WorkbookRangeFillClearRequestParameter undocumented 3332 type WorkbookRangeFillClearRequestParameter struct { 3333 } 3334 3335 // WorkbookRangeFormatAutofitColumnsRequestParameter undocumented 3336 type WorkbookRangeFormatAutofitColumnsRequestParameter struct { 3337 } 3338 3339 // WorkbookRangeFormatAutofitRowsRequestParameter undocumented 3340 type WorkbookRangeFormatAutofitRowsRequestParameter struct { 3341 } 3342 3343 // WorkbookRangeSortApplyRequestParameter undocumented 3344 type WorkbookRangeSortApplyRequestParameter struct { 3345 // Fields undocumented 3346 Fields []WorkbookSortField `json:"fields,omitempty"` 3347 // MatchCase undocumented 3348 MatchCase *bool `json:"matchCase,omitempty"` 3349 // HasHeaders undocumented 3350 HasHeaders *bool `json:"hasHeaders,omitempty"` 3351 // Orientation undocumented 3352 Orientation *string `json:"orientation,omitempty"` 3353 // Method undocumented 3354 Method *string `json:"method,omitempty"` 3355 } 3356 3357 // WorkbookTableClearFiltersRequestParameter undocumented 3358 type WorkbookTableClearFiltersRequestParameter struct { 3359 } 3360 3361 // WorkbookTableConvertToRangeRequestParameter undocumented 3362 type WorkbookTableConvertToRangeRequestParameter struct { 3363 } 3364 3365 // WorkbookTableReapplyFiltersRequestParameter undocumented 3366 type WorkbookTableReapplyFiltersRequestParameter struct { 3367 } 3368 3369 // WorkbookTableSortApplyRequestParameter undocumented 3370 type WorkbookTableSortApplyRequestParameter struct { 3371 // Fields undocumented 3372 Fields []WorkbookSortField `json:"fields,omitempty"` 3373 // MatchCase undocumented 3374 MatchCase *bool `json:"matchCase,omitempty"` 3375 // Method undocumented 3376 Method *string `json:"method,omitempty"` 3377 } 3378 3379 // WorkbookTableSortClearRequestParameter undocumented 3380 type WorkbookTableSortClearRequestParameter struct { 3381 } 3382 3383 // WorkbookTableSortReapplyRequestParameter undocumented 3384 type WorkbookTableSortReapplyRequestParameter struct { 3385 } 3386 3387 // WorkbookWorksheetProtectionProtectRequestParameter undocumented 3388 type WorkbookWorksheetProtectionProtectRequestParameter struct { 3389 // Options undocumented 3390 Options *WorkbookWorksheetProtectionOptions `json:"options,omitempty"` 3391 } 3392 3393 // WorkbookWorksheetProtectionUnprotectRequestParameter undocumented 3394 type WorkbookWorksheetProtectionUnprotectRequestParameter struct { 3395 } 3396 3397 // Application is navigation property 3398 func (b *WorkbookRequestBuilder) Application() *WorkbookApplicationRequestBuilder { 3399 bb := &WorkbookApplicationRequestBuilder{BaseRequestBuilder: b.BaseRequestBuilder} 3400 bb.baseURL += "/application" 3401 return bb 3402 } 3403 3404 // Comments returns request builder for WorkbookComment collection 3405 func (b *WorkbookRequestBuilder) Comments() *WorkbookCommentsCollectionRequestBuilder { 3406 bb := &WorkbookCommentsCollectionRequestBuilder{BaseRequestBuilder: b.BaseRequestBuilder} 3407 bb.baseURL += "/comments" 3408 return bb 3409 } 3410 3411 // WorkbookCommentsCollectionRequestBuilder is request builder for WorkbookComment collection 3412 type WorkbookCommentsCollectionRequestBuilder struct{ BaseRequestBuilder } 3413 3414 // Request returns request for WorkbookComment collection 3415 func (b *WorkbookCommentsCollectionRequestBuilder) Request() *WorkbookCommentsCollectionRequest { 3416 return &WorkbookCommentsCollectionRequest{ 3417 BaseRequest: BaseRequest{baseURL: b.baseURL, client: b.client}, 3418 } 3419 } 3420 3421 // ID returns request builder for WorkbookComment item 3422 func (b *WorkbookCommentsCollectionRequestBuilder) ID(id string) *WorkbookCommentRequestBuilder { 3423 bb := &WorkbookCommentRequestBuilder{BaseRequestBuilder: b.BaseRequestBuilder} 3424 bb.baseURL += "/" + id 3425 return bb 3426 } 3427 3428 // WorkbookCommentsCollectionRequest is request for WorkbookComment collection 3429 type WorkbookCommentsCollectionRequest struct{ BaseRequest } 3430 3431 // Paging perfoms paging operation for WorkbookComment collection 3432 func (r *WorkbookCommentsCollectionRequest) Paging(ctx context.Context, method, path string, obj interface{}, n int) ([]WorkbookComment, error) { 3433 req, err := r.NewJSONRequest(method, path, obj) 3434 if err != nil { 3435 return nil, err 3436 } 3437 if ctx != nil { 3438 req = req.WithContext(ctx) 3439 } 3440 res, err := r.client.Do(req) 3441 if err != nil { 3442 return nil, err 3443 } 3444 var values []WorkbookComment 3445 for { 3446 if res.StatusCode != http.StatusOK { 3447 b, _ := ioutil.ReadAll(res.Body) 3448 res.Body.Close() 3449 errRes := &ErrorResponse{Response: res} 3450 err := jsonx.Unmarshal(b, errRes) 3451 if err != nil { 3452 return nil, fmt.Errorf("%s: %s", res.Status, string(b)) 3453 } 3454 return nil, errRes 3455 } 3456 var ( 3457 paging Paging 3458 value []WorkbookComment 3459 ) 3460 err := jsonx.NewDecoder(res.Body).Decode(&paging) 3461 res.Body.Close() 3462 if err != nil { 3463 return nil, err 3464 } 3465 err = jsonx.Unmarshal(paging.Value, &value) 3466 if err != nil { 3467 return nil, err 3468 } 3469 values = append(values, value...) 3470 if n >= 0 { 3471 n-- 3472 } 3473 if n == 0 || len(paging.NextLink) == 0 { 3474 return values, nil 3475 } 3476 req, err = http.NewRequest("GET", paging.NextLink, nil) 3477 if ctx != nil { 3478 req = req.WithContext(ctx) 3479 } 3480 res, err = r.client.Do(req) 3481 if err != nil { 3482 return nil, err 3483 } 3484 } 3485 } 3486 3487 // GetN performs GET request for WorkbookComment collection, max N pages 3488 func (r *WorkbookCommentsCollectionRequest) GetN(ctx context.Context, n int) ([]WorkbookComment, error) { 3489 var query string 3490 if r.query != nil { 3491 query = "?" + r.query.Encode() 3492 } 3493 return r.Paging(ctx, "GET", query, nil, n) 3494 } 3495 3496 // Get performs GET request for WorkbookComment collection 3497 func (r *WorkbookCommentsCollectionRequest) Get(ctx context.Context) ([]WorkbookComment, error) { 3498 return r.GetN(ctx, 0) 3499 } 3500 3501 // Add performs POST request for WorkbookComment collection 3502 func (r *WorkbookCommentsCollectionRequest) Add(ctx context.Context, reqObj *WorkbookComment) (resObj *WorkbookComment, err error) { 3503 err = r.JSONRequest(ctx, "POST", "", reqObj, &resObj) 3504 return 3505 } 3506 3507 // Functions is navigation property 3508 func (b *WorkbookRequestBuilder) Functions() *WorkbookFunctionsRequestBuilder { 3509 bb := &WorkbookFunctionsRequestBuilder{BaseRequestBuilder: b.BaseRequestBuilder} 3510 bb.baseURL += "/functions" 3511 return bb 3512 } 3513 3514 // Names returns request builder for WorkbookNamedItem collection 3515 func (b *WorkbookRequestBuilder) Names() *WorkbookNamesCollectionRequestBuilder { 3516 bb := &WorkbookNamesCollectionRequestBuilder{BaseRequestBuilder: b.BaseRequestBuilder} 3517 bb.baseURL += "/names" 3518 return bb 3519 } 3520 3521 // WorkbookNamesCollectionRequestBuilder is request builder for WorkbookNamedItem collection 3522 type WorkbookNamesCollectionRequestBuilder struct{ BaseRequestBuilder } 3523 3524 // Request returns request for WorkbookNamedItem collection 3525 func (b *WorkbookNamesCollectionRequestBuilder) Request() *WorkbookNamesCollectionRequest { 3526 return &WorkbookNamesCollectionRequest{ 3527 BaseRequest: BaseRequest{baseURL: b.baseURL, client: b.client}, 3528 } 3529 } 3530 3531 // ID returns request builder for WorkbookNamedItem item 3532 func (b *WorkbookNamesCollectionRequestBuilder) ID(id string) *WorkbookNamedItemRequestBuilder { 3533 bb := &WorkbookNamedItemRequestBuilder{BaseRequestBuilder: b.BaseRequestBuilder} 3534 bb.baseURL += "/" + id 3535 return bb 3536 } 3537 3538 // WorkbookNamesCollectionRequest is request for WorkbookNamedItem collection 3539 type WorkbookNamesCollectionRequest struct{ BaseRequest } 3540 3541 // Paging perfoms paging operation for WorkbookNamedItem collection 3542 func (r *WorkbookNamesCollectionRequest) Paging(ctx context.Context, method, path string, obj interface{}, n int) ([]WorkbookNamedItem, error) { 3543 req, err := r.NewJSONRequest(method, path, obj) 3544 if err != nil { 3545 return nil, err 3546 } 3547 if ctx != nil { 3548 req = req.WithContext(ctx) 3549 } 3550 res, err := r.client.Do(req) 3551 if err != nil { 3552 return nil, err 3553 } 3554 var values []WorkbookNamedItem 3555 for { 3556 if res.StatusCode != http.StatusOK { 3557 b, _ := ioutil.ReadAll(res.Body) 3558 res.Body.Close() 3559 errRes := &ErrorResponse{Response: res} 3560 err := jsonx.Unmarshal(b, errRes) 3561 if err != nil { 3562 return nil, fmt.Errorf("%s: %s", res.Status, string(b)) 3563 } 3564 return nil, errRes 3565 } 3566 var ( 3567 paging Paging 3568 value []WorkbookNamedItem 3569 ) 3570 err := jsonx.NewDecoder(res.Body).Decode(&paging) 3571 res.Body.Close() 3572 if err != nil { 3573 return nil, err 3574 } 3575 err = jsonx.Unmarshal(paging.Value, &value) 3576 if err != nil { 3577 return nil, err 3578 } 3579 values = append(values, value...) 3580 if n >= 0 { 3581 n-- 3582 } 3583 if n == 0 || len(paging.NextLink) == 0 { 3584 return values, nil 3585 } 3586 req, err = http.NewRequest("GET", paging.NextLink, nil) 3587 if ctx != nil { 3588 req = req.WithContext(ctx) 3589 } 3590 res, err = r.client.Do(req) 3591 if err != nil { 3592 return nil, err 3593 } 3594 } 3595 } 3596 3597 // GetN performs GET request for WorkbookNamedItem collection, max N pages 3598 func (r *WorkbookNamesCollectionRequest) GetN(ctx context.Context, n int) ([]WorkbookNamedItem, error) { 3599 var query string 3600 if r.query != nil { 3601 query = "?" + r.query.Encode() 3602 } 3603 return r.Paging(ctx, "GET", query, nil, n) 3604 } 3605 3606 // Get performs GET request for WorkbookNamedItem collection 3607 func (r *WorkbookNamesCollectionRequest) Get(ctx context.Context) ([]WorkbookNamedItem, error) { 3608 return r.GetN(ctx, 0) 3609 } 3610 3611 // Add performs POST request for WorkbookNamedItem collection 3612 func (r *WorkbookNamesCollectionRequest) Add(ctx context.Context, reqObj *WorkbookNamedItem) (resObj *WorkbookNamedItem, err error) { 3613 err = r.JSONRequest(ctx, "POST", "", reqObj, &resObj) 3614 return 3615 } 3616 3617 // Tables returns request builder for WorkbookTable collection 3618 func (b *WorkbookRequestBuilder) Tables() *WorkbookTablesCollectionRequestBuilder { 3619 bb := &WorkbookTablesCollectionRequestBuilder{BaseRequestBuilder: b.BaseRequestBuilder} 3620 bb.baseURL += "/tables" 3621 return bb 3622 } 3623 3624 // WorkbookTablesCollectionRequestBuilder is request builder for WorkbookTable collection 3625 type WorkbookTablesCollectionRequestBuilder struct{ BaseRequestBuilder } 3626 3627 // Request returns request for WorkbookTable collection 3628 func (b *WorkbookTablesCollectionRequestBuilder) Request() *WorkbookTablesCollectionRequest { 3629 return &WorkbookTablesCollectionRequest{ 3630 BaseRequest: BaseRequest{baseURL: b.baseURL, client: b.client}, 3631 } 3632 } 3633 3634 // ID returns request builder for WorkbookTable item 3635 func (b *WorkbookTablesCollectionRequestBuilder) ID(id string) *WorkbookTableRequestBuilder { 3636 bb := &WorkbookTableRequestBuilder{BaseRequestBuilder: b.BaseRequestBuilder} 3637 bb.baseURL += "/" + id 3638 return bb 3639 } 3640 3641 // WorkbookTablesCollectionRequest is request for WorkbookTable collection 3642 type WorkbookTablesCollectionRequest struct{ BaseRequest } 3643 3644 // Paging perfoms paging operation for WorkbookTable collection 3645 func (r *WorkbookTablesCollectionRequest) Paging(ctx context.Context, method, path string, obj interface{}, n int) ([]WorkbookTable, error) { 3646 req, err := r.NewJSONRequest(method, path, obj) 3647 if err != nil { 3648 return nil, err 3649 } 3650 if ctx != nil { 3651 req = req.WithContext(ctx) 3652 } 3653 res, err := r.client.Do(req) 3654 if err != nil { 3655 return nil, err 3656 } 3657 var values []WorkbookTable 3658 for { 3659 if res.StatusCode != http.StatusOK { 3660 b, _ := ioutil.ReadAll(res.Body) 3661 res.Body.Close() 3662 errRes := &ErrorResponse{Response: res} 3663 err := jsonx.Unmarshal(b, errRes) 3664 if err != nil { 3665 return nil, fmt.Errorf("%s: %s", res.Status, string(b)) 3666 } 3667 return nil, errRes 3668 } 3669 var ( 3670 paging Paging 3671 value []WorkbookTable 3672 ) 3673 err := jsonx.NewDecoder(res.Body).Decode(&paging) 3674 res.Body.Close() 3675 if err != nil { 3676 return nil, err 3677 } 3678 err = jsonx.Unmarshal(paging.Value, &value) 3679 if err != nil { 3680 return nil, err 3681 } 3682 values = append(values, value...) 3683 if n >= 0 { 3684 n-- 3685 } 3686 if n == 0 || len(paging.NextLink) == 0 { 3687 return values, nil 3688 } 3689 req, err = http.NewRequest("GET", paging.NextLink, nil) 3690 if ctx != nil { 3691 req = req.WithContext(ctx) 3692 } 3693 res, err = r.client.Do(req) 3694 if err != nil { 3695 return nil, err 3696 } 3697 } 3698 } 3699 3700 // GetN performs GET request for WorkbookTable collection, max N pages 3701 func (r *WorkbookTablesCollectionRequest) GetN(ctx context.Context, n int) ([]WorkbookTable, error) { 3702 var query string 3703 if r.query != nil { 3704 query = "?" + r.query.Encode() 3705 } 3706 return r.Paging(ctx, "GET", query, nil, n) 3707 } 3708 3709 // Get performs GET request for WorkbookTable collection 3710 func (r *WorkbookTablesCollectionRequest) Get(ctx context.Context) ([]WorkbookTable, error) { 3711 return r.GetN(ctx, 0) 3712 } 3713 3714 // Add performs POST request for WorkbookTable collection 3715 func (r *WorkbookTablesCollectionRequest) Add(ctx context.Context, reqObj *WorkbookTable) (resObj *WorkbookTable, err error) { 3716 err = r.JSONRequest(ctx, "POST", "", reqObj, &resObj) 3717 return 3718 } 3719 3720 // Worksheets returns request builder for WorkbookWorksheet collection 3721 func (b *WorkbookRequestBuilder) Worksheets() *WorkbookWorksheetsCollectionRequestBuilder { 3722 bb := &WorkbookWorksheetsCollectionRequestBuilder{BaseRequestBuilder: b.BaseRequestBuilder} 3723 bb.baseURL += "/worksheets" 3724 return bb 3725 } 3726 3727 // WorkbookWorksheetsCollectionRequestBuilder is request builder for WorkbookWorksheet collection 3728 type WorkbookWorksheetsCollectionRequestBuilder struct{ BaseRequestBuilder } 3729 3730 // Request returns request for WorkbookWorksheet collection 3731 func (b *WorkbookWorksheetsCollectionRequestBuilder) Request() *WorkbookWorksheetsCollectionRequest { 3732 return &WorkbookWorksheetsCollectionRequest{ 3733 BaseRequest: BaseRequest{baseURL: b.baseURL, client: b.client}, 3734 } 3735 } 3736 3737 // ID returns request builder for WorkbookWorksheet item 3738 func (b *WorkbookWorksheetsCollectionRequestBuilder) ID(id string) *WorkbookWorksheetRequestBuilder { 3739 bb := &WorkbookWorksheetRequestBuilder{BaseRequestBuilder: b.BaseRequestBuilder} 3740 bb.baseURL += "/" + id 3741 return bb 3742 } 3743 3744 // WorkbookWorksheetsCollectionRequest is request for WorkbookWorksheet collection 3745 type WorkbookWorksheetsCollectionRequest struct{ BaseRequest } 3746 3747 // Paging perfoms paging operation for WorkbookWorksheet collection 3748 func (r *WorkbookWorksheetsCollectionRequest) Paging(ctx context.Context, method, path string, obj interface{}, n int) ([]WorkbookWorksheet, error) { 3749 req, err := r.NewJSONRequest(method, path, obj) 3750 if err != nil { 3751 return nil, err 3752 } 3753 if ctx != nil { 3754 req = req.WithContext(ctx) 3755 } 3756 res, err := r.client.Do(req) 3757 if err != nil { 3758 return nil, err 3759 } 3760 var values []WorkbookWorksheet 3761 for { 3762 if res.StatusCode != http.StatusOK { 3763 b, _ := ioutil.ReadAll(res.Body) 3764 res.Body.Close() 3765 errRes := &ErrorResponse{Response: res} 3766 err := jsonx.Unmarshal(b, errRes) 3767 if err != nil { 3768 return nil, fmt.Errorf("%s: %s", res.Status, string(b)) 3769 } 3770 return nil, errRes 3771 } 3772 var ( 3773 paging Paging 3774 value []WorkbookWorksheet 3775 ) 3776 err := jsonx.NewDecoder(res.Body).Decode(&paging) 3777 res.Body.Close() 3778 if err != nil { 3779 return nil, err 3780 } 3781 err = jsonx.Unmarshal(paging.Value, &value) 3782 if err != nil { 3783 return nil, err 3784 } 3785 values = append(values, value...) 3786 if n >= 0 { 3787 n-- 3788 } 3789 if n == 0 || len(paging.NextLink) == 0 { 3790 return values, nil 3791 } 3792 req, err = http.NewRequest("GET", paging.NextLink, nil) 3793 if ctx != nil { 3794 req = req.WithContext(ctx) 3795 } 3796 res, err = r.client.Do(req) 3797 if err != nil { 3798 return nil, err 3799 } 3800 } 3801 } 3802 3803 // GetN performs GET request for WorkbookWorksheet collection, max N pages 3804 func (r *WorkbookWorksheetsCollectionRequest) GetN(ctx context.Context, n int) ([]WorkbookWorksheet, error) { 3805 var query string 3806 if r.query != nil { 3807 query = "?" + r.query.Encode() 3808 } 3809 return r.Paging(ctx, "GET", query, nil, n) 3810 } 3811 3812 // Get performs GET request for WorkbookWorksheet collection 3813 func (r *WorkbookWorksheetsCollectionRequest) Get(ctx context.Context) ([]WorkbookWorksheet, error) { 3814 return r.GetN(ctx, 0) 3815 } 3816 3817 // Add performs POST request for WorkbookWorksheet collection 3818 func (r *WorkbookWorksheetsCollectionRequest) Add(ctx context.Context, reqObj *WorkbookWorksheet) (resObj *WorkbookWorksheet, err error) { 3819 err = r.JSONRequest(ctx, "POST", "", reqObj, &resObj) 3820 return 3821 } 3822 3823 // Axes is navigation property 3824 func (b *WorkbookChartRequestBuilder) Axes() *WorkbookChartAxesRequestBuilder { 3825 bb := &WorkbookChartAxesRequestBuilder{BaseRequestBuilder: b.BaseRequestBuilder} 3826 bb.baseURL += "/axes" 3827 return bb 3828 } 3829 3830 // DataLabels is navigation property 3831 func (b *WorkbookChartRequestBuilder) DataLabels() *WorkbookChartDataLabelsRequestBuilder { 3832 bb := &WorkbookChartDataLabelsRequestBuilder{BaseRequestBuilder: b.BaseRequestBuilder} 3833 bb.baseURL += "/dataLabels" 3834 return bb 3835 } 3836 3837 // Format is navigation property 3838 func (b *WorkbookChartRequestBuilder) Format() *WorkbookChartAreaFormatRequestBuilder { 3839 bb := &WorkbookChartAreaFormatRequestBuilder{BaseRequestBuilder: b.BaseRequestBuilder} 3840 bb.baseURL += "/format" 3841 return bb 3842 } 3843 3844 // Legend is navigation property 3845 func (b *WorkbookChartRequestBuilder) Legend() *WorkbookChartLegendRequestBuilder { 3846 bb := &WorkbookChartLegendRequestBuilder{BaseRequestBuilder: b.BaseRequestBuilder} 3847 bb.baseURL += "/legend" 3848 return bb 3849 } 3850 3851 // Series returns request builder for WorkbookChartSeries collection 3852 func (b *WorkbookChartRequestBuilder) Series() *WorkbookChartSeriesCollectionRequestBuilder { 3853 bb := &WorkbookChartSeriesCollectionRequestBuilder{BaseRequestBuilder: b.BaseRequestBuilder} 3854 bb.baseURL += "/series" 3855 return bb 3856 } 3857 3858 // WorkbookChartSeriesCollectionRequestBuilder is request builder for WorkbookChartSeries collection 3859 type WorkbookChartSeriesCollectionRequestBuilder struct{ BaseRequestBuilder } 3860 3861 // Request returns request for WorkbookChartSeries collection 3862 func (b *WorkbookChartSeriesCollectionRequestBuilder) Request() *WorkbookChartSeriesCollectionRequest { 3863 return &WorkbookChartSeriesCollectionRequest{ 3864 BaseRequest: BaseRequest{baseURL: b.baseURL, client: b.client}, 3865 } 3866 } 3867 3868 // ID returns request builder for WorkbookChartSeries item 3869 func (b *WorkbookChartSeriesCollectionRequestBuilder) ID(id string) *WorkbookChartSeriesRequestBuilder { 3870 bb := &WorkbookChartSeriesRequestBuilder{BaseRequestBuilder: b.BaseRequestBuilder} 3871 bb.baseURL += "/" + id 3872 return bb 3873 } 3874 3875 // WorkbookChartSeriesCollectionRequest is request for WorkbookChartSeries collection 3876 type WorkbookChartSeriesCollectionRequest struct{ BaseRequest } 3877 3878 // Paging perfoms paging operation for WorkbookChartSeries collection 3879 func (r *WorkbookChartSeriesCollectionRequest) Paging(ctx context.Context, method, path string, obj interface{}, n int) ([]WorkbookChartSeries, error) { 3880 req, err := r.NewJSONRequest(method, path, obj) 3881 if err != nil { 3882 return nil, err 3883 } 3884 if ctx != nil { 3885 req = req.WithContext(ctx) 3886 } 3887 res, err := r.client.Do(req) 3888 if err != nil { 3889 return nil, err 3890 } 3891 var values []WorkbookChartSeries 3892 for { 3893 if res.StatusCode != http.StatusOK { 3894 b, _ := ioutil.ReadAll(res.Body) 3895 res.Body.Close() 3896 errRes := &ErrorResponse{Response: res} 3897 err := jsonx.Unmarshal(b, errRes) 3898 if err != nil { 3899 return nil, fmt.Errorf("%s: %s", res.Status, string(b)) 3900 } 3901 return nil, errRes 3902 } 3903 var ( 3904 paging Paging 3905 value []WorkbookChartSeries 3906 ) 3907 err := jsonx.NewDecoder(res.Body).Decode(&paging) 3908 res.Body.Close() 3909 if err != nil { 3910 return nil, err 3911 } 3912 err = jsonx.Unmarshal(paging.Value, &value) 3913 if err != nil { 3914 return nil, err 3915 } 3916 values = append(values, value...) 3917 if n >= 0 { 3918 n-- 3919 } 3920 if n == 0 || len(paging.NextLink) == 0 { 3921 return values, nil 3922 } 3923 req, err = http.NewRequest("GET", paging.NextLink, nil) 3924 if ctx != nil { 3925 req = req.WithContext(ctx) 3926 } 3927 res, err = r.client.Do(req) 3928 if err != nil { 3929 return nil, err 3930 } 3931 } 3932 } 3933 3934 // GetN performs GET request for WorkbookChartSeries collection, max N pages 3935 func (r *WorkbookChartSeriesCollectionRequest) GetN(ctx context.Context, n int) ([]WorkbookChartSeries, error) { 3936 var query string 3937 if r.query != nil { 3938 query = "?" + r.query.Encode() 3939 } 3940 return r.Paging(ctx, "GET", query, nil, n) 3941 } 3942 3943 // Get performs GET request for WorkbookChartSeries collection 3944 func (r *WorkbookChartSeriesCollectionRequest) Get(ctx context.Context) ([]WorkbookChartSeries, error) { 3945 return r.GetN(ctx, 0) 3946 } 3947 3948 // Add performs POST request for WorkbookChartSeries collection 3949 func (r *WorkbookChartSeriesCollectionRequest) Add(ctx context.Context, reqObj *WorkbookChartSeries) (resObj *WorkbookChartSeries, err error) { 3950 err = r.JSONRequest(ctx, "POST", "", reqObj, &resObj) 3951 return 3952 } 3953 3954 // Title is navigation property 3955 func (b *WorkbookChartRequestBuilder) Title() *WorkbookChartTitleRequestBuilder { 3956 bb := &WorkbookChartTitleRequestBuilder{BaseRequestBuilder: b.BaseRequestBuilder} 3957 bb.baseURL += "/title" 3958 return bb 3959 } 3960 3961 // Worksheet is navigation property 3962 func (b *WorkbookChartRequestBuilder) Worksheet() *WorkbookWorksheetRequestBuilder { 3963 bb := &WorkbookWorksheetRequestBuilder{BaseRequestBuilder: b.BaseRequestBuilder} 3964 bb.baseURL += "/worksheet" 3965 return bb 3966 } 3967 3968 // Fill is navigation property 3969 func (b *WorkbookChartAreaFormatRequestBuilder) Fill() *WorkbookChartFillRequestBuilder { 3970 bb := &WorkbookChartFillRequestBuilder{BaseRequestBuilder: b.BaseRequestBuilder} 3971 bb.baseURL += "/fill" 3972 return bb 3973 } 3974 3975 // Font is navigation property 3976 func (b *WorkbookChartAreaFormatRequestBuilder) Font() *WorkbookChartFontRequestBuilder { 3977 bb := &WorkbookChartFontRequestBuilder{BaseRequestBuilder: b.BaseRequestBuilder} 3978 bb.baseURL += "/font" 3979 return bb 3980 } 3981 3982 // CategoryAxis is navigation property 3983 func (b *WorkbookChartAxesRequestBuilder) CategoryAxis() *WorkbookChartAxisRequestBuilder { 3984 bb := &WorkbookChartAxisRequestBuilder{BaseRequestBuilder: b.BaseRequestBuilder} 3985 bb.baseURL += "/categoryAxis" 3986 return bb 3987 } 3988 3989 // SeriesAxis is navigation property 3990 func (b *WorkbookChartAxesRequestBuilder) SeriesAxis() *WorkbookChartAxisRequestBuilder { 3991 bb := &WorkbookChartAxisRequestBuilder{BaseRequestBuilder: b.BaseRequestBuilder} 3992 bb.baseURL += "/seriesAxis" 3993 return bb 3994 } 3995 3996 // ValueAxis is navigation property 3997 func (b *WorkbookChartAxesRequestBuilder) ValueAxis() *WorkbookChartAxisRequestBuilder { 3998 bb := &WorkbookChartAxisRequestBuilder{BaseRequestBuilder: b.BaseRequestBuilder} 3999 bb.baseURL += "/valueAxis" 4000 return bb 4001 } 4002 4003 // Format is navigation property 4004 func (b *WorkbookChartAxisRequestBuilder) Format() *WorkbookChartAxisFormatRequestBuilder { 4005 bb := &WorkbookChartAxisFormatRequestBuilder{BaseRequestBuilder: b.BaseRequestBuilder} 4006 bb.baseURL += "/format" 4007 return bb 4008 } 4009 4010 // MajorGridlines is navigation property 4011 func (b *WorkbookChartAxisRequestBuilder) MajorGridlines() *WorkbookChartGridlinesRequestBuilder { 4012 bb := &WorkbookChartGridlinesRequestBuilder{BaseRequestBuilder: b.BaseRequestBuilder} 4013 bb.baseURL += "/majorGridlines" 4014 return bb 4015 } 4016 4017 // MinorGridlines is navigation property 4018 func (b *WorkbookChartAxisRequestBuilder) MinorGridlines() *WorkbookChartGridlinesRequestBuilder { 4019 bb := &WorkbookChartGridlinesRequestBuilder{BaseRequestBuilder: b.BaseRequestBuilder} 4020 bb.baseURL += "/minorGridlines" 4021 return bb 4022 } 4023 4024 // Title is navigation property 4025 func (b *WorkbookChartAxisRequestBuilder) Title() *WorkbookChartAxisTitleRequestBuilder { 4026 bb := &WorkbookChartAxisTitleRequestBuilder{BaseRequestBuilder: b.BaseRequestBuilder} 4027 bb.baseURL += "/title" 4028 return bb 4029 } 4030 4031 // Font is navigation property 4032 func (b *WorkbookChartAxisFormatRequestBuilder) Font() *WorkbookChartFontRequestBuilder { 4033 bb := &WorkbookChartFontRequestBuilder{BaseRequestBuilder: b.BaseRequestBuilder} 4034 bb.baseURL += "/font" 4035 return bb 4036 } 4037 4038 // Line is navigation property 4039 func (b *WorkbookChartAxisFormatRequestBuilder) Line() *WorkbookChartLineFormatRequestBuilder { 4040 bb := &WorkbookChartLineFormatRequestBuilder{BaseRequestBuilder: b.BaseRequestBuilder} 4041 bb.baseURL += "/line" 4042 return bb 4043 } 4044 4045 // Format is navigation property 4046 func (b *WorkbookChartAxisTitleRequestBuilder) Format() *WorkbookChartAxisTitleFormatRequestBuilder { 4047 bb := &WorkbookChartAxisTitleFormatRequestBuilder{BaseRequestBuilder: b.BaseRequestBuilder} 4048 bb.baseURL += "/format" 4049 return bb 4050 } 4051 4052 // Font is navigation property 4053 func (b *WorkbookChartAxisTitleFormatRequestBuilder) Font() *WorkbookChartFontRequestBuilder { 4054 bb := &WorkbookChartFontRequestBuilder{BaseRequestBuilder: b.BaseRequestBuilder} 4055 bb.baseURL += "/font" 4056 return bb 4057 } 4058 4059 // Fill is navigation property 4060 func (b *WorkbookChartDataLabelFormatRequestBuilder) Fill() *WorkbookChartFillRequestBuilder { 4061 bb := &WorkbookChartFillRequestBuilder{BaseRequestBuilder: b.BaseRequestBuilder} 4062 bb.baseURL += "/fill" 4063 return bb 4064 } 4065 4066 // Font is navigation property 4067 func (b *WorkbookChartDataLabelFormatRequestBuilder) Font() *WorkbookChartFontRequestBuilder { 4068 bb := &WorkbookChartFontRequestBuilder{BaseRequestBuilder: b.BaseRequestBuilder} 4069 bb.baseURL += "/font" 4070 return bb 4071 } 4072 4073 // Format is navigation property 4074 func (b *WorkbookChartDataLabelsRequestBuilder) Format() *WorkbookChartDataLabelFormatRequestBuilder { 4075 bb := &WorkbookChartDataLabelFormatRequestBuilder{BaseRequestBuilder: b.BaseRequestBuilder} 4076 bb.baseURL += "/format" 4077 return bb 4078 } 4079 4080 // Format is navigation property 4081 func (b *WorkbookChartGridlinesRequestBuilder) Format() *WorkbookChartGridlinesFormatRequestBuilder { 4082 bb := &WorkbookChartGridlinesFormatRequestBuilder{BaseRequestBuilder: b.BaseRequestBuilder} 4083 bb.baseURL += "/format" 4084 return bb 4085 } 4086 4087 // Line is navigation property 4088 func (b *WorkbookChartGridlinesFormatRequestBuilder) Line() *WorkbookChartLineFormatRequestBuilder { 4089 bb := &WorkbookChartLineFormatRequestBuilder{BaseRequestBuilder: b.BaseRequestBuilder} 4090 bb.baseURL += "/line" 4091 return bb 4092 } 4093 4094 // Format is navigation property 4095 func (b *WorkbookChartLegendRequestBuilder) Format() *WorkbookChartLegendFormatRequestBuilder { 4096 bb := &WorkbookChartLegendFormatRequestBuilder{BaseRequestBuilder: b.BaseRequestBuilder} 4097 bb.baseURL += "/format" 4098 return bb 4099 } 4100 4101 // Fill is navigation property 4102 func (b *WorkbookChartLegendFormatRequestBuilder) Fill() *WorkbookChartFillRequestBuilder { 4103 bb := &WorkbookChartFillRequestBuilder{BaseRequestBuilder: b.BaseRequestBuilder} 4104 bb.baseURL += "/fill" 4105 return bb 4106 } 4107 4108 // Font is navigation property 4109 func (b *WorkbookChartLegendFormatRequestBuilder) Font() *WorkbookChartFontRequestBuilder { 4110 bb := &WorkbookChartFontRequestBuilder{BaseRequestBuilder: b.BaseRequestBuilder} 4111 bb.baseURL += "/font" 4112 return bb 4113 } 4114 4115 // Format is navigation property 4116 func (b *WorkbookChartPointRequestBuilder) Format() *WorkbookChartPointFormatRequestBuilder { 4117 bb := &WorkbookChartPointFormatRequestBuilder{BaseRequestBuilder: b.BaseRequestBuilder} 4118 bb.baseURL += "/format" 4119 return bb 4120 } 4121 4122 // Fill is navigation property 4123 func (b *WorkbookChartPointFormatRequestBuilder) Fill() *WorkbookChartFillRequestBuilder { 4124 bb := &WorkbookChartFillRequestBuilder{BaseRequestBuilder: b.BaseRequestBuilder} 4125 bb.baseURL += "/fill" 4126 return bb 4127 } 4128 4129 // Format is navigation property 4130 func (b *WorkbookChartSeriesRequestBuilder) Format() *WorkbookChartSeriesFormatRequestBuilder { 4131 bb := &WorkbookChartSeriesFormatRequestBuilder{BaseRequestBuilder: b.BaseRequestBuilder} 4132 bb.baseURL += "/format" 4133 return bb 4134 } 4135 4136 // Points returns request builder for WorkbookChartPoint collection 4137 func (b *WorkbookChartSeriesRequestBuilder) Points() *WorkbookChartSeriesPointsCollectionRequestBuilder { 4138 bb := &WorkbookChartSeriesPointsCollectionRequestBuilder{BaseRequestBuilder: b.BaseRequestBuilder} 4139 bb.baseURL += "/points" 4140 return bb 4141 } 4142 4143 // WorkbookChartSeriesPointsCollectionRequestBuilder is request builder for WorkbookChartPoint collection 4144 type WorkbookChartSeriesPointsCollectionRequestBuilder struct{ BaseRequestBuilder } 4145 4146 // Request returns request for WorkbookChartPoint collection 4147 func (b *WorkbookChartSeriesPointsCollectionRequestBuilder) Request() *WorkbookChartSeriesPointsCollectionRequest { 4148 return &WorkbookChartSeriesPointsCollectionRequest{ 4149 BaseRequest: BaseRequest{baseURL: b.baseURL, client: b.client}, 4150 } 4151 } 4152 4153 // ID returns request builder for WorkbookChartPoint item 4154 func (b *WorkbookChartSeriesPointsCollectionRequestBuilder) ID(id string) *WorkbookChartPointRequestBuilder { 4155 bb := &WorkbookChartPointRequestBuilder{BaseRequestBuilder: b.BaseRequestBuilder} 4156 bb.baseURL += "/" + id 4157 return bb 4158 } 4159 4160 // WorkbookChartSeriesPointsCollectionRequest is request for WorkbookChartPoint collection 4161 type WorkbookChartSeriesPointsCollectionRequest struct{ BaseRequest } 4162 4163 // Paging perfoms paging operation for WorkbookChartPoint collection 4164 func (r *WorkbookChartSeriesPointsCollectionRequest) Paging(ctx context.Context, method, path string, obj interface{}, n int) ([]WorkbookChartPoint, error) { 4165 req, err := r.NewJSONRequest(method, path, obj) 4166 if err != nil { 4167 return nil, err 4168 } 4169 if ctx != nil { 4170 req = req.WithContext(ctx) 4171 } 4172 res, err := r.client.Do(req) 4173 if err != nil { 4174 return nil, err 4175 } 4176 var values []WorkbookChartPoint 4177 for { 4178 if res.StatusCode != http.StatusOK { 4179 b, _ := ioutil.ReadAll(res.Body) 4180 res.Body.Close() 4181 errRes := &ErrorResponse{Response: res} 4182 err := jsonx.Unmarshal(b, errRes) 4183 if err != nil { 4184 return nil, fmt.Errorf("%s: %s", res.Status, string(b)) 4185 } 4186 return nil, errRes 4187 } 4188 var ( 4189 paging Paging 4190 value []WorkbookChartPoint 4191 ) 4192 err := jsonx.NewDecoder(res.Body).Decode(&paging) 4193 res.Body.Close() 4194 if err != nil { 4195 return nil, err 4196 } 4197 err = jsonx.Unmarshal(paging.Value, &value) 4198 if err != nil { 4199 return nil, err 4200 } 4201 values = append(values, value...) 4202 if n >= 0 { 4203 n-- 4204 } 4205 if n == 0 || len(paging.NextLink) == 0 { 4206 return values, nil 4207 } 4208 req, err = http.NewRequest("GET", paging.NextLink, nil) 4209 if ctx != nil { 4210 req = req.WithContext(ctx) 4211 } 4212 res, err = r.client.Do(req) 4213 if err != nil { 4214 return nil, err 4215 } 4216 } 4217 } 4218 4219 // GetN performs GET request for WorkbookChartPoint collection, max N pages 4220 func (r *WorkbookChartSeriesPointsCollectionRequest) GetN(ctx context.Context, n int) ([]WorkbookChartPoint, error) { 4221 var query string 4222 if r.query != nil { 4223 query = "?" + r.query.Encode() 4224 } 4225 return r.Paging(ctx, "GET", query, nil, n) 4226 } 4227 4228 // Get performs GET request for WorkbookChartPoint collection 4229 func (r *WorkbookChartSeriesPointsCollectionRequest) Get(ctx context.Context) ([]WorkbookChartPoint, error) { 4230 return r.GetN(ctx, 0) 4231 } 4232 4233 // Add performs POST request for WorkbookChartPoint collection 4234 func (r *WorkbookChartSeriesPointsCollectionRequest) Add(ctx context.Context, reqObj *WorkbookChartPoint) (resObj *WorkbookChartPoint, err error) { 4235 err = r.JSONRequest(ctx, "POST", "", reqObj, &resObj) 4236 return 4237 } 4238 4239 // Fill is navigation property 4240 func (b *WorkbookChartSeriesFormatRequestBuilder) Fill() *WorkbookChartFillRequestBuilder { 4241 bb := &WorkbookChartFillRequestBuilder{BaseRequestBuilder: b.BaseRequestBuilder} 4242 bb.baseURL += "/fill" 4243 return bb 4244 } 4245 4246 // Line is navigation property 4247 func (b *WorkbookChartSeriesFormatRequestBuilder) Line() *WorkbookChartLineFormatRequestBuilder { 4248 bb := &WorkbookChartLineFormatRequestBuilder{BaseRequestBuilder: b.BaseRequestBuilder} 4249 bb.baseURL += "/line" 4250 return bb 4251 } 4252 4253 // Format is navigation property 4254 func (b *WorkbookChartTitleRequestBuilder) Format() *WorkbookChartTitleFormatRequestBuilder { 4255 bb := &WorkbookChartTitleFormatRequestBuilder{BaseRequestBuilder: b.BaseRequestBuilder} 4256 bb.baseURL += "/format" 4257 return bb 4258 } 4259 4260 // Fill is navigation property 4261 func (b *WorkbookChartTitleFormatRequestBuilder) Fill() *WorkbookChartFillRequestBuilder { 4262 bb := &WorkbookChartFillRequestBuilder{BaseRequestBuilder: b.BaseRequestBuilder} 4263 bb.baseURL += "/fill" 4264 return bb 4265 } 4266 4267 // Font is navigation property 4268 func (b *WorkbookChartTitleFormatRequestBuilder) Font() *WorkbookChartFontRequestBuilder { 4269 bb := &WorkbookChartFontRequestBuilder{BaseRequestBuilder: b.BaseRequestBuilder} 4270 bb.baseURL += "/font" 4271 return bb 4272 } 4273 4274 // Replies returns request builder for WorkbookCommentReply collection 4275 func (b *WorkbookCommentRequestBuilder) Replies() *WorkbookCommentRepliesCollectionRequestBuilder { 4276 bb := &WorkbookCommentRepliesCollectionRequestBuilder{BaseRequestBuilder: b.BaseRequestBuilder} 4277 bb.baseURL += "/replies" 4278 return bb 4279 } 4280 4281 // WorkbookCommentRepliesCollectionRequestBuilder is request builder for WorkbookCommentReply collection 4282 type WorkbookCommentRepliesCollectionRequestBuilder struct{ BaseRequestBuilder } 4283 4284 // Request returns request for WorkbookCommentReply collection 4285 func (b *WorkbookCommentRepliesCollectionRequestBuilder) Request() *WorkbookCommentRepliesCollectionRequest { 4286 return &WorkbookCommentRepliesCollectionRequest{ 4287 BaseRequest: BaseRequest{baseURL: b.baseURL, client: b.client}, 4288 } 4289 } 4290 4291 // ID returns request builder for WorkbookCommentReply item 4292 func (b *WorkbookCommentRepliesCollectionRequestBuilder) ID(id string) *WorkbookCommentReplyRequestBuilder { 4293 bb := &WorkbookCommentReplyRequestBuilder{BaseRequestBuilder: b.BaseRequestBuilder} 4294 bb.baseURL += "/" + id 4295 return bb 4296 } 4297 4298 // WorkbookCommentRepliesCollectionRequest is request for WorkbookCommentReply collection 4299 type WorkbookCommentRepliesCollectionRequest struct{ BaseRequest } 4300 4301 // Paging perfoms paging operation for WorkbookCommentReply collection 4302 func (r *WorkbookCommentRepliesCollectionRequest) Paging(ctx context.Context, method, path string, obj interface{}, n int) ([]WorkbookCommentReply, error) { 4303 req, err := r.NewJSONRequest(method, path, obj) 4304 if err != nil { 4305 return nil, err 4306 } 4307 if ctx != nil { 4308 req = req.WithContext(ctx) 4309 } 4310 res, err := r.client.Do(req) 4311 if err != nil { 4312 return nil, err 4313 } 4314 var values []WorkbookCommentReply 4315 for { 4316 if res.StatusCode != http.StatusOK { 4317 b, _ := ioutil.ReadAll(res.Body) 4318 res.Body.Close() 4319 errRes := &ErrorResponse{Response: res} 4320 err := jsonx.Unmarshal(b, errRes) 4321 if err != nil { 4322 return nil, fmt.Errorf("%s: %s", res.Status, string(b)) 4323 } 4324 return nil, errRes 4325 } 4326 var ( 4327 paging Paging 4328 value []WorkbookCommentReply 4329 ) 4330 err := jsonx.NewDecoder(res.Body).Decode(&paging) 4331 res.Body.Close() 4332 if err != nil { 4333 return nil, err 4334 } 4335 err = jsonx.Unmarshal(paging.Value, &value) 4336 if err != nil { 4337 return nil, err 4338 } 4339 values = append(values, value...) 4340 if n >= 0 { 4341 n-- 4342 } 4343 if n == 0 || len(paging.NextLink) == 0 { 4344 return values, nil 4345 } 4346 req, err = http.NewRequest("GET", paging.NextLink, nil) 4347 if ctx != nil { 4348 req = req.WithContext(ctx) 4349 } 4350 res, err = r.client.Do(req) 4351 if err != nil { 4352 return nil, err 4353 } 4354 } 4355 } 4356 4357 // GetN performs GET request for WorkbookCommentReply collection, max N pages 4358 func (r *WorkbookCommentRepliesCollectionRequest) GetN(ctx context.Context, n int) ([]WorkbookCommentReply, error) { 4359 var query string 4360 if r.query != nil { 4361 query = "?" + r.query.Encode() 4362 } 4363 return r.Paging(ctx, "GET", query, nil, n) 4364 } 4365 4366 // Get performs GET request for WorkbookCommentReply collection 4367 func (r *WorkbookCommentRepliesCollectionRequest) Get(ctx context.Context) ([]WorkbookCommentReply, error) { 4368 return r.GetN(ctx, 0) 4369 } 4370 4371 // Add performs POST request for WorkbookCommentReply collection 4372 func (r *WorkbookCommentRepliesCollectionRequest) Add(ctx context.Context, reqObj *WorkbookCommentReply) (resObj *WorkbookCommentReply, err error) { 4373 err = r.JSONRequest(ctx, "POST", "", reqObj, &resObj) 4374 return 4375 } 4376 4377 // Worksheet is navigation property 4378 func (b *WorkbookNamedItemRequestBuilder) Worksheet() *WorkbookWorksheetRequestBuilder { 4379 bb := &WorkbookWorksheetRequestBuilder{BaseRequestBuilder: b.BaseRequestBuilder} 4380 bb.baseURL += "/worksheet" 4381 return bb 4382 } 4383 4384 // Worksheet is navigation property 4385 func (b *WorkbookPivotTableRequestBuilder) Worksheet() *WorkbookWorksheetRequestBuilder { 4386 bb := &WorkbookWorksheetRequestBuilder{BaseRequestBuilder: b.BaseRequestBuilder} 4387 bb.baseURL += "/worksheet" 4388 return bb 4389 } 4390 4391 // Format is navigation property 4392 func (b *WorkbookRangeRequestBuilder) Format() *WorkbookRangeFormatRequestBuilder { 4393 bb := &WorkbookRangeFormatRequestBuilder{BaseRequestBuilder: b.BaseRequestBuilder} 4394 bb.baseURL += "/format" 4395 return bb 4396 } 4397 4398 // Sort is navigation property 4399 func (b *WorkbookRangeRequestBuilder) Sort() *WorkbookRangeSortRequestBuilder { 4400 bb := &WorkbookRangeSortRequestBuilder{BaseRequestBuilder: b.BaseRequestBuilder} 4401 bb.baseURL += "/sort" 4402 return bb 4403 } 4404 4405 // Worksheet is navigation property 4406 func (b *WorkbookRangeRequestBuilder) Worksheet() *WorkbookWorksheetRequestBuilder { 4407 bb := &WorkbookWorksheetRequestBuilder{BaseRequestBuilder: b.BaseRequestBuilder} 4408 bb.baseURL += "/worksheet" 4409 return bb 4410 } 4411 4412 // Borders returns request builder for WorkbookRangeBorder collection 4413 func (b *WorkbookRangeFormatRequestBuilder) Borders() *WorkbookRangeFormatBordersCollectionRequestBuilder { 4414 bb := &WorkbookRangeFormatBordersCollectionRequestBuilder{BaseRequestBuilder: b.BaseRequestBuilder} 4415 bb.baseURL += "/borders" 4416 return bb 4417 } 4418 4419 // WorkbookRangeFormatBordersCollectionRequestBuilder is request builder for WorkbookRangeBorder collection 4420 type WorkbookRangeFormatBordersCollectionRequestBuilder struct{ BaseRequestBuilder } 4421 4422 // Request returns request for WorkbookRangeBorder collection 4423 func (b *WorkbookRangeFormatBordersCollectionRequestBuilder) Request() *WorkbookRangeFormatBordersCollectionRequest { 4424 return &WorkbookRangeFormatBordersCollectionRequest{ 4425 BaseRequest: BaseRequest{baseURL: b.baseURL, client: b.client}, 4426 } 4427 } 4428 4429 // ID returns request builder for WorkbookRangeBorder item 4430 func (b *WorkbookRangeFormatBordersCollectionRequestBuilder) ID(id string) *WorkbookRangeBorderRequestBuilder { 4431 bb := &WorkbookRangeBorderRequestBuilder{BaseRequestBuilder: b.BaseRequestBuilder} 4432 bb.baseURL += "/" + id 4433 return bb 4434 } 4435 4436 // WorkbookRangeFormatBordersCollectionRequest is request for WorkbookRangeBorder collection 4437 type WorkbookRangeFormatBordersCollectionRequest struct{ BaseRequest } 4438 4439 // Paging perfoms paging operation for WorkbookRangeBorder collection 4440 func (r *WorkbookRangeFormatBordersCollectionRequest) Paging(ctx context.Context, method, path string, obj interface{}, n int) ([]WorkbookRangeBorder, error) { 4441 req, err := r.NewJSONRequest(method, path, obj) 4442 if err != nil { 4443 return nil, err 4444 } 4445 if ctx != nil { 4446 req = req.WithContext(ctx) 4447 } 4448 res, err := r.client.Do(req) 4449 if err != nil { 4450 return nil, err 4451 } 4452 var values []WorkbookRangeBorder 4453 for { 4454 if res.StatusCode != http.StatusOK { 4455 b, _ := ioutil.ReadAll(res.Body) 4456 res.Body.Close() 4457 errRes := &ErrorResponse{Response: res} 4458 err := jsonx.Unmarshal(b, errRes) 4459 if err != nil { 4460 return nil, fmt.Errorf("%s: %s", res.Status, string(b)) 4461 } 4462 return nil, errRes 4463 } 4464 var ( 4465 paging Paging 4466 value []WorkbookRangeBorder 4467 ) 4468 err := jsonx.NewDecoder(res.Body).Decode(&paging) 4469 res.Body.Close() 4470 if err != nil { 4471 return nil, err 4472 } 4473 err = jsonx.Unmarshal(paging.Value, &value) 4474 if err != nil { 4475 return nil, err 4476 } 4477 values = append(values, value...) 4478 if n >= 0 { 4479 n-- 4480 } 4481 if n == 0 || len(paging.NextLink) == 0 { 4482 return values, nil 4483 } 4484 req, err = http.NewRequest("GET", paging.NextLink, nil) 4485 if ctx != nil { 4486 req = req.WithContext(ctx) 4487 } 4488 res, err = r.client.Do(req) 4489 if err != nil { 4490 return nil, err 4491 } 4492 } 4493 } 4494 4495 // GetN performs GET request for WorkbookRangeBorder collection, max N pages 4496 func (r *WorkbookRangeFormatBordersCollectionRequest) GetN(ctx context.Context, n int) ([]WorkbookRangeBorder, error) { 4497 var query string 4498 if r.query != nil { 4499 query = "?" + r.query.Encode() 4500 } 4501 return r.Paging(ctx, "GET", query, nil, n) 4502 } 4503 4504 // Get performs GET request for WorkbookRangeBorder collection 4505 func (r *WorkbookRangeFormatBordersCollectionRequest) Get(ctx context.Context) ([]WorkbookRangeBorder, error) { 4506 return r.GetN(ctx, 0) 4507 } 4508 4509 // Add performs POST request for WorkbookRangeBorder collection 4510 func (r *WorkbookRangeFormatBordersCollectionRequest) Add(ctx context.Context, reqObj *WorkbookRangeBorder) (resObj *WorkbookRangeBorder, err error) { 4511 err = r.JSONRequest(ctx, "POST", "", reqObj, &resObj) 4512 return 4513 } 4514 4515 // Fill is navigation property 4516 func (b *WorkbookRangeFormatRequestBuilder) Fill() *WorkbookRangeFillRequestBuilder { 4517 bb := &WorkbookRangeFillRequestBuilder{BaseRequestBuilder: b.BaseRequestBuilder} 4518 bb.baseURL += "/fill" 4519 return bb 4520 } 4521 4522 // Font is navigation property 4523 func (b *WorkbookRangeFormatRequestBuilder) Font() *WorkbookRangeFontRequestBuilder { 4524 bb := &WorkbookRangeFontRequestBuilder{BaseRequestBuilder: b.BaseRequestBuilder} 4525 bb.baseURL += "/font" 4526 return bb 4527 } 4528 4529 // Protection is navigation property 4530 func (b *WorkbookRangeFormatRequestBuilder) Protection() *WorkbookFormatProtectionRequestBuilder { 4531 bb := &WorkbookFormatProtectionRequestBuilder{BaseRequestBuilder: b.BaseRequestBuilder} 4532 bb.baseURL += "/protection" 4533 return bb 4534 } 4535 4536 // Rows returns request builder for WorkbookRangeView collection 4537 func (b *WorkbookRangeViewRequestBuilder) Rows() *WorkbookRangeViewRowsCollectionRequestBuilder { 4538 bb := &WorkbookRangeViewRowsCollectionRequestBuilder{BaseRequestBuilder: b.BaseRequestBuilder} 4539 bb.baseURL += "/rows" 4540 return bb 4541 } 4542 4543 // WorkbookRangeViewRowsCollectionRequestBuilder is request builder for WorkbookRangeView collection 4544 type WorkbookRangeViewRowsCollectionRequestBuilder struct{ BaseRequestBuilder } 4545 4546 // Request returns request for WorkbookRangeView collection 4547 func (b *WorkbookRangeViewRowsCollectionRequestBuilder) Request() *WorkbookRangeViewRowsCollectionRequest { 4548 return &WorkbookRangeViewRowsCollectionRequest{ 4549 BaseRequest: BaseRequest{baseURL: b.baseURL, client: b.client}, 4550 } 4551 } 4552 4553 // ID returns request builder for WorkbookRangeView item 4554 func (b *WorkbookRangeViewRowsCollectionRequestBuilder) ID(id string) *WorkbookRangeViewRequestBuilder { 4555 bb := &WorkbookRangeViewRequestBuilder{BaseRequestBuilder: b.BaseRequestBuilder} 4556 bb.baseURL += "/" + id 4557 return bb 4558 } 4559 4560 // WorkbookRangeViewRowsCollectionRequest is request for WorkbookRangeView collection 4561 type WorkbookRangeViewRowsCollectionRequest struct{ BaseRequest } 4562 4563 // Paging perfoms paging operation for WorkbookRangeView collection 4564 func (r *WorkbookRangeViewRowsCollectionRequest) Paging(ctx context.Context, method, path string, obj interface{}, n int) ([]WorkbookRangeView, error) { 4565 req, err := r.NewJSONRequest(method, path, obj) 4566 if err != nil { 4567 return nil, err 4568 } 4569 if ctx != nil { 4570 req = req.WithContext(ctx) 4571 } 4572 res, err := r.client.Do(req) 4573 if err != nil { 4574 return nil, err 4575 } 4576 var values []WorkbookRangeView 4577 for { 4578 if res.StatusCode != http.StatusOK { 4579 b, _ := ioutil.ReadAll(res.Body) 4580 res.Body.Close() 4581 errRes := &ErrorResponse{Response: res} 4582 err := jsonx.Unmarshal(b, errRes) 4583 if err != nil { 4584 return nil, fmt.Errorf("%s: %s", res.Status, string(b)) 4585 } 4586 return nil, errRes 4587 } 4588 var ( 4589 paging Paging 4590 value []WorkbookRangeView 4591 ) 4592 err := jsonx.NewDecoder(res.Body).Decode(&paging) 4593 res.Body.Close() 4594 if err != nil { 4595 return nil, err 4596 } 4597 err = jsonx.Unmarshal(paging.Value, &value) 4598 if err != nil { 4599 return nil, err 4600 } 4601 values = append(values, value...) 4602 if n >= 0 { 4603 n-- 4604 } 4605 if n == 0 || len(paging.NextLink) == 0 { 4606 return values, nil 4607 } 4608 req, err = http.NewRequest("GET", paging.NextLink, nil) 4609 if ctx != nil { 4610 req = req.WithContext(ctx) 4611 } 4612 res, err = r.client.Do(req) 4613 if err != nil { 4614 return nil, err 4615 } 4616 } 4617 } 4618 4619 // GetN performs GET request for WorkbookRangeView collection, max N pages 4620 func (r *WorkbookRangeViewRowsCollectionRequest) GetN(ctx context.Context, n int) ([]WorkbookRangeView, error) { 4621 var query string 4622 if r.query != nil { 4623 query = "?" + r.query.Encode() 4624 } 4625 return r.Paging(ctx, "GET", query, nil, n) 4626 } 4627 4628 // Get performs GET request for WorkbookRangeView collection 4629 func (r *WorkbookRangeViewRowsCollectionRequest) Get(ctx context.Context) ([]WorkbookRangeView, error) { 4630 return r.GetN(ctx, 0) 4631 } 4632 4633 // Add performs POST request for WorkbookRangeView collection 4634 func (r *WorkbookRangeViewRowsCollectionRequest) Add(ctx context.Context, reqObj *WorkbookRangeView) (resObj *WorkbookRangeView, err error) { 4635 err = r.JSONRequest(ctx, "POST", "", reqObj, &resObj) 4636 return 4637 } 4638 4639 // Columns returns request builder for WorkbookTableColumn collection 4640 func (b *WorkbookTableRequestBuilder) Columns() *WorkbookTableColumnsCollectionRequestBuilder { 4641 bb := &WorkbookTableColumnsCollectionRequestBuilder{BaseRequestBuilder: b.BaseRequestBuilder} 4642 bb.baseURL += "/columns" 4643 return bb 4644 } 4645 4646 // WorkbookTableColumnsCollectionRequestBuilder is request builder for WorkbookTableColumn collection 4647 type WorkbookTableColumnsCollectionRequestBuilder struct{ BaseRequestBuilder } 4648 4649 // Request returns request for WorkbookTableColumn collection 4650 func (b *WorkbookTableColumnsCollectionRequestBuilder) Request() *WorkbookTableColumnsCollectionRequest { 4651 return &WorkbookTableColumnsCollectionRequest{ 4652 BaseRequest: BaseRequest{baseURL: b.baseURL, client: b.client}, 4653 } 4654 } 4655 4656 // ID returns request builder for WorkbookTableColumn item 4657 func (b *WorkbookTableColumnsCollectionRequestBuilder) ID(id string) *WorkbookTableColumnRequestBuilder { 4658 bb := &WorkbookTableColumnRequestBuilder{BaseRequestBuilder: b.BaseRequestBuilder} 4659 bb.baseURL += "/" + id 4660 return bb 4661 } 4662 4663 // WorkbookTableColumnsCollectionRequest is request for WorkbookTableColumn collection 4664 type WorkbookTableColumnsCollectionRequest struct{ BaseRequest } 4665 4666 // Paging perfoms paging operation for WorkbookTableColumn collection 4667 func (r *WorkbookTableColumnsCollectionRequest) Paging(ctx context.Context, method, path string, obj interface{}, n int) ([]WorkbookTableColumn, error) { 4668 req, err := r.NewJSONRequest(method, path, obj) 4669 if err != nil { 4670 return nil, err 4671 } 4672 if ctx != nil { 4673 req = req.WithContext(ctx) 4674 } 4675 res, err := r.client.Do(req) 4676 if err != nil { 4677 return nil, err 4678 } 4679 var values []WorkbookTableColumn 4680 for { 4681 if res.StatusCode != http.StatusOK { 4682 b, _ := ioutil.ReadAll(res.Body) 4683 res.Body.Close() 4684 errRes := &ErrorResponse{Response: res} 4685 err := jsonx.Unmarshal(b, errRes) 4686 if err != nil { 4687 return nil, fmt.Errorf("%s: %s", res.Status, string(b)) 4688 } 4689 return nil, errRes 4690 } 4691 var ( 4692 paging Paging 4693 value []WorkbookTableColumn 4694 ) 4695 err := jsonx.NewDecoder(res.Body).Decode(&paging) 4696 res.Body.Close() 4697 if err != nil { 4698 return nil, err 4699 } 4700 err = jsonx.Unmarshal(paging.Value, &value) 4701 if err != nil { 4702 return nil, err 4703 } 4704 values = append(values, value...) 4705 if n >= 0 { 4706 n-- 4707 } 4708 if n == 0 || len(paging.NextLink) == 0 { 4709 return values, nil 4710 } 4711 req, err = http.NewRequest("GET", paging.NextLink, nil) 4712 if ctx != nil { 4713 req = req.WithContext(ctx) 4714 } 4715 res, err = r.client.Do(req) 4716 if err != nil { 4717 return nil, err 4718 } 4719 } 4720 } 4721 4722 // GetN performs GET request for WorkbookTableColumn collection, max N pages 4723 func (r *WorkbookTableColumnsCollectionRequest) GetN(ctx context.Context, n int) ([]WorkbookTableColumn, error) { 4724 var query string 4725 if r.query != nil { 4726 query = "?" + r.query.Encode() 4727 } 4728 return r.Paging(ctx, "GET", query, nil, n) 4729 } 4730 4731 // Get performs GET request for WorkbookTableColumn collection 4732 func (r *WorkbookTableColumnsCollectionRequest) Get(ctx context.Context) ([]WorkbookTableColumn, error) { 4733 return r.GetN(ctx, 0) 4734 } 4735 4736 // Add performs POST request for WorkbookTableColumn collection 4737 func (r *WorkbookTableColumnsCollectionRequest) Add(ctx context.Context, reqObj *WorkbookTableColumn) (resObj *WorkbookTableColumn, err error) { 4738 err = r.JSONRequest(ctx, "POST", "", reqObj, &resObj) 4739 return 4740 } 4741 4742 // Rows returns request builder for WorkbookTableRow collection 4743 func (b *WorkbookTableRequestBuilder) Rows() *WorkbookTableRowsCollectionRequestBuilder { 4744 bb := &WorkbookTableRowsCollectionRequestBuilder{BaseRequestBuilder: b.BaseRequestBuilder} 4745 bb.baseURL += "/rows" 4746 return bb 4747 } 4748 4749 // WorkbookTableRowsCollectionRequestBuilder is request builder for WorkbookTableRow collection 4750 type WorkbookTableRowsCollectionRequestBuilder struct{ BaseRequestBuilder } 4751 4752 // Request returns request for WorkbookTableRow collection 4753 func (b *WorkbookTableRowsCollectionRequestBuilder) Request() *WorkbookTableRowsCollectionRequest { 4754 return &WorkbookTableRowsCollectionRequest{ 4755 BaseRequest: BaseRequest{baseURL: b.baseURL, client: b.client}, 4756 } 4757 } 4758 4759 // ID returns request builder for WorkbookTableRow item 4760 func (b *WorkbookTableRowsCollectionRequestBuilder) ID(id string) *WorkbookTableRowRequestBuilder { 4761 bb := &WorkbookTableRowRequestBuilder{BaseRequestBuilder: b.BaseRequestBuilder} 4762 bb.baseURL += "/" + id 4763 return bb 4764 } 4765 4766 // WorkbookTableRowsCollectionRequest is request for WorkbookTableRow collection 4767 type WorkbookTableRowsCollectionRequest struct{ BaseRequest } 4768 4769 // Paging perfoms paging operation for WorkbookTableRow collection 4770 func (r *WorkbookTableRowsCollectionRequest) Paging(ctx context.Context, method, path string, obj interface{}, n int) ([]WorkbookTableRow, error) { 4771 req, err := r.NewJSONRequest(method, path, obj) 4772 if err != nil { 4773 return nil, err 4774 } 4775 if ctx != nil { 4776 req = req.WithContext(ctx) 4777 } 4778 res, err := r.client.Do(req) 4779 if err != nil { 4780 return nil, err 4781 } 4782 var values []WorkbookTableRow 4783 for { 4784 if res.StatusCode != http.StatusOK { 4785 b, _ := ioutil.ReadAll(res.Body) 4786 res.Body.Close() 4787 errRes := &ErrorResponse{Response: res} 4788 err := jsonx.Unmarshal(b, errRes) 4789 if err != nil { 4790 return nil, fmt.Errorf("%s: %s", res.Status, string(b)) 4791 } 4792 return nil, errRes 4793 } 4794 var ( 4795 paging Paging 4796 value []WorkbookTableRow 4797 ) 4798 err := jsonx.NewDecoder(res.Body).Decode(&paging) 4799 res.Body.Close() 4800 if err != nil { 4801 return nil, err 4802 } 4803 err = jsonx.Unmarshal(paging.Value, &value) 4804 if err != nil { 4805 return nil, err 4806 } 4807 values = append(values, value...) 4808 if n >= 0 { 4809 n-- 4810 } 4811 if n == 0 || len(paging.NextLink) == 0 { 4812 return values, nil 4813 } 4814 req, err = http.NewRequest("GET", paging.NextLink, nil) 4815 if ctx != nil { 4816 req = req.WithContext(ctx) 4817 } 4818 res, err = r.client.Do(req) 4819 if err != nil { 4820 return nil, err 4821 } 4822 } 4823 } 4824 4825 // GetN performs GET request for WorkbookTableRow collection, max N pages 4826 func (r *WorkbookTableRowsCollectionRequest) GetN(ctx context.Context, n int) ([]WorkbookTableRow, error) { 4827 var query string 4828 if r.query != nil { 4829 query = "?" + r.query.Encode() 4830 } 4831 return r.Paging(ctx, "GET", query, nil, n) 4832 } 4833 4834 // Get performs GET request for WorkbookTableRow collection 4835 func (r *WorkbookTableRowsCollectionRequest) Get(ctx context.Context) ([]WorkbookTableRow, error) { 4836 return r.GetN(ctx, 0) 4837 } 4838 4839 // Add performs POST request for WorkbookTableRow collection 4840 func (r *WorkbookTableRowsCollectionRequest) Add(ctx context.Context, reqObj *WorkbookTableRow) (resObj *WorkbookTableRow, err error) { 4841 err = r.JSONRequest(ctx, "POST", "", reqObj, &resObj) 4842 return 4843 } 4844 4845 // Sort is navigation property 4846 func (b *WorkbookTableRequestBuilder) Sort() *WorkbookTableSortRequestBuilder { 4847 bb := &WorkbookTableSortRequestBuilder{BaseRequestBuilder: b.BaseRequestBuilder} 4848 bb.baseURL += "/sort" 4849 return bb 4850 } 4851 4852 // Worksheet is navigation property 4853 func (b *WorkbookTableRequestBuilder) Worksheet() *WorkbookWorksheetRequestBuilder { 4854 bb := &WorkbookWorksheetRequestBuilder{BaseRequestBuilder: b.BaseRequestBuilder} 4855 bb.baseURL += "/worksheet" 4856 return bb 4857 } 4858 4859 // Filter is navigation property 4860 func (b *WorkbookTableColumnRequestBuilder) Filter() *WorkbookFilterRequestBuilder { 4861 bb := &WorkbookFilterRequestBuilder{BaseRequestBuilder: b.BaseRequestBuilder} 4862 bb.baseURL += "/filter" 4863 return bb 4864 } 4865 4866 // Charts returns request builder for WorkbookChart collection 4867 func (b *WorkbookWorksheetRequestBuilder) Charts() *WorkbookWorksheetChartsCollectionRequestBuilder { 4868 bb := &WorkbookWorksheetChartsCollectionRequestBuilder{BaseRequestBuilder: b.BaseRequestBuilder} 4869 bb.baseURL += "/charts" 4870 return bb 4871 } 4872 4873 // WorkbookWorksheetChartsCollectionRequestBuilder is request builder for WorkbookChart collection 4874 type WorkbookWorksheetChartsCollectionRequestBuilder struct{ BaseRequestBuilder } 4875 4876 // Request returns request for WorkbookChart collection 4877 func (b *WorkbookWorksheetChartsCollectionRequestBuilder) Request() *WorkbookWorksheetChartsCollectionRequest { 4878 return &WorkbookWorksheetChartsCollectionRequest{ 4879 BaseRequest: BaseRequest{baseURL: b.baseURL, client: b.client}, 4880 } 4881 } 4882 4883 // ID returns request builder for WorkbookChart item 4884 func (b *WorkbookWorksheetChartsCollectionRequestBuilder) ID(id string) *WorkbookChartRequestBuilder { 4885 bb := &WorkbookChartRequestBuilder{BaseRequestBuilder: b.BaseRequestBuilder} 4886 bb.baseURL += "/" + id 4887 return bb 4888 } 4889 4890 // WorkbookWorksheetChartsCollectionRequest is request for WorkbookChart collection 4891 type WorkbookWorksheetChartsCollectionRequest struct{ BaseRequest } 4892 4893 // Paging perfoms paging operation for WorkbookChart collection 4894 func (r *WorkbookWorksheetChartsCollectionRequest) Paging(ctx context.Context, method, path string, obj interface{}, n int) ([]WorkbookChart, error) { 4895 req, err := r.NewJSONRequest(method, path, obj) 4896 if err != nil { 4897 return nil, err 4898 } 4899 if ctx != nil { 4900 req = req.WithContext(ctx) 4901 } 4902 res, err := r.client.Do(req) 4903 if err != nil { 4904 return nil, err 4905 } 4906 var values []WorkbookChart 4907 for { 4908 if res.StatusCode != http.StatusOK { 4909 b, _ := ioutil.ReadAll(res.Body) 4910 res.Body.Close() 4911 errRes := &ErrorResponse{Response: res} 4912 err := jsonx.Unmarshal(b, errRes) 4913 if err != nil { 4914 return nil, fmt.Errorf("%s: %s", res.Status, string(b)) 4915 } 4916 return nil, errRes 4917 } 4918 var ( 4919 paging Paging 4920 value []WorkbookChart 4921 ) 4922 err := jsonx.NewDecoder(res.Body).Decode(&paging) 4923 res.Body.Close() 4924 if err != nil { 4925 return nil, err 4926 } 4927 err = jsonx.Unmarshal(paging.Value, &value) 4928 if err != nil { 4929 return nil, err 4930 } 4931 values = append(values, value...) 4932 if n >= 0 { 4933 n-- 4934 } 4935 if n == 0 || len(paging.NextLink) == 0 { 4936 return values, nil 4937 } 4938 req, err = http.NewRequest("GET", paging.NextLink, nil) 4939 if ctx != nil { 4940 req = req.WithContext(ctx) 4941 } 4942 res, err = r.client.Do(req) 4943 if err != nil { 4944 return nil, err 4945 } 4946 } 4947 } 4948 4949 // GetN performs GET request for WorkbookChart collection, max N pages 4950 func (r *WorkbookWorksheetChartsCollectionRequest) GetN(ctx context.Context, n int) ([]WorkbookChart, error) { 4951 var query string 4952 if r.query != nil { 4953 query = "?" + r.query.Encode() 4954 } 4955 return r.Paging(ctx, "GET", query, nil, n) 4956 } 4957 4958 // Get performs GET request for WorkbookChart collection 4959 func (r *WorkbookWorksheetChartsCollectionRequest) Get(ctx context.Context) ([]WorkbookChart, error) { 4960 return r.GetN(ctx, 0) 4961 } 4962 4963 // Add performs POST request for WorkbookChart collection 4964 func (r *WorkbookWorksheetChartsCollectionRequest) Add(ctx context.Context, reqObj *WorkbookChart) (resObj *WorkbookChart, err error) { 4965 err = r.JSONRequest(ctx, "POST", "", reqObj, &resObj) 4966 return 4967 } 4968 4969 // Names returns request builder for WorkbookNamedItem collection 4970 func (b *WorkbookWorksheetRequestBuilder) Names() *WorkbookWorksheetNamesCollectionRequestBuilder { 4971 bb := &WorkbookWorksheetNamesCollectionRequestBuilder{BaseRequestBuilder: b.BaseRequestBuilder} 4972 bb.baseURL += "/names" 4973 return bb 4974 } 4975 4976 // WorkbookWorksheetNamesCollectionRequestBuilder is request builder for WorkbookNamedItem collection 4977 type WorkbookWorksheetNamesCollectionRequestBuilder struct{ BaseRequestBuilder } 4978 4979 // Request returns request for WorkbookNamedItem collection 4980 func (b *WorkbookWorksheetNamesCollectionRequestBuilder) Request() *WorkbookWorksheetNamesCollectionRequest { 4981 return &WorkbookWorksheetNamesCollectionRequest{ 4982 BaseRequest: BaseRequest{baseURL: b.baseURL, client: b.client}, 4983 } 4984 } 4985 4986 // ID returns request builder for WorkbookNamedItem item 4987 func (b *WorkbookWorksheetNamesCollectionRequestBuilder) ID(id string) *WorkbookNamedItemRequestBuilder { 4988 bb := &WorkbookNamedItemRequestBuilder{BaseRequestBuilder: b.BaseRequestBuilder} 4989 bb.baseURL += "/" + id 4990 return bb 4991 } 4992 4993 // WorkbookWorksheetNamesCollectionRequest is request for WorkbookNamedItem collection 4994 type WorkbookWorksheetNamesCollectionRequest struct{ BaseRequest } 4995 4996 // Paging perfoms paging operation for WorkbookNamedItem collection 4997 func (r *WorkbookWorksheetNamesCollectionRequest) Paging(ctx context.Context, method, path string, obj interface{}, n int) ([]WorkbookNamedItem, error) { 4998 req, err := r.NewJSONRequest(method, path, obj) 4999 if err != nil { 5000 return nil, err 5001 } 5002 if ctx != nil { 5003 req = req.WithContext(ctx) 5004 } 5005 res, err := r.client.Do(req) 5006 if err != nil { 5007 return nil, err 5008 } 5009 var values []WorkbookNamedItem 5010 for { 5011 if res.StatusCode != http.StatusOK { 5012 b, _ := ioutil.ReadAll(res.Body) 5013 res.Body.Close() 5014 errRes := &ErrorResponse{Response: res} 5015 err := jsonx.Unmarshal(b, errRes) 5016 if err != nil { 5017 return nil, fmt.Errorf("%s: %s", res.Status, string(b)) 5018 } 5019 return nil, errRes 5020 } 5021 var ( 5022 paging Paging 5023 value []WorkbookNamedItem 5024 ) 5025 err := jsonx.NewDecoder(res.Body).Decode(&paging) 5026 res.Body.Close() 5027 if err != nil { 5028 return nil, err 5029 } 5030 err = jsonx.Unmarshal(paging.Value, &value) 5031 if err != nil { 5032 return nil, err 5033 } 5034 values = append(values, value...) 5035 if n >= 0 { 5036 n-- 5037 } 5038 if n == 0 || len(paging.NextLink) == 0 { 5039 return values, nil 5040 } 5041 req, err = http.NewRequest("GET", paging.NextLink, nil) 5042 if ctx != nil { 5043 req = req.WithContext(ctx) 5044 } 5045 res, err = r.client.Do(req) 5046 if err != nil { 5047 return nil, err 5048 } 5049 } 5050 } 5051 5052 // GetN performs GET request for WorkbookNamedItem collection, max N pages 5053 func (r *WorkbookWorksheetNamesCollectionRequest) GetN(ctx context.Context, n int) ([]WorkbookNamedItem, error) { 5054 var query string 5055 if r.query != nil { 5056 query = "?" + r.query.Encode() 5057 } 5058 return r.Paging(ctx, "GET", query, nil, n) 5059 } 5060 5061 // Get performs GET request for WorkbookNamedItem collection 5062 func (r *WorkbookWorksheetNamesCollectionRequest) Get(ctx context.Context) ([]WorkbookNamedItem, error) { 5063 return r.GetN(ctx, 0) 5064 } 5065 5066 // Add performs POST request for WorkbookNamedItem collection 5067 func (r *WorkbookWorksheetNamesCollectionRequest) Add(ctx context.Context, reqObj *WorkbookNamedItem) (resObj *WorkbookNamedItem, err error) { 5068 err = r.JSONRequest(ctx, "POST", "", reqObj, &resObj) 5069 return 5070 } 5071 5072 // PivotTables returns request builder for WorkbookPivotTable collection 5073 func (b *WorkbookWorksheetRequestBuilder) PivotTables() *WorkbookWorksheetPivotTablesCollectionRequestBuilder { 5074 bb := &WorkbookWorksheetPivotTablesCollectionRequestBuilder{BaseRequestBuilder: b.BaseRequestBuilder} 5075 bb.baseURL += "/pivotTables" 5076 return bb 5077 } 5078 5079 // WorkbookWorksheetPivotTablesCollectionRequestBuilder is request builder for WorkbookPivotTable collection 5080 type WorkbookWorksheetPivotTablesCollectionRequestBuilder struct{ BaseRequestBuilder } 5081 5082 // Request returns request for WorkbookPivotTable collection 5083 func (b *WorkbookWorksheetPivotTablesCollectionRequestBuilder) Request() *WorkbookWorksheetPivotTablesCollectionRequest { 5084 return &WorkbookWorksheetPivotTablesCollectionRequest{ 5085 BaseRequest: BaseRequest{baseURL: b.baseURL, client: b.client}, 5086 } 5087 } 5088 5089 // ID returns request builder for WorkbookPivotTable item 5090 func (b *WorkbookWorksheetPivotTablesCollectionRequestBuilder) ID(id string) *WorkbookPivotTableRequestBuilder { 5091 bb := &WorkbookPivotTableRequestBuilder{BaseRequestBuilder: b.BaseRequestBuilder} 5092 bb.baseURL += "/" + id 5093 return bb 5094 } 5095 5096 // WorkbookWorksheetPivotTablesCollectionRequest is request for WorkbookPivotTable collection 5097 type WorkbookWorksheetPivotTablesCollectionRequest struct{ BaseRequest } 5098 5099 // Paging perfoms paging operation for WorkbookPivotTable collection 5100 func (r *WorkbookWorksheetPivotTablesCollectionRequest) Paging(ctx context.Context, method, path string, obj interface{}, n int) ([]WorkbookPivotTable, error) { 5101 req, err := r.NewJSONRequest(method, path, obj) 5102 if err != nil { 5103 return nil, err 5104 } 5105 if ctx != nil { 5106 req = req.WithContext(ctx) 5107 } 5108 res, err := r.client.Do(req) 5109 if err != nil { 5110 return nil, err 5111 } 5112 var values []WorkbookPivotTable 5113 for { 5114 if res.StatusCode != http.StatusOK { 5115 b, _ := ioutil.ReadAll(res.Body) 5116 res.Body.Close() 5117 errRes := &ErrorResponse{Response: res} 5118 err := jsonx.Unmarshal(b, errRes) 5119 if err != nil { 5120 return nil, fmt.Errorf("%s: %s", res.Status, string(b)) 5121 } 5122 return nil, errRes 5123 } 5124 var ( 5125 paging Paging 5126 value []WorkbookPivotTable 5127 ) 5128 err := jsonx.NewDecoder(res.Body).Decode(&paging) 5129 res.Body.Close() 5130 if err != nil { 5131 return nil, err 5132 } 5133 err = jsonx.Unmarshal(paging.Value, &value) 5134 if err != nil { 5135 return nil, err 5136 } 5137 values = append(values, value...) 5138 if n >= 0 { 5139 n-- 5140 } 5141 if n == 0 || len(paging.NextLink) == 0 { 5142 return values, nil 5143 } 5144 req, err = http.NewRequest("GET", paging.NextLink, nil) 5145 if ctx != nil { 5146 req = req.WithContext(ctx) 5147 } 5148 res, err = r.client.Do(req) 5149 if err != nil { 5150 return nil, err 5151 } 5152 } 5153 } 5154 5155 // GetN performs GET request for WorkbookPivotTable collection, max N pages 5156 func (r *WorkbookWorksheetPivotTablesCollectionRequest) GetN(ctx context.Context, n int) ([]WorkbookPivotTable, error) { 5157 var query string 5158 if r.query != nil { 5159 query = "?" + r.query.Encode() 5160 } 5161 return r.Paging(ctx, "GET", query, nil, n) 5162 } 5163 5164 // Get performs GET request for WorkbookPivotTable collection 5165 func (r *WorkbookWorksheetPivotTablesCollectionRequest) Get(ctx context.Context) ([]WorkbookPivotTable, error) { 5166 return r.GetN(ctx, 0) 5167 } 5168 5169 // Add performs POST request for WorkbookPivotTable collection 5170 func (r *WorkbookWorksheetPivotTablesCollectionRequest) Add(ctx context.Context, reqObj *WorkbookPivotTable) (resObj *WorkbookPivotTable, err error) { 5171 err = r.JSONRequest(ctx, "POST", "", reqObj, &resObj) 5172 return 5173 } 5174 5175 // Protection is navigation property 5176 func (b *WorkbookWorksheetRequestBuilder) Protection() *WorkbookWorksheetProtectionRequestBuilder { 5177 bb := &WorkbookWorksheetProtectionRequestBuilder{BaseRequestBuilder: b.BaseRequestBuilder} 5178 bb.baseURL += "/protection" 5179 return bb 5180 } 5181 5182 // Tables returns request builder for WorkbookTable collection 5183 func (b *WorkbookWorksheetRequestBuilder) Tables() *WorkbookWorksheetTablesCollectionRequestBuilder { 5184 bb := &WorkbookWorksheetTablesCollectionRequestBuilder{BaseRequestBuilder: b.BaseRequestBuilder} 5185 bb.baseURL += "/tables" 5186 return bb 5187 } 5188 5189 // WorkbookWorksheetTablesCollectionRequestBuilder is request builder for WorkbookTable collection 5190 type WorkbookWorksheetTablesCollectionRequestBuilder struct{ BaseRequestBuilder } 5191 5192 // Request returns request for WorkbookTable collection 5193 func (b *WorkbookWorksheetTablesCollectionRequestBuilder) Request() *WorkbookWorksheetTablesCollectionRequest { 5194 return &WorkbookWorksheetTablesCollectionRequest{ 5195 BaseRequest: BaseRequest{baseURL: b.baseURL, client: b.client}, 5196 } 5197 } 5198 5199 // ID returns request builder for WorkbookTable item 5200 func (b *WorkbookWorksheetTablesCollectionRequestBuilder) ID(id string) *WorkbookTableRequestBuilder { 5201 bb := &WorkbookTableRequestBuilder{BaseRequestBuilder: b.BaseRequestBuilder} 5202 bb.baseURL += "/" + id 5203 return bb 5204 } 5205 5206 // WorkbookWorksheetTablesCollectionRequest is request for WorkbookTable collection 5207 type WorkbookWorksheetTablesCollectionRequest struct{ BaseRequest } 5208 5209 // Paging perfoms paging operation for WorkbookTable collection 5210 func (r *WorkbookWorksheetTablesCollectionRequest) Paging(ctx context.Context, method, path string, obj interface{}, n int) ([]WorkbookTable, error) { 5211 req, err := r.NewJSONRequest(method, path, obj) 5212 if err != nil { 5213 return nil, err 5214 } 5215 if ctx != nil { 5216 req = req.WithContext(ctx) 5217 } 5218 res, err := r.client.Do(req) 5219 if err != nil { 5220 return nil, err 5221 } 5222 var values []WorkbookTable 5223 for { 5224 if res.StatusCode != http.StatusOK { 5225 b, _ := ioutil.ReadAll(res.Body) 5226 res.Body.Close() 5227 errRes := &ErrorResponse{Response: res} 5228 err := jsonx.Unmarshal(b, errRes) 5229 if err != nil { 5230 return nil, fmt.Errorf("%s: %s", res.Status, string(b)) 5231 } 5232 return nil, errRes 5233 } 5234 var ( 5235 paging Paging 5236 value []WorkbookTable 5237 ) 5238 err := jsonx.NewDecoder(res.Body).Decode(&paging) 5239 res.Body.Close() 5240 if err != nil { 5241 return nil, err 5242 } 5243 err = jsonx.Unmarshal(paging.Value, &value) 5244 if err != nil { 5245 return nil, err 5246 } 5247 values = append(values, value...) 5248 if n >= 0 { 5249 n-- 5250 } 5251 if n == 0 || len(paging.NextLink) == 0 { 5252 return values, nil 5253 } 5254 req, err = http.NewRequest("GET", paging.NextLink, nil) 5255 if ctx != nil { 5256 req = req.WithContext(ctx) 5257 } 5258 res, err = r.client.Do(req) 5259 if err != nil { 5260 return nil, err 5261 } 5262 } 5263 } 5264 5265 // GetN performs GET request for WorkbookTable collection, max N pages 5266 func (r *WorkbookWorksheetTablesCollectionRequest) GetN(ctx context.Context, n int) ([]WorkbookTable, error) { 5267 var query string 5268 if r.query != nil { 5269 query = "?" + r.query.Encode() 5270 } 5271 return r.Paging(ctx, "GET", query, nil, n) 5272 } 5273 5274 // Get performs GET request for WorkbookTable collection 5275 func (r *WorkbookWorksheetTablesCollectionRequest) Get(ctx context.Context) ([]WorkbookTable, error) { 5276 return r.GetN(ctx, 0) 5277 } 5278 5279 // Add performs POST request for WorkbookTable collection 5280 func (r *WorkbookWorksheetTablesCollectionRequest) Add(ctx context.Context, reqObj *WorkbookTable) (resObj *WorkbookTable, err error) { 5281 err = r.JSONRequest(ctx, "POST", "", reqObj, &resObj) 5282 return 5283 }