GET api/Analysis?startRow={startRow}&startCol={startCol}
Request Information
URI Parameters
| Name | Description | Type | Additional information |
|---|---|---|---|
| startRow | integer |
Required |
|
| startCol | integer |
Required |
Body Parameters
Worksheet| Name | Description | Type | Additional information |
|---|---|---|---|
| AutoFilters | Collection of Object |
None. |
|
| Cells | Collection of Collection of Object |
None. |
|
| Columns | Collection of Collection of Object |
None. |
|
| Charts | Collection of Object |
None. |
|
| Comments | Collection of Object |
None. |
|
| HPageBreaks | Collection of Object |
None. |
|
| HyperLinks | Collection of Object |
None. |
|
| PageSetup | PageSetup |
None. |
|
| Pictures | Collection of Object |
None. |
|
| Range | Collection of Object |
None. |
|
| Rows | Collection of Collection of Object |
None. |
|
| VPageBreaks | Collection of Object |
None. |
|
| Item | Collection of Object |
None. |
|
| Item | Collection of Object |
None. |
|
| Item | Collection of Object |
None. |
|
| AllocatedRange | Collection of Object |
None. |
|
| PrintRange | Collection of Object |
None. |
|
| MergedCells | Collection of Collection of Object |
None. |
|
| Workbook | Workbook |
None. |
|
| FormulaEngine | FormulaEngine |
None. |
|
| HasSheetCalculation | boolean |
None. |
|
| VerticalSplit | integer |
None. |
|
| HorizontalSplit | integer |
None. |
|
| FirstVisibleRow | integer |
None. |
|
| FirstVisibleColumn | integer |
None. |
|
| SelectionCount | integer |
None. |
|
| DVTable | Collection of Object |
None. |
|
| AutoFilters | IAutoFilters |
None. |
|
| ViewMode | ViewMode |
None. |
|
| Zoom | integer |
None. |
|
| ZoomScaleNormal | integer |
None. |
|
| ZoomScalePageBreakView | integer |
None. |
|
| ZoomScalePageLayoutView | integer |
None. |
|
| DefaultPrintRowHeight | integer |
None. |
|
| CellRecords | Dictionary of Object [key] and Object [value] |
None. |
|
| ConditionalFormats | Collection of Object |
None. |
|
| UseRangesCache | boolean |
None. |
|
| QuotedName | string |
None. |
|
| Version | ExcelVersion |
None. |
|
| HasMergedCells | boolean |
None. |
|
| Item | Collection of Object |
None. |
|
| Item | Collection of Object |
None. |
|
| Item | Collection of Object |
None. |
|
| ActivePane | integer |
None. |
|
| Cells | Collection of Collection of Object |
None. |
|
| Columns | Collection of Collection of Object |
None. |
|
| DisplayPageBreaks | boolean |
None. |
|
| OleObjects | Collection of Object |
None. |
|
| HasOleObjects | boolean |
None. |
|
| SparklineGroups | Collection of Object |
None. |
|
| HPageBreaks | Collection of Object |
None. |
|
| HyperLinks | IHyperLinks |
None. |
|
| IsDisplayZeros | boolean |
None. |
|
| GridLinesVisible | boolean |
None. |
|
| RowColumnHeadersVisible | boolean |
None. |
|
| IsStringsPreserved | boolean |
None. |
|
| MergedCells | Collection of Collection of Object |
None. |
|
| Names | Collection of Object |
None. |
|
| PageSetup | IPageSetup |
None. |
|
| AllocatedRange | Collection of Object |
None. |
|
| Rows | Collection of Collection of Object |
None. |
|
| IsFreezePanes | boolean |
None. |
|
| DefaultRowHeight | decimal number |
None. |
|
| StandardHeightFlag | boolean |
None. |
|
| DefaultColumnWidth | decimal number |
None. |
|
| Type | ExcelSheetType |
None. |
|
| Range | Collection of Object |
None. |
|
| VPageBreaks | Collection of Object |
None. |
|
| IsEmpty | boolean |
None. |
|
| AllocatedRangeIncludesFormatting | boolean |
None. |
|
| PivotTables | Collection of Object |
None. |
|
| ListObjects | Collection of Object |
None. |
|
| ProtectContents | boolean |
None. |
|
| TopLeftCell | Collection of Object |
None. |
|
| Name | string |
None. |
|
| IsSaved | boolean |
None. |
|
| HeaderFooterShapes | Collection of Object |
None. |
|
| Comments | Collection of Object |
None. |
|
| Charts | Collection of Object |
None. |
|
| Pictures | Collection of Object |
None. |
|
| CodeName | string |
None. |
|
| ProtectDrawingObjects | boolean |
None. |
|
| ProtectScenarios | boolean |
None. |
|
| IsPasswordProtected | boolean |
None. |
|
| IsParsed | boolean |
None. |
|
| IsParsing | boolean |
None. |
|
| IsSkipParsing | boolean |
None. |
|
| IsSupported | boolean |
None. |
|
| ParentWorkbook | XlsWorkbook |
None. |
|
| FirstRow | integer |
None. |
|
| FirstColumn | integer |
None. |
|
| LastRow | integer |
None. |
|
| LastColumn | integer |
None. |
|
| TabColorObject | OColor |
None. |
|
| TabKnownColor | ExcelColors |
None. |
|
| TabColor | Color |
None. |
|
| Workbook | IWorkbook |
None. |
|
| GridLineColor | ExcelColors |
None. |
|
| DefaultGridlineColor | boolean |
None. |
|
| IsRightToLeft | boolean |
None. |
|
| IsSelected | boolean |
None. |
|
| Index | integer |
None. |
|
| Protection | SheetProtectionType |
None. |
|
| Visibility | WorksheetVisibility |
None. |
|
| TopVisibleRow | integer |
None. |
|
| LeftVisibleColumn | integer |
None. |
|
| UnknownVmlShapes | boolean |
None. |
|
| TypedTextBoxes | Collection of Object |
None. |
|
| TypedLines | Collection of Object |
None. |
|
| TextBoxes | ITextBoxes |
None. |
|
| PrstGeomShapes | Collection of Object |
None. |
|
| TypedCheckBoxes | Collection of Object |
None. |
|
| TypedComboBoxes | Collection of Object |
None. |
|
| CheckBoxes | ICheckBoxes |
None. |
|
| RadioButtons | IRadioButtons |
None. |
|
| ComboBoxes | IComboBoxes |
None. |
|
| HasVmlShapes | boolean |
None. |
|
| VmlShapesCount | integer |
None. |
|
| IsTransitionEvaluation | boolean |
None. |
|
| HasPictures | boolean |
None. |
|
| SheetId | integer |
None. |
|
| RealIndex | integer |
None. |
|
| Parent | Object |
None. |
Request Formats
application/json, text/json, application/x-www-form-urlencoded
Sample:
Sample not available.
Response Information
Resource Description
integerResponse Formats
application/json, text/json
Sample:
1