public class CellsApi extends Object
Constructor and Description |
---|
CellsApi(String apiKey,
String appSid) |
CellsApi(String apiKey,
String appSid,
boolean isDebug) |
CellsApi(String basePath,
String apiKey,
String appSid) |
CellsApi(String basePath,
String apiKey,
String appSid,
boolean isDebug) |
Modifier and Type | Method and Description |
---|---|
SaaSposeResponse |
DeleteDecryptDocument(String name,
String storage,
String folder,
WorkbookEncryptionRequest body)
DeleteDecryptDocument
Decrypt document.
|
CellsDocumentPropertiesResponse |
DeleteDocumentProperties(String name,
String storage,
String folder)
DeleteDocumentProperties
Delete all custom document properties and clean built-in ones.
|
CellsDocumentPropertiesResponse |
DeleteDocumentProperty(String name,
String propertyName,
String storage,
String folder)
DeleteDocumentProperty
Delete document property.
|
SaaSposeResponse |
DeleteDocumentUnProtectFromChanges(String name,
String storage,
String folder)
DeleteDocumentUnProtectFromChanges
Unprotect document from changes.
|
SaaSposeResponse |
DeleteUnProtectDocument(String name,
String storage,
String folder,
WorkbookProtectionRequest body)
DeleteUnProtectDocument
Unprotect document.
|
WorksheetResponse |
DeleteUnprotectWorksheet(String name,
String sheetName,
String storage,
String folder,
ProtectSheetParameter body)
DeleteUnprotectWorksheet
Unprotect worksheet.
This method will only work on JDK8+ because of JDK-7157360 bug - HttpURLConnection: HTTP method DELETE doesn't support |
WorksheetsResponse |
DeleteWorksheet(String name,
String sheetName,
String storage,
String folder)
DeleteWorksheet
Delete worksheet.
|
SaaSposeResponse |
DeleteWorkSheetBackground(String name,
String sheetName,
String folder,
String storage)
DeleteWorkSheetBackground
Set worksheet background image.
|
SaaSposeResponse |
DeleteWorksheetChartLegend(String name,
String sheetName,
Integer chartIndex,
String storage,
String folder)
DeleteWorksheetChartLegend
Hide legend in chart
|
SaaSposeResponse |
DeleteWorksheetChartTitle(String name,
String sheetName,
Integer chartIndex,
String storage,
String folder)
DeleteWorksheetChartTitle
Hide title in chart
|
SaaSposeResponse |
DeleteWorksheetClearCharts(String name,
String sheetName,
String storage,
String folder)
DeleteWorksheetClearCharts
Clear the charts.
|
ColumnsResponse |
DeleteWorksheetColumns(String name,
String sheetName,
Integer columnIndex,
Integer columns,
Boolean updateReference,
String storage,
String folder)
DeleteWorksheetColumns
Delete worksheet columns.
|
SaaSposeResponse |
DeleteWorkSheetComment(String name,
String sheetName,
String cellName,
String storage,
String folder)
DeleteWorkSheetComment
Delete worksheet's cell comment.
|
ChartsResponse |
DeleteWorksheetDeleteChart(String name,
String sheetName,
Integer chartIndex,
String storage,
String folder)
DeleteWorksheetDeleteChart
Delete worksheet chart by index.
|
SaaSposeResponse |
DeleteWorksheetFreezePanes(String name,
String sheetName,
Integer row,
Integer column,
Integer freezedRows,
Integer freezedColumns,
String folder,
String storage)
DeleteWorksheetFreezePanes
Unfreeze panes
|
SaaSposeResponse |
DeleteWorkSheetHyperlink(String name,
String sheetName,
Integer hyperlinkIndex,
String storage,
String folder)
DeleteWorkSheetHyperlink
Delete worksheet hyperlink by index.
|
SaaSposeResponse |
DeleteWorkSheetHyperlinks(String name,
String sheetName,
String storage,
String folder)
DeleteWorkSheetHyperlinks
Delete all hyperlinks in worksheet.
|
SaaSposeResponse |
DeleteWorksheetOleObject(String name,
String sheetName,
Integer oleObjectIndex,
String storage,
String folder)
DeleteWorksheetOleObject
Delete OLE object.
|
SaaSposeResponse |
DeleteWorksheetOleObjects(String name,
String sheetName,
String storage,
String folder)
DeleteWorksheetOleObjects
Delete all OLE objects.
|
SaaSposeResponse |
DeleteWorksheetPicture(String name,
String sheetName,
Integer pictureIndex,
String storage,
String folder)
DeleteWorksheetPicture
Delete a picture object in worksheet
|
SaaSposeResponse |
DeleteWorkSheetPictures(String name,
String sheetName,
String storage,
String folder)
DeleteWorkSheetPictures
Delete all pictures in worksheet.
|
SaaSposeResponse |
DeleteWorksheetPivotTable(String name,
String sheetName,
Integer pivotTableIndex,
String storage,
String folder)
DeleteWorksheetPivotTable
Delete worksheet pivot table by index
|
SaaSposeResponse |
DeleteWorksheetPivotTables(String name,
String sheetName,
String storage,
String folder)
DeleteWorksheetPivotTables
Delete worksheet pivot tables
|
SaaSposeResponse |
DeleteWorksheetRow(String name,
String sheetName,
Integer rowIndex,
String storage,
String folder)
DeleteWorksheetRow
Delete worksheet row.
|
SaaSposeResponse |
DeleteWorksheetRows(String name,
String sheetName,
Integer startrow,
Integer totalRows,
Boolean updateReference,
String storage,
String folder)
DeleteWorksheetRows
Delete several worksheet rows.
|
ValidationResponse |
DeleteWorkSheetValidation(String name,
String sheetName,
Integer validationIndex,
String storage,
String folder)
DeleteWorkSheetValidation
Delete worksheet validation by index.
|
String |
getBasePath() |
ChartAreaResponse |
GetChartArea(String name,
String sheetName,
Integer chartIndex,
String storage,
String folder)
GetChartArea
Get chart area info.
|
LineResponse |
GetChartAreaBorder(String name,
String sheetName,
Integer chartIndex,
String storage,
String folder)
GetChartAreaBorder
Get chart area border info.
|
FillFormatResponse |
GetChartAreaFillFormat(String name,
String sheetName,
Integer chartIndex,
String storage,
String folder)
GetChartAreaFillFormat
Get chart area fill format info.
|
CellsDocumentPropertiesResponse |
GetDocumentProperties(String name,
String storage,
String folder)
GetDocumentProperties
Read document properties.
|
CellsDocumentPropertyResponse |
GetDocumentProperty(String name,
String propertyName,
String storage,
String folder)
GetDocumentProperty
Read document property by name.
|
BarcodeResponseList |
GetExtractBarcodes(String name,
String sheetName,
Integer pictureNumber,
String storage,
String folder)
GetExtractBarcodes
Extract barcodes from worksheet picture.
|
ApiInvoker |
getInvoker() |
WorkbookResponse |
GetWorkBook(String name,
String password,
Boolean isAutoFit,
String storage,
String folder)
GetWorkBook
Read workbook info or export.
|
StyleResponse |
GetWorkBookDefaultStyle(String name,
String storage,
String folder)
GetWorkBookDefaultStyle
Read workbook default style info.
|
NameResponse |
GetWorkBookName(String name,
String nameName,
String storage,
String folder)
GetWorkBookName
Read workbook's name.
|
NamesResponse |
GetWorkBookNames(String name,
String storage,
String folder)
GetWorkBookNames
Read workbook's names.
|
TextItemsResponse |
GetWorkBookTextItems(String name,
String storage,
String folder)
GetWorkBookTextItems
Read workbook's text items.
|
ResponseMessage |
GetWorkBookWithFormat(String name,
String format,
String password,
Boolean isAutoFit,
String storage,
String folder,
String outPath)
GetWorkBookWithFormat
EExport workbook to some format.
|
ResponseMessage |
GetWorkSheet(String name,
String sheetName,
Integer verticalResolution,
Integer horizontalResolution,
String storage,
String folder)
GetWorkSheet
Read worksheet info or export.
|
AutoShapeResponse |
GetWorksheetAutoshape(String name,
String sheetName,
Integer autoshapeNumber,
String storage,
String folder)
GetWorksheetAutoshape
Get autoshape info.
|
AutoShapesResponse |
GetWorksheetAutoshapes(String name,
String sheetName,
String storage,
String folder)
GetWorksheetAutoshapes
Get worksheet autoshapes info.
|
ResponseMessage |
GetWorksheetAutoshapeWithFormat(String name,
String sheetName,
Integer autoshapeNumber,
String format,
String storage,
String folder)
GetWorksheetAutoshapeWithFormat
Get autoshape info in some format.
|
SingleValueResponse |
GetWorkSheetCalculateFormula(String name,
String sheetName,
String formula,
String storage,
String folder)
GetWorkSheetCalculateFormula
Calculate formula value.
|
CellResponse |
GetWorksheetCell(String name,
String sheetName,
String cellOrMethodName,
String storage,
String folder)
GetWorksheetCell
Read cell data by cell's name.
|
Integer |
GetWorksheetCellProperty(String name,
String sheetName,
String cellOrMethodName,
String storage,
String folder)
GetWorksheetCellProperty
Read cell data property by cell's name.
|
CellsResponse |
GetWorksheetCells(String name,
String sheetName,
Integer offest,
Integer count,
String storage,
String folder)
GetWorksheetCells
Get cells info.
|
StyleResponse |
GetWorksheetCellStyle(String name,
String sheetName,
String cellName,
String storage,
String folder)
GetWorksheetCellStyle
Read cell's style info.
|
ChartResponse |
GetWorksheetChart(String name,
String sheetName,
Integer chartNumber,
String storage,
String folder)
GetWorksheetChart
Get chart info.
|
LegendResponse |
GetWorksheetChartLegend(String name,
String sheetName,
Integer chartIndex,
String storage,
String folder)
GetWorksheetChartLegend
Get chart legend
|
ChartsResponse |
GetWorksheetCharts(String name,
String sheetName,
String storage,
String folder)
GetWorksheetCharts
Get worksheet charts info.
|
ResponseMessage |
GetWorksheetChartWithFormat(String name,
String sheetName,
Integer chartNumber,
String format,
String storage,
String folder)
GetWorksheetChartWithFormat
Get chart in some format.
|
ColumnResponse |
GetWorksheetColumn(String name,
String sheetName,
Integer columnIndex,
String storage,
String folder)
GetWorksheetColumn
Read worksheet column data by column's index.
|
ColumnsResponse |
GetWorksheetColumns(String name,
String sheetName,
String storage,
String folder)
GetWorksheetColumns
Read worksheet columns info.
|
CommentResponse |
GetWorkSheetComment(String name,
String sheetName,
String cellName,
String storage,
String folder)
GetWorkSheetComment
Get worksheet comment by cell name.
|
CommentsResponse |
GetWorkSheetComments(String name,
String sheetName,
String storage,
String folder)
GetWorkSheetComments
Get worksheet comments.
|
HyperlinkResponse |
GetWorkSheetHyperlink(String name,
String sheetName,
Integer hyperlinkIndex,
String storage,
String folder)
GetWorkSheetHyperlink
Get worksheet hyperlink by index.
|
HyperlinksResponse |
GetWorkSheetHyperlinks(String name,
String sheetName,
String storage,
String folder)
GetWorkSheetHyperlinks
Get worksheet hyperlinks.
|
MergedCellResponse |
GetWorkSheetMergedCell(String name,
String sheetName,
Integer mergedCellIndex,
String storage,
String folder)
GetWorkSheetMergedCell
Get worksheet merged cell by its index.
|
MergedCellsResponse |
GetWorkSheetMergedCells(String name,
String sheetName,
String storage,
String folder)
GetWorkSheetMergedCells
Get worksheet merged cells.
|
OleObjectResponse |
GetWorksheetOleObject(String name,
String sheetName,
Integer objectNumber,
String storage,
String folder)
GetWorksheetOleObject
Get OLE object info.
|
OleObjectsResponse |
GetWorksheetOleObjects(String name,
String sheetName,
String storage,
String folder)
GetWorksheetOleObjects
Get worksheet OLE objects info.
|
ResponseMessage |
GetWorksheetOleObjectWithFormat(String name,
String sheetName,
Integer objectNumber,
String format,
String storage,
String folder)
GetWorksheetOleObjectWithFormat
Get OLE object info or get the OLE object in some format.
|
PictureResponse |
GetWorksheetPicture(String name,
String sheetName,
Integer pictureNumber,
String storage,
String folder)
GetWorksheetPicture
GRead worksheet picture by number.
|
PicturesResponse |
GetWorksheetPictures(String name,
String sheetName,
String storage,
String folder)
GetWorksheetPictures
Read worksheet pictures.
|
ResponseMessage |
GetWorksheetPictureWithFormat(String name,
String sheetName,
Integer pictureNumber,
String format,
String storage,
String folder)
GetWorksheetPictureWithFormat
GRead worksheet picture by number.
|
PivotTableResponse |
GetWorksheetPivotTable(String name,
String sheetName,
Integer pivottableIndex,
String storage,
String folder)
GetWorksheetPivotTable
Get worksheet pivottable info by index.
|
PivotTablesResponse |
GetWorksheetPivotTables(String name,
String sheetName,
String storage,
String folder)
GetWorksheetPivotTables
Get worksheet pivottables info.
|
RowResponse |
GetWorksheetRow(String name,
String sheetName,
Integer rowIndex,
String storage,
String folder)
GetWorksheetRow
Read worksheet row data by row's index.
|
RowsResponse |
GetWorksheetRows(String name,
String sheetName,
String storage,
String folder)
GetWorksheetRows
Read worksheet rows info.
|
WorksheetsResponse |
GetWorkSheets(String name,
String storage,
String folder)
GetWorkSheets
Read worksheets info.
|
TextItemsResponse |
GetWorkSheetTextItems(String name,
String sheetName,
String storage,
String folder)
GetWorkSheetTextItems
Get worksheet text items.
|
ValidationResponse |
GetWorkSheetValidation(String name,
String sheetName,
Integer validationIndex,
String storage,
String folder)
GetWorkSheetValidation
Get worksheet validation by index.
|
ValidationsResponse |
GetWorkSheetValidations(String name,
String sheetName,
String storage,
String folder)
GetWorkSheetValidations
Get worksheet validations.
|
ResponseMessage |
GetWorkSheetWithFormat(String name,
String sheetName,
String format,
Integer verticalResolution,
Integer horizontalResolution,
String storage,
String folder)
GetWorkSheetWithFormat
Read worksheet info or export.
|
SaaSposeResponse |
PostAutofitWorkbookRows(String name,
Integer startRow,
Integer endRow,
Boolean onlyAuto,
String storage,
String folder,
AutoFitterOptions body)
PostAutofitWorkbookRows
Autofit workbook rows.
|
SaaSposeResponse |
PostAutofitWorksheetRows(String name,
String sheetName,
Integer startRow,
Integer endRow,
Boolean onlyAuto,
String storage,
String folder,
AutoFitterOptions body)
PostAutofitWorksheetRows
Autofit worksheet rows.
|
SaaSposeResponse |
PostClearContents(String name,
String sheetName,
String range,
Integer startRow,
Integer startColumn,
Integer endRow,
Integer endColumn,
String storage,
String folder)
PostClearContents
Clear cells contents.
|
SaaSposeResponse |
PostClearFormats(String name,
String sheetName,
String range,
Integer startRow,
Integer startColumn,
Integer endRow,
Integer endColumn,
String storage,
String folder)
PostClearFormats
Clear cells contents.
|
SaaSposeResponse |
PostColumnStyle(String name,
String sheetName,
Integer columnIndex,
String storage,
String folder,
Style body)
PostColumnStyle
Set column style
|
SaaSposeResponse |
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 |
PostCopyWorksheet(String name,
String sheetName,
String sourceSheet,
String folder,
String storage)
PostCopyWorksheet
Copy worksheet
|
SaaSposeResponse |
PostCopyWorksheetColumns(String name,
String sheetName,
Integer sourceColumnIndex,
Integer destinationColumnIndex,
Integer columnNumber,
String worksheet,
String storage,
String folder)
PostCopyWorksheetColumns
Copy worksheet columns.
|
SaaSposeResponse |
PostCopyWorksheetRows(String name,
String sheetName,
Integer sourceRowIndex,
Integer destinationRowIndex,
Integer rowNumber,
String worksheet,
String storage,
String folder)
PostCopyWorksheetRows
Copy worksheet rows.
|
SaveResponse |
PostDocumentSaveAs(String name,
String newfilename,
Boolean isAutoFitRows,
Boolean isAutoFitColumns,
String storage,
String folder,
SaveOptions body)
PostDocumentSaveAs
Convert document and save result to storage.
|
SaaSposeResponse |
PostEncryptDocument(String name,
String storage,
String folder,
WorkbookEncryptionRequest body)
PostEncryptDocument
Encript document.
|
SaaSposeResponse |
PostGroupWorksheetColumns(String name,
String sheetName,
Integer firstIndex,
Integer lastIndex,
Boolean hide,
String storage,
String folder)
PostGroupWorksheetColumns
Group worksheet columns.
|
SaaSposeResponse |
PostGroupWorksheetRows(String name,
String sheetName,
Integer firstIndex,
Integer lastIndex,
Boolean hide,
String storage,
String folder)
PostGroupWorksheetRows
Group worksheet rows.
|
SaaSposeResponse |
PostHideWorksheetColumns(String name,
String sheetName,
Integer startColumn,
Integer totalColumns,
String storage,
String folder)
PostHideWorksheetColumns
Hide worksheet columns.
|
SaaSposeResponse |
PostHideWorksheetRows(String name,
String sheetName,
Integer startrow,
Integer totalRows,
String storage,
String folder)
PostHideWorksheetRows
Hide worksheet rows.
|
SaaSposeResponse |
PostImportData(String name,
String storage,
String folder,
ImportOption body)
PostImportData
Import data to workbook.
|
WorksheetsResponse |
PostMoveWorksheet(String name,
String sheetName,
String storage,
String folder,
WorksheetMovingRequest body)
PostMoveWorksheet
Move worksheet.
|
SaaSposeResponse |
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 |
PostPivotTableStyle(String name,
String sheetName,
Integer pivotTableIndex,
String storage,
String folder,
Style body)
PostPivotTableStyle
Update style for pivot table
|
SaaSposeResponse |
PostProtectDocument(String name,
String storage,
String folder,
WorkbookProtectionRequest body)
PostProtectDocument
Protect document.
|
SaaSposeResponse |
PostRenameWorksheet(String name,
String sheetName,
String newname,
String folder,
String storage)
PostRenameWorksheet
Rename worksheet
|
SaaSposeResponse |
PostRowStyle(String name,
String sheetName,
Integer rowIndex,
String storage,
String folder,
Style body)
PostRowStyle
Set row style.
|
CellResponse |
PostSetCellHtmlString(String name,
String sheetName,
String cellName,
String storage,
String folder,
File file)
PostSetCellHtmlString
Set htmlstring value into cell
|
SaaSposeResponse |
PostSetCellRangeValue(String name,
String sheetName,
String cellarea,
String value,
String type,
String storage,
String folder)
PostSetCellRangeValue
Set cell range value
|
ColumnResponse |
PostSetWorksheetColumnWidth(String name,
String sheetName,
Integer columnIndex,
Double width,
String storage,
String folder)
PostSetWorksheetColumnWidth
Set worksheet column width.
|
SaaSposeResponse |
PostUngroupWorksheetColumns(String name,
String sheetName,
Integer firstIndex,
Integer lastIndex,
String storage,
String folder)
PostUngroupWorksheetColumns
Ungroup worksheet columns.
|
SaaSposeResponse |
PostUngroupWorksheetRows(String name,
String sheetName,
Integer firstIndex,
Integer lastIndex,
Boolean isAll,
String storage,
String folder)
PostUngroupWorksheetRows
Ungroup worksheet rows.
|
SaaSposeResponse |
PostUnhideWorksheetColumns(String name,
String sheetName,
Integer startcolumn,
Integer totalColumns,
Double width,
String storage,
String folder)
PostUnhideWorksheetColumns
Unhide worksheet columns.
|
SaaSposeResponse |
PostUnhideWorksheetRows(String name,
String sheetName,
Integer startrow,
Integer totalRows,
Double height,
String storage,
String folder)
PostUnhideWorksheetRows
Unhide worksheet rows.
|
StyleResponse |
PostUpdateWorksheetCellStyle(String name,
String sheetName,
String cellName,
String storage,
String folder,
Style body)
PostUpdateWorksheetCellStyle
Update cell's style.
|
SaaSposeResponse |
PostUpdateWorksheetOleObject(String name,
String sheetName,
Integer oleObjectIndex,
String storage,
String folder,
OleObject body)
PostUpdateWorksheetOleObject
Update OLE object.
|
WorksheetResponse |
PostUpdateWorksheetProperty(String name,
String sheetName,
String folder,
String storage,
Worksheet body)
PostUpdateWorksheetProperty
Update worksheet property
|
SaaSposeResponse |
PostUpdateWorksheetRangeStyle(String name,
String sheetName,
String range,
String storage,
String folder,
Style body)
PostUpdateWorksheetRangeStyle
Update cell's range style.
|
RowResponse |
PostUpdateWorksheetRow(String name,
String sheetName,
Integer rowIndex,
Double height,
String storage,
String folder)
PostUpdateWorksheetRow
Update worksheet row.
|
SaaSposeResponse |
PostWorkbookCalculateFormula(String name,
String storage,
String folder)
PostWorkbookCalculateFormula
Calculate all formulas in workbook.
|
ResponseMessage |
PostWorkbookGetSmartMarkerResult(String name,
String xmlFile,
String storage,
String folder,
String outPath,
File file)
PostWorkbookGetSmartMarkerResult
Smart marker processing result.
|
WorkbookResponse |
PostWorkbooksMerge(String name,
String mergeWith,
String storage,
String folder)
PostWorkbooksMerge
Merge workbooks.
|
SplitResultResponse |
PostWorkbookSplit(String name,
String format,
Integer from,
Integer to,
Integer horizontalResolution,
Integer verticalResolution,
String storage,
String folder)
PostWorkbookSplit
Split workbook.
|
WorkbookReplaceResponse |
PostWorkbooksTextReplace(String name,
String oldValue,
String newValue,
String storage,
String folder)
PostWorkbooksTextReplace
Replace text.
|
TextItemsResponse |
PostWorkbooksTextSearch(String name,
String text,
String storage,
String folder)
PostWorkbooksTextSearch
Search text.
|
CellResponse |
PostWorksheetCellSetValue(String name,
String sheetName,
String cellName,
String value,
String type,
String formula,
String storage,
String folder)
PostWorksheetCellSetValue
Set cell value.
|
LegendResponse |
PostWorksheetChartLegend(String name,
String sheetName,
Integer chartIndex,
String storage,
String folder,
Legend body)
PostWorksheetChartLegend
Update chart legend
|
TitleResponse |
PostWorksheetChartTitle(String name,
String sheetName,
Integer chartIndex,
String storage,
String folder,
Title body)
PostWorksheetChartTitle
Update chart title
|
SaaSposeResponse |
PostWorkSheetComment(String name,
String sheetName,
String cellName,
String storage,
String folder,
Comment body)
PostWorkSheetComment
Update worksheet's cell comment.
|
HyperlinkResponse |
PostWorkSheetHyperlink(String name,
String sheetName,
Integer hyperlinkIndex,
String storage,
String folder,
Hyperlink body)
PostWorkSheetHyperlink
Update worksheet hyperlink by index.
|
SaaSposeResponse |
PostWorksheetMerge(String name,
String sheetName,
Integer startRow,
Integer startColumn,
Integer totalRows,
Integer totalColumns,
String storage,
String folder)
PostWorksheetMerge
Merge cells.
|
PictureResponse |
PostWorkSheetPicture(String name,
String sheetName,
Integer pictureIndex,
String storage,
String folder,
Picture body)
PostWorkSheetPicture
Update worksheet picture by index.
|
SaaSposeResponse |
PostWorksheetRangeSort(String name,
String sheetName,
String cellArea,
String storage,
String folder,
DataSorter body)
PostWorksheetRangeSort
Sort worksheet range.
|
TextItemsResponse |
PostWorkSheetTextSearch(String name,
String sheetName,
String text,
String storage,
String folder)
PostWorkSheetTextSearch
Search text.
|
SaaSposeResponse |
PostWorksheetUnmerge(String name,
String sheetName,
Integer startRow,
Integer startColumn,
Integer totalRows,
Integer totalColumns,
String storage,
String folder)
PostWorksheetUnmerge
Unmerge cells.
|
ValidationResponse |
PostWorkSheetValidation(String name,
String sheetName,
Integer validationIndex,
String storage,
String folder,
File file)
PostWorkSheetValidation
Update worksheet validation by index.
|
WorksheetReplaceResponse |
PostWorsheetTextReplace(String name,
String sheetName,
String oldValue,
String newValue,
String storage,
String folder)
PostWorsheetTextReplace
Replace text.
|
WorksheetsResponse |
PutAddNewWorksheet(String name,
String sheetName,
String storage,
String folder)
PutAddNewWorksheet
Add new worksheet.
|
WorksheetResponse |
PutChangeVisibilityWorksheet(String name,
String sheetName,
Boolean isVisible,
String storage,
String folder)
PutChangeVisibilityWorksheet
Change worksheet visibility.
|
ResponseMessage |
PutConvertWorkBook(String format,
String password,
String outPath,
File file,
Object data)
PutConvertWorkBook
Convert workbook from request content to some format.
|
CellsDocumentPropertyResponse |
PutDocumentProperty(String name,
String propertyName,
String storage,
String folder,
CellsDocumentProperty body)
PutDocumentProperty
Set/create document property.
|
SaaSposeResponse |
PutDocumentProtectFromChanges(String name,
String storage,
String folder,
PasswordRequest body)
PutDocumentProtectFromChanges
Protect document from changes.
|
ColumnsResponse |
PutInsertWorksheetColumns(String name,
String sheetName,
Integer columnIndex,
Integer columns,
Boolean updateReference,
String storage,
String folder)
PutInsertWorksheetColumns
Insert worksheet columns.
|
RowResponse |
PutInsertWorksheetRow(String name,
String sheetName,
Integer rowIndex,
String storage,
String folder)
PutInsertWorksheetRow
Insert new worksheet row.
|
SaaSposeResponse |
PutInsertWorksheetRows(String name,
String sheetName,
Integer startrow,
Integer totalRows,
Boolean updateReference,
String storage,
String folder)
PutInsertWorksheetRows
Insert several new worksheet rows.
|
SaaSposeResponse |
PutPivotTableField(String name,
String sheetName,
Integer pivotTableIndex,
String pivotFieldType,
String storage,
String folder,
PivotTableFieldRequest body)
PutPivotTableField
Add pivot field into into pivot table
|
WorksheetResponse |
PutProtectWorksheet(String name,
String sheetName,
String storage,
String folder,
ProtectSheetParameter body)
PutProtectWorksheet
Protect worksheet.
|
WorkbookResponse |
PutWorkbookCreate(String name,
String templateFile,
String dataFile,
String storage,
String folder,
File file)
PutWorkbookCreate
Create new workbook using deferent methods.
|
ChartsResponse |
PutWorksheetAddChart(String name,
String sheetName,
String chartType,
Integer upperLeftRow,
Integer upperLeftColumn,
Integer lowerRightRow,
Integer lowerRightColumn,
String area,
Boolean isVertical,
String categoryData,
Boolean isAutoGetSerialName,
String title,
String storage,
String folder)
PutWorksheetAddChart
Add new chart to worksheet.
|
PicturesResponse |
PutWorksheetAddPicture(String name,
String sheetName,
Integer upperLeftRow,
Integer upperLeftColumn,
Integer lowerRightRow,
Integer lowerRightColumn,
String picturePath,
String storage,
String folder,
File file)
PutWorksheetAddPicture
Add a new worksheet picture.
|
SaaSposeResponse |
PutWorkSheetBackground(String name,
String sheetName,
String folder,
String storage,
File file)
PutWorkSheetBackground
Set worksheet background image.
|
SaaSposeResponse |
PutWorksheetChartLegend(String name,
String sheetName,
Integer chartIndex,
String storage,
String folder)
PutWorksheetChartLegend
Show legend in chart
|
TitleResponse |
PutWorksheetChartTitle(String name,
String sheetName,
Integer chartIndex,
String storage,
String folder,
Title body)
PutWorksheetChartTitle
Add chart title / Set chart title visible
|
CommentResponse |
PutWorkSheetComment(String name,
String sheetName,
String cellName,
String storage,
String folder,
Comment body)
PutWorkSheetComment
Add worksheet's cell comment.
|
SaaSposeResponse |
PutWorksheetFreezePanes(String name,
String sheetName,
Integer row,
Integer column,
Integer freezedRows,
Integer freezedColumns,
String folder,
String storage)
PutWorksheetFreezePanes
Set freeze panes
|
HyperlinkResponse |
PutWorkSheetHyperlink(String name,
String sheetName,
Integer firstRow,
Integer firstColumn,
Integer totalRows,
Integer totalColumns,
String address,
String storage,
String folder)
PutWorkSheetHyperlink
Add worksheet hyperlink.
|
OleObjectResponse |
PutWorksheetOleObject(String name,
String sheetName,
Integer upperLeftRow,
Integer upperLeftColumn,
Integer height,
Integer width,
String oleFile,
String imageFile,
String storage,
String folder,
OleObject body)
PutWorksheetOleObject
Add OLE object
|
PivotTableResponse |
PutWorksheetPivotTable(String name,
String sheetName,
String storage,
String folder,
String sourceData,
String destCellName,
String tableName,
Boolean useSameSource,
CreatePivotTableRequest body)
PutWorksheetPivotTable
Add a pivot table into worksheet.
|
ValidationResponse |
PutWorkSheetValidation(String name,
String sheetName,
String range,
String storage,
String folder,
Object file)
PutWorkSheetValidation
Add worksheet validation at index.
|
void |
setBasePath(String basePath) |
public ApiInvoker getInvoker()
public void setBasePath(String basePath)
public String getBasePath()
public ColumnsResponse DeleteWorksheetColumns(String name, String sheetName, Integer columnIndex, Integer columns, Boolean updateReference, String storage, String folder)
name
- String The workbook name.sheetName
- String The worksheet name.columnIndex
- Integer The column index.columns
- Integer The columns.updateReference
- Boolean The update reference.storage
- String Workbook storage.folder
- String The workbook folder.public SaaSposeResponse DeleteWorksheetRow(String name, String sheetName, Integer rowIndex, String storage, String folder)
name
- String The workbook name.sheetName
- String The worksheet bame.rowIndex
- Integer The row index.storage
- String The document storage.folder
- String The document folder.public SaaSposeResponse DeleteWorksheetRows(String name, String sheetName, Integer startrow, Integer totalRows, Boolean updateReference, String storage, String folder)
name
- String The workbook name.sheetName
- String The worksheet bame.startrow
- Integer The begin row index to be operated.totalRows
- Integer Number of rows to be operated.updateReference
- Boolean Indicates if update references in other worksheets.storage
- String The document storage.folder
- String The document folder.public CellResponse GetWorksheetCell(String name, String sheetName, String cellOrMethodName, String storage, String folder)
name
- String Document name.sheetName
- String Worksheet name.cellOrMethodName
- String The cell's or method name. (Method name like firstcell, endcell etc.)storage
- String Workbook storage.folder
- String Document's folder.public Integer GetWorksheetCellProperty(String name, String sheetName, String cellOrMethodName, String storage, String folder)
name
- String Document name.sheetName
- String Worksheet name.cellOrMethodName
- String The cell's or method name. (Method name like maxrow, maxdatarow, maxcolumn, maxdatacolumn, minrow, mindatarow, mincolumn, mindatacolumn)storage
- String Workbook storage.folder
- String Document's folder.public CellsResponse GetWorksheetCells(String name, String sheetName, Integer offest, Integer count, String storage, String folder)
name
- String Document name.sheetName
- String Worksheet name.offest
- Integer Begginig offset.count
- Integer Maximum amount of cells in the response.storage
- String Workbook storage.folder
- String Document's folder name.public StyleResponse GetWorksheetCellStyle(String name, String sheetName, String cellName, String storage, String folder)
name
- String Document name.sheetName
- String Worksheet name.cellName
- String Cell's name.storage
- String Workbook storage.folder
- String Document's folder.public ColumnResponse GetWorksheetColumn(String name, String sheetName, Integer columnIndex, String storage, String folder)
name
- String The workbook name.sheetName
- String The worksheet name.columnIndex
- Integer The column index.storage
- String Workbook storage.folder
- String The workbook folder.public ColumnsResponse GetWorksheetColumns(String name, String sheetName, String storage, String folder)
name
- String The workbook name.sheetName
- String The worksheet name.storage
- String Workbook storage.folder
- String The workdook folder.public RowResponse GetWorksheetRow(String name, String sheetName, Integer rowIndex, String storage, String folder)
name
- String The workbook name.sheetName
- String The worksheet name.rowIndex
- Integer The row index.storage
- String Workbook storage.folder
- String The workbook folder.public RowsResponse GetWorksheetRows(String name, String sheetName, String storage, String folder)
name
- String The workbook name.sheetName
- String The worksheet name.storage
- String Workbook storage.folder
- String The workdook folder.public SaaSposeResponse PostClearContents(String name, String sheetName, String range, Integer startRow, Integer startColumn, Integer endRow, Integer endColumn, String storage, String folder)
name
- String Workbook name.sheetName
- String Worksheet name.range
- String The range.startRow
- Integer The start row.startColumn
- Integer The start column.endRow
- Integer The end row.endColumn
- Integer The end column.storage
- String Workbook storage.folder
- String The workbook folder.public SaaSposeResponse PostClearFormats(String name, String sheetName, String range, Integer startRow, Integer startColumn, Integer endRow, Integer endColumn, String storage, String folder)
name
- String Workbook name.sheetName
- String Worksheet name.range
- String The range.startRow
- Integer The start row.startColumn
- Integer The start column.endRow
- Integer The end row.endColumn
- Integer The end column.storage
- String Workbook storage.folder
- String The workbook folder.public SaaSposeResponse PostColumnStyle(String name, String sheetName, Integer columnIndex, String storage, String folder, Style body)
name
- String The workbook name.sheetName
- String The worksheet name.columnIndex
- Integer The column index.storage
- String Workbook storage.folder
- String The workbook folder.body
- Style Style dtopublic SaaSposeResponse PostCopyCellIntoCell(String name, String destCellName, String sheetName, String worksheet, String cellname, Integer row, Integer column, String storage, String folder)
name
- String Workbook name.destCellName
- String Destination cell namesheetName
- String Destination worksheet name.worksheet
- String Source worksheet name.cellname
- String Source cell namerow
- Integer Source rowcolumn
- Integer Source columnstorage
- String Storage namefolder
- String Folder namepublic SaaSposeResponse PostCopyWorksheetColumns(String name, String sheetName, Integer sourceColumnIndex, Integer destinationColumnIndex, Integer columnNumber, String worksheet, String storage, String folder)
name
- String The workbook name.sheetName
- String The worksheet name.sourceColumnIndex
- Integer Source column indexdestinationColumnIndex
- Integer Destination column indexcolumnNumber
- Integer The copied column numberworksheet
- String The Worksheetstorage
- String The document storage.folder
- String The document folder.public SaaSposeResponse PostCopyWorksheetRows(String name, String sheetName, Integer sourceRowIndex, Integer destinationRowIndex, Integer rowNumber, String worksheet, String storage, String folder)
name
- String The workbook name.sheetName
- String The worksheet name.sourceRowIndex
- Integer Source row indexdestinationRowIndex
- Integer Destination row indexrowNumber
- Integer The copied row numberworksheet
- String worksheetstorage
- String The document storage.folder
- String The document folder.public SaaSposeResponse PostGroupWorksheetColumns(String name, String sheetName, Integer firstIndex, Integer lastIndex, Boolean hide, String storage, String folder)
name
- String The workbook name.sheetName
- String The worksheet name.firstIndex
- Integer The first column index to be operated.lastIndex
- Integer The last column index to be operated.hide
- Boolean columns visible statestorage
- String The document storage.folder
- String The document folder.public SaaSposeResponse PostGroupWorksheetRows(String name, String sheetName, Integer firstIndex, Integer lastIndex, Boolean hide, String storage, String folder)
name
- String The workbook name.sheetName
- String The worksheet name.firstIndex
- Integer The first row index to be operated.lastIndex
- Integer The last row index to be operated.hide
- Boolean rows visible statestorage
- String The document storage.folder
- String The document folder.public SaaSposeResponse PostHideWorksheetColumns(String name, String sheetName, Integer startColumn, Integer totalColumns, String storage, String folder)
name
- String The workbook name.sheetName
- String The worksheet name.startColumn
- Integer The begin column index to be operated.totalColumns
- Integer Number of columns to be operated.storage
- String The document storage.folder
- String The document folder.public SaaSposeResponse PostHideWorksheetRows(String name, String sheetName, Integer startrow, Integer totalRows, String storage, String folder)
name
- String The workbook name.sheetName
- String The worksheet name.startrow
- Integer The begin row index to be operated.totalRows
- Integer Number of rows to be operated.storage
- String The document storage.folder
- String The document folder.public SaaSposeResponse PostRowStyle(String name, String sheetName, Integer rowIndex, String storage, String folder, Style body)
name
- String The workbook name.sheetName
- String The worksheet name.rowIndex
- Integer The row index.storage
- String The document storage.folder
- String The document folder.body
- Style Style dtopublic CellResponse PostSetCellHtmlString(String name, String sheetName, String cellName, String storage, String folder, File file)
name
- String Workbook name.sheetName
- String Worksheet name.cellName
- String The cell name.storage
- String Workbook storage.folder
- String The workbook folder.file
- Filepublic SaaSposeResponse PostSetCellRangeValue(String name, String sheetName, String cellarea, String value, String type, String storage, String folder)
name
- String Workbook name.sheetName
- String Worksheet name.cellarea
- String Cell area (like A1:C2)value
- String Range valuetype
- String Value data type (like int)storage
- String Storage namefolder
- String Folder namepublic ColumnResponse PostSetWorksheetColumnWidth(String name, String sheetName, Integer columnIndex, Double width, String storage, String folder)
name
- String The workbook name.sheetName
- String The worksheet name.columnIndex
- Integer The column index.width
- Double The width.storage
- String Workbook storage.folder
- String The workbook folder.public SaaSposeResponse PostUngroupWorksheetColumns(String name, String sheetName, Integer firstIndex, Integer lastIndex, String storage, String folder)
name
- String The workbook name.sheetName
- String The worksheet name.firstIndex
- Integer The first column index to be operated.lastIndex
- Integer The last column index to be operated.storage
- String The document storage.folder
- String The document folder.public SaaSposeResponse PostUngroupWorksheetRows(String name, String sheetName, Integer firstIndex, Integer lastIndex, Boolean isAll, String storage, String folder)
name
- String The workbook name.sheetName
- String The worksheet name.firstIndex
- Integer The first row index to be operated.lastIndex
- Integer The last row index to be operated.isAll
- Boolean Is all row to be operatedstorage
- String The document storage.folder
- String The document folder.public SaaSposeResponse PostUnhideWorksheetColumns(String name, String sheetName, Integer startcolumn, Integer totalColumns, Double width, String storage, String folder)
name
- String The workbook name.sheetName
- String The worksheet name.startcolumn
- Integer The begin column index to be operated.totalColumns
- Integer Number of columns to be operated.width
- Double The new column width.storage
- String The document storage.folder
- String The document folder.public SaaSposeResponse PostUnhideWorksheetRows(String name, String sheetName, Integer startrow, Integer totalRows, Double height, String storage, String folder)
name
- String The workbook name.sheetName
- String The worksheet name.startrow
- Integer The begin row index to be operated.totalRows
- Integer Number of rows to be operated.height
- Double The new row height.storage
- String The document storage.folder
- String The document folder.public StyleResponse PostUpdateWorksheetCellStyle(String name, String sheetName, String cellName, String storage, String folder, Style body)
name
- String Workbook name.sheetName
- String Worksheet name.cellName
- String The cell name.storage
- String Workbook storage.folder
- String The workbook folder.body
- Style with update style settings.public SaaSposeResponse PostUpdateWorksheetRangeStyle(String name, String sheetName, String range, String storage, String folder, Style body)
name
- String Workbook name.sheetName
- String Worksheet name.range
- String The range.storage
- String Workbook storage.folder
- String The workbook folder.body
- Style with update style settings.public RowResponse PostUpdateWorksheetRow(String name, String sheetName, Integer rowIndex, Double height, String storage, String folder)
name
- String The workbook name.sheetName
- String The worksheet name.rowIndex
- Integer The row index.height
- Double The new row height.storage
- String The document storage.folder
- String The document folder.public CellResponse PostWorksheetCellSetValue(String name, String sheetName, String cellName, String value, String type, String formula, String storage, String folder)
name
- String The document name.sheetName
- String The worksheet name.cellName
- String The cell name.value
- String The cell value.type
- String The value type.formula
- String Formula for cellstorage
- String Workbook storage.folder
- String The document folder.public SaaSposeResponse PostWorksheetMerge(String name, String sheetName, Integer startRow, Integer startColumn, Integer totalRows, Integer totalColumns, String storage, String folder)
name
- String The workbook name.sheetName
- String The worksheet name.startRow
- Integer The start row.startColumn
- Integer The start column.totalRows
- Integer The total rowstotalColumns
- Integer The total columns.storage
- String The document storage.folder
- String The workbook folder.public SaaSposeResponse PostWorksheetUnmerge(String name, String sheetName, Integer startRow, Integer startColumn, Integer totalRows, Integer totalColumns, String storage, String folder)
name
- String The workbook name.sheetName
- String The worksheet name.startRow
- Integer The start row.startColumn
- Integer The start column.totalRows
- Integer The total rowstotalColumns
- Integer The total columns.storage
- String The document storage.folder
- String The workbook folder.public ColumnsResponse PutInsertWorksheetColumns(String name, String sheetName, Integer columnIndex, Integer columns, Boolean updateReference, String storage, String folder)
name
- String The workbook name.sheetName
- String The worksheet name.columnIndex
- Integer The column index.columns
- Integer The columns.updateReference
- Boolean The update reference.storage
- String Workbook storage.folder
- String The workbook folder.public RowResponse PutInsertWorksheetRow(String name, String sheetName, Integer rowIndex, String storage, String folder)
name
- String The workbook name.sheetName
- String The worksheet name.rowIndex
- Integer The new row index.storage
- String The document storage.folder
- String The document folder.public SaaSposeResponse PutInsertWorksheetRows(String name, String sheetName, Integer startrow, Integer totalRows, Boolean updateReference, String storage, String folder)
name
- String The workbook name.sheetName
- String The worksheet name.startrow
- Integer The begin row index to be operated.totalRows
- Integer Number of rows to be operated.updateReference
- Boolean Indicates if update references in other worksheets.storage
- String The document storage.folder
- String The document folder.public AutoShapeResponse GetWorksheetAutoshape(String name, String sheetName, Integer autoshapeNumber, String storage, String folder)
name
- String Document name.sheetName
- String Worksheet name.autoshapeNumber
- Integer The autoshape number.storage
- String Workbook storage.folder
- String The document folder.public AutoShapesResponse GetWorksheetAutoshapes(String name, String sheetName, String storage, String folder)
name
- String Document name.sheetName
- String The worksheet name.storage
- String Workbook storage.folder
- String Document's folder.public ResponseMessage GetWorksheetAutoshapeWithFormat(String name, String sheetName, Integer autoshapeNumber, String format, String storage, String folder)
name
- String Document name.sheetName
- String Worksheet name.autoshapeNumber
- Integer The autoshape number.format
- String Autoshape conversion format.storage
- String Workbook storage.folder
- String The document folder.public BarcodeResponseList GetExtractBarcodes(String name, String sheetName, Integer pictureNumber, String storage, String folder)
name
- String Workbook name.sheetName
- String Worksheet name.pictureNumber
- Integer Picture index.storage
- String Workbook storage.folder
- String Workbook folder.public ChartAreaResponse GetChartArea(String name, String sheetName, Integer chartIndex, String storage, String folder)
name
- String Workbook name.sheetName
- String Worksheet name.chartIndex
- Integer The chart index.storage
- String Workbook storage.folder
- String Workbook folder.public LineResponse GetChartAreaBorder(String name, String sheetName, Integer chartIndex, String storage, String folder)
name
- String Workbook name.sheetName
- String Worksheet name.chartIndex
- Integer The chart index.storage
- String Workbook storage.folder
- String Workbook folder.public FillFormatResponse GetChartAreaFillFormat(String name, String sheetName, Integer chartIndex, String storage, String folder)
name
- String Workbook name.sheetName
- String Worksheet name.chartIndex
- Integer The chart index.storage
- String Workbook storage.folder
- String Workbook folder.public SaaSposeResponse DeleteWorksheetChartLegend(String name, String sheetName, Integer chartIndex, String storage, String folder)
name
- String Workbook name.sheetName
- String Worksheet name.chartIndex
- Integer The chart index.storage
- String Workbook storage.folder
- String The workbook folder.public SaaSposeResponse DeleteWorksheetChartTitle(String name, String sheetName, Integer chartIndex, String storage, String folder)
name
- String Workbook name.sheetName
- String Worksheet name.chartIndex
- Integer The chart index.storage
- String Workbook storage.folder
- String The workbook folder.public SaaSposeResponse DeleteWorksheetClearCharts(String name, String sheetName, String storage, String folder)
name
- String Workbook name.sheetName
- String The worksheet name.storage
- String Workbook storage.folder
- String The workbook folder.public ChartsResponse DeleteWorksheetDeleteChart(String name, String sheetName, Integer chartIndex, String storage, String folder)
name
- String Workbook name.sheetName
- String Worksheet name.chartIndex
- Integer The chart index.storage
- String Workbook storage.folder
- String The workbook folder.public ChartResponse GetWorksheetChart(String name, String sheetName, Integer chartNumber, String storage, String folder)
name
- String Document name.sheetName
- String Worksheet name.chartNumber
- Integer The chart number.storage
- String Workbook storage.folder
- String The document folder.public LegendResponse GetWorksheetChartLegend(String name, String sheetName, Integer chartIndex, String storage, String folder)
name
- String Workbook name.sheetName
- String Worksheet name.chartIndex
- Integer The chart index.storage
- String Workbook storage.folder
- String The workbook folder.public ChartsResponse GetWorksheetCharts(String name, String sheetName, String storage, String folder)
name
- String Document name.sheetName
- String The worksheet name.storage
- String Workbook storage.folder
- String Document's folder.public ResponseMessage GetWorksheetChartWithFormat(String name, String sheetName, Integer chartNumber, String format, String storage, String folder)
name
- String Document name.sheetName
- String Worksheet name.chartNumber
- Integer The chart number.format
- String Chart conversion format.storage
- String Workbook storage.folder
- String The document folder.public LegendResponse PostWorksheetChartLegend(String name, String sheetName, Integer chartIndex, String storage, String folder, Legend body)
name
- String Workbook name.sheetName
- String Worksheet name.chartIndex
- Integer The chart index.storage
- String Workbook storage.folder
- String The workbook folder.body
- Legendpublic TitleResponse PostWorksheetChartTitle(String name, String sheetName, Integer chartIndex, String storage, String folder, Title body)
name
- String Workbook name.sheetName
- String Worksheet name.chartIndex
- Integer The chart index.storage
- String Workbook storage.folder
- String The workbook folder.body
- Title Chart titlepublic ChartsResponse PutWorksheetAddChart(String name, String sheetName, String chartType, Integer upperLeftRow, Integer upperLeftColumn, Integer lowerRightRow, Integer lowerRightColumn, String area, Boolean isVertical, String categoryData, Boolean isAutoGetSerialName, String title, String storage, String folder)
name
- String Workbook name.sheetName
- String The worksheet name.chartType
- String Chart type, please refer property Type in chart resource.upperLeftRow
- Integer New chart upper left row.upperLeftColumn
- Integer New chart upperleft column.lowerRightRow
- Integer New chart lower right row.lowerRightColumn
- Integer New chart lower right column.area
- String Specifies values from which to plot the data series.isVertical
- Boolean Specifies whether to plot the series from a range of cell values by row or by column.categoryData
- String Gets or sets the range of category Axis values. It can be a range of cells (such as, d1:e10).isAutoGetSerialName
- Boolean Specifies whether auto update serial name.title
- String Specifies chart title name.storage
- String Workbook storage.folder
- String The workbook folder.public SaaSposeResponse PutWorksheetChartLegend(String name, String sheetName, Integer chartIndex, String storage, String folder)
name
- String Workbook name.sheetName
- String Worksheet name.chartIndex
- Integer The chart index.storage
- String Workbook storage.folder
- String The workbook folder.public TitleResponse PutWorksheetChartTitle(String name, String sheetName, Integer chartIndex, String storage, String folder, Title body)
name
- String Workbook name.sheetName
- String Worksheet name.chartIndex
- Integer The chart index.storage
- String Workbook storage.folder
- String The workbook folder.body
- Title Chart title.public SaaSposeResponse DeleteWorkSheetHyperlink(String name, String sheetName, Integer hyperlinkIndex, String storage, String folder)
name
- String Document name.sheetName
- String Worksheet name.hyperlinkIndex
- Integer The hyperlink's index.storage
- String The document storage.folder
- String The document folder.public SaaSposeResponse DeleteWorkSheetHyperlinks(String name, String sheetName, String storage, String folder)
name
- String Document name.sheetName
- String Worksheet name.storage
- String The document storage.folder
- String The document folder.public HyperlinkResponse GetWorkSheetHyperlink(String name, String sheetName, Integer hyperlinkIndex, String storage, String folder)
name
- String Document name.sheetName
- String Worksheet name.hyperlinkIndex
- Integer The hyperlink's index.storage
- String The document storage.folder
- String The document folder.public HyperlinksResponse GetWorkSheetHyperlinks(String name, String sheetName, String storage, String folder)
name
- String Document name.sheetName
- String The worksheet name.storage
- String The document storage.folder
- String Document's folder.public HyperlinkResponse PostWorkSheetHyperlink(String name, String sheetName, Integer hyperlinkIndex, String storage, String folder, Hyperlink body)
name
- String Document name.sheetName
- String Worksheet name.hyperlinkIndex
- Integer The hyperlink's index.storage
- String The document storage.folder
- String The document folder.body
- Hyperlink Hyperlink objectpublic HyperlinkResponse PutWorkSheetHyperlink(String name, String sheetName, Integer firstRow, Integer firstColumn, Integer totalRows, Integer totalColumns, String address, String storage, String folder)
name
- String Document name.sheetName
- String Worksheet name.firstRow
- IntegerfirstColumn
- IntegertotalRows
- IntegertotalColumns
- Integeraddress
- Stringstorage
- String The document storage.folder
- String The document folder.public SaaSposeResponse DeleteWorksheetOleObject(String name, String sheetName, Integer oleObjectIndex, String storage, String folder)
name
- String The workbook name.sheetName
- String The worsheet name.oleObjectIndex
- Integer Ole object indexstorage
- String The workbook storage.folder
- String The workbook folder.public SaaSposeResponse DeleteWorksheetOleObjects(String name, String sheetName, String storage, String folder)
name
- String The workbook name.sheetName
- String The worsheet name.storage
- String The workbook storage.folder
- String The workbook folder.public OleObjectResponse GetWorksheetOleObject(String name, String sheetName, Integer objectNumber, String storage, String folder)
name
- String Document name.sheetName
- String Worksheet name.objectNumber
- Integer The object number.storage
- String Workbook storage.folder
- String The document folder.public OleObjectsResponse GetWorksheetOleObjects(String name, String sheetName, String storage, String folder)
name
- String Document name.sheetName
- String The worksheet name.storage
- String Workbook storage.folder
- String Document's folder.public ResponseMessage GetWorksheetOleObjectWithFormat(String name, String sheetName, Integer objectNumber, String format, String storage, String folder)
name
- String Document name.sheetName
- String Worksheet name.objectNumber
- Integer The object number.format
- String Object conversion format.storage
- String Workbook storage.folder
- String The document folder.public SaaSposeResponse PostUpdateWorksheetOleObject(String name, String sheetName, Integer oleObjectIndex, String storage, String folder, OleObject body)
name
- String The workbook name.sheetName
- String The worsheet name.oleObjectIndex
- Integer Ole object indexstorage
- String The workbook storage.folder
- String The workbook folder.body
- OleObject Ole Objectpublic OleObjectResponse PutWorksheetOleObject(String name, String sheetName, Integer upperLeftRow, Integer upperLeftColumn, Integer height, Integer width, String oleFile, String imageFile, String storage, String folder, OleObject body)
name
- String The workbook name.sheetName
- String The worsheet name.upperLeftRow
- Integer Upper left row indexupperLeftColumn
- Integer Upper left column indexheight
- Integer Height of oleObject, in unit of pixelwidth
- Integer Width of oleObject, in unit of pixeloleFile
- String OLE filenameimageFile
- String Image filenamestorage
- String The workbook storage.folder
- String The workbook folder.body
- OleObject Ole Objectpublic SaaSposeResponse DeleteWorksheetPicture(String name, String sheetName, Integer pictureIndex, String storage, String folder)
name
- String The workbook name.sheetName
- String The worsheet name.pictureIndex
- Integer Picture indexstorage
- String The workbook storage.folder
- String The workbook folder.public SaaSposeResponse DeleteWorkSheetPictures(String name, String sheetName, String storage, String folder)
name
- String Document name.sheetName
- String Worksheet name.storage
- String The document storage.folder
- String The document folder.public PictureResponse GetWorksheetPicture(String name, String sheetName, Integer pictureNumber, String storage, String folder)
name
- String Document name.sheetName
- String Worksheet name.pictureNumber
- Integer The picture number.storage
- String The document storage.folder
- String The document folder.public PicturesResponse GetWorksheetPictures(String name, String sheetName, String storage, String folder)
name
- String Document name.sheetName
- String The worksheet name.storage
- String The document storage.folder
- String Document's folder.public ResponseMessage GetWorksheetPictureWithFormat(String name, String sheetName, Integer pictureNumber, String format, String storage, String folder)
name
- String Document name.sheetName
- String Worksheet name.pictureNumber
- Integer The picture number.format
- String Picture conversion format.storage
- String The document storage.folder
- String The document folder.public PictureResponse PostWorkSheetPicture(String name, String sheetName, Integer pictureIndex, String storage, String folder, Picture body)
name
- String Document name.sheetName
- String Worksheet name.pictureIndex
- Integer The picture's index.storage
- String The document storage.folder
- String The document folder.body
- Picture Picture objectpublic PicturesResponse PutWorksheetAddPicture(String name, String sheetName, Integer upperLeftRow, Integer upperLeftColumn, Integer lowerRightRow, Integer lowerRightColumn, String picturePath, String storage, String folder, File file)
name
- String The workbook name.sheetName
- String The worsheet name.upperLeftRow
- Integer The image upper left row.upperLeftColumn
- Integer The image upper left column.lowerRightRow
- Integer The image low right row.lowerRightColumn
- Integer The image low right column.picturePath
- String The picture path, if not provided the picture data is inspected in the request body.storage
- String The workbook storage.folder
- String The workbook folder.file
- Filepublic SaaSposeResponse DeleteWorksheetPivotTable(String name, String sheetName, Integer pivotTableIndex, String storage, String folder)
name
- String Document name.sheetName
- String The worksheet name.pivotTableIndex
- Integer Pivot table indexstorage
- String Workbook storage.folder
- String Document's folder.public SaaSposeResponse DeleteWorksheetPivotTables(String name, String sheetName, String storage, String folder)
name
- String Document name.sheetName
- String The worksheet name.storage
- String Workbook storage.folder
- String Document's folder.public PivotTableResponse GetWorksheetPivotTable(String name, String sheetName, Integer pivottableIndex, String storage, String folder)
name
- String Document name.sheetName
- String The worksheet name.pivottableIndex
- Integerstorage
- String Workbook storage.folder
- String Document's folder.public PivotTablesResponse GetWorksheetPivotTables(String name, String sheetName, String storage, String folder)
name
- String Document name.sheetName
- String The worksheet name.storage
- String Workbook storage.folder
- String Document's folder.public SaaSposeResponse PostPivotTableCellStyle(String name, String sheetName, Integer pivotTableIndex, Integer column, Integer row, String storage, String folder, Style body)
name
- String Document name.sheetName
- String The worksheet name.pivotTableIndex
- Integer Pivot table indexcolumn
- Integerrow
- Integerstorage
- String Workbook storage.folder
- String Document's folder.body
- Style Style dto in request body.public SaaSposeResponse PostPivotTableStyle(String name, String sheetName, Integer pivotTableIndex, String storage, String folder, Style body)
name
- String Document name.sheetName
- String The worksheet name.pivotTableIndex
- Integer Pivot table indexstorage
- String Workbook storage.folder
- String Document's folder.body
- Style Style dto in request body.public SaaSposeResponse PutPivotTableField(String name, String sheetName, Integer pivotTableIndex, String pivotFieldType, String storage, String folder, PivotTableFieldRequest body)
name
- String Document name.sheetName
- String The worksheet name.pivotTableIndex
- Integer Pivot table indexpivotFieldType
- Stringstorage
- String Workbook storage.folder
- String Document's folder.body
- PivotTableFieldRequest Dto that conrains field indexespublic PivotTableResponse PutWorksheetPivotTable(String name, String sheetName, String storage, String folder, String sourceData, String destCellName, String tableName, Boolean useSameSource, CreatePivotTableRequest body)
name
- String Document name.sheetName
- String The worksheet name.storage
- String Workbook storage.folder
- String Document's folder.sourceData
- String The data for the new PivotTable cache.destCellName
- String The cell in the upper-left corner of the PivotTable report's destination range.tableName
- String The name of the new PivotTable report.useSameSource
- Boolean Indicates whether using same data source when another existing pivot table has used this data source. If the property is true, it will save memory.body
- CreatePivotTableRequest CreatePivotTableRequest dto in request body.public CellsDocumentPropertiesResponse DeleteDocumentProperties(String name, String storage, String folder)
name
- String The document name.storage
- String The document storage.folder
- String The document folder.public CellsDocumentPropertiesResponse DeleteDocumentProperty(String name, String propertyName, String storage, String folder)
name
- String The document name.propertyName
- String The property name.storage
- String The document storage.folder
- String The document folder.public CellsDocumentPropertiesResponse GetDocumentProperties(String name, String storage, String folder)
name
- String The document name.storage
- String The document storage.folder
- String The document folder.public CellsDocumentPropertyResponse GetDocumentProperty(String name, String propertyName, String storage, String folder)
name
- String The document name.propertyName
- String The property name.storage
- String The document storage.folder
- String The document folder.public CellsDocumentPropertyResponse PutDocumentProperty(String name, String propertyName, String storage, String folder, CellsDocumentProperty body)
name
- String The document name.propertyName
- String The property name.storage
- String The document storage.folder
- String The document folder.body
- CellsDocumentProperty with new property value.public SaveResponse PostDocumentSaveAs(String name, String newfilename, Boolean isAutoFitRows, Boolean isAutoFitColumns, String storage, String folder, SaveOptions body)
name
- String The document name.newfilename
- String The new file name.isAutoFitRows
- Boolean Autofit rows.isAutoFitColumns
- Boolean Autofit columns.storage
- String The document storage.folder
- String The document folder.body
- SaveOptions Save options.public SaaSposeResponse DeleteDecryptDocument(String name, String storage, String folder, WorkbookEncryptionRequest body)
name
- String The document name.storage
- String The document storage.folder
- String The document folder.body
- WorkbookEncryptionRequest Encryption settings, only password can be specified.public SaaSposeResponse DeleteDocumentUnProtectFromChanges(String name, String storage, String folder)
name
- String The document name.storage
- String The document storage.folder
- String Document's folder.public SaaSposeResponse DeleteUnProtectDocument(String name, String storage, String folder, WorkbookProtectionRequest body)
name
- String The document name.storage
- String The document storage.folder
- String The document folder.body
- WorkbookProtectionRequest Protection settings, only password can be specified.public WorkbookResponse GetWorkBook(String name, String password, Boolean isAutoFit, String storage, String folder)
name
- String The document name.password
- String The document password.isAutoFit
- Boolean Set document rows to be autofit.storage
- String The document storage.folder
- String The document folder.public StyleResponse GetWorkBookDefaultStyle(String name, String storage, String folder)
name
- String The workbook name.storage
- String The document storage.folder
- String The document's folder.public NameResponse GetWorkBookName(String name, String nameName, String storage, String folder)
name
- String The workbook name.nameName
- String The name.storage
- String The document storage.folder
- String The workbook folder.public NamesResponse GetWorkBookNames(String name, String storage, String folder)
name
- String The workbook name.storage
- String The document storage.folder
- String The workbook folder.public TextItemsResponse GetWorkBookTextItems(String name, String storage, String folder)
name
- String The workbook name.storage
- String The document storage.folder
- String The workbook folder.public ResponseMessage GetWorkBookWithFormat(String name, String format, String password, Boolean isAutoFit, String storage, String folder, String outPath)
name
- String The document name.format
- String The conversion format.password
- String The document password.isAutoFit
- Boolean Set document rows to be autofit.storage
- String The document storage.folder
- String The document folder.outPath
- String Path to save resultpublic SaaSposeResponse PostAutofitWorkbookRows(String name, Integer startRow, Integer endRow, Boolean onlyAuto, String storage, String folder, AutoFitterOptions body)
name
- String Document name.startRow
- Integer Start row.endRow
- Integer End row.onlyAuto
- Boolean Only auto.storage
- String The document storage.folder
- String Document's folder.body
- AutoFitterOptions Auto Fitter Options.public SaaSposeResponse PostEncryptDocument(String name, String storage, String folder, WorkbookEncryptionRequest body)
name
- String The document name.storage
- String The document storage.folder
- String The document folder.body
- WorkbookEncryptionRequest Encryption parameters.public SaaSposeResponse PostImportData(String name, String storage, String folder, ImportOption body)
name
- String The workbook name.storage
- String The workbook storage.folder
- String The workbook folder.body
- ImportOption The import option.public SaaSposeResponse PostProtectDocument(String name, String storage, String folder, WorkbookProtectionRequest body)
name
- String The document name.storage
- String The document storage.folder
- String The document folder.body
- WorkbookProtectionRequest The protection settings.public SaaSposeResponse PostWorkbookCalculateFormula(String name, String storage, String folder)
name
- String Document name.storage
- String The document storage.folder
- String Document's folder.public ResponseMessage PostWorkbookGetSmartMarkerResult(String name, String xmlFile, String storage, String folder, String outPath, File file)
name
- String The workbook name.xmlFile
- String The xml file full path, if empty the data is read from request body.storage
- String The document storage.folder
- String The workbook folder full path.outPath
- String Path to save resultfile
- Filepublic WorkbookResponse PostWorkbooksMerge(String name, String mergeWith, String storage, String folder)
name
- String Workbook name.mergeWith
- String The workbook to merge with.storage
- String The document storage.folder
- String Source workbook folder.public SplitResultResponse PostWorkbookSplit(String name, String format, Integer from, Integer to, Integer horizontalResolution, Integer verticalResolution, String storage, String folder)
name
- String The workbook name.format
- String Split format.from
- Integer Start worksheet index.to
- Integer End worksheet index.horizontalResolution
- Integer Image horizontal resolution.verticalResolution
- Integer Image vertical resolution.storage
- String The workbook storage.folder
- String The workbook folder.public WorkbookReplaceResponse PostWorkbooksTextReplace(String name, String oldValue, String newValue, String storage, String folder)
name
- String Document name.oldValue
- String The old value.newValue
- String The new value.storage
- String The document storage.folder
- String Document's folder.public TextItemsResponse PostWorkbooksTextSearch(String name, String text, String storage, String folder)
name
- String Document name.text
- String Text sample.storage
- String The document storage.folder
- String Document's folder.public ResponseMessage PutConvertWorkBook(String format, String password, String outPath, File file, Object data)
format
- String The format to convert.password
- String The workbook password.outPath
- String Path to save resultfile
- Filepublic SaaSposeResponse PutDocumentProtectFromChanges(String name, String storage, String folder, PasswordRequest body)
name
- String Document name.storage
- String The document storage.folder
- String Document's folder.body
- PasswordRequest Modification password.public WorkbookResponse PutWorkbookCreate(String name, String templateFile, String dataFile, String storage, String folder, File file)
name
- String The new document name.templateFile
- String The template file, if the data not provided default workbook is created.dataFile
- String Smart marker data file, if the data not provided the request content is checked for the data.storage
- String The document storage.folder
- String The new document folder.file
- Filepublic WorksheetResponse DeleteUnprotectWorksheet(String name, String sheetName, String storage, String folder, ProtectSheetParameter body)
name
- String Document name.sheetName
- String The worksheet name.storage
- String The document storage.folder
- String Document folder.body
- ProtectSheetParameter with protection settings. Only password is used here.public WorksheetsResponse DeleteWorksheet(String name, String sheetName, String storage, String folder)
name
- String Document name.sheetName
- String The worksheet name.storage
- String The document storage.folder
- String Document's folder.public SaaSposeResponse DeleteWorkSheetBackground(String name, String sheetName, String folder, String storage)
name
- StringsheetName
- Stringfolder
- Stringstorage
- Stringpublic SaaSposeResponse DeleteWorkSheetComment(String name, String sheetName, String cellName, String storage, String folder)
name
- String The document name.sheetName
- String The worksheet name.cellName
- String The cell namestorage
- String The document storage.folder
- String The document folder.public SaaSposeResponse DeleteWorksheetFreezePanes(String name, String sheetName, Integer row, Integer column, Integer freezedRows, Integer freezedColumns, String folder, String storage)
name
- StringsheetName
- Stringrow
- Integercolumn
- IntegerfreezedRows
- IntegerfreezedColumns
- Integerfolder
- Stringstorage
- Stringpublic ResponseMessage GetWorkSheet(String name, String sheetName, Integer verticalResolution, Integer horizontalResolution, String storage, String folder)
name
- String The document name.sheetName
- String The worksheet name.verticalResolution
- Integer Image vertical resolution.horizontalResolution
- Integer Image horizontal resolution.storage
- String The document storage.folder
- String The document folder.public SingleValueResponse GetWorkSheetCalculateFormula(String name, String sheetName, String formula, String storage, String folder)
name
- String Document name.sheetName
- String Worksheet name.formula
- String The formula.storage
- String The document storage.folder
- String Document's folder.public CommentResponse GetWorkSheetComment(String name, String sheetName, String cellName, String storage, String folder)
name
- String The document name.sheetName
- String The worksheet name.cellName
- String The cell namestorage
- String The document storage.folder
- String The document folder.public CommentsResponse GetWorkSheetComments(String name, String sheetName, String storage, String folder)
name
- String Workbook name.sheetName
- String The worksheet name.storage
- String The document storage.folder
- String The document folder.public MergedCellResponse GetWorkSheetMergedCell(String name, String sheetName, Integer mergedCellIndex, String storage, String folder)
name
- String Document name.sheetName
- String Worksheet name.mergedCellIndex
- Integer Merged cell index.storage
- String The document storage.folder
- String Document folder.public MergedCellsResponse GetWorkSheetMergedCells(String name, String sheetName, String storage, String folder)
name
- String Document name.sheetName
- String The workseet name.storage
- String The document storage.folder
- String Document folder.public WorksheetsResponse GetWorkSheets(String name, String storage, String folder)
name
- String Document name.storage
- String The document storage.folder
- String Document folder.public TextItemsResponse GetWorkSheetTextItems(String name, String sheetName, String storage, String folder)
name
- String Workbook name.sheetName
- String The worksheet name.storage
- String The document storage.folder
- String The workbook's folder.public ResponseMessage GetWorkSheetWithFormat(String name, String sheetName, String format, Integer verticalResolution, Integer horizontalResolution, String storage, String folder)
name
- String The document name.sheetName
- String The worksheet name.format
- String Export format.verticalResolution
- Integer Image vertical resolution.horizontalResolution
- Integer Image horizontal resolution.storage
- String The document storage.folder
- String The document folder.public SaaSposeResponse PostAutofitWorksheetRows(String name, String sheetName, Integer startRow, Integer endRow, Boolean onlyAuto, String storage, String folder, AutoFitterOptions body)
name
- String Document name.sheetName
- String The worksheet name.startRow
- Integer Start row.endRow
- Integer End row.onlyAuto
- Boolean Only auto.storage
- String The document storage.folder
- String Document's folder.body
- AutoFitterOptions Auto Fitter Options.public SaaSposeResponse PostCopyWorksheet(String name, String sheetName, String sourceSheet, String folder, String storage)
name
- StringsheetName
- StringsourceSheet
- Stringfolder
- Stringstorage
- Stringpublic WorksheetsResponse PostMoveWorksheet(String name, String sheetName, String storage, String folder, WorksheetMovingRequest body)
name
- String Document name.sheetName
- String The worksheet name.storage
- String The document storage.folder
- String The document folder.body
- WorksheetMovingRequest with moving parameters.public SaaSposeResponse PostRenameWorksheet(String name, String sheetName, String newname, String folder, String storage)
name
- StringsheetName
- Stringnewname
- Stringfolder
- Stringstorage
- Stringpublic WorksheetResponse PostUpdateWorksheetProperty(String name, String sheetName, String folder, String storage, Worksheet body)
name
- StringsheetName
- Stringfolder
- Stringstorage
- Stringbody
- Worksheetpublic SaaSposeResponse PostWorkSheetComment(String name, String sheetName, String cellName, String storage, String folder, Comment body)
name
- String The document name.sheetName
- String The worksheet name.cellName
- String The cell namestorage
- String The document storage.folder
- String The document folder.body
- Comment Comment objectpublic SaaSposeResponse PostWorksheetRangeSort(String name, String sheetName, String cellArea, String storage, String folder, DataSorter body)
name
- String The workbook name.sheetName
- String The worksheet name.cellArea
- String The range to sort.storage
- String The document storage.folder
- String The workbook folder.body
- DataSorter with sorting settings.public TextItemsResponse PostWorkSheetTextSearch(String name, String sheetName, String text, String storage, String folder)
name
- String Document name.sheetName
- String The worksheet name.text
- String Text to search.storage
- String The document storage.folder
- String Document's folder.public WorksheetReplaceResponse PostWorsheetTextReplace(String name, String sheetName, String oldValue, String newValue, String storage, String folder)
name
- String Document name.sheetName
- String Worksheet name.oldValue
- String The old text to replace.newValue
- String The new text to replace by.storage
- String The document storage.folder
- String Document's folder.public WorksheetsResponse PutAddNewWorksheet(String name, String sheetName, String storage, String folder)
name
- String Document name.sheetName
- String The new sheet name.storage
- String The document storage.folder
- String Document folder.public WorksheetResponse PutChangeVisibilityWorksheet(String name, String sheetName, Boolean isVisible, String storage, String folder)
name
- String Document name.sheetName
- String Worksheet name.isVisible
- Boolean New worksheet visibility value.storage
- String The document storage.folder
- String The document folder.public WorksheetResponse PutProtectWorksheet(String name, String sheetName, String storage, String folder, ProtectSheetParameter body)
name
- String Document name.sheetName
- String The worksheet name.storage
- String The document storage.folder
- String Document folder.body
- ProtectSheetParameter with protection settings.public SaaSposeResponse PutWorkSheetBackground(String name, String sheetName, String folder, String storage, File file)
name
- StringsheetName
- Stringfolder
- Stringstorage
- Stringfile
- Filepublic CommentResponse PutWorkSheetComment(String name, String sheetName, String cellName, String storage, String folder, Comment body)
name
- String The document name.sheetName
- String The worksheet name.cellName
- String The cell namestorage
- String The document storage.folder
- String The document folder.body
- Comment Comment objectpublic SaaSposeResponse PutWorksheetFreezePanes(String name, String sheetName, Integer row, Integer column, Integer freezedRows, Integer freezedColumns, String folder, String storage)
name
- StringsheetName
- Stringrow
- Integercolumn
- IntegerfreezedRows
- IntegerfreezedColumns
- Integerfolder
- Stringstorage
- Stringpublic ValidationResponse DeleteWorkSheetValidation(String name, String sheetName, Integer validationIndex, String storage, String folder)
name
- String Document name.sheetName
- String Worksheet name.validationIndex
- Integer The validation index.storage
- String The document storage.folder
- String Document's folder.public ValidationResponse GetWorkSheetValidation(String name, String sheetName, Integer validationIndex, String storage, String folder)
name
- String Document name.sheetName
- String Worksheet name.validationIndex
- Integer The validation index.storage
- String The document storage.folder
- String Document's folder.public ValidationsResponse GetWorkSheetValidations(String name, String sheetName, String storage, String folder)
name
- String Document name.sheetName
- String Worksheet name.storage
- String The document storage.folder
- String Document folder.public ValidationResponse PostWorkSheetValidation(String name, String sheetName, Integer validationIndex, String storage, String folder, File file)
name
- String Document name.sheetName
- String Worksheet name.validationIndex
- Integer The validation index.storage
- String The document storage.folder
- String Document's folder.file
- Filepublic ValidationResponse PutWorkSheetValidation(String name, String sheetName, String range, String storage, String folder, Object file)
name
- String Document name.sheetName
- String Worksheet name.range
- String Specified cells areastorage
- String The document storage.folder
- String Document's folder.file
- FileCopyright © 2015. All rights reserved.