1// Code generated by msgraph.go/gen DO NOT EDIT. 2 3package msgraph 4 5import ( 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 16type 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 26type 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 36type 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 46type WorkbookPivotTableCollectionRefreshAllRequestParameter struct { 47} 48 49// WorkbookTableCollectionAddRequestParameter undocumented 50type 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 58type 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 68type 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 76type WorkbookWorksheetCollectionAddRequestParameter struct { 77 // Name undocumented 78 Name *string `json:"name,omitempty"` 79} 80 81// WorkbookCreateSessionRequestParameter undocumented 82type WorkbookCreateSessionRequestParameter struct { 83 // PersistChanges undocumented 84 PersistChanges *bool `json:"persistChanges,omitempty"` 85} 86 87// WorkbookCloseSessionRequestParameter undocumented 88type WorkbookCloseSessionRequestParameter struct { 89} 90 91// WorkbookRefreshSessionRequestParameter undocumented 92type WorkbookRefreshSessionRequestParameter struct { 93} 94 95// WorkbookApplicationCalculateRequestParameter undocumented 96type WorkbookApplicationCalculateRequestParameter struct { 97 // CalculationType undocumented 98 CalculationType *string `json:"calculationType,omitempty"` 99} 100 101// WorkbookChartSetDataRequestParameter undocumented 102type 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 110type 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 118type WorkbookChartFillClearRequestParameter struct { 119} 120 121// WorkbookChartFillSetSolidColorRequestParameter undocumented 122type WorkbookChartFillSetSolidColorRequestParameter struct { 123 // Color undocumented 124 Color *string `json:"color,omitempty"` 125} 126 127// WorkbookChartLineFormatClearRequestParameter undocumented 128type WorkbookChartLineFormatClearRequestParameter struct { 129} 130 131// WorkbookFilterApplyRequestParameter undocumented 132type WorkbookFilterApplyRequestParameter struct { 133 // Criteria undocumented 134 Criteria *WorkbookFilterCriteria `json:"criteria,omitempty"` 135} 136 137// WorkbookFilterApplyBottomItemsFilterRequestParameter undocumented 138type WorkbookFilterApplyBottomItemsFilterRequestParameter struct { 139 // Count undocumented 140 Count *int `json:"count,omitempty"` 141} 142 143// WorkbookFilterApplyBottomPercentFilterRequestParameter undocumented 144type WorkbookFilterApplyBottomPercentFilterRequestParameter struct { 145 // Percent undocumented 146 Percent *int `json:"percent,omitempty"` 147} 148 149// WorkbookFilterApplyCellColorFilterRequestParameter undocumented 150type WorkbookFilterApplyCellColorFilterRequestParameter struct { 151 // Color undocumented 152 Color *string `json:"color,omitempty"` 153} 154 155// WorkbookFilterApplyCustomFilterRequestParameter undocumented 156type 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 166type WorkbookFilterApplyDynamicFilterRequestParameter struct { 167 // Criteria undocumented 168 Criteria *string `json:"criteria,omitempty"` 169} 170 171// WorkbookFilterApplyFontColorFilterRequestParameter undocumented 172type WorkbookFilterApplyFontColorFilterRequestParameter struct { 173 // Color undocumented 174 Color *string `json:"color,omitempty"` 175} 176 177// WorkbookFilterApplyIconFilterRequestParameter undocumented 178type WorkbookFilterApplyIconFilterRequestParameter struct { 179 // Icon undocumented 180 Icon *WorkbookIcon `json:"icon,omitempty"` 181} 182 183// WorkbookFilterApplyTopItemsFilterRequestParameter undocumented 184type WorkbookFilterApplyTopItemsFilterRequestParameter struct { 185 // Count undocumented 186 Count *int `json:"count,omitempty"` 187} 188 189// WorkbookFilterApplyTopPercentFilterRequestParameter undocumented 190type WorkbookFilterApplyTopPercentFilterRequestParameter struct { 191 // Percent undocumented 192 Percent *int `json:"percent,omitempty"` 193} 194 195// WorkbookFilterApplyValuesFilterRequestParameter undocumented 196type WorkbookFilterApplyValuesFilterRequestParameter struct { 197 // Values undocumented 198 Values json.RawMessage `json:"values,omitempty"` 199} 200 201// WorkbookFilterClearRequestParameter undocumented 202type WorkbookFilterClearRequestParameter struct { 203} 204 205// WorkbookFunctionsAbsRequestParameter undocumented 206type WorkbookFunctionsAbsRequestParameter struct { 207 // Number undocumented 208 Number json.RawMessage `json:"number,omitempty"` 209} 210 211// WorkbookFunctionsAccrIntRequestParameter undocumented 212type 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 232type 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 246type WorkbookFunctionsAcosRequestParameter struct { 247 // Number undocumented 248 Number json.RawMessage `json:"number,omitempty"` 249} 250 251// WorkbookFunctionsAcoshRequestParameter undocumented 252type WorkbookFunctionsAcoshRequestParameter struct { 253 // Number undocumented 254 Number json.RawMessage `json:"number,omitempty"` 255} 256 257// WorkbookFunctionsAcotRequestParameter undocumented 258type WorkbookFunctionsAcotRequestParameter struct { 259 // Number undocumented 260 Number json.RawMessage `json:"number,omitempty"` 261} 262 263// WorkbookFunctionsAcothRequestParameter undocumented 264type WorkbookFunctionsAcothRequestParameter struct { 265 // Number undocumented 266 Number json.RawMessage `json:"number,omitempty"` 267} 268 269// WorkbookFunctionsAmorDegrcRequestParameter undocumented 270type 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 288type 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 306type WorkbookFunctionsAndRequestParameter struct { 307 // Values undocumented 308 Values json.RawMessage `json:"values,omitempty"` 309} 310 311// WorkbookFunctionsArabicRequestParameter undocumented 312type WorkbookFunctionsArabicRequestParameter struct { 313 // Text undocumented 314 Text json.RawMessage `json:"text,omitempty"` 315} 316 317// WorkbookFunctionsAreasRequestParameter undocumented 318type WorkbookFunctionsAreasRequestParameter struct { 319 // Reference undocumented 320 Reference json.RawMessage `json:"reference,omitempty"` 321} 322 323// WorkbookFunctionsAscRequestParameter undocumented 324type WorkbookFunctionsAscRequestParameter struct { 325 // Text undocumented 326 Text json.RawMessage `json:"text,omitempty"` 327} 328 329// WorkbookFunctionsAsinRequestParameter undocumented 330type WorkbookFunctionsAsinRequestParameter struct { 331 // Number undocumented 332 Number json.RawMessage `json:"number,omitempty"` 333} 334 335// WorkbookFunctionsAsinhRequestParameter undocumented 336type WorkbookFunctionsAsinhRequestParameter struct { 337 // Number undocumented 338 Number json.RawMessage `json:"number,omitempty"` 339} 340 341// WorkbookFunctionsAtanRequestParameter undocumented 342type WorkbookFunctionsAtanRequestParameter struct { 343 // Number undocumented 344 Number json.RawMessage `json:"number,omitempty"` 345} 346 347// WorkbookFunctionsAtan2RequestParameter undocumented 348type 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 356type WorkbookFunctionsAtanhRequestParameter struct { 357 // Number undocumented 358 Number json.RawMessage `json:"number,omitempty"` 359} 360 361// WorkbookFunctionsAveDevRequestParameter undocumented 362type WorkbookFunctionsAveDevRequestParameter struct { 363 // Values undocumented 364 Values json.RawMessage `json:"values,omitempty"` 365} 366 367// WorkbookFunctionsAverageRequestParameter undocumented 368type WorkbookFunctionsAverageRequestParameter struct { 369 // Values undocumented 370 Values json.RawMessage `json:"values,omitempty"` 371} 372 373// WorkbookFunctionsAverageARequestParameter undocumented 374type WorkbookFunctionsAverageARequestParameter struct { 375 // Values undocumented 376 Values json.RawMessage `json:"values,omitempty"` 377} 378 379// WorkbookFunctionsAverageIfRequestParameter undocumented 380type 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 390type 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 398type WorkbookFunctionsBahtTextRequestParameter struct { 399 // Number undocumented 400 Number json.RawMessage `json:"number,omitempty"` 401} 402 403// WorkbookFunctionsBaseRequestParameter undocumented 404type 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 414type 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 422type 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 430type 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 438type 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 446type 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 462type 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 476type WorkbookFunctionsBin2DecRequestParameter struct { 477 // Number undocumented 478 Number json.RawMessage `json:"number,omitempty"` 479} 480 481// WorkbookFunctionsBin2HexRequestParameter undocumented 482type 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 490type 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 498type 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 510type 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 522type 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 532type 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 540type 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 548type 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 556type 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 564type 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 572type 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 582type 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 590type WorkbookFunctionsCharRequestParameter struct { 591 // Number undocumented 592 Number json.RawMessage `json:"number,omitempty"` 593} 594 595// WorkbookFunctionsChiSq_DistRequestParameter undocumented 596type 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 606type 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 614type 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 622type 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 630type 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 638type WorkbookFunctionsCleanRequestParameter struct { 639 // Text undocumented 640 Text json.RawMessage `json:"text,omitempty"` 641} 642 643// WorkbookFunctionsCodeRequestParameter undocumented 644type WorkbookFunctionsCodeRequestParameter struct { 645 // Text undocumented 646 Text json.RawMessage `json:"text,omitempty"` 647} 648 649// WorkbookFunctionsColumnsRequestParameter undocumented 650type WorkbookFunctionsColumnsRequestParameter struct { 651 // Array undocumented 652 Array json.RawMessage `json:"array,omitempty"` 653} 654 655// WorkbookFunctionsCombinRequestParameter undocumented 656type 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 664type 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 672type 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 682type WorkbookFunctionsConcatenateRequestParameter struct { 683 // Values undocumented 684 Values json.RawMessage `json:"values,omitempty"` 685} 686 687// WorkbookFunctionsConfidence_NormRequestParameter undocumented 688type 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 698type 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 708type 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 718type WorkbookFunctionsCosRequestParameter struct { 719 // Number undocumented 720 Number json.RawMessage `json:"number,omitempty"` 721} 722 723// WorkbookFunctionsCoshRequestParameter undocumented 724type WorkbookFunctionsCoshRequestParameter struct { 725 // Number undocumented 726 Number json.RawMessage `json:"number,omitempty"` 727} 728 729// WorkbookFunctionsCotRequestParameter undocumented 730type WorkbookFunctionsCotRequestParameter struct { 731 // Number undocumented 732 Number json.RawMessage `json:"number,omitempty"` 733} 734 735// WorkbookFunctionsCothRequestParameter undocumented 736type WorkbookFunctionsCothRequestParameter struct { 737 // Number undocumented 738 Number json.RawMessage `json:"number,omitempty"` 739} 740 741// WorkbookFunctionsCountRequestParameter undocumented 742type WorkbookFunctionsCountRequestParameter struct { 743 // Values undocumented 744 Values json.RawMessage `json:"values,omitempty"` 745} 746 747// WorkbookFunctionsCountARequestParameter undocumented 748type WorkbookFunctionsCountARequestParameter struct { 749 // Values undocumented 750 Values json.RawMessage `json:"values,omitempty"` 751} 752 753// WorkbookFunctionsCountBlankRequestParameter undocumented 754type WorkbookFunctionsCountBlankRequestParameter struct { 755 // Range undocumented 756 Range json.RawMessage `json:"range,omitempty"` 757} 758 759// WorkbookFunctionsCountIfRequestParameter undocumented 760type 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 768type WorkbookFunctionsCountIfsRequestParameter struct { 769 // Values undocumented 770 Values json.RawMessage `json:"values,omitempty"` 771} 772 773// WorkbookFunctionsCoupDayBsRequestParameter undocumented 774type 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 786type 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 798type 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 810type 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 822type 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 834type 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 846type WorkbookFunctionsCscRequestParameter struct { 847 // Number undocumented 848 Number json.RawMessage `json:"number,omitempty"` 849} 850 851// WorkbookFunctionsCschRequestParameter undocumented 852type WorkbookFunctionsCschRequestParameter struct { 853 // Number undocumented 854 Number json.RawMessage `json:"number,omitempty"` 855} 856 857// WorkbookFunctionsCumIPmtRequestParameter undocumented 858type 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 874type 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 890type 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 900type 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 910type 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 920type 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 930type 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 940type 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 950type 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 960type 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 970type 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 980type 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 990type 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 1000type 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 1010type 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 1020type WorkbookFunctionsDatevalueRequestParameter struct { 1021 // DateText undocumented 1022 DateText json.RawMessage `json:"dateText,omitempty"` 1023} 1024 1025// WorkbookFunctionsDayRequestParameter undocumented 1026type WorkbookFunctionsDayRequestParameter struct { 1027 // SerialNumber undocumented 1028 SerialNumber json.RawMessage `json:"serialNumber,omitempty"` 1029} 1030 1031// WorkbookFunctionsDaysRequestParameter undocumented 1032type 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 1040type 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 1050type 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 1064type WorkbookFunctionsDbcsRequestParameter struct { 1065 // Text undocumented 1066 Text json.RawMessage `json:"text,omitempty"` 1067} 1068 1069// WorkbookFunctionsDdbRequestParameter undocumented 1070type 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 1084type 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 1092type 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 1100type 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 1108type 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 1116type WorkbookFunctionsDegreesRequestParameter struct { 1117 // Angle undocumented 1118 Angle json.RawMessage `json:"angle,omitempty"` 1119} 1120 1121// WorkbookFunctionsDeltaRequestParameter undocumented 1122type 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 1130type WorkbookFunctionsDevSqRequestParameter struct { 1131 // Values undocumented 1132 Values json.RawMessage `json:"values,omitempty"` 1133} 1134 1135// WorkbookFunctionsDiscRequestParameter undocumented 1136type 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 1150type 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 1158type 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 1166type 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 1174type 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 1190type 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 1198type 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 1206type 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 1214type 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 1222type 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 1230type WorkbookFunctionsErfCRequestParameter struct { 1231 // X undocumented 1232 X json.RawMessage `json:"x,omitempty"` 1233} 1234 1235// WorkbookFunctionsErfC_PreciseRequestParameter undocumented 1236type WorkbookFunctionsErfC_PreciseRequestParameter struct { 1237 // X undocumented 1238 X json.RawMessage `json:"X,omitempty"` 1239} 1240 1241// WorkbookFunctionsErf_PreciseRequestParameter undocumented 1242type WorkbookFunctionsErf_PreciseRequestParameter struct { 1243 // X undocumented 1244 X json.RawMessage `json:"X,omitempty"` 1245} 1246 1247// WorkbookFunctionsError_TypeRequestParameter undocumented 1248type WorkbookFunctionsError_TypeRequestParameter struct { 1249 // ErrorVal undocumented 1250 ErrorVal json.RawMessage `json:"errorVal,omitempty"` 1251} 1252 1253// WorkbookFunctionsEvenRequestParameter undocumented 1254type WorkbookFunctionsEvenRequestParameter struct { 1255 // Number undocumented 1256 Number json.RawMessage `json:"number,omitempty"` 1257} 1258 1259// WorkbookFunctionsExactRequestParameter undocumented 1260type 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 1268type WorkbookFunctionsExpRequestParameter struct { 1269 // Number undocumented 1270 Number json.RawMessage `json:"number,omitempty"` 1271} 1272 1273// WorkbookFunctionsExpon_DistRequestParameter undocumented 1274type 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 1284type 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 1292type 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 1304type 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 1314type 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 1324type 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 1334type WorkbookFunctionsFactRequestParameter struct { 1335 // Number undocumented 1336 Number json.RawMessage `json:"number,omitempty"` 1337} 1338 1339// WorkbookFunctionsFactDoubleRequestParameter undocumented 1340type WorkbookFunctionsFactDoubleRequestParameter struct { 1341 // Number undocumented 1342 Number json.RawMessage `json:"number,omitempty"` 1343} 1344 1345// WorkbookFunctionsFalseRequestParameter undocumented 1346type WorkbookFunctionsFalseRequestParameter struct { 1347} 1348 1349// WorkbookFunctionsFindRequestParameter undocumented 1350type 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 1360type 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 1370type WorkbookFunctionsFisherRequestParameter struct { 1371 // X undocumented 1372 X json.RawMessage `json:"x,omitempty"` 1373} 1374 1375// WorkbookFunctionsFisherInvRequestParameter undocumented 1376type WorkbookFunctionsFisherInvRequestParameter struct { 1377 // Y undocumented 1378 Y json.RawMessage `json:"y,omitempty"` 1379} 1380 1381// WorkbookFunctionsFixedRequestParameter undocumented 1382type 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 1392type 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 1402type 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 1410type 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 1424type WorkbookFunctionsGammaRequestParameter struct { 1425 // X undocumented 1426 X json.RawMessage `json:"x,omitempty"` 1427} 1428 1429// WorkbookFunctionsGammaLnRequestParameter undocumented 1430type WorkbookFunctionsGammaLnRequestParameter struct { 1431 // X undocumented 1432 X json.RawMessage `json:"x,omitempty"` 1433} 1434 1435// WorkbookFunctionsGammaLn_PreciseRequestParameter undocumented 1436type WorkbookFunctionsGammaLn_PreciseRequestParameter struct { 1437 // X undocumented 1438 X json.RawMessage `json:"x,omitempty"` 1439} 1440 1441// WorkbookFunctionsGamma_DistRequestParameter undocumented 1442type 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 1454type 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 1464type WorkbookFunctionsGaussRequestParameter struct { 1465 // X undocumented 1466 X json.RawMessage `json:"x,omitempty"` 1467} 1468 1469// WorkbookFunctionsGcdRequestParameter undocumented 1470type WorkbookFunctionsGcdRequestParameter struct { 1471 // Values undocumented 1472 Values json.RawMessage `json:"values,omitempty"` 1473} 1474 1475// WorkbookFunctionsGeStepRequestParameter undocumented 1476type 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 1484type WorkbookFunctionsGeoMeanRequestParameter struct { 1485 // Values undocumented 1486 Values json.RawMessage `json:"values,omitempty"` 1487} 1488 1489// WorkbookFunctionsHlookupRequestParameter undocumented 1490type 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 1502type WorkbookFunctionsHarMeanRequestParameter struct { 1503 // Values undocumented 1504 Values json.RawMessage `json:"values,omitempty"` 1505} 1506 1507// WorkbookFunctionsHex2BinRequestParameter undocumented 1508type 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 1516type WorkbookFunctionsHex2DecRequestParameter struct { 1517 // Number undocumented 1518 Number json.RawMessage `json:"number,omitempty"` 1519} 1520 1521// WorkbookFunctionsHex2OctRequestParameter undocumented 1522type 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 1530type WorkbookFunctionsHourRequestParameter struct { 1531 // SerialNumber undocumented 1532 SerialNumber json.RawMessage `json:"serialNumber,omitempty"` 1533} 1534 1535// WorkbookFunctionsHypGeom_DistRequestParameter undocumented 1536type 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 1550type 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 1558type 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 1566type 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 1576type WorkbookFunctionsImAbsRequestParameter struct { 1577 // Inumber undocumented 1578 Inumber json.RawMessage `json:"inumber,omitempty"` 1579} 1580 1581// WorkbookFunctionsImArgumentRequestParameter undocumented 1582type WorkbookFunctionsImArgumentRequestParameter struct { 1583 // Inumber undocumented 1584 Inumber json.RawMessage `json:"inumber,omitempty"` 1585} 1586 1587// WorkbookFunctionsImConjugateRequestParameter undocumented 1588type WorkbookFunctionsImConjugateRequestParameter struct { 1589 // Inumber undocumented 1590 Inumber json.RawMessage `json:"inumber,omitempty"` 1591} 1592 1593// WorkbookFunctionsImCosRequestParameter undocumented 1594type WorkbookFunctionsImCosRequestParameter struct { 1595 // Inumber undocumented 1596 Inumber json.RawMessage `json:"inumber,omitempty"` 1597} 1598 1599// WorkbookFunctionsImCoshRequestParameter undocumented 1600type WorkbookFunctionsImCoshRequestParameter struct { 1601 // Inumber undocumented 1602 Inumber json.RawMessage `json:"inumber,omitempty"` 1603} 1604 1605// WorkbookFunctionsImCotRequestParameter undocumented 1606type WorkbookFunctionsImCotRequestParameter struct { 1607 // Inumber undocumented 1608 Inumber json.RawMessage `json:"inumber,omitempty"` 1609} 1610 1611// WorkbookFunctionsImCscRequestParameter undocumented 1612type WorkbookFunctionsImCscRequestParameter struct { 1613 // Inumber undocumented 1614 Inumber json.RawMessage `json:"inumber,omitempty"` 1615} 1616 1617// WorkbookFunctionsImCschRequestParameter undocumented 1618type WorkbookFunctionsImCschRequestParameter struct { 1619 // Inumber undocumented 1620 Inumber json.RawMessage `json:"inumber,omitempty"` 1621} 1622 1623// WorkbookFunctionsImDivRequestParameter undocumented 1624type 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 1632type WorkbookFunctionsImExpRequestParameter struct { 1633 // Inumber undocumented 1634 Inumber json.RawMessage `json:"inumber,omitempty"` 1635} 1636 1637// WorkbookFunctionsImLnRequestParameter undocumented 1638type WorkbookFunctionsImLnRequestParameter struct { 1639 // Inumber undocumented 1640 Inumber json.RawMessage `json:"inumber,omitempty"` 1641} 1642 1643// WorkbookFunctionsImLog10RequestParameter undocumented 1644type WorkbookFunctionsImLog10RequestParameter struct { 1645 // Inumber undocumented 1646 Inumber json.RawMessage `json:"inumber,omitempty"` 1647} 1648 1649// WorkbookFunctionsImLog2RequestParameter undocumented 1650type WorkbookFunctionsImLog2RequestParameter struct { 1651 // Inumber undocumented 1652 Inumber json.RawMessage `json:"inumber,omitempty"` 1653} 1654 1655// WorkbookFunctionsImPowerRequestParameter undocumented 1656type 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 1664type WorkbookFunctionsImProductRequestParameter struct { 1665 // Values undocumented 1666 Values json.RawMessage `json:"values,omitempty"` 1667} 1668 1669// WorkbookFunctionsImRealRequestParameter undocumented 1670type WorkbookFunctionsImRealRequestParameter struct { 1671 // Inumber undocumented 1672 Inumber json.RawMessage `json:"inumber,omitempty"` 1673} 1674 1675// WorkbookFunctionsImSecRequestParameter undocumented 1676type WorkbookFunctionsImSecRequestParameter struct { 1677 // Inumber undocumented 1678 Inumber json.RawMessage `json:"inumber,omitempty"` 1679} 1680 1681// WorkbookFunctionsImSechRequestParameter undocumented 1682type WorkbookFunctionsImSechRequestParameter struct { 1683 // Inumber undocumented 1684 Inumber json.RawMessage `json:"inumber,omitempty"` 1685} 1686 1687// WorkbookFunctionsImSinRequestParameter undocumented 1688type WorkbookFunctionsImSinRequestParameter struct { 1689 // Inumber undocumented 1690 Inumber json.RawMessage `json:"inumber,omitempty"` 1691} 1692 1693// WorkbookFunctionsImSinhRequestParameter undocumented 1694type WorkbookFunctionsImSinhRequestParameter struct { 1695 // Inumber undocumented 1696 Inumber json.RawMessage `json:"inumber,omitempty"` 1697} 1698 1699// WorkbookFunctionsImSqrtRequestParameter undocumented 1700type WorkbookFunctionsImSqrtRequestParameter struct { 1701 // Inumber undocumented 1702 Inumber json.RawMessage `json:"inumber,omitempty"` 1703} 1704 1705// WorkbookFunctionsImSubRequestParameter undocumented 1706type 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 1714type WorkbookFunctionsImSumRequestParameter struct { 1715 // Values undocumented 1716 Values json.RawMessage `json:"values,omitempty"` 1717} 1718 1719// WorkbookFunctionsImTanRequestParameter undocumented 1720type WorkbookFunctionsImTanRequestParameter struct { 1721 // Inumber undocumented 1722 Inumber json.RawMessage `json:"inumber,omitempty"` 1723} 1724 1725// WorkbookFunctionsImaginaryRequestParameter undocumented 1726type WorkbookFunctionsImaginaryRequestParameter struct { 1727 // Inumber undocumented 1728 Inumber json.RawMessage `json:"inumber,omitempty"` 1729} 1730 1731// WorkbookFunctionsIntRequestParameter undocumented 1732type WorkbookFunctionsIntRequestParameter struct { 1733 // Number undocumented 1734 Number json.RawMessage `json:"number,omitempty"` 1735} 1736 1737// WorkbookFunctionsIntRateRequestParameter undocumented 1738type 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 1752type 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 1768type 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 1776type WorkbookFunctionsIsErrRequestParameter struct { 1777 // Value undocumented 1778 Value json.RawMessage `json:"value,omitempty"` 1779} 1780 1781// WorkbookFunctionsIsErrorRequestParameter undocumented 1782type WorkbookFunctionsIsErrorRequestParameter struct { 1783 // Value undocumented 1784 Value json.RawMessage `json:"value,omitempty"` 1785} 1786 1787// WorkbookFunctionsIsEvenRequestParameter undocumented 1788type WorkbookFunctionsIsEvenRequestParameter struct { 1789 // Number undocumented 1790 Number json.RawMessage `json:"number,omitempty"` 1791} 1792 1793// WorkbookFunctionsIsFormulaRequestParameter undocumented 1794type WorkbookFunctionsIsFormulaRequestParameter struct { 1795 // Reference undocumented 1796 Reference json.RawMessage `json:"reference,omitempty"` 1797} 1798 1799// WorkbookFunctionsIsLogicalRequestParameter undocumented 1800type WorkbookFunctionsIsLogicalRequestParameter struct { 1801 // Value undocumented 1802 Value json.RawMessage `json:"value,omitempty"` 1803} 1804 1805// WorkbookFunctionsIsNARequestParameter undocumented 1806type WorkbookFunctionsIsNARequestParameter struct { 1807 // Value undocumented 1808 Value json.RawMessage `json:"value,omitempty"` 1809} 1810 1811// WorkbookFunctionsIsNonTextRequestParameter undocumented 1812type WorkbookFunctionsIsNonTextRequestParameter struct { 1813 // Value undocumented 1814 Value json.RawMessage `json:"value,omitempty"` 1815} 1816 1817// WorkbookFunctionsIsNumberRequestParameter undocumented 1818type WorkbookFunctionsIsNumberRequestParameter struct { 1819 // Value undocumented 1820 Value json.RawMessage `json:"value,omitempty"` 1821} 1822 1823// WorkbookFunctionsIsOddRequestParameter undocumented 1824type WorkbookFunctionsIsOddRequestParameter struct { 1825 // Number undocumented 1826 Number json.RawMessage `json:"number,omitempty"` 1827} 1828 1829// WorkbookFunctionsIsTextRequestParameter undocumented 1830type WorkbookFunctionsIsTextRequestParameter struct { 1831 // Value undocumented 1832 Value json.RawMessage `json:"value,omitempty"` 1833} 1834 1835// WorkbookFunctionsIsoWeekNumRequestParameter undocumented 1836type WorkbookFunctionsIsoWeekNumRequestParameter struct { 1837 // Date undocumented 1838 Date json.RawMessage `json:"date,omitempty"` 1839} 1840 1841// WorkbookFunctionsIspmtRequestParameter undocumented 1842type 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 1854type WorkbookFunctionsIsrefRequestParameter struct { 1855 // Value undocumented 1856 Value json.RawMessage `json:"value,omitempty"` 1857} 1858 1859// WorkbookFunctionsKurtRequestParameter undocumented 1860type WorkbookFunctionsKurtRequestParameter struct { 1861 // Values undocumented 1862 Values json.RawMessage `json:"values,omitempty"` 1863} 1864 1865// WorkbookFunctionsLargeRequestParameter undocumented 1866type 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 1874type WorkbookFunctionsLcmRequestParameter struct { 1875 // Values undocumented 1876 Values json.RawMessage `json:"values,omitempty"` 1877} 1878 1879// WorkbookFunctionsLeftRequestParameter undocumented 1880type 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 1888type 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 1896type WorkbookFunctionsLenRequestParameter struct { 1897 // Text undocumented 1898 Text json.RawMessage `json:"text,omitempty"` 1899} 1900 1901// WorkbookFunctionsLenbRequestParameter undocumented 1902type WorkbookFunctionsLenbRequestParameter struct { 1903 // Text undocumented 1904 Text json.RawMessage `json:"text,omitempty"` 1905} 1906 1907// WorkbookFunctionsLnRequestParameter undocumented 1908type WorkbookFunctionsLnRequestParameter struct { 1909 // Number undocumented 1910 Number json.RawMessage `json:"number,omitempty"` 1911} 1912 1913// WorkbookFunctionsLogRequestParameter undocumented 1914type 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 1922type WorkbookFunctionsLog10RequestParameter struct { 1923 // Number undocumented 1924 Number json.RawMessage `json:"number,omitempty"` 1925} 1926 1927// WorkbookFunctionsLogNorm_DistRequestParameter undocumented 1928type 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 1940type 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 1950type 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 1960type WorkbookFunctionsLowerRequestParameter struct { 1961 // Text undocumented 1962 Text json.RawMessage `json:"text,omitempty"` 1963} 1964 1965// WorkbookFunctionsMdurationRequestParameter undocumented 1966type 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 1982type 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 1992type 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 2000type 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 2010type WorkbookFunctionsMaxRequestParameter struct { 2011 // Values undocumented 2012 Values json.RawMessage `json:"values,omitempty"` 2013} 2014 2015// WorkbookFunctionsMaxARequestParameter undocumented 2016type WorkbookFunctionsMaxARequestParameter struct { 2017 // Values undocumented 2018 Values json.RawMessage `json:"values,omitempty"` 2019} 2020 2021// WorkbookFunctionsMedianRequestParameter undocumented 2022type WorkbookFunctionsMedianRequestParameter struct { 2023 // Values undocumented 2024 Values json.RawMessage `json:"values,omitempty"` 2025} 2026 2027// WorkbookFunctionsMidRequestParameter undocumented 2028type 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 2038type 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 2048type WorkbookFunctionsMinRequestParameter struct { 2049 // Values undocumented 2050 Values json.RawMessage `json:"values,omitempty"` 2051} 2052 2053// WorkbookFunctionsMinARequestParameter undocumented 2054type WorkbookFunctionsMinARequestParameter struct { 2055 // Values undocumented 2056 Values json.RawMessage `json:"values,omitempty"` 2057} 2058 2059// WorkbookFunctionsMinuteRequestParameter undocumented 2060type WorkbookFunctionsMinuteRequestParameter struct { 2061 // SerialNumber undocumented 2062 SerialNumber json.RawMessage `json:"serialNumber,omitempty"` 2063} 2064 2065// WorkbookFunctionsModRequestParameter undocumented 2066type 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 2074type WorkbookFunctionsMonthRequestParameter struct { 2075 // SerialNumber undocumented 2076 SerialNumber json.RawMessage `json:"serialNumber,omitempty"` 2077} 2078 2079// WorkbookFunctionsMultiNomialRequestParameter undocumented 2080type WorkbookFunctionsMultiNomialRequestParameter struct { 2081 // Values undocumented 2082 Values json.RawMessage `json:"values,omitempty"` 2083} 2084 2085// WorkbookFunctionsNRequestParameter undocumented 2086type WorkbookFunctionsNRequestParameter struct { 2087 // Value undocumented 2088 Value json.RawMessage `json:"value,omitempty"` 2089} 2090 2091// WorkbookFunctionsNperRequestParameter undocumented 2092type 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 2106type WorkbookFunctionsNaRequestParameter struct { 2107} 2108 2109// WorkbookFunctionsNegBinom_DistRequestParameter undocumented 2110type 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 2122type 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 2132type 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 2144type 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 2152type 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 2164type 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 2174type 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 2182type WorkbookFunctionsNorm_S_InvRequestParameter struct { 2183 // Probability undocumented 2184 Probability json.RawMessage `json:"probability,omitempty"` 2185} 2186 2187// WorkbookFunctionsNotRequestParameter undocumented 2188type WorkbookFunctionsNotRequestParameter struct { 2189 // Logical undocumented 2190 Logical json.RawMessage `json:"logical,omitempty"` 2191} 2192 2193// WorkbookFunctionsNowRequestParameter undocumented 2194type WorkbookFunctionsNowRequestParameter struct { 2195} 2196 2197// WorkbookFunctionsNpvRequestParameter undocumented 2198type 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 2206type 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 2216type 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 2224type WorkbookFunctionsOct2DecRequestParameter struct { 2225 // Number undocumented 2226 Number json.RawMessage `json:"number,omitempty"` 2227} 2228 2229// WorkbookFunctionsOct2HexRequestParameter undocumented 2230type 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 2238type WorkbookFunctionsOddRequestParameter struct { 2239 // Number undocumented 2240 Number json.RawMessage `json:"number,omitempty"` 2241} 2242 2243// WorkbookFunctionsOddFPriceRequestParameter undocumented 2244type 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 2266type 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 2288type 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 2308type 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 2328type WorkbookFunctionsOrRequestParameter struct { 2329 // Values undocumented 2330 Values json.RawMessage `json:"values,omitempty"` 2331} 2332 2333// WorkbookFunctionsPdurationRequestParameter undocumented 2334type 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 2344type 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 2354type 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 2364type 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 2372type 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 2380type 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 2388type 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 2396type WorkbookFunctionsPhiRequestParameter struct { 2397 // X undocumented 2398 X json.RawMessage `json:"x,omitempty"` 2399} 2400 2401// WorkbookFunctionsPiRequestParameter undocumented 2402type WorkbookFunctionsPiRequestParameter struct { 2403} 2404 2405// WorkbookFunctionsPmtRequestParameter undocumented 2406type 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 2420type 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 2430type 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 2438type 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 2454type 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 2472type 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 2486type 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 2502type WorkbookFunctionsProductRequestParameter struct { 2503 // Values undocumented 2504 Values json.RawMessage `json:"values,omitempty"` 2505} 2506 2507// WorkbookFunctionsProperRequestParameter undocumented 2508type WorkbookFunctionsProperRequestParameter struct { 2509 // Text undocumented 2510 Text json.RawMessage `json:"text,omitempty"` 2511} 2512 2513// WorkbookFunctionsPvRequestParameter undocumented 2514type 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 2528type 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 2536type 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 2544type 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 2552type WorkbookFunctionsRadiansRequestParameter struct { 2553 // Angle undocumented 2554 Angle json.RawMessage `json:"angle,omitempty"` 2555} 2556 2557// WorkbookFunctionsRandRequestParameter undocumented 2558type WorkbookFunctionsRandRequestParameter struct { 2559} 2560 2561// WorkbookFunctionsRandBetweenRequestParameter undocumented 2562type 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 2570type 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 2580type 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 2590type 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 2606type 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 2620type 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 2632type 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 2644type 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 2652type 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 2660type 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 2668type 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 2676type 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 2684type 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 2692type 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 2700type WorkbookFunctionsRowsRequestParameter struct { 2701 // Array undocumented 2702 Array json.RawMessage `json:"array,omitempty"` 2703} 2704 2705// WorkbookFunctionsRriRequestParameter undocumented 2706type 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 2716type WorkbookFunctionsSecRequestParameter struct { 2717 // Number undocumented 2718 Number json.RawMessage `json:"number,omitempty"` 2719} 2720 2721// WorkbookFunctionsSechRequestParameter undocumented 2722type WorkbookFunctionsSechRequestParameter struct { 2723 // Number undocumented 2724 Number json.RawMessage `json:"number,omitempty"` 2725} 2726 2727// WorkbookFunctionsSecondRequestParameter undocumented 2728type WorkbookFunctionsSecondRequestParameter struct { 2729 // SerialNumber undocumented 2730 SerialNumber json.RawMessage `json:"serialNumber,omitempty"` 2731} 2732 2733// WorkbookFunctionsSeriesSumRequestParameter undocumented 2734type 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 2746type WorkbookFunctionsSheetRequestParameter struct { 2747 // Value undocumented 2748 Value json.RawMessage `json:"value,omitempty"` 2749} 2750 2751// WorkbookFunctionsSheetsRequestParameter undocumented 2752type WorkbookFunctionsSheetsRequestParameter struct { 2753 // Reference undocumented 2754 Reference json.RawMessage `json:"reference,omitempty"` 2755} 2756 2757// WorkbookFunctionsSignRequestParameter undocumented 2758type WorkbookFunctionsSignRequestParameter struct { 2759 // Number undocumented 2760 Number json.RawMessage `json:"number,omitempty"` 2761} 2762 2763// WorkbookFunctionsSinRequestParameter undocumented 2764type WorkbookFunctionsSinRequestParameter struct { 2765 // Number undocumented 2766 Number json.RawMessage `json:"number,omitempty"` 2767} 2768 2769// WorkbookFunctionsSinhRequestParameter undocumented 2770type WorkbookFunctionsSinhRequestParameter struct { 2771 // Number undocumented 2772 Number json.RawMessage `json:"number,omitempty"` 2773} 2774 2775// WorkbookFunctionsSkewRequestParameter undocumented 2776type WorkbookFunctionsSkewRequestParameter struct { 2777 // Values undocumented 2778 Values json.RawMessage `json:"values,omitempty"` 2779} 2780 2781// WorkbookFunctionsSkew_pRequestParameter undocumented 2782type WorkbookFunctionsSkew_pRequestParameter struct { 2783 // Values undocumented 2784 Values json.RawMessage `json:"values,omitempty"` 2785} 2786 2787// WorkbookFunctionsSlnRequestParameter undocumented 2788type 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 2798type 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 2806type WorkbookFunctionsSqrtRequestParameter struct { 2807 // Number undocumented 2808 Number json.RawMessage `json:"number,omitempty"` 2809} 2810 2811// WorkbookFunctionsSqrtPiRequestParameter undocumented 2812type WorkbookFunctionsSqrtPiRequestParameter struct { 2813 // Number undocumented 2814 Number json.RawMessage `json:"number,omitempty"` 2815} 2816 2817// WorkbookFunctionsStDevARequestParameter undocumented 2818type WorkbookFunctionsStDevARequestParameter struct { 2819 // Values undocumented 2820 Values json.RawMessage `json:"values,omitempty"` 2821} 2822 2823// WorkbookFunctionsStDevPARequestParameter undocumented 2824type WorkbookFunctionsStDevPARequestParameter struct { 2825 // Values undocumented 2826 Values json.RawMessage `json:"values,omitempty"` 2827} 2828 2829// WorkbookFunctionsStDev_PRequestParameter undocumented 2830type WorkbookFunctionsStDev_PRequestParameter struct { 2831 // Values undocumented 2832 Values json.RawMessage `json:"values,omitempty"` 2833} 2834 2835// WorkbookFunctionsStDev_SRequestParameter undocumented 2836type WorkbookFunctionsStDev_SRequestParameter struct { 2837 // Values undocumented 2838 Values json.RawMessage `json:"values,omitempty"` 2839} 2840 2841// WorkbookFunctionsStandardizeRequestParameter undocumented 2842type 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 2852type 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 2864type 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 2872type WorkbookFunctionsSumRequestParameter struct { 2873 // Values undocumented 2874 Values json.RawMessage `json:"values,omitempty"` 2875} 2876 2877// WorkbookFunctionsSumIfRequestParameter undocumented 2878type 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 2888type 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 2896type WorkbookFunctionsSumSqRequestParameter struct { 2897 // Values undocumented 2898 Values json.RawMessage `json:"values,omitempty"` 2899} 2900 2901// WorkbookFunctionsSydRequestParameter undocumented 2902type 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 2914type WorkbookFunctionsTRequestParameter struct { 2915 // Value undocumented 2916 Value json.RawMessage `json:"value,omitempty"` 2917} 2918 2919// WorkbookFunctionsTbillEqRequestParameter undocumented 2920type 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 2930type 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 2940type 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 2950type 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 2960type 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 2968type 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 2976type 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 2984type 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 2992type WorkbookFunctionsTanRequestParameter struct { 2993 // Number undocumented 2994 Number json.RawMessage `json:"number,omitempty"` 2995} 2996 2997// WorkbookFunctionsTanhRequestParameter undocumented 2998type WorkbookFunctionsTanhRequestParameter struct { 2999 // Number undocumented 3000 Number json.RawMessage `json:"number,omitempty"` 3001} 3002 3003// WorkbookFunctionsTextRequestParameter undocumented 3004type 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 3012type 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 3022type WorkbookFunctionsTimevalueRequestParameter struct { 3023 // TimeText undocumented 3024 TimeText json.RawMessage `json:"timeText,omitempty"` 3025} 3026 3027// WorkbookFunctionsTodayRequestParameter undocumented 3028type WorkbookFunctionsTodayRequestParameter struct { 3029} 3030 3031// WorkbookFunctionsTrimRequestParameter undocumented 3032type WorkbookFunctionsTrimRequestParameter struct { 3033 // Text undocumented 3034 Text json.RawMessage `json:"text,omitempty"` 3035} 3036 3037// WorkbookFunctionsTrimMeanRequestParameter undocumented 3038type 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 3046type WorkbookFunctionsTrueRequestParameter struct { 3047} 3048 3049// WorkbookFunctionsTruncRequestParameter undocumented 3050type 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 3058type WorkbookFunctionsTypeRequestParameter struct { 3059 // Value undocumented 3060 Value json.RawMessage `json:"value,omitempty"` 3061} 3062 3063// WorkbookFunctionsUsdollarRequestParameter undocumented 3064type 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 3072type WorkbookFunctionsUnicharRequestParameter struct { 3073 // Number undocumented 3074 Number json.RawMessage `json:"number,omitempty"` 3075} 3076 3077// WorkbookFunctionsUnicodeRequestParameter undocumented 3078type WorkbookFunctionsUnicodeRequestParameter struct { 3079 // Text undocumented 3080 Text json.RawMessage `json:"text,omitempty"` 3081} 3082 3083// WorkbookFunctionsUpperRequestParameter undocumented 3084type WorkbookFunctionsUpperRequestParameter struct { 3085 // Text undocumented 3086 Text json.RawMessage `json:"text,omitempty"` 3087} 3088 3089// WorkbookFunctionsVlookupRequestParameter undocumented 3090type 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 3102type WorkbookFunctionsValueRequestParameter struct { 3103 // Text undocumented 3104 Text json.RawMessage `json:"text,omitempty"` 3105} 3106 3107// WorkbookFunctionsVarARequestParameter undocumented 3108type WorkbookFunctionsVarARequestParameter struct { 3109 // Values undocumented 3110 Values json.RawMessage `json:"values,omitempty"` 3111} 3112 3113// WorkbookFunctionsVarPARequestParameter undocumented 3114type WorkbookFunctionsVarPARequestParameter struct { 3115 // Values undocumented 3116 Values json.RawMessage `json:"values,omitempty"` 3117} 3118 3119// WorkbookFunctionsVar_PRequestParameter undocumented 3120type WorkbookFunctionsVar_PRequestParameter struct { 3121 // Values undocumented 3122 Values json.RawMessage `json:"values,omitempty"` 3123} 3124 3125// WorkbookFunctionsVar_SRequestParameter undocumented 3126type WorkbookFunctionsVar_SRequestParameter struct { 3127 // Values undocumented 3128 Values json.RawMessage `json:"values,omitempty"` 3129} 3130 3131// WorkbookFunctionsVdbRequestParameter undocumented 3132type 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 3150type 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 3158type 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 3166type 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 3178type 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 3188type 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 3200type 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 3210type 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 3220type WorkbookFunctionsXorRequestParameter struct { 3221 // Values undocumented 3222 Values json.RawMessage `json:"values,omitempty"` 3223} 3224 3225// WorkbookFunctionsYearRequestParameter undocumented 3226type WorkbookFunctionsYearRequestParameter struct { 3227 // SerialNumber undocumented 3228 SerialNumber json.RawMessage `json:"serialNumber,omitempty"` 3229} 3230 3231// WorkbookFunctionsYearFracRequestParameter undocumented 3232type 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 3242type 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 3260type 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 3274type 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 3290type 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 3300type WorkbookPivotTableRefreshRequestParameter struct { 3301} 3302 3303// WorkbookRangeClearRequestParameter undocumented 3304type WorkbookRangeClearRequestParameter struct { 3305 // ApplyTo undocumented 3306 ApplyTo *string `json:"applyTo,omitempty"` 3307} 3308 3309// WorkbookRangeDeleteRequestParameter undocumented 3310type WorkbookRangeDeleteRequestParameter struct { 3311 // Shift undocumented 3312 Shift *string `json:"shift,omitempty"` 3313} 3314 3315// WorkbookRangeInsertRequestParameter undocumented 3316type WorkbookRangeInsertRequestParameter struct { 3317 // Shift undocumented 3318 Shift *string `json:"shift,omitempty"` 3319} 3320 3321// WorkbookRangeMergeRequestParameter undocumented 3322type WorkbookRangeMergeRequestParameter struct { 3323 // Across undocumented 3324 Across *bool `json:"across,omitempty"` 3325} 3326 3327// WorkbookRangeUnmergeRequestParameter undocumented 3328type WorkbookRangeUnmergeRequestParameter struct { 3329} 3330 3331// WorkbookRangeFillClearRequestParameter undocumented 3332type WorkbookRangeFillClearRequestParameter struct { 3333} 3334 3335// WorkbookRangeFormatAutofitColumnsRequestParameter undocumented 3336type WorkbookRangeFormatAutofitColumnsRequestParameter struct { 3337} 3338 3339// WorkbookRangeFormatAutofitRowsRequestParameter undocumented 3340type WorkbookRangeFormatAutofitRowsRequestParameter struct { 3341} 3342 3343// WorkbookRangeSortApplyRequestParameter undocumented 3344type 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 3358type WorkbookTableClearFiltersRequestParameter struct { 3359} 3360 3361// WorkbookTableConvertToRangeRequestParameter undocumented 3362type WorkbookTableConvertToRangeRequestParameter struct { 3363} 3364 3365// WorkbookTableReapplyFiltersRequestParameter undocumented 3366type WorkbookTableReapplyFiltersRequestParameter struct { 3367} 3368 3369// WorkbookTableSortApplyRequestParameter undocumented 3370type 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 3380type WorkbookTableSortClearRequestParameter struct { 3381} 3382 3383// WorkbookTableSortReapplyRequestParameter undocumented 3384type WorkbookTableSortReapplyRequestParameter struct { 3385} 3386 3387// WorkbookWorksheetProtectionProtectRequestParameter undocumented 3388type WorkbookWorksheetProtectionProtectRequestParameter struct { 3389 // Options undocumented 3390 Options *WorkbookWorksheetProtectionOptions `json:"options,omitempty"` 3391} 3392 3393// WorkbookWorksheetProtectionUnprotectRequestParameter undocumented 3394type WorkbookWorksheetProtectionUnprotectRequestParameter struct { 3395} 3396 3397// Application is navigation property 3398func (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 3405func (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 3412type WorkbookCommentsCollectionRequestBuilder struct{ BaseRequestBuilder } 3413 3414// Request returns request for WorkbookComment collection 3415func (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 3422func (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 3429type WorkbookCommentsCollectionRequest struct{ BaseRequest } 3430 3431// Paging perfoms paging operation for WorkbookComment collection 3432func (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 3488func (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 3497func (r *WorkbookCommentsCollectionRequest) Get(ctx context.Context) ([]WorkbookComment, error) { 3498 return r.GetN(ctx, 0) 3499} 3500 3501// Add performs POST request for WorkbookComment collection 3502func (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 3508func (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 3515func (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 3522type WorkbookNamesCollectionRequestBuilder struct{ BaseRequestBuilder } 3523 3524// Request returns request for WorkbookNamedItem collection 3525func (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 3532func (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 3539type WorkbookNamesCollectionRequest struct{ BaseRequest } 3540 3541// Paging perfoms paging operation for WorkbookNamedItem collection 3542func (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 3598func (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 3607func (r *WorkbookNamesCollectionRequest) Get(ctx context.Context) ([]WorkbookNamedItem, error) { 3608 return r.GetN(ctx, 0) 3609} 3610 3611// Add performs POST request for WorkbookNamedItem collection 3612func (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 3618func (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 3625type WorkbookTablesCollectionRequestBuilder struct{ BaseRequestBuilder } 3626 3627// Request returns request for WorkbookTable collection 3628func (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 3635func (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 3642type WorkbookTablesCollectionRequest struct{ BaseRequest } 3643 3644// Paging perfoms paging operation for WorkbookTable collection 3645func (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 3701func (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 3710func (r *WorkbookTablesCollectionRequest) Get(ctx context.Context) ([]WorkbookTable, error) { 3711 return r.GetN(ctx, 0) 3712} 3713 3714// Add performs POST request for WorkbookTable collection 3715func (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 3721func (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 3728type WorkbookWorksheetsCollectionRequestBuilder struct{ BaseRequestBuilder } 3729 3730// Request returns request for WorkbookWorksheet collection 3731func (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 3738func (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 3745type WorkbookWorksheetsCollectionRequest struct{ BaseRequest } 3746 3747// Paging perfoms paging operation for WorkbookWorksheet collection 3748func (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 3804func (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 3813func (r *WorkbookWorksheetsCollectionRequest) Get(ctx context.Context) ([]WorkbookWorksheet, error) { 3814 return r.GetN(ctx, 0) 3815} 3816 3817// Add performs POST request for WorkbookWorksheet collection 3818func (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 3824func (b *WorkbookChartRequestBuilder) Axes() *WorkbookChartAxesRequestBuilder { 3825 bb := &WorkbookChartAxesRequestBuilder{BaseRequestBuilder: b.BaseRequestBuilder} 3826 bb.baseURL += "/axes" 3827 return bb 3828} 3829 3830// DataLabels is navigation property 3831func (b *WorkbookChartRequestBuilder) DataLabels() *WorkbookChartDataLabelsRequestBuilder { 3832 bb := &WorkbookChartDataLabelsRequestBuilder{BaseRequestBuilder: b.BaseRequestBuilder} 3833 bb.baseURL += "/dataLabels" 3834 return bb 3835} 3836 3837// Format is navigation property 3838func (b *WorkbookChartRequestBuilder) Format() *WorkbookChartAreaFormatRequestBuilder { 3839 bb := &WorkbookChartAreaFormatRequestBuilder{BaseRequestBuilder: b.BaseRequestBuilder} 3840 bb.baseURL += "/format" 3841 return bb 3842} 3843 3844// Legend is navigation property 3845func (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 3852func (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 3859type WorkbookChartSeriesCollectionRequestBuilder struct{ BaseRequestBuilder } 3860 3861// Request returns request for WorkbookChartSeries collection 3862func (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 3869func (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 3876type WorkbookChartSeriesCollectionRequest struct{ BaseRequest } 3877 3878// Paging perfoms paging operation for WorkbookChartSeries collection 3879func (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 3935func (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 3944func (r *WorkbookChartSeriesCollectionRequest) Get(ctx context.Context) ([]WorkbookChartSeries, error) { 3945 return r.GetN(ctx, 0) 3946} 3947 3948// Add performs POST request for WorkbookChartSeries collection 3949func (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 3955func (b *WorkbookChartRequestBuilder) Title() *WorkbookChartTitleRequestBuilder { 3956 bb := &WorkbookChartTitleRequestBuilder{BaseRequestBuilder: b.BaseRequestBuilder} 3957 bb.baseURL += "/title" 3958 return bb 3959} 3960 3961// Worksheet is navigation property 3962func (b *WorkbookChartRequestBuilder) Worksheet() *WorkbookWorksheetRequestBuilder { 3963 bb := &WorkbookWorksheetRequestBuilder{BaseRequestBuilder: b.BaseRequestBuilder} 3964 bb.baseURL += "/worksheet" 3965 return bb 3966} 3967 3968// Fill is navigation property 3969func (b *WorkbookChartAreaFormatRequestBuilder) Fill() *WorkbookChartFillRequestBuilder { 3970 bb := &WorkbookChartFillRequestBuilder{BaseRequestBuilder: b.BaseRequestBuilder} 3971 bb.baseURL += "/fill" 3972 return bb 3973} 3974 3975// Font is navigation property 3976func (b *WorkbookChartAreaFormatRequestBuilder) Font() *WorkbookChartFontRequestBuilder { 3977 bb := &WorkbookChartFontRequestBuilder{BaseRequestBuilder: b.BaseRequestBuilder} 3978 bb.baseURL += "/font" 3979 return bb 3980} 3981 3982// CategoryAxis is navigation property 3983func (b *WorkbookChartAxesRequestBuilder) CategoryAxis() *WorkbookChartAxisRequestBuilder { 3984 bb := &WorkbookChartAxisRequestBuilder{BaseRequestBuilder: b.BaseRequestBuilder} 3985 bb.baseURL += "/categoryAxis" 3986 return bb 3987} 3988 3989// SeriesAxis is navigation property 3990func (b *WorkbookChartAxesRequestBuilder) SeriesAxis() *WorkbookChartAxisRequestBuilder { 3991 bb := &WorkbookChartAxisRequestBuilder{BaseRequestBuilder: b.BaseRequestBuilder} 3992 bb.baseURL += "/seriesAxis" 3993 return bb 3994} 3995 3996// ValueAxis is navigation property 3997func (b *WorkbookChartAxesRequestBuilder) ValueAxis() *WorkbookChartAxisRequestBuilder { 3998 bb := &WorkbookChartAxisRequestBuilder{BaseRequestBuilder: b.BaseRequestBuilder} 3999 bb.baseURL += "/valueAxis" 4000 return bb 4001} 4002 4003// Format is navigation property 4004func (b *WorkbookChartAxisRequestBuilder) Format() *WorkbookChartAxisFormatRequestBuilder { 4005 bb := &WorkbookChartAxisFormatRequestBuilder{BaseRequestBuilder: b.BaseRequestBuilder} 4006 bb.baseURL += "/format" 4007 return bb 4008} 4009 4010// MajorGridlines is navigation property 4011func (b *WorkbookChartAxisRequestBuilder) MajorGridlines() *WorkbookChartGridlinesRequestBuilder { 4012 bb := &WorkbookChartGridlinesRequestBuilder{BaseRequestBuilder: b.BaseRequestBuilder} 4013 bb.baseURL += "/majorGridlines" 4014 return bb 4015} 4016 4017// MinorGridlines is navigation property 4018func (b *WorkbookChartAxisRequestBuilder) MinorGridlines() *WorkbookChartGridlinesRequestBuilder { 4019 bb := &WorkbookChartGridlinesRequestBuilder{BaseRequestBuilder: b.BaseRequestBuilder} 4020 bb.baseURL += "/minorGridlines" 4021 return bb 4022} 4023 4024// Title is navigation property 4025func (b *WorkbookChartAxisRequestBuilder) Title() *WorkbookChartAxisTitleRequestBuilder { 4026 bb := &WorkbookChartAxisTitleRequestBuilder{BaseRequestBuilder: b.BaseRequestBuilder} 4027 bb.baseURL += "/title" 4028 return bb 4029} 4030 4031// Font is navigation property 4032func (b *WorkbookChartAxisFormatRequestBuilder) Font() *WorkbookChartFontRequestBuilder { 4033 bb := &WorkbookChartFontRequestBuilder{BaseRequestBuilder: b.BaseRequestBuilder} 4034 bb.baseURL += "/font" 4035 return bb 4036} 4037 4038// Line is navigation property 4039func (b *WorkbookChartAxisFormatRequestBuilder) Line() *WorkbookChartLineFormatRequestBuilder { 4040 bb := &WorkbookChartLineFormatRequestBuilder{BaseRequestBuilder: b.BaseRequestBuilder} 4041 bb.baseURL += "/line" 4042 return bb 4043} 4044 4045// Format is navigation property 4046func (b *WorkbookChartAxisTitleRequestBuilder) Format() *WorkbookChartAxisTitleFormatRequestBuilder { 4047 bb := &WorkbookChartAxisTitleFormatRequestBuilder{BaseRequestBuilder: b.BaseRequestBuilder} 4048 bb.baseURL += "/format" 4049 return bb 4050} 4051 4052// Font is navigation property 4053func (b *WorkbookChartAxisTitleFormatRequestBuilder) Font() *WorkbookChartFontRequestBuilder { 4054 bb := &WorkbookChartFontRequestBuilder{BaseRequestBuilder: b.BaseRequestBuilder} 4055 bb.baseURL += "/font" 4056 return bb 4057} 4058 4059// Fill is navigation property 4060func (b *WorkbookChartDataLabelFormatRequestBuilder) Fill() *WorkbookChartFillRequestBuilder { 4061 bb := &WorkbookChartFillRequestBuilder{BaseRequestBuilder: b.BaseRequestBuilder} 4062 bb.baseURL += "/fill" 4063 return bb 4064} 4065 4066// Font is navigation property 4067func (b *WorkbookChartDataLabelFormatRequestBuilder) Font() *WorkbookChartFontRequestBuilder { 4068 bb := &WorkbookChartFontRequestBuilder{BaseRequestBuilder: b.BaseRequestBuilder} 4069 bb.baseURL += "/font" 4070 return bb 4071} 4072 4073// Format is navigation property 4074func (b *WorkbookChartDataLabelsRequestBuilder) Format() *WorkbookChartDataLabelFormatRequestBuilder { 4075 bb := &WorkbookChartDataLabelFormatRequestBuilder{BaseRequestBuilder: b.BaseRequestBuilder} 4076 bb.baseURL += "/format" 4077 return bb 4078} 4079 4080// Format is navigation property 4081func (b *WorkbookChartGridlinesRequestBuilder) Format() *WorkbookChartGridlinesFormatRequestBuilder { 4082 bb := &WorkbookChartGridlinesFormatRequestBuilder{BaseRequestBuilder: b.BaseRequestBuilder} 4083 bb.baseURL += "/format" 4084 return bb 4085} 4086 4087// Line is navigation property 4088func (b *WorkbookChartGridlinesFormatRequestBuilder) Line() *WorkbookChartLineFormatRequestBuilder { 4089 bb := &WorkbookChartLineFormatRequestBuilder{BaseRequestBuilder: b.BaseRequestBuilder} 4090 bb.baseURL += "/line" 4091 return bb 4092} 4093 4094// Format is navigation property 4095func (b *WorkbookChartLegendRequestBuilder) Format() *WorkbookChartLegendFormatRequestBuilder { 4096 bb := &WorkbookChartLegendFormatRequestBuilder{BaseRequestBuilder: b.BaseRequestBuilder} 4097 bb.baseURL += "/format" 4098 return bb 4099} 4100 4101// Fill is navigation property 4102func (b *WorkbookChartLegendFormatRequestBuilder) Fill() *WorkbookChartFillRequestBuilder { 4103 bb := &WorkbookChartFillRequestBuilder{BaseRequestBuilder: b.BaseRequestBuilder} 4104 bb.baseURL += "/fill" 4105 return bb 4106} 4107 4108// Font is navigation property 4109func (b *WorkbookChartLegendFormatRequestBuilder) Font() *WorkbookChartFontRequestBuilder { 4110 bb := &WorkbookChartFontRequestBuilder{BaseRequestBuilder: b.BaseRequestBuilder} 4111 bb.baseURL += "/font" 4112 return bb 4113} 4114 4115// Format is navigation property 4116func (b *WorkbookChartPointRequestBuilder) Format() *WorkbookChartPointFormatRequestBuilder { 4117 bb := &WorkbookChartPointFormatRequestBuilder{BaseRequestBuilder: b.BaseRequestBuilder} 4118 bb.baseURL += "/format" 4119 return bb 4120} 4121 4122// Fill is navigation property 4123func (b *WorkbookChartPointFormatRequestBuilder) Fill() *WorkbookChartFillRequestBuilder { 4124 bb := &WorkbookChartFillRequestBuilder{BaseRequestBuilder: b.BaseRequestBuilder} 4125 bb.baseURL += "/fill" 4126 return bb 4127} 4128 4129// Format is navigation property 4130func (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 4137func (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 4144type WorkbookChartSeriesPointsCollectionRequestBuilder struct{ BaseRequestBuilder } 4145 4146// Request returns request for WorkbookChartPoint collection 4147func (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 4154func (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 4161type WorkbookChartSeriesPointsCollectionRequest struct{ BaseRequest } 4162 4163// Paging perfoms paging operation for WorkbookChartPoint collection 4164func (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 4220func (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 4229func (r *WorkbookChartSeriesPointsCollectionRequest) Get(ctx context.Context) ([]WorkbookChartPoint, error) { 4230 return r.GetN(ctx, 0) 4231} 4232 4233// Add performs POST request for WorkbookChartPoint collection 4234func (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 4240func (b *WorkbookChartSeriesFormatRequestBuilder) Fill() *WorkbookChartFillRequestBuilder { 4241 bb := &WorkbookChartFillRequestBuilder{BaseRequestBuilder: b.BaseRequestBuilder} 4242 bb.baseURL += "/fill" 4243 return bb 4244} 4245 4246// Line is navigation property 4247func (b *WorkbookChartSeriesFormatRequestBuilder) Line() *WorkbookChartLineFormatRequestBuilder { 4248 bb := &WorkbookChartLineFormatRequestBuilder{BaseRequestBuilder: b.BaseRequestBuilder} 4249 bb.baseURL += "/line" 4250 return bb 4251} 4252 4253// Format is navigation property 4254func (b *WorkbookChartTitleRequestBuilder) Format() *WorkbookChartTitleFormatRequestBuilder { 4255 bb := &WorkbookChartTitleFormatRequestBuilder{BaseRequestBuilder: b.BaseRequestBuilder} 4256 bb.baseURL += "/format" 4257 return bb 4258} 4259 4260// Fill is navigation property 4261func (b *WorkbookChartTitleFormatRequestBuilder) Fill() *WorkbookChartFillRequestBuilder { 4262 bb := &WorkbookChartFillRequestBuilder{BaseRequestBuilder: b.BaseRequestBuilder} 4263 bb.baseURL += "/fill" 4264 return bb 4265} 4266 4267// Font is navigation property 4268func (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 4275func (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 4282type WorkbookCommentRepliesCollectionRequestBuilder struct{ BaseRequestBuilder } 4283 4284// Request returns request for WorkbookCommentReply collection 4285func (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 4292func (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 4299type WorkbookCommentRepliesCollectionRequest struct{ BaseRequest } 4300 4301// Paging perfoms paging operation for WorkbookCommentReply collection 4302func (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 4358func (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 4367func (r *WorkbookCommentRepliesCollectionRequest) Get(ctx context.Context) ([]WorkbookCommentReply, error) { 4368 return r.GetN(ctx, 0) 4369} 4370 4371// Add performs POST request for WorkbookCommentReply collection 4372func (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 4378func (b *WorkbookNamedItemRequestBuilder) Worksheet() *WorkbookWorksheetRequestBuilder { 4379 bb := &WorkbookWorksheetRequestBuilder{BaseRequestBuilder: b.BaseRequestBuilder} 4380 bb.baseURL += "/worksheet" 4381 return bb 4382} 4383 4384// Worksheet is navigation property 4385func (b *WorkbookPivotTableRequestBuilder) Worksheet() *WorkbookWorksheetRequestBuilder { 4386 bb := &WorkbookWorksheetRequestBuilder{BaseRequestBuilder: b.BaseRequestBuilder} 4387 bb.baseURL += "/worksheet" 4388 return bb 4389} 4390 4391// Format is navigation property 4392func (b *WorkbookRangeRequestBuilder) Format() *WorkbookRangeFormatRequestBuilder { 4393 bb := &WorkbookRangeFormatRequestBuilder{BaseRequestBuilder: b.BaseRequestBuilder} 4394 bb.baseURL += "/format" 4395 return bb 4396} 4397 4398// Sort is navigation property 4399func (b *WorkbookRangeRequestBuilder) Sort() *WorkbookRangeSortRequestBuilder { 4400 bb := &WorkbookRangeSortRequestBuilder{BaseRequestBuilder: b.BaseRequestBuilder} 4401 bb.baseURL += "/sort" 4402 return bb 4403} 4404 4405// Worksheet is navigation property 4406func (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 4413func (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 4420type WorkbookRangeFormatBordersCollectionRequestBuilder struct{ BaseRequestBuilder } 4421 4422// Request returns request for WorkbookRangeBorder collection 4423func (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 4430func (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 4437type WorkbookRangeFormatBordersCollectionRequest struct{ BaseRequest } 4438 4439// Paging perfoms paging operation for WorkbookRangeBorder collection 4440func (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 4496func (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 4505func (r *WorkbookRangeFormatBordersCollectionRequest) Get(ctx context.Context) ([]WorkbookRangeBorder, error) { 4506 return r.GetN(ctx, 0) 4507} 4508 4509// Add performs POST request for WorkbookRangeBorder collection 4510func (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 4516func (b *WorkbookRangeFormatRequestBuilder) Fill() *WorkbookRangeFillRequestBuilder { 4517 bb := &WorkbookRangeFillRequestBuilder{BaseRequestBuilder: b.BaseRequestBuilder} 4518 bb.baseURL += "/fill" 4519 return bb 4520} 4521 4522// Font is navigation property 4523func (b *WorkbookRangeFormatRequestBuilder) Font() *WorkbookRangeFontRequestBuilder { 4524 bb := &WorkbookRangeFontRequestBuilder{BaseRequestBuilder: b.BaseRequestBuilder} 4525 bb.baseURL += "/font" 4526 return bb 4527} 4528 4529// Protection is navigation property 4530func (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 4537func (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 4544type WorkbookRangeViewRowsCollectionRequestBuilder struct{ BaseRequestBuilder } 4545 4546// Request returns request for WorkbookRangeView collection 4547func (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 4554func (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 4561type WorkbookRangeViewRowsCollectionRequest struct{ BaseRequest } 4562 4563// Paging perfoms paging operation for WorkbookRangeView collection 4564func (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 4620func (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 4629func (r *WorkbookRangeViewRowsCollectionRequest) Get(ctx context.Context) ([]WorkbookRangeView, error) { 4630 return r.GetN(ctx, 0) 4631} 4632 4633// Add performs POST request for WorkbookRangeView collection 4634func (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 4640func (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 4647type WorkbookTableColumnsCollectionRequestBuilder struct{ BaseRequestBuilder } 4648 4649// Request returns request for WorkbookTableColumn collection 4650func (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 4657func (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 4664type WorkbookTableColumnsCollectionRequest struct{ BaseRequest } 4665 4666// Paging perfoms paging operation for WorkbookTableColumn collection 4667func (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 4723func (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 4732func (r *WorkbookTableColumnsCollectionRequest) Get(ctx context.Context) ([]WorkbookTableColumn, error) { 4733 return r.GetN(ctx, 0) 4734} 4735 4736// Add performs POST request for WorkbookTableColumn collection 4737func (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 4743func (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 4750type WorkbookTableRowsCollectionRequestBuilder struct{ BaseRequestBuilder } 4751 4752// Request returns request for WorkbookTableRow collection 4753func (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 4760func (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 4767type WorkbookTableRowsCollectionRequest struct{ BaseRequest } 4768 4769// Paging perfoms paging operation for WorkbookTableRow collection 4770func (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 4826func (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 4835func (r *WorkbookTableRowsCollectionRequest) Get(ctx context.Context) ([]WorkbookTableRow, error) { 4836 return r.GetN(ctx, 0) 4837} 4838 4839// Add performs POST request for WorkbookTableRow collection 4840func (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 4846func (b *WorkbookTableRequestBuilder) Sort() *WorkbookTableSortRequestBuilder { 4847 bb := &WorkbookTableSortRequestBuilder{BaseRequestBuilder: b.BaseRequestBuilder} 4848 bb.baseURL += "/sort" 4849 return bb 4850} 4851 4852// Worksheet is navigation property 4853func (b *WorkbookTableRequestBuilder) Worksheet() *WorkbookWorksheetRequestBuilder { 4854 bb := &WorkbookWorksheetRequestBuilder{BaseRequestBuilder: b.BaseRequestBuilder} 4855 bb.baseURL += "/worksheet" 4856 return bb 4857} 4858 4859// Filter is navigation property 4860func (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 4867func (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 4874type WorkbookWorksheetChartsCollectionRequestBuilder struct{ BaseRequestBuilder } 4875 4876// Request returns request for WorkbookChart collection 4877func (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 4884func (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 4891type WorkbookWorksheetChartsCollectionRequest struct{ BaseRequest } 4892 4893// Paging perfoms paging operation for WorkbookChart collection 4894func (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 4950func (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 4959func (r *WorkbookWorksheetChartsCollectionRequest) Get(ctx context.Context) ([]WorkbookChart, error) { 4960 return r.GetN(ctx, 0) 4961} 4962 4963// Add performs POST request for WorkbookChart collection 4964func (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 4970func (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 4977type WorkbookWorksheetNamesCollectionRequestBuilder struct{ BaseRequestBuilder } 4978 4979// Request returns request for WorkbookNamedItem collection 4980func (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 4987func (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 4994type WorkbookWorksheetNamesCollectionRequest struct{ BaseRequest } 4995 4996// Paging perfoms paging operation for WorkbookNamedItem collection 4997func (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 5053func (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 5062func (r *WorkbookWorksheetNamesCollectionRequest) Get(ctx context.Context) ([]WorkbookNamedItem, error) { 5063 return r.GetN(ctx, 0) 5064} 5065 5066// Add performs POST request for WorkbookNamedItem collection 5067func (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 5073func (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 5080type WorkbookWorksheetPivotTablesCollectionRequestBuilder struct{ BaseRequestBuilder } 5081 5082// Request returns request for WorkbookPivotTable collection 5083func (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 5090func (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 5097type WorkbookWorksheetPivotTablesCollectionRequest struct{ BaseRequest } 5098 5099// Paging perfoms paging operation for WorkbookPivotTable collection 5100func (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 5156func (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 5165func (r *WorkbookWorksheetPivotTablesCollectionRequest) Get(ctx context.Context) ([]WorkbookPivotTable, error) { 5166 return r.GetN(ctx, 0) 5167} 5168 5169// Add performs POST request for WorkbookPivotTable collection 5170func (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 5176func (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 5183func (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 5190type WorkbookWorksheetTablesCollectionRequestBuilder struct{ BaseRequestBuilder } 5191 5192// Request returns request for WorkbookTable collection 5193func (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 5200func (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 5207type WorkbookWorksheetTablesCollectionRequest struct{ BaseRequest } 5208 5209// Paging perfoms paging operation for WorkbookTable collection 5210func (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 5266func (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 5275func (r *WorkbookWorksheetTablesCollectionRequest) Get(ctx context.Context) ([]WorkbookTable, error) { 5276 return r.GetN(ctx, 0) 5277} 5278 5279// Add performs POST request for WorkbookTable collection 5280func (r *WorkbookWorksheetTablesCollectionRequest) Add(ctx context.Context, reqObj *WorkbookTable) (resObj *WorkbookTable, err error) { 5281 err = r.JSONRequest(ctx, "POST", "", reqObj, &resObj) 5282 return 5283} 5284