Package | Description |
---|---|
com.aspose.cells.api |
Modifier and Type | Method and Description |
---|---|
SaaSposeResponse |
CellsApi.DeleteDecryptDocument(String name,
String storage,
String folder,
WorkbookEncryptionRequest body)
DeleteDecryptDocument
Decrypt document.
|
SaaSposeResponse |
CellsApi.DeleteDocumentUnProtectFromChanges(String name,
String storage,
String folder)
DeleteDocumentUnProtectFromChanges
Unprotect document from changes.
|
SaaSposeResponse |
CellsApi.DeleteUnProtectDocument(String name,
String storage,
String folder,
WorkbookProtectionRequest body)
DeleteUnProtectDocument
Unprotect document.
|
SaaSposeResponse |
CellsApi.DeleteWorkSheetBackground(String name,
String sheetName,
String folder,
String storage)
DeleteWorkSheetBackground
Set worksheet background image.
|
SaaSposeResponse |
CellsApi.DeleteWorksheetChartLegend(String name,
String sheetName,
Integer chartIndex,
String storage,
String folder)
DeleteWorksheetChartLegend
Hide legend in chart
|
SaaSposeResponse |
CellsApi.DeleteWorksheetChartTitle(String name,
String sheetName,
Integer chartIndex,
String storage,
String folder)
DeleteWorksheetChartTitle
Hide title in chart
|
SaaSposeResponse |
CellsApi.DeleteWorksheetClearCharts(String name,
String sheetName,
String storage,
String folder)
DeleteWorksheetClearCharts
Clear the charts.
|
SaaSposeResponse |
CellsApi.DeleteWorkSheetComment(String name,
String sheetName,
String cellName,
String storage,
String folder)
DeleteWorkSheetComment
Delete worksheet's cell comment.
|
SaaSposeResponse |
CellsApi.DeleteWorksheetFreezePanes(String name,
String sheetName,
Integer row,
Integer column,
Integer freezedRows,
Integer freezedColumns,
String folder,
String storage)
DeleteWorksheetFreezePanes
Unfreeze panes
|
SaaSposeResponse |
CellsApi.DeleteWorkSheetHyperlink(String name,
String sheetName,
Integer hyperlinkIndex,
String storage,
String folder)
DeleteWorkSheetHyperlink
Delete worksheet hyperlink by index.
|
SaaSposeResponse |
CellsApi.DeleteWorkSheetHyperlinks(String name,
String sheetName,
String storage,
String folder)
DeleteWorkSheetHyperlinks
Delete all hyperlinks in worksheet.
|
SaaSposeResponse |
CellsApi.DeleteWorksheetOleObject(String name,
String sheetName,
Integer oleObjectIndex,
String storage,
String folder)
DeleteWorksheetOleObject
Delete OLE object.
|
SaaSposeResponse |
CellsApi.DeleteWorksheetOleObjects(String name,
String sheetName,
String storage,
String folder)
DeleteWorksheetOleObjects
Delete all OLE objects.
|
SaaSposeResponse |
CellsApi.DeleteWorksheetPicture(String name,
String sheetName,
Integer pictureIndex,
String storage,
String folder)
DeleteWorksheetPicture
Delete a picture object in worksheet
|
SaaSposeResponse |
CellsApi.DeleteWorkSheetPictures(String name,
String sheetName,
String storage,
String folder)
DeleteWorkSheetPictures
Delete all pictures in worksheet.
|
SaaSposeResponse |
CellsApi.DeleteWorksheetPivotTable(String name,
String sheetName,
Integer pivotTableIndex,
String storage,
String folder)
DeleteWorksheetPivotTable
Delete worksheet pivot table by index
|
SaaSposeResponse |
CellsApi.DeleteWorksheetPivotTables(String name,
String sheetName,
String storage,
String folder)
DeleteWorksheetPivotTables
Delete worksheet pivot tables
|
SaaSposeResponse |
CellsApi.DeleteWorksheetRow(String name,
String sheetName,
Integer rowIndex,
String storage,
String folder)
DeleteWorksheetRow
Delete worksheet row.
|
SaaSposeResponse |
CellsApi.DeleteWorksheetRows(String name,
String sheetName,
Integer startrow,
Integer totalRows,
Boolean updateReference,
String storage,
String folder)
DeleteWorksheetRows
Delete several worksheet rows.
|
SaaSposeResponse |
CellsApi.PostAutofitWorkbookRows(String name,
Integer startRow,
Integer endRow,
Boolean onlyAuto,
String storage,
String folder,
AutoFitterOptions body)
PostAutofitWorkbookRows
Autofit workbook rows.
|
SaaSposeResponse |
CellsApi.PostAutofitWorksheetRows(String name,
String sheetName,
Integer startRow,
Integer endRow,
Boolean onlyAuto,
String storage,
String folder,
AutoFitterOptions body)
PostAutofitWorksheetRows
Autofit worksheet rows.
|
SaaSposeResponse |
CellsApi.PostClearContents(String name,
String sheetName,
String range,
Integer startRow,
Integer startColumn,
Integer endRow,
Integer endColumn,
String storage,
String folder)
PostClearContents
Clear cells contents.
|
SaaSposeResponse |
CellsApi.PostClearFormats(String name,
String sheetName,
String range,
Integer startRow,
Integer startColumn,
Integer endRow,
Integer endColumn,
String storage,
String folder)
PostClearFormats
Clear cells contents.
|
SaaSposeResponse |
CellsApi.PostColumnStyle(String name,
String sheetName,
Integer columnIndex,
String storage,
String folder,
Style body)
PostColumnStyle
Set column style
|
SaaSposeResponse |
CellsApi.PostCopyCellIntoCell(String name,
String destCellName,
String sheetName,
String worksheet,
String cellname,
Integer row,
Integer column,
String storage,
String folder)
PostCopyCellIntoCell
Copy cell into cell
|
SaaSposeResponse |
CellsApi.PostCopyWorksheet(String name,
String sheetName,
String sourceSheet,
String folder,
String storage)
PostCopyWorksheet
Copy worksheet
|
SaaSposeResponse |
CellsApi.PostCopyWorksheetColumns(String name,
String sheetName,
Integer sourceColumnIndex,
Integer destinationColumnIndex,
Integer columnNumber,
String worksheet,
String storage,
String folder)
PostCopyWorksheetColumns
Copy worksheet columns.
|
SaaSposeResponse |
CellsApi.PostCopyWorksheetRows(String name,
String sheetName,
Integer sourceRowIndex,
Integer destinationRowIndex,
Integer rowNumber,
String worksheet,
String storage,
String folder)
PostCopyWorksheetRows
Copy worksheet rows.
|
SaaSposeResponse |
CellsApi.PostEncryptDocument(String name,
String storage,
String folder,
WorkbookEncryptionRequest body)
PostEncryptDocument
Encript document.
|
SaaSposeResponse |
CellsApi.PostGroupWorksheetColumns(String name,
String sheetName,
Integer firstIndex,
Integer lastIndex,
Boolean hide,
String storage,
String folder)
PostGroupWorksheetColumns
Group worksheet columns.
|
SaaSposeResponse |
CellsApi.PostGroupWorksheetRows(String name,
String sheetName,
Integer firstIndex,
Integer lastIndex,
Boolean hide,
String storage,
String folder)
PostGroupWorksheetRows
Group worksheet rows.
|
SaaSposeResponse |
CellsApi.PostHideWorksheetColumns(String name,
String sheetName,
Integer startColumn,
Integer totalColumns,
String storage,
String folder)
PostHideWorksheetColumns
Hide worksheet columns.
|
SaaSposeResponse |
CellsApi.PostHideWorksheetRows(String name,
String sheetName,
Integer startrow,
Integer totalRows,
String storage,
String folder)
PostHideWorksheetRows
Hide worksheet rows.
|
SaaSposeResponse |
CellsApi.PostImportData(String name,
String storage,
String folder,
ImportOption body)
PostImportData
Import data to workbook.
|
SaaSposeResponse |
CellsApi.PostPivotTableCellStyle(String name,
String sheetName,
Integer pivotTableIndex,
Integer column,
Integer row,
String storage,
String folder,
Style body)
PostPivotTableCellStyle
Update cell style for pivot table
|
SaaSposeResponse |
CellsApi.PostPivotTableStyle(String name,
String sheetName,
Integer pivotTableIndex,
String storage,
String folder,
Style body)
PostPivotTableStyle
Update style for pivot table
|
SaaSposeResponse |
CellsApi.PostProtectDocument(String name,
String storage,
String folder,
WorkbookProtectionRequest body)
PostProtectDocument
Protect document.
|
SaaSposeResponse |
CellsApi.PostRenameWorksheet(String name,
String sheetName,
String newname,
String folder,
String storage)
PostRenameWorksheet
Rename worksheet
|
SaaSposeResponse |
CellsApi.PostRowStyle(String name,
String sheetName,
Integer rowIndex,
String storage,
String folder,
Style body)
PostRowStyle
Set row style.
|
SaaSposeResponse |
CellsApi.PostSetCellRangeValue(String name,
String sheetName,
String cellarea,
String value,
String type,
String storage,
String folder)
PostSetCellRangeValue
Set cell range value
|
SaaSposeResponse |
CellsApi.PostUngroupWorksheetColumns(String name,
String sheetName,
Integer firstIndex,
Integer lastIndex,
String storage,
String folder)
PostUngroupWorksheetColumns
Ungroup worksheet columns.
|
SaaSposeResponse |
CellsApi.PostUngroupWorksheetRows(String name,
String sheetName,
Integer firstIndex,
Integer lastIndex,
Boolean isAll,
String storage,
String folder)
PostUngroupWorksheetRows
Ungroup worksheet rows.
|
SaaSposeResponse |
CellsApi.PostUnhideWorksheetColumns(String name,
String sheetName,
Integer startcolumn,
Integer totalColumns,
Double width,
String storage,
String folder)
PostUnhideWorksheetColumns
Unhide worksheet columns.
|
SaaSposeResponse |
CellsApi.PostUnhideWorksheetRows(String name,
String sheetName,
Integer startrow,
Integer totalRows,
Double height,
String storage,
String folder)
PostUnhideWorksheetRows
Unhide worksheet rows.
|
SaaSposeResponse |
CellsApi.PostUpdateWorksheetOleObject(String name,
String sheetName,
Integer oleObjectIndex,
String storage,
String folder,
OleObject body)
PostUpdateWorksheetOleObject
Update OLE object.
|
SaaSposeResponse |
CellsApi.PostUpdateWorksheetRangeStyle(String name,
String sheetName,
String range,
String storage,
String folder,
Style body)
PostUpdateWorksheetRangeStyle
Update cell's range style.
|
SaaSposeResponse |
CellsApi.PostWorkbookCalculateFormula(String name,
String storage,
String folder)
PostWorkbookCalculateFormula
Calculate all formulas in workbook.
|
SaaSposeResponse |
CellsApi.PostWorkSheetComment(String name,
String sheetName,
String cellName,
String storage,
String folder,
Comment body)
PostWorkSheetComment
Update worksheet's cell comment.
|
SaaSposeResponse |
CellsApi.PostWorksheetMerge(String name,
String sheetName,
Integer startRow,
Integer startColumn,
Integer totalRows,
Integer totalColumns,
String storage,
String folder)
PostWorksheetMerge
Merge cells.
|
SaaSposeResponse |
CellsApi.PostWorksheetRangeSort(String name,
String sheetName,
String cellArea,
String storage,
String folder,
DataSorter body)
PostWorksheetRangeSort
Sort worksheet range.
|
SaaSposeResponse |
CellsApi.PostWorksheetUnmerge(String name,
String sheetName,
Integer startRow,
Integer startColumn,
Integer totalRows,
Integer totalColumns,
String storage,
String folder)
PostWorksheetUnmerge
Unmerge cells.
|
SaaSposeResponse |
CellsApi.PutDocumentProtectFromChanges(String name,
String storage,
String folder,
PasswordRequest body)
PutDocumentProtectFromChanges
Protect document from changes.
|
SaaSposeResponse |
CellsApi.PutInsertWorksheetRows(String name,
String sheetName,
Integer startrow,
Integer totalRows,
Boolean updateReference,
String storage,
String folder)
PutInsertWorksheetRows
Insert several new worksheet rows.
|
SaaSposeResponse |
CellsApi.PutPivotTableField(String name,
String sheetName,
Integer pivotTableIndex,
String pivotFieldType,
String storage,
String folder,
PivotTableFieldRequest body)
PutPivotTableField
Add pivot field into into pivot table
|
SaaSposeResponse |
CellsApi.PutWorkSheetBackground(String name,
String sheetName,
String folder,
String storage,
File file)
PutWorkSheetBackground
Set worksheet background image.
|
SaaSposeResponse |
CellsApi.PutWorksheetChartLegend(String name,
String sheetName,
Integer chartIndex,
String storage,
String folder)
PutWorksheetChartLegend
Show legend in chart
|
SaaSposeResponse |
CellsApi.PutWorksheetFreezePanes(String name,
String sheetName,
Integer row,
Integer column,
Integer freezedRows,
Integer freezedColumns,
String folder,
String storage)
PutWorksheetFreezePanes
Set freeze panes
|
Copyright © 2015. All rights reserved.