Skip to content

Instantly share code, notes, and snippets.

@aspose-cloud

aspose-cloud/AddChartToWorksheet.py

Last active December 2, 2021 07:26
Show Gist options
  • Star 0 You must be signed in to star a gist
  • Fork 0 You must be signed in to fork a gist
  • Save aspose-cloud/5161752550311c9baf73ffa0a811ea0b to your computer and use it in GitHub Desktop.
Save aspose-cloud/5161752550311c9baf73ffa0a811ea0b to your computer and use it in GitHub Desktop.
Download ZIP
This Gist repository contains code snippet related to Aspose.Tasks Cloud SDK for Python
Raw
AddChartToWorksheet.py
# For complete examples and data files, please go to https://github.com/aspose-cells-cloud/aspose-cells-cloud-python
import os
import sys
import asposecellscloud
from asposecellscloud.apis.cells_api import CellsApi
api = asposecellscloud.apis.cells_api.CellsApi(os.getenv('CellsCloudClientId'),os.getenv('CellsCloudClientSecret'),"v3.0",os.getenv('CellsCloudApiBaseUrl'))
name ='myDocument.xlsx'
sheet_name ='Sheet3'
chartType = 'Pie'
upperLeftRow = 5
upperLeftColumn = 5
lowerRightRow = 10
lowerRightColumn = 10
area = "C7:D11"
isVertical = True
categoryData = None
isAutoGetSerialName = None
title = None
folder = "PythonTest"
result = api.upload_file(folder + '/' + name, "c:/TestData/" + name)
result = api.cells_charts_put_worksheet_add_chart(name, sheet_name, chartType , upper_left_row=upperLeftRow , upper_left_column=upperLeftColumn, lower_right_row=lowerRightRow, lower_right_column=lowerRightColumn, area=area, is_vertical=isVertical, category_data=categoryData,is_auto_get_serial_name=isAutoGetSerialName,title=title, folder=folder)
Raw
AddEmptyRowInWorkSheet.py
# For complete examples and data files, please go to https://github.com/aspose-cells-cloud/aspose-cells-cloud-python
import os
import sys
import asposecellscloud
from asposecellscloud.apis.cells_api import CellsApi
api = asposecellscloud.apis.cells_api.CellsApi(os.getenv('CellsCloudClientId'),os.getenv('CellsCloudClientSecret'),"v3.0",os.getenv('CellsCloudApiBaseUrl'))
name ='Book1.xlsx'
sheet_name ='Sheet1'
rowIndex = 1
folder = "PythonTest"
result = api.upload_file(folder + '/' + name, "c:/TestData/" + name)
result = api.cells_put_insert_worksheet_row(name, sheet_name, rowIndex , folder = folder)
Raw
AddHyperlinksFromExcelWorksheet.py
# For complete examples and data files, please go to https://github.com/aspose-cells-cloud/aspose-cells-cloud-python
import os
import sys
import asposecellscloud
from asposecellscloud.apis.cells_api import CellsApi
api = asposecellscloud.apis.cells_api.CellsApi(os.getenv('CellsCloudClientId'),os.getenv('CellsCloudClientSecret'),"v3.0",os.getenv('CellsCloudApiBaseUrl'))
name ='Book1.xlsx'
sheet_name ='Sheet1'
firstRow = 1
firstColumn =1
totalRows = 2
totalColumns = 3
address = 'http://www.aspose.com'
folder = "Temp"
AuthUtil.Ready(name, folder)
result = api.cells_hypelinks_put_worksheet_hyperlink(name, sheet_name,firstRow,firstColumn,totalRows,totalColumns,address,folder=folder)
Raw
AddNewExcelWorksheet.py
# For complete examples and data files, please go to https://github.com/aspose-cells-cloud/aspose-cells-cloud-python
import os
import sys
import asposecellscloud
from asposecellscloud.apis.cells_api import CellsApi
api = asposecellscloud.apis.cells_api.CellsApi(os.getenv('CellsCloudClientId'),os.getenv('CellsCloudClientSecret'),"v3.0",os.getenv('CellsCloudApiBaseUrl'))
name = "Book1.xlsx"
sheet_name ='Sheet1'
position = 1
sheettype = "VB"
folder = "PythonTest"
result = api.upload_file(folder + '/' + name, "c:/TestData/" + name)
result = api.cells_worksheets_put_add_new_worksheet(name, sheet_name, position=position, sheettype=sheettype, folder=folder)
self.assertEqual(result.code,201)
Raw
AddOLEObjectsToExcelWorksheet.py
# For complete examples and data files, please go to https://github.com/aspose-cells-cloud/aspose-cells-cloud-python
import os
import sys
import asposecellscloud
from asposecellscloud.apis.cells_api import CellsApi
api = asposecellscloud.apis.cells_api.CellsApi(os.getenv('CellsCloudClientId'),os.getenv('CellsCloudClientSecret'),"v3.0",os.getenv('CellsCloudApiBaseUrl'))
name ='Book1.xlsx'
sheet_name ='Sheet6'
ole = None
upperLeftRow = 1
upperLeftColumn = 1
height = 100
width = 80
oleFile = 'OLEDoc.docx'
imageFile = 'word.jpg'
folder = "PythonTest"
result = api.upload_file(folder + '/' + name, "c:/TestData/" + name)
result = AuthUtil.Ready(api, oleFile, folder)
result = AuthUtil.Ready(api, imageFile, folder)
result = api.cells_ole_objects_put_worksheet_ole_object(name, sheet_name, ole_object=ole,upper_left_row=upperLeftRow,upper_left_column=upperLeftColumn,height=height,width=width,ole_file=(folder +'/'+oleFile), image_file=(folder +'/'+imageFile),folder=folder)
pass
Raw
AddPictureToExcelWorksheet.py
# For complete examples and data files, please go to https://github.com/aspose-cells-cloud/aspose-cells-cloud-python
import os
import sys
import asposecellscloud
from asposecellscloud.apis.cells_api import CellsApi
api = asposecellscloud.apis.cells_api.CellsApi(os.getenv('CellsCloudClientId'),os.getenv('CellsCloudClientSecret'),"v3.0",os.getenv('CellsCloudApiBaseUrl'))
name ='Book1.xlsx'
sheet_name ='Sheet6'
picture = None
upperLeftRow = 1
upperLeftColumn = 1
lowerRightRow = 10
lowerRightColumn = 10
picturePath = 'WaterMark.png'
folder = "Temp"
AuthUtil.Ready(name, folder)
result = api.cells_pictures_put_worksheet_add_picture(name, sheet_name, picture=picture, upper_left_row=upperLeftRow,upper_left_column=upperLeftColumn,lower_right_row=lowerRightRow,lower_right_column=lowerRightColumn,picture_path=picturePath, folder=folder)
Raw
AddPivotFieldInPivotTable.py
# For complete examples and data files, please go to https://github.com/aspose-cells-cloud/aspose-cells-cloud-python
import os
import sys
import asposecellscloud
from asposecellscloud.apis.cells_api import CellsApi
api = asposecellscloud.apis.cells_api.CellsApi(os.getenv('CellsCloudClientId'),os.getenv('CellsCloudClientSecret'),"v3.0",os.getenv('CellsCloudApiBaseUrl'))
name ='TestCase.xlsx'
sheet_name ='Sheet4'
pivotTableIndex = 0
pivotFieldType = "row"
request = PivotTableFieldRequest()
request.data = [1]
folder = "PythonTest"
result = api.upload_file(folder + '/' + name, "c:/TestData/" + name)
result = api.cells_pivot_tables_put_pivot_table_field(name, sheet_name, pivotTableIndex, pivotFieldType,request=request,need_re_calculate=True,folder=folder)
Raw
AddPivotTableInWorkSheet.py
# For complete examples and data files, please go to https://github.com/aspose-cells-cloud/aspose-cells-cloud-python
import os
import sys
import asposecellscloud
from asposecellscloud.apis.cells_api import CellsApi
api = asposecellscloud.apis.cells_api.CellsApi(os.getenv('CellsCloudClientId'),os.getenv('CellsCloudClientSecret'),"v3.0",os.getenv('CellsCloudApiBaseUrl'))
name ='TestCase.xlsx'
sheet_name ='Sheet4'
request = CreatePivotTableRequest(use_same_source=True)
request.name = "TestPivot"
request.dest_cell_name = "C1"
request.source_data = "Sheet1!C6:E13"
sourceData = "Sheet1!C6:E13"
destCellName = "C1"
tableName = "TestPivot"
useSameSource = 'true'
folder = "PythonTest"
result = api.upload_file(folder + '/' + name, "c:/TestData/" + name)
result = api.cells_pivot_tables_put_worksheet_pivot_table(name, sheet_name, request=None, folder=folder,source_data=sourceData,dest_cell_name=destCellName,table_name=tableName,use_same_source=useSameSource)
Raw
Aspose.Tasks-Cloud-SDK-Python
Aspose.Tasks-Cloud-SDK-Python
Raw
AutoFitRowsInExcelWorksheet.py
# For complete examples and data files, please go to https://github.com/aspose-cells-cloud/aspose-cells-cloud-python
import os
import sys
import asposecellscloud
from asposecellscloud.apis.cells_api import CellsApi
api = asposecellscloud.apis.cells_api.CellsApi(os.getenv('CellsCloudClientId'),os.getenv('CellsCloudClientSecret'),"v3.0",os.getenv('CellsCloudApiBaseUrl'))
name ='Book1.xlsx'
folder = "PythonTest"
password = None
isAutoFit = True
result = api.upload_file(folder + '/' + name, "c:/TestData/" + name)
result = api.cells_workbook_get_workbook(name,password=password,is_auto_fit=isAutoFit, folder=folder)
Raw
CalculateFormulaInWorksheet.py
# For complete examples and data files, please go to https://github.com/aspose-cells-cloud/aspose-cells-cloud-python
import os
import sys
import asposecellscloud
from asposecellscloud.apis.cells_api import CellsApi
api = asposecellscloud.apis.cells_api.CellsApi(os.getenv('CellsCloudClientId'),os.getenv('CellsCloudClientSecret'),"v3.0",os.getenv('CellsCloudApiBaseUrl'))
name ='Book1.xlsx'
sheet_name ='Sheet1'
formula = "=NOW()"
folder = "PythonTest"
result = api.upload_file(folder + '/' + name, "c:/TestData/" + name)
result = api.cells_worksheets_get_worksheet_calculate_formula(name, sheet_name, formula, folder=folder)
Raw
ClearCellFormattingInExcelWorksheet.py
# For complete examples and data files, please go to https://github.com/aspose-cells-cloud/aspose-cells-cloud-python
import os
import sys
import asposecellscloud
from asposecellscloud.apis.cells_api import CellsApi
api = asposecellscloud.apis.cells_api.CellsApi(os.getenv('CellsCloudClientId'),os.getenv('CellsCloudClientSecret'),"v3.0",os.getenv('CellsCloudApiBaseUrl'))
name ='Book1.xlsx'
sheet_name ='Sheet1'
range = 'A1:C10'
startRow = 1
startColumn =1
endRow = 3
endColumn = 3
folder = "PythonTest"
result = api.upload_file(folder + '/' + name, "c:/TestData/" + name)
result = api.cells_post_clear_formats(name, sheet_name, range=range, start_row=startRow,start_column=startColumn,end_row=endRow,end_column=endColumn,folder=folder)
Raw
ClearContentsFromExcelWorkSheet.py
# For complete examples and data files, please go to https://github.com/aspose-cells-cloud/aspose-cells-cloud-python
import os
import sys
import asposecellscloud
from asposecellscloud.apis.cells_api import CellsApi
api = asposecellscloud.apis.cells_api.CellsApi(os.getenv('CellsCloudClientId'),os.getenv('CellsCloudClientSecret'),"v3.0",os.getenv('CellsCloudApiBaseUrl'))
name ='Book1.xlsx'
sheet_name ='Sheet1'
range = 'A1:C10'
startRow = 1
startColumn =1
endRow = 3
endColumn = 3
folder = "PythonTest"
result = api.upload_file(folder + '/' + name, "c:/TestData/" + name)
result = api.cells_post_clear_contents(name, sheet_name, range = range, start_row = startRow,start_column = startColumn,end_row=endRow,end_column=endColumn,folder=folder)
Raw
ClearModifyPassword.py
# For complete examples and data files, please go to https://github.com/aspose-cells-cloud/aspose-cells-cloud-python
import os
import sys
import asposecellscloud
from asposecellscloud.apis.cells_api import CellsApi
api = asposecellscloud.apis.cells_api.CellsApi(os.getenv('CellsCloudClientId'),os.getenv('CellsCloudClientSecret'),"v3.0",os.getenv('CellsCloudApiBaseUrl'))
name ='Book1.xlsx'
folder = "PythonTest"
result = api.upload_file(folder + '/' + name, "c:/TestData/" + name)
result = api.cells_workbook_delete_document_unprotect_from_changes(name, folder=folder)
Raw
ConvertAutoShapeToImage.py
# For complete examples and data files, please go to https://github.com/aspose-cells-cloud/aspose-cells-cloud-python
import os
import sys
import asposecellscloud
from asposecellscloud.apis.cells_api import CellsApi
api = asposecellscloud.apis.cells_api.CellsApi(os.getenv('CellsCloudClientId'),os.getenv('CellsCloudClientSecret'),"v3.0",os.getenv('CellsCloudApiBaseUrl'))
name ='myDocument.xlsx'
sheet_name ='Sheet2'
autoshapeNumber = 4
folder = "PythonTest"
result = api.upload_file(folder + '/' + name, "c:/TestData/" + name)
result = api.cells_autoshapes_get_worksheet_autoshape(name, sheet_name,autoshapeNumber, folder=folder)
Raw
ConvertChartToImage.py
# For complete examples and data files, please go to https://github.com/aspose-cells-cloud/aspose-cells-cloud-python
import os
import sys
import asposecellscloud
from asposecellscloud.apis.cells_api import CellsApi
api = asposecellscloud.apis.cells_api.CellsApi(os.getenv('CellsCloudClientId'),os.getenv('CellsCloudClientSecret'),"v3.0",os.getenv('CellsCloudApiBaseUrl'))
name ='myDocument.xlsx'
sheet_name ='Sheet3'
chartIndex = 0
format = 'png'
folder = "PythonTest"
result = api.upload_file(folder + '/' + name, "c:/TestData/" + name)
result = api.cells_charts_get_worksheet_chart(name, sheet_name, chartIndex, format=format, folder=folder)
Raw
ConvertExcelToVariousFormats.py
# For complete examples and data files, please go to https://github.com/aspose-cells-cloud/aspose-cells-cloud-python
import os
import sys
import asposecellscloud
from asposecellscloud.apis.cells_api import CellsApi
api = asposecellscloud.apis.cells_api.CellsApi(os.getenv('CellsCloudClientId'),os.getenv('CellsCloudClientSecret'),"v3.0",os.getenv('CellsCloudApiBaseUrl'))
name ='Book1.xlsx'
saveOptions = None
newfilename = "newbook.xlsx"
isAutoFitRows= True
isAutoFitColumns= True
folder = "PythonTest"
result = api.upload_file(folder + '/' + name, "c:/TestData/" + name)
result = api.cells_save_as_post_document_save_as(name, save_options=saveOptions, newfilename=(folder +'/' + newfilename),is_auto_fit_rows=isAutoFitRows, is_auto_fit_columns=isAutoFitColumns,folder=folder)
Raw
ConvertExcelToVariousFormatsWithoutStorage.py
# For complete examples and data files, please go to https://github.com/aspose-cells-cloud/aspose-cells-cloud-python
import os
import sys
import asposecellscloud
from asposecellscloud.apis.cells_api import CellsApi
api = asposecellscloud.apis.cells_api.CellsApi(os.getenv('CellsCloudClientId'),os.getenv('CellsCloudClientSecret'),"v3.0",os.getenv('CellsCloudApiBaseUrl'))
fullfilename = os.path.dirname(os.path.realpath(__file__)) + "/../TestData/" + "Book1.xlsx"
f = open(fullfilename, 'rb')
workbook = f.read()
f.close()
format ='pdf'
password = None
outPath = None
result = api.cells_workbook_put_convert_workbook(fullfilename,format=format)
Raw
ConvertExcelWorkbookWithAdditionalSettings.py
# For complete examples and data files, please go to https://github.com/aspose-cells-cloud/aspose-cells-cloud-python
import os
import sys
import asposecellscloud
from asposecellscloud.apis.cells_api import CellsApi
api = asposecellscloud.apis.cells_api.CellsApi(os.getenv('CellsCloudClientId'),os.getenv('CellsCloudClientSecret'),"v3.0",os.getenv('CellsCloudApiBaseUrl'))
name ='Book1.xlsx'
saveOptions = None
newfilename = "newbook.xlsx"
isAutoFitRows= True
isAutoFitColumns= True
folder = "PythonTest"
result = api.upload_file(folder + '/' + name, "c:/TestData/" + name)
result = api.cells_save_as_post_document_save_as(name, save_options=saveOptions, newfilename=(folder +'/' + newfilename),is_auto_fit_rows=isAutoFitRows, is_auto_fit_columns=isAutoFitColumns,folder=folder)
Raw
ConvertOLEObjectToImage.py
# For complete examples and data files, please go to https://github.com/aspose-cells-cloud/aspose-cells-cloud-python
import os
import sys
import asposecellscloud
from asposecellscloud.apis.cells_api import CellsApi
api = asposecellscloud.apis.cells_api.CellsApi(os.getenv('CellsCloudClientId'),os.getenv('CellsCloudClientSecret'),"v3.0",os.getenv('CellsCloudApiBaseUrl'))
name ='Book1.xlsx'
sheet_name ='Sheet6'
oleObjectIndex = 0
folder = "PythonTest"
result = api.upload_file(folder + '/' + name, "c:/TestData/" + name)
result = api.cells_ole_objects_get_worksheet_ole_object(name, sheet_name,oleObjectIndex,folder=folder)
Raw
ConvertPictureToImage.py
# For complete examples and data files, please go to https://github.com/aspose-cells-cloud/aspose-cells-cloud-python
import os
import sys
import asposecellscloud
from asposecellscloud.apis.cells_api import CellsApi
api = asposecellscloud.apis.cells_api.CellsApi(os.getenv('CellsCloudClientId'),os.getenv('CellsCloudClientSecret'),"v3.0",os.getenv('CellsCloudApiBaseUrl'))
name ='Book1.xlsx'
sheet_name ='Sheet6'
pictureIndex = 0
folder = "PythonTest"
result = api.upload_file(folder + '/' + name, "c:/TestData/" + name)
result = api.cells_pictures_get_worksheet_picture(name, sheet_name,pictureIndex,format="png", folder=folder)
Raw
ConvertWorkSheetToImage.py
# For complete examples and data files, please go to https://github.com/aspose-cells-cloud/aspose-cells-cloud-python
import os
import sys
import asposecellscloud
from asposecellscloud.apis.cells_api import CellsApi
api = asposecellscloud.apis.cells_api.CellsApi(os.getenv('CellsCloudClientId'),os.getenv('CellsCloudClientSecret'),"v3.0",os.getenv('CellsCloudApiBaseUrl'))
name ='Book1.xlsx'
sheet_name ='Sheet1'
verticalResolution =100
horizontalResolution =90
format = "png"
folder = "PythonTest"
result = api.upload_file(folder + '/' + name, "c:/TestData/" + name)
result = api.cells_worksheets_get_worksheet(name, sheet_name, format=format, vertical_resolution=verticalResolution, horizontal_resolution=horizontalResolution, _preload_content=False, folder=folder)
Raw
CopyExcelWorksheet.py
# For complete examples and data files, please go to https://github.com/aspose-cells-cloud/aspose-cells-cloud-python
import os
import sys
import asposecellscloud
from asposecellscloud.apis.cells_api import CellsApi
api = asposecellscloud.apis.cells_api.CellsApi(os.getenv('CellsCloudClientId'),os.getenv('CellsCloudClientSecret'),"v3.0",os.getenv('CellsCloudApiBaseUrl'))
name = "NewCopy.xlsx"
sheet_name ='Sheet5'
sourceSheet ='Sheet6'
options = CopyOptions()
options.column_character_width = True
sourceWorkbook = 'Book1.xlsx'
sourceFolder = "PythonTest"
folder = "PythonTest"
result = api.upload_file(folder + '/' + name, "c:/TestData/" + name)
result = api.cells_worksheets_post_copy_worksheet(name, sheet_name, sourceSheet, options=options,source_workbook=sourceWorkbook, source_folder=sourceFolder, folder=folder)
Raw
CopyRowsInExcelWorksheet.py
# For complete examples and data files, please go to https://github.com/aspose-cells-cloud/aspose-cells-cloud-python
import os
import sys
import asposecellscloud
from asposecellscloud.apis.cells_api import CellsApi
api = asposecellscloud.apis.cells_api.CellsApi(os.getenv('CellsCloudClientId'),os.getenv('CellsCloudClientSecret'),"v3.0",os.getenv('CellsCloudApiBaseUrl'))
name ='Book1.xlsx'
sheet_name ='Sheet1'
sourceRowIndex = 1
destinationRowIndex = 21
rowNumber =1
worksheet ='Sheet2'
folder = "PythonTest"
result = api.upload_file(folder + '/' + name, "c:/TestData/" + name)
result = api.cells_post_copy_worksheet_rows(name, sheet_name, sourceRowIndex, destinationRowIndex,rowNumber,worksheet=worksheet,folder=folder)
Raw
CreateEmptyExcelWorkbook.py
# For complete examples and data files, please go to https://github.com/aspose-cells-cloud/aspose-cells-cloud-python
import os
import sys
import asposecellscloud
from asposecellscloud.apis.cells_api import CellsApi
api = asposecellscloud.apis.cells_api.CellsApi(os.getenv('CellsCloudClientId'),os.getenv('CellsCloudClientSecret'),"v3.0",os.getenv('CellsCloudApiBaseUrl'))
folder = "PythonTest"
name = "NewBook" + datetime.now().strftime("%Y%m%d%H%M%S") + ".xlsx"
template_file = folder + "/" + templateFile
data_file = folder + "/" + dataFile
result = api.cells_workbook_put_workbook_create(name, folder=folder)
Raw
CreateExcelWorkbookFromSmartMarkerTemplate.py
# For complete examples and data files, please go to https://github.com/aspose-cells-cloud/aspose-cells-cloud-python
import os
import sys
import asposecellscloud
from asposecellscloud.apis.cells_api import CellsApi
api = asposecellscloud.apis.cells_api.CellsApi(os.getenv('CellsCloudClientId'),os.getenv('CellsCloudClientSecret'),"v3.0",os.getenv('CellsCloudApiBaseUrl'))
templateFile ='Book1.xlsx'
folder = "PythonTest"
name = "NewBook" + datetime.now().strftime("%Y%m%d%H%M%S") + ".xlsx"
dataFile = "ReportData.xml"
AuthUtil.Ready(api,templateFile, folder)
AuthUtil.Ready(api,dataFile, folder)
template_file = folder + "/" + templateFile
data_file = folder + "/" + dataFile
result = api.cells_workbook_put_workbook_create(name, template_file=template_file, data_file=data_file, folder=folder)
Raw
CreateExcelWorkbookFromTempateFile.py
# For complete examples and data files, please go to https://github.com/aspose-cells-cloud/aspose-cells-cloud-python
import os
import sys
import asposecellscloud
from asposecellscloud.apis.cells_api import CellsApi
api = asposecellscloud.apis.cells_api.CellsApi(os.getenv('CellsCloudClientId'),os.getenv('CellsCloudClientSecret'),"v3.0",os.getenv('CellsCloudApiBaseUrl'))
templateFile ='Book1.xlsx'
folder = "PythonTest"
name = "NewBook" + datetime.now().strftime("%Y%m%d%H%M%S") + ".xlsx"
AuthUtil.Ready(api,templateFile, folder)
AuthUtil.Ready(api,dataFile, folder)
template_file = folder + "/" + templateFile
data_file = folder + "/" + dataFile
result = api.cells_workbook_put_workbook_create(name, template_file=template_file, folder=folder)
Raw
DecryptExcelWorkbooks.py
# For complete examples and data files, please go to https://github.com/aspose-cells-cloud/aspose-cells-cloud-python
import os
import sys
import asposecellscloud
from asposecellscloud.apis.cells_api import CellsApi
api = asposecellscloud.apis.cells_api.CellsApi(os.getenv('CellsCloudClientId'),os.getenv('CellsCloudClientSecret'),"v3.0",os.getenv('CellsCloudApiBaseUrl'))
name ='Book1.xlsx'
encryption = WorkbookEncryptionRequest(key_length = 128)
encryption.password = "123456"
encryption.encryption_type = "XOR"
folder = "PythonTest"
result = api.upload_file(folder + '/' + name, "c:/TestData/" + name)
result = api.cells_workbook_delete_decrypt_document(name, encryption=encryption,folder=folder)
Raw
DeleteAllChartsFromAWorksheet.py
# For complete examples and data files, please go to https://github.com/aspose-cells-cloud/aspose-cells-cloud-python
import os
import sys
import asposecellscloud
from asposecellscloud.apis.cells_api import CellsApi
api = asposecellscloud.apis.cells_api.CellsApi(os.getenv('CellsCloudClientId'),os.getenv('CellsCloudClientSecret'),"v3.0",os.getenv('CellsCloudApiBaseUrl'))
name ='myDocument.xlsx'
sheet_name ='Sheet3'
chartIndex = 1
folder = "PythonTest"
result = api.upload_file(folder + '/' + name, "c:/TestData/" + name)
result = api.cells_charts_delete_worksheet_clear_charts(name, sheet_name, folder=folder)
Raw
DeleteAllObjectsFromExcelWorksheet.py
# For complete examples and data files, please go to https://github.com/aspose-cells-cloud/aspose-cells-cloud-python
import os
import sys
import asposecellscloud
from asposecellscloud.apis.cells_api import CellsApi
api = asposecellscloud.apis.cells_api.CellsApi(os.getenv('CellsCloudClientId'),os.getenv('CellsCloudClientSecret'),"v3.0",os.getenv('CellsCloudApiBaseUrl'))
name ='Book1.xlsx'
sheet_name ='Sheet6'
oleObjectIndex = 0
folder = "PythonTest"
result = api.upload_file(folder + '/' + name, "c:/TestData/" + name)
result = api.cells_ole_objects_delete_worksheet_ole_objects(name, sheet_name,folder=folder)
Raw
DeleteAllPicturesFromExcelWorksheet.py
# For complete examples and data files, please go to https://github.com/aspose-cells-cloud/aspose-cells-cloud-python
import os
import sys
import asposecellscloud
from asposecellscloud.apis.cells_api import CellsApi
api = asposecellscloud.apis.cells_api.CellsApi(os.getenv('CellsCloudClientId'),os.getenv('CellsCloudClientSecret'),"v3.0",os.getenv('CellsCloudApiBaseUrl'))
name ='Book1.xlsx'
sheet_name ='Sheet6'
index = 0
folder = "PythonTest"
result = api.upload_file(folder + '/' + name, "c:/TestData/" + name)
result = api.cells_pictures_delete_worksheet_pictures(name, sheet_name,folder=folder)
Raw
DeleteBackground.py
# For complete examples and data files, please go to https://github.com/aspose-cells-cloud/aspose-cells-cloud-python
import os
import sys
import asposecellscloud
from asposecellscloud.apis.cells_api import CellsApi
api = asposecellscloud.apis.cells_api.CellsApi(os.getenv('CellsCloudClientId'),os.getenv('CellsCloudClientSecret'),"v3.0",os.getenv('CellsCloudApiBaseUrl'))
name ='Book1.xlsx'
sheet_name ='Sheet1'
folder = "PythonTest"
result = api.upload_file(folder + '/' + name, "c:/TestData/" + name)
result = api.cells_worksheets_delete_worksheet_background(name, sheet_name, folder=folder)
Raw
DeleteChartExcelWorksheet.py
# For complete examples and data files, please go to https://github.com/aspose-cells-cloud/aspose-cells-cloud-python
import os
import sys
import asposecellscloud
from asposecellscloud.apis.cells_api import CellsApi
api = asposecellscloud.apis.cells_api.CellsApi(os.getenv('CellsCloudClientId'),os.getenv('CellsCloudClientSecret'),"v3.0",os.getenv('CellsCloudApiBaseUrl'))
name ='myDocument.xlsx'
sheet_name ='Sheet3'
chartIndex = 1
folder = "PythonTest"
result = api.upload_file(folder + '/' + name, "c:/TestData/" + name)
result = api.cells_charts_delete_worksheet_chart_title(name, sheet_name,chartIndex, folder=folder)
Raw
DeleteChartFromWorkSheet.py
# For complete examples and data files, please go to https://github.com/aspose-cells-cloud/aspose-cells-cloud-python
import os
import sys
import asposecellscloud
from asposecellscloud.apis.cells_api import CellsApi
api = asposecellscloud.apis.cells_api.CellsApi(os.getenv('CellsCloudClientId'),os.getenv('CellsCloudClientSecret'),"v3.0",os.getenv('CellsCloudApiBaseUrl'))
name ='myDocument.xlsx'
sheet_name ='Sheet3'
chartIndex = 0
folder = "PythonTest"
result = api.upload_file(folder + '/' + name, "c:/TestData/" + name)
result = api.cells_charts_delete_worksheet_delete_chart(name, sheet_name,chartIndex, folder=folder)
Raw
DeleteHyperlinksFromExcelWorksheet.py
# For complete examples and data files, please go to https://github.com/aspose-cells-cloud/aspose-cells-cloud-python
import os
import sys
import asposecellscloud
from asposecellscloud.apis.cells_api import CellsApi
api = asposecellscloud.apis.cells_api.CellsApi(os.getenv('CellsCloudClientId'),os.getenv('CellsCloudClientSecret'),"v3.0",os.getenv('CellsCloudApiBaseUrl'))
name ='Book1.xlsx'
sheet_name ='Sheet1'
hyperlinkIndex = 0
folder = "PythonTest"
result = api.upload_file(folder + '/' + name, "c:/TestData/" + name)
result = api.cells_hypelinks_delete_worksheet_hyperlink(name, sheet_name,hyperlinkIndex,folder=folder)
Raw
DeleteRowsFromWorkSheet.py
# For complete examples and data files, please go to https://github.com/aspose-cells-cloud/aspose-cells-cloud-python
import os
import sys
import asposecellscloud
from asposecellscloud.apis.cells_api import CellsApi
api = asposecellscloud.apis.cells_api.CellsApi(os.getenv('CellsCloudClientId'),os.getenv('CellsCloudClientSecret'),"v3.0",os.getenv('CellsCloudApiBaseUrl'))
name ='Book1.xlsx'
sheet_name ='Sheet1'
row_index = 1
folder = "PythonTest"
result = api.upload_file(folder + '/' + name, "c:/TestData/" + name)
result = api.cells_delete_worksheet_row(name, sheet_name, row_index, folder = folder)
Raw
DeleteSpecificPictureFromExcelWorksheet.py
# For complete examples and data files, please go to https://github.com/aspose-cells-cloud/aspose-cells-cloud-python
import os
import sys
import asposecellscloud
from asposecellscloud.apis.cells_api import CellsApi
api = asposecellscloud.apis.cells_api.CellsApi(os.getenv('CellsCloudClientId'),os.getenv('CellsCloudClientSecret'),"v3.0",os.getenv('CellsCloudApiBaseUrl'))
name ='Book1.xlsx'
sheet_name ='Sheet6'
pictureIndex = 0
folder = "PythonTest"
result = api.upload_file(folder + '/' + name, "c:/TestData/" + name)
result = api.cells_pictures_delete_worksheet_picture(name, sheet_name,pictureIndex,folder=folder)
Raw
DeleteWorksheetPivotTables.py
# For complete examples and data files, please go to https://github.com/aspose-cells-cloud/aspose-cells-cloud-python
import os
import sys
import asposecellscloud
from asposecellscloud.apis.cells_api import CellsApi
api = asposecellscloud.apis.cells_api.CellsApi(os.getenv('CellsCloudClientId'),os.getenv('CellsCloudClientSecret'),"v3.0",os.getenv('CellsCloudApiBaseUrl'))
name ='TestCase.xlsx'
sheet_name ='Sheet4'
pivotTableIndex = 0
fieldIndex = 0
folder = "PythonTest"
result = api.upload_file(folder + '/' + name, "c:/TestData/" + name)
result = api.cells_pivot_tables_delete_worksheet_pivot_tables(name, sheet_name, folder=folder)
Raw
DeleteWorksheetPivotTablesByIndex.py
# For complete examples and data files, please go to https://github.com/aspose-cells-cloud/aspose-cells-cloud-python
import os
import sys
import asposecellscloud
from asposecellscloud.apis.cells_api import CellsApi
api = asposecellscloud.apis.cells_api.CellsApi(os.getenv('CellsCloudClientId'),os.getenv('CellsCloudClientSecret'),"v3.0",os.getenv('CellsCloudApiBaseUrl'))
name ='TestCase.xlsx'
sheet_name ='Sheet4'
pivotTableIndex = 0
pivotFieldType = "row"
request = PivotTableFieldRequest()
request.data = [1]
folder = "PythonTest"
result = api.upload_file(folder + '/' + name, "c:/TestData/" + name)
result = api.cells_pivot_tables_delete_worksheet_pivot_table(name, sheet_name, pivotTableIndex, folder=folder)
Raw
DelteSpecificObjectFromOLEWorksheet.py
# For complete examples and data files, please go to https://github.com/aspose-cells-cloud/aspose-cells-cloud-python
import os
import sys
import asposecellscloud
from asposecellscloud.apis.cells_api import CellsApi
api = asposecellscloud.apis.cells_api.CellsApi(os.getenv('CellsCloudClientId'),os.getenv('CellsCloudClientSecret'),"v3.0",os.getenv('CellsCloudApiBaseUrl'))
name ='Book1.xlsx'
sheet_name ='Sheet6'
oleObjectIndex = 0
folder = "PythonTest"
result = api.upload_file(folder + '/' + name, "c:/TestData/" + name)
result = api.cells_ole_objects_delete_worksheet_ole_object(name, sheet_name,oleObjectIndex,folder=folder)
Raw
Examples-PutResource.py
# For complete examples and data files, please go to https://github.com/aspose-cells-cloud/aspose-cells-cloud-python
import os
import sys
import asposecellscloud
from asposecellscloud.apis.cells_api import CellsApi
api = asposecellscloud.apis.cells_api.CellsApi(os.getenv('CellsCloudClientId'),os.getenv('CellsCloudClientSecret'),"v3.0",os.getenv('CellsCloudApiBaseUrl'))
# For complete examples and data files, please go to https://github.com/aspose-cells-cloud/aspose-cells-cloud-python
filename = 'sample.mpp'
self.upload_file(filename)
get_request = GetResourceRequest(filename, 1)
get_result = self.tasks_api.get_resource(get_request)
self.assertIsNotNone(get_result)
self.assertIsInstance(get_result, ResourceResponse)
baseline = Baseline(BaselineType.BASELINE1, cost=44)
resource = get_result.resource
resource.name = 'Modified Resource1'
resource.cost = 200
resource.start = datetime(2000, 10, 10)
resource.work = '4.04:10:00'
resource.finish = datetime(2000, 10, 10)
resource.overtime_work = '4.04:00:00'
resource.standard_rate = 101
resource.baselines = [baseline]
put_request = PutResourceRequest(filename, 1, resource, CalculationMode.NONE, False)
put_result = self.tasks_api.put_resource(put_request)
self.assertIsNotNone(put_result)
Raw
FindTextInWorkbook.py
# For complete examples and data files, please go to https://github.com/aspose-cells-cloud/aspose-cells-cloud-python
import os
import sys
import asposecellscloud
from asposecellscloud.apis.cells_api import CellsApi
api = asposecellscloud.apis.cells_api.CellsApi(os.getenv('CellsCloudClientId'),os.getenv('CellsCloudClientSecret'),"v3.0",os.getenv('CellsCloudApiBaseUrl'))
name ='Book1.xlsx'
folder = "PythonTest"
text = "!test"
result = api.upload_file(folder + '/' + name, "c:/TestData/" + name)
result = api.cells_workbook_post_workbooks_text_search(name, text, folder=folder)
Raw
FindTextInWorksheet.py
# For complete examples and data files, please go to https://github.com/aspose-cells-cloud/aspose-cells-cloud-python
import os
import sys
import asposecellscloud
from asposecellscloud.apis.cells_api import CellsApi
api = asposecellscloud.apis.cells_api.CellsApi(os.getenv('CellsCloudClientId'),os.getenv('CellsCloudClientSecret'),"v3.0",os.getenv('CellsCloudApiBaseUrl'))
name = "Book1.xlsx"
sheet_name ='Sheet1'
text = "B3"
folder = "PythonTest"
result = api.upload_file(folder + '/' + name, "c:/TestData/" + name)
result = api.cells_worksheets_post_worksheet_text_search(name, sheet_name, text, folder=folder)
Raw
GetAllDocumentProperties.py
# For complete examples and data files, please go to https://github.com/aspose-cells-cloud/aspose-cells-cloud-python
import os
import sys
import asposecellscloud
from asposecellscloud.apis.cells_api import CellsApi
api = asposecellscloud.apis.cells_api.CellsApi(os.getenv('CellsCloudClientId'),os.getenv('CellsCloudClientSecret'),"v3.0",os.getenv('CellsCloudApiBaseUrl'))
name ='Book1.xlsx'
folder = "PythonTest"
result = api.upload_file(folder + '/' + name, "c:/TestData/" + name)
result = api.cells_properties_get_document_properties(name,folder=folder)
Raw
GetAutoshapeFromWorksheet.py
# For complete examples and data files, please go to https://github.com/aspose-cells-cloud/aspose-cells-cloud-python
import os
import sys
import asposecellscloud
from asposecellscloud.apis.cells_api import CellsApi
api = asposecellscloud.apis.cells_api.CellsApi(os.getenv('CellsCloudClientId'),os.getenv('CellsCloudClientSecret'),"v3.0",os.getenv('CellsCloudApiBaseUrl'))
name ='myDocument.xlsx'
sheet_name ='Sheet2'
autoshapeNumber = 4
folder = "PythonTest"
result = api.upload_file(folder + '/' + name, "c:/TestData/" + name)
result = api.cells_autoshapes_get_worksheet_autoshape(name, sheet_name,autoshapeNumber, folder=folder)
Raw
GetCellFromWorksheet.py
# For complete examples and data files, please go to https://github.com/aspose-cells-cloud/aspose-cells-cloud-python
import os
import sys
import asposecellscloud
from asposecellscloud.apis.cells_api import CellsApi
api = asposecellscloud.apis.cells_api.CellsApi(os.getenv('CellsCloudClientId'),os.getenv('CellsCloudClientSecret'),"v3.0",os.getenv('CellsCloudApiBaseUrl'))
name ='Book1.xlsx'
sheet_name ='Sheet1'
cell_or_method_name = 'C1'
folder = "PythonTest"
result = api.upload_file(folder + '/' + name, "c:/TestData/" + name)
result = api.cells_get_worksheet_cell(name, sheet_name, cell_or_method_name, folder = folder)
Raw
GetCellStyleFromWorksheet.py
# For complete examples and data files, please go to https://github.com/aspose-cells-cloud/aspose-cells-cloud-python
import os
import sys
import asposecellscloud
from asposecellscloud.apis.cells_api import CellsApi
api = asposecellscloud.apis.cells_api.CellsApi(os.getenv('CellsCloudClientId'),os.getenv('CellsCloudClientSecret'),"v3.0",os.getenv('CellsCloudApiBaseUrl'))
name ='Book1.xlsx'
sheet_name ='Sheet1'
cellName = 'C1'
folder = "PythonTest"
result = api.upload_file(folder + '/' + name, "c:/TestData/" + name)
result = api.cells_get_worksheet_cell_style(name, sheet_name, cellName, folder = folder)
Raw
GetChartAreaFromWorksheet.py
# For complete examples and data files, please go to https://github.com/aspose-cells-cloud/aspose-cells-cloud-python
import os
import sys
import asposecellscloud
from asposecellscloud.apis.cells_api import CellsApi
api = asposecellscloud.apis.cells_api.CellsApi(os.getenv('CellsCloudClientId'),os.getenv('CellsCloudClientSecret'),"v3.0",os.getenv('CellsCloudApiBaseUrl'))
name ='myDocument.xlsx'
sheet_name ='Sheet3'
chartIndex = 0
folder = "PythonTest"
result = api.upload_file(folder + '/' + name, "c:/TestData/" + name)
result = api.cells_chart_area_get_chart_area(name, sheet_name,chartIndex, folder=folder)
Raw
GetChartFromWorksheet.py
# For complete examples and data files, please go to https://github.com/aspose-cells-cloud/aspose-cells-cloud-python
import os
import sys
import asposecellscloud
from asposecellscloud.apis.cells_api import CellsApi
api = asposecellscloud.apis.cells_api.CellsApi(os.getenv('CellsCloudClientId'),os.getenv('CellsCloudClientSecret'),"v3.0",os.getenv('CellsCloudApiBaseUrl'))
name ='myDocument.xlsx'
sheet_name ='Sheet3'
chartIndex = 0
format = 'png'
folder = "PythonTest"
result = api.upload_file(folder + '/' + name, "c:/TestData/" + name)
result = api.cells_charts_get_worksheet_chart(name, sheet_name, chartIndex, format=format, folder=folder)
Raw
GetChartLegendFromWorksheet.py
# For complete examples and data files, please go to https://github.com/aspose-cells-cloud/aspose-cells-cloud-python
import os
import sys
import asposecellscloud
from asposecellscloud.apis.cells_api import CellsApi
api = asposecellscloud.apis.cells_api.CellsApi(os.getenv('CellsCloudClientId'),os.getenv('CellsCloudClientSecret'),"v3.0",os.getenv('CellsCloudApiBaseUrl'))
name ='myDocument.xlsx'
sheet_name ='Sheet3'
chartIndex = 0
folder = "PythonTest"
result = api.upload_file(folder + '/' + name, "c:/TestData/" + name)
result = api.cells_charts_get_worksheet_chart_legend(name, sheet_name,chartIndex, folder=folder)
Raw
GetColumnFromWorksheet.py
# For complete examples and data files, please go to https://github.com/aspose-cells-cloud/aspose-cells-cloud-python
import os
import sys
import asposecellscloud
from asposecellscloud.apis.cells_api import CellsApi
api = asposecellscloud.apis.cells_api.CellsApi(os.getenv('CellsCloudClientId'),os.getenv('CellsCloudClientSecret'),"v3.0",os.getenv('CellsCloudApiBaseUrl'))
name ='Book1.xlsx'
sheet_name ='Sheet1'
columnIndex = 2
folder = "PythonTest"
result = api.upload_file(folder + '/' + name, "c:/TestData/" + name)
result = api.cells_get_worksheet_column(name, sheet_name, columnIndex, folder = folder)
Raw
GetCommentFromWorksheet.py
# For complete examples and data files, please go to https://github.com/aspose-cells-cloud/aspose-cells-cloud-python
import os
import sys
import asposecellscloud
from asposecellscloud.apis.cells_api import CellsApi
api = asposecellscloud.apis.cells_api.CellsApi(os.getenv('CellsCloudClientId'),os.getenv('CellsCloudClientSecret'),"v3.0",os.getenv('CellsCloudApiBaseUrl'))
name ='Book1.xlsx'
sheet_name ='Sheet1'
cellName = "B3"
folder = "PythonTest"
result = api.upload_file(folder + '/' + name, "c:/TestData/" + name)
result = api.cells_worksheets_get_worksheet_comment(name, sheet_name, cellName, folder=folder)
Raw
GetFillFormatOfChartAreaFromWorksheet.py
# For complete examples and data files, please go to https://github.com/aspose-cells-cloud/aspose-cells-cloud-python
import os
import sys
import asposecellscloud
from asposecellscloud.apis.cells_api import CellsApi
api = asposecellscloud.apis.cells_api.CellsApi(os.getenv('CellsCloudClientId'),os.getenv('CellsCloudClientSecret'),"v3.0",os.getenv('CellsCloudApiBaseUrl'))
name ='myDocument.xlsx'
sheet_name ='Sheet3'
chartIndex = 0
folder = "PythonTest"
result = api.upload_file(folder + '/' + name, "c:/TestData/" + name)
result = api.cells_chart_area_get_chart_area_fill_format(name, sheet_name,chartIndex, folder = folder)
Raw
GetFirstCellFromExcelWorksheet.py
# For complete examples and data files, please go to https://github.com/aspose-cells-cloud/aspose-cells-cloud-python
import os
import sys
import asposecellscloud
from asposecellscloud.apis.cells_api import CellsApi
api = asposecellscloud.apis.cells_api.CellsApi(os.getenv('CellsCloudClientId'),os.getenv('CellsCloudClientSecret'),"v3.0",os.getenv('CellsCloudApiBaseUrl'))
name ='Book1.xlsx'
sheet_name ='Sheet1'
cell_or_method_name = 'firstcell'
folder = "PythonTest"
result = api.upload_file(folder + '/' + name, "c:/TestData/" + name)
result = api.cells_get_worksheet_cell(name, sheet_name, cell_or_method_name, folder = folder)
Raw
GetHyperlinkFromExcelWorksheet.py
# For complete examples and data files, please go to https://github.com/aspose-cells-cloud/aspose-cells-cloud-python
import os
import sys
import asposecellscloud
from asposecellscloud.apis.cells_api import CellsApi
api = asposecellscloud.apis.cells_api.CellsApi(os.getenv('CellsCloudClientId'),os.getenv('CellsCloudClientSecret'),"v3.0",os.getenv('CellsCloudApiBaseUrl'))
name ='Book1.xlsx'
sheet_name ='Sheet1'
hyperlinkIndex = 0
folder = "PythonTest"
result = api.upload_file(folder + '/' + name, "c:/TestData/" + name)
result = api.cells_hypelinks_get_worksheet_hyperlink(name, sheet_name,hyperlinkIndex,folder=folder)
Raw
GetLastCellOfExcelWorksheet.py
# For complete examples and data files, please go to https://github.com/aspose-cells-cloud/aspose-cells-cloud-python
import os
import sys
import asposecellscloud
from asposecellscloud.apis.cells_api import CellsApi
api = asposecellscloud.apis.cells_api.CellsApi(os.getenv('CellsCloudClientId'),os.getenv('CellsCloudClientSecret'),"v3.0",os.getenv('CellsCloudApiBaseUrl'))
name ='Book1.xlsx'
sheet_name ='Sheet1'
cell_or_method_name = 'endcell'
folder = "PythonTest"
result = api.upload_file(folder + '/' + name, "c:/TestData/" + name)
result = api.cells_get_worksheet_cell(name, sheet_name, cell_or_method_name, folder = folder)
Raw
GetMaxColumnFromExcelWorksheet.py
# For complete examples and data files, please go to https://github.com/aspose-cells-cloud/aspose-cells-cloud-python
import os
import sys
import asposecellscloud
from asposecellscloud.apis.cells_api import CellsApi
api = asposecellscloud.apis.cells_api.CellsApi(os.getenv('CellsCloudClientId'),os.getenv('CellsCloudClientSecret'),"v3.0",os.getenv('CellsCloudApiBaseUrl'))
name ='Book1.xlsx'
sheet_name ='Sheet1'
cell_or_method_name = 'maxcolumn'
folder = "PythonTest"
result = api.upload_file(folder + '/' + name, "c:/TestData/" + name)
result = api.cells_get_worksheet_cell(name, sheet_name, cell_or_method_name, folder = folder)
Raw
GetMaxDataColumnFromExcelWorksheet.py
# For complete examples and data files, please go to https://github.com/aspose-cells-cloud/aspose-cells-cloud-python
import os
import sys
import asposecellscloud
from asposecellscloud.apis.cells_api import CellsApi
api = asposecellscloud.apis.cells_api.CellsApi(os.getenv('CellsCloudClientId'),os.getenv('CellsCloudClientSecret'),"v3.0",os.getenv('CellsCloudApiBaseUrl'))
name ='Book1.xlsx'
sheet_name ='Sheet1'
cell_or_method_name = 'maxdatacolumn'
folder = "PythonTest"
result = api.upload_file(folder + '/' + name, "c:/TestData/" + name)
result = api.cells_get_worksheet_cell(name, sheet_name, cell_or_method_name, folder = folder)
Raw
GetMaxDataRowFromExcelWorksheet.py
# For complete examples and data files, please go to https://github.com/aspose-cells-cloud/aspose-cells-cloud-python
import os
import sys
import asposecellscloud
from asposecellscloud.apis.cells_api import CellsApi
api = asposecellscloud.apis.cells_api.CellsApi(os.getenv('CellsCloudClientId'),os.getenv('CellsCloudClientSecret'),"v3.0",os.getenv('CellsCloudApiBaseUrl'))
name ='Book1.xlsx'
sheet_name ='Sheet1'
cell_or_method_name = 'maxdatarow'
folder = "PythonTest"
result = api.upload_file(folder + '/' + name, "c:/TestData/" + name)
result = api.cells_get_worksheet_cell(name, sheet_name, cell_or_method_name, folder = folder)
Raw
GetMaxRowFromExcelWorksheet.py
# For complete examples and data files, please go to https://github.com/aspose-cells-cloud/aspose-cells-cloud-python
import os
import sys
import asposecellscloud
from asposecellscloud.apis.cells_api import CellsApi
api = asposecellscloud.apis.cells_api.CellsApi(os.getenv('CellsCloudClientId'),os.getenv('CellsCloudClientSecret'),"v3.0",os.getenv('CellsCloudApiBaseUrl'))
name ='Book1.xlsx'
sheet_name ='Sheet1'
cell_or_method_name = 'maxrow'
folder = "PythonTest"
result = api.upload_file(folder + '/' + name, "c:/TestData/" + name)
result = api.cells_get_worksheet_cell(name, sheet_name, cell_or_method_name, folder = folder)
Raw
GetMergedCellFromWorksheet.py
# For complete examples and data files, please go to https://github.com/aspose-cells-cloud/aspose-cells-cloud-python
import os
import sys
import asposecellscloud
from asposecellscloud.apis.cells_api import CellsApi
api = asposecellscloud.apis.cells_api.CellsApi(os.getenv('CellsCloudClientId'),os.getenv('CellsCloudClientSecret'),"v3.0",os.getenv('CellsCloudApiBaseUrl'))
name ='Book1.xlsx'
sheet_name ='Sheet1'
mergedCellIndex =1
folder = "PythonTest"
result = api.upload_file(folder + '/' + name, "c:/TestData/" + name)
result = api.cells_worksheets_get_worksheet_merged_cell(name, sheet_name,mergedCellIndex, folder=folder)
Raw
GetMinColumnFromExcelWorksheet.py
# For complete examples and data files, please go to https://github.com/aspose-cells-cloud/aspose-cells-cloud-python
import os
import sys
import asposecellscloud
from asposecellscloud.apis.cells_api import CellsApi
api = asposecellscloud.apis.cells_api.CellsApi(os.getenv('CellsCloudClientId'),os.getenv('CellsCloudClientSecret'),"v3.0",os.getenv('CellsCloudApiBaseUrl'))
name ='Book1.xlsx'
sheet_name ='Sheet1'
cell_or_method_name = 'mincolumn'
folder = "PythonTest"
result = api.upload_file(folder + '/' + name, "c:/TestData/" + name)
result = api.cells_get_worksheet_cell(name, sheet_name, cell_or_method_name, folder = folder)
Raw
GetMinDataColumnFromExcelWorksheet.py
# For complete examples and data files, please go to https://github.com/aspose-cells-cloud/aspose-cells-cloud-python
import os
import sys
import asposecellscloud
from asposecellscloud.apis.cells_api import CellsApi
api = asposecellscloud.apis.cells_api.CellsApi(os.getenv('CellsCloudClientId'),os.getenv('CellsCloudClientSecret'),"v3.0",os.getenv('CellsCloudApiBaseUrl'))
name ='Book1.xlsx'
sheet_name ='Sheet1'
cell_or_method_name = 'mindatacolumn'
folder = "PythonTest"
result = api.upload_file(folder + '/' + name, "c:/TestData/" + name)
result = api.cells_get_worksheet_cell(name, sheet_name, cell_or_method_name, folder = folder)
Raw
GetMinDataRowFromExcelWorksheet.py
# For complete examples and data files, please go to https://github.com/aspose-cells-cloud/aspose-cells-cloud-python
import os
import sys
import asposecellscloud
from asposecellscloud.apis.cells_api import CellsApi
api = asposecellscloud.apis.cells_api.CellsApi(os.getenv('CellsCloudClientId'),os.getenv('CellsCloudClientSecret'),"v3.0",os.getenv('CellsCloudApiBaseUrl'))
name ='Book1.xlsx'
sheet_name ='Sheet1'
cell_or_method_name = 'mindatarow'
folder = "PythonTest"
result = api.upload_file(folder + '/' + name, "c:/TestData/" + name)
result = api.cells_get_worksheet_cell(name, sheet_name, cell_or_method_name, folder = folder)
Raw
GetMinRowFromExcelWorksheet.py
# For complete examples and data files, please go to https://github.com/aspose-cells-cloud/aspose-cells-cloud-python
import os
import sys
import asposecellscloud
from asposecellscloud.apis.cells_api import CellsApi
api = asposecellscloud.apis.cells_api.CellsApi(os.getenv('CellsCloudClientId'),os.getenv('CellsCloudClientSecret'),"v3.0",os.getenv('CellsCloudApiBaseUrl'))
name ='Book1.xlsx'
sheet_name ='Sheet1'
cell_or_method_name = 'minrow'
folder = "PythonTest"
result = api.upload_file(folder + '/' + name, "c:/TestData/" + name)
result = api.cells_get_worksheet_cell(name, sheet_name, cell_or_method_name, folder = folder)
Raw
GetNamesCountFromExcelWorkbook.py
# For complete examples and data files, please go to https://github.com/aspose-cells-cloud/aspose-cells-cloud-python
import os
import sys
import asposecellscloud
from asposecellscloud.apis.cells_api import CellsApi
api = asposecellscloud.apis.cells_api.CellsApi(os.getenv('CellsCloudClientId'),os.getenv('CellsCloudClientSecret'),"v3.0",os.getenv('CellsCloudApiBaseUrl'))
name ='Book1.xlsx'
folder = "PythonTest"
result = api.upload_file(folder + '/' + name, "c:/TestData/" + name)
result = api.cells_workbook_get_workbook_names(name, folder=folder)
Raw
GetOLEObjectFromWorksheet.py
# For complete examples and data files, please go to https://github.com/aspose-cells-cloud/aspose-cells-cloud-python
import os
import sys
import asposecellscloud
from asposecellscloud.apis.cells_api import CellsApi
api = asposecellscloud.apis.cells_api.CellsApi(os.getenv('CellsCloudClientId'),os.getenv('CellsCloudClientSecret'),"v3.0",os.getenv('CellsCloudApiBaseUrl'))
name ='Book1.xlsx'
sheet_name ='Sheet6'
oleObjectIndex = 0
folder = "PythonTest"
result = api.upload_file(folder + '/' + name, "c:/TestData/" + name)
result = api.cells_ole_objects_get_worksheet_ole_object(name, sheet_name,oleObjectIndex,folder=folder)
Raw
GetParticularDocumentProperty.py
# For complete examples and data files, please go to https://github.com/aspose-cells-cloud/aspose-cells-cloud-python
import os
import sys
import asposecellscloud
from asposecellscloud.apis.cells_api import CellsApi
api = asposecellscloud.apis.cells_api.CellsApi(os.getenv('CellsCloudClientId'),os.getenv('CellsCloudClientSecret'),"v3.0",os.getenv('CellsCloudApiBaseUrl'))
name ='Book1.xlsx'
propertyName = "Author"
folder = "PythonTest"
result = api.upload_file(folder + '/' + name, "c:/TestData/" + name)
result = api.cells_properties_get_document_property(name,propertyName,folder=folder)
Raw
GetPictureFromExcelWorksheet.py
# For complete examples and data files, please go to https://github.com/aspose-cells-cloud/aspose-cells-cloud-python
import os
import sys
import asposecellscloud
from asposecellscloud.apis.cells_api import CellsApi
api = asposecellscloud.apis.cells_api.CellsApi(os.getenv('CellsCloudClientId'),os.getenv('CellsCloudClientSecret'),"v3.0",os.getenv('CellsCloudApiBaseUrl'))
name ='Book1.xlsx'
sheet_name ='Sheet6'
pictureIndex = 0
folder = "PythonTest"
result = api.upload_file(folder + '/' + name, "c:/TestData/" + name)
result = api.cells_pictures_get_worksheet_picture(name, sheet_name,pictureIndex,folder=folder)
Raw
GetRowFromWorksheet.py
# For complete examples and data files, please go to https://github.com/aspose-cells-cloud/aspose-cells-cloud-python
import os
import sys
import asposecellscloud
from asposecellscloud.apis.cells_api import CellsApi
api = asposecellscloud.apis.cells_api.CellsApi(os.getenv('CellsCloudClientId'),os.getenv('CellsCloudClientSecret'),"v3.0",os.getenv('CellsCloudApiBaseUrl'))
name ='Book1.xlsx'
sheet_name ='Sheet1'
rowIndex = 1
folder = "PythonTest"
result = api.upload_file(folder + '/' + name, "c:/TestData/" + name)
result = api.cells_get_worksheet_row(name, sheet_name, rowIndex,folder=folder)
Raw
GetTextItemsFromWorkbook.py
# For complete examples and data files, please go to https://github.com/aspose-cells-cloud/aspose-cells-cloud-python
import os
import sys
import asposecellscloud
from asposecellscloud.apis.cells_api import CellsApi
api = asposecellscloud.apis.cells_api.CellsApi(os.getenv('CellsCloudClientId'),os.getenv('CellsCloudClientSecret'),"v3.0",os.getenv('CellsCloudApiBaseUrl'))
name ='Book1.xlsx'
folder = "PythonTest"
result = api.upload_file(folder + '/' + name, "c:/TestData/" + name)
result = api.cells_workbook_get_workbook_text_items(name, folder=folder)
Raw
GetTextITemsFromWorkSheet.py
# For complete examples and data files, please go to https://github.com/aspose-cells-cloud/aspose-cells-cloud-python
import os
import sys
import asposecellscloud
from asposecellscloud.apis.cells_api import CellsApi
api = asposecellscloud.apis.cells_api.CellsApi(os.getenv('CellsCloudClientId'),os.getenv('CellsCloudClientSecret'),"v3.0",os.getenv('CellsCloudApiBaseUrl'))
name ='Book1.xlsx'
folder = "PythonTest"
result = api.upload_file(folder + '/' + name, "c:/TestData/" + name)
result = api.test_cells_worksheets_get_worksheet_text_items(name, folder=folder)
Raw
GetValidationFromWorksheet.py
# For complete examples and data files, please go to https://github.com/aspose-cells-cloud/aspose-cells-cloud-python
import os
import sys
import asposecellscloud
from asposecellscloud.apis.cells_api import CellsApi
api = asposecellscloud.apis.cells_api.CellsApi(os.getenv('CellsCloudClientId'),os.getenv('CellsCloudClientSecret'),"v3.0",os.getenv('CellsCloudApiBaseUrl'))
name ='Book1.xlsx'
sheet_name ='Sheet1'
validationIndex = 0
folder = "PythonTest"
result = api.upload_file(folder + '/' + name, "c:/TestData/" + name)
result = api.cells_worksheet_validations_get_worksheet_validation(name, sheet_name, validationIndex, folder=folder)
Raw
GetWorksheetCount.py
# For complete examples and data files, please go to https://github.com/aspose-cells-cloud/aspose-cells-cloud-python
import os
import sys
import asposecellscloud
from asposecellscloud.apis.cells_api import CellsApi
api = asposecellscloud.apis.cells_api.CellsApi(os.getenv('CellsCloudClientId'),os.getenv('CellsCloudClientSecret'),"v3.0",os.getenv('CellsCloudApiBaseUrl'))
name ='Book1.xlsx'
sheet_name ='Sheet1'
folder = "PythonTest"
result = api.upload_file(folder + '/' + name, "c:/TestData/" + name)
result = api.cells_worksheets_get_worksheets(name, folder=folder)
Raw
GetWorksheetPivotTablesInformation.py
# For complete examples and data files, please go to https://github.com/aspose-cells-cloud/aspose-cells-cloud-python
import os
import sys
import asposecellscloud
from asposecellscloud.apis.cells_api import CellsApi
api = asposecellscloud.apis.cells_api.CellsApi(os.getenv('CellsCloudClientId'),os.getenv('CellsCloudClientSecret'),"v3.0",os.getenv('CellsCloudApiBaseUrl'))
name ='TestCase.xlsx'
sheet_name ='Sheet4'
pivotTableIndex = 0
fieldIndex = 0
folder = "PythonTest"
result = api.upload_file(folder + '/' + name, "c:/TestData/" + name)
result = api.cells_pivot_tables_get_worksheet_pivot_tables(name, sheet_name, folder=folder)
Raw
GetWorksheetPivotTablesInformationByIndex.py
# For complete examples and data files, please go to https://github.com/aspose-cells-cloud/aspose-cells-cloud-python
import os
import sys
import asposecellscloud
from asposecellscloud.apis.cells_api import CellsApi
api = asposecellscloud.apis.cells_api.CellsApi(os.getenv('CellsCloudClientId'),os.getenv('CellsCloudClientSecret'),"v3.0",os.getenv('CellsCloudApiBaseUrl'))
name ='TestCase.xlsx'
sheet_name ='Sheet4'
pivotTableIndex = 0
fieldIndex = 0
folder = "PythonTest"
result = api.upload_file(folder + '/' + name, "c:/TestData/" + name)
result = api.cells_pivot_tables_get_worksheet_pivot_table(name, sheet_name,pivotTableIndex, folder=folder)
Raw
GroupRowsInExcelWorksheet.py
# For complete examples and data files, please go to https://github.com/aspose-cells-cloud/aspose-cells-cloud-python
import os
import sys
import asposecellscloud
from asposecellscloud.apis.cells_api import CellsApi
api = asposecellscloud.apis.cells_api.CellsApi(os.getenv('CellsCloudClientId'),os.getenv('CellsCloudClientSecret'),"v3.0",os.getenv('CellsCloudApiBaseUrl'))
name ='Book1.xlsx'
sheet_name ='Sheet1'
firstIndex = 1
lastIndex = 21
hide ='true'
folder = "PythonTest"
result = api.upload_file(folder + '/' + name, "c:/TestData/" + name)
result = api.cells_post_group_worksheet_rows(name, sheet_name, firstIndex, lastIndex,hide=hide,folder=folder)
Raw
HideChartLegendInWorkSheet.py
# For complete examples and data files, please go to https://github.com/aspose-cells-cloud/aspose-cells-cloud-python
import os
import sys
import asposecellscloud
from asposecellscloud.apis.cells_api import CellsApi
api = asposecellscloud.apis.cells_api.CellsApi(os.getenv('CellsCloudClientId'),os.getenv('CellsCloudClientSecret'),"v3.0",os.getenv('CellsCloudApiBaseUrl'))
name ='myDocument.xlsx'
sheet_name ='Sheet3'
chartIndex = 1
folder = "PythonTest"
result = api.upload_file(folder + '/' + name, "c:/TestData/" + name)
result = api.cells_charts_delete_worksheet_chart_legend(name, sheet_name,chartIndex, folder=folder)
Raw
HideExcelWorkSheets.py
# For complete examples and data files, please go to https://github.com/aspose-cells-cloud/aspose-cells-cloud-python
import os
import sys
import asposecellscloud
from asposecellscloud.apis.cells_api import CellsApi
api = asposecellscloud.apis.cells_api.CellsApi(os.getenv('CellsCloudClientId'),os.getenv('CellsCloudClientSecret'),"v3.0",os.getenv('CellsCloudApiBaseUrl'))
name = "Book1.xlsx"
sheet_name ='Sheet1'
isVisible = True
sheettype = "VB"
folder = "PythonTest"
result = api.upload_file(folder + '/' + name, "c:/TestData/" + name)
result = api.cells_worksheets_put_change_visibility_worksheet(name, sheet_name, isVisible, folder=folder)
Raw
HideRowsInExcelWorksheet.py
# For complete examples and data files, please go to https://github.com/aspose-cells-cloud/aspose-cells-cloud-python
import os
import sys
import asposecellscloud
from asposecellscloud.apis.cells_api import CellsApi
api = asposecellscloud.apis.cells_api.CellsApi(os.getenv('CellsCloudClientId'),os.getenv('CellsCloudClientSecret'),"v3.0",os.getenv('CellsCloudApiBaseUrl'))
name ='Book1.xlsx'
sheet_name ='Sheet1'
startrow = 1
totalRows = 21
folder = "PythonTest"
result = api.upload_file(folder + '/' + name, "c:/TestData/" + name)
result = api.cells_post_hide_worksheet_rows(name, sheet_name, startrow, totalRows,folder=folder)
Raw
LiteCellsAssembly.py
# For complete examples and data files, please go to https://github.com/aspose-cells-cloud/aspose-cells-cloud-python
import os
import sys
import asposecellscloud
from asposecellscloud.apis.lite_cells_api import LiteCellsApi
api = asposecellscloud.apis.lite_cells_api.LiteCellsApi(os.getenv('CellsCloudClientId'),os.getenv('CellsCloudClientSecret'),"v3.0",os.getenv('CellsCloudApiBaseUrl'))
assemblytest = os.path.dirname(os.path.realpath(__file__)) + "C:/TestData/assemblytest.xlsx"
datasource = os.path.dirname(os.path.realpath(__file__)) + "C:/TestData/datasource.xlsx"
api.post_assemble({ "assemblytest.xlsx" :assemblytest, "datasource.xlsx":datasource},"ds")
Raw
LiteCellsClear.py
# For complete examples and data files, please go to https://github.com/aspose-cells-cloud/aspose-cells-cloud-python
import os
import sys
import asposecellscloud
from asposecellscloud.apis.lite_cells_api import LiteCellsApi
api = asposecellscloud.apis.lite_cells_api.LiteCellsApi(os.getenv('CellsCloudClientId'),os.getenv('CellsCloudClientSecret'),"v3.0",os.getenv('CellsCloudApiBaseUrl'))
assemblytest = os.path.dirname(os.path.realpath(__file__)) + "C:/TestData/assemblytest.xlsx"
datasource = os.path.dirname(os.path.realpath(__file__)) + "C:/TestData/datasource.xlsx"
api.post_clear_objects({ "assemblytest.xlsx" :assemblytest, "datasource.xlsx":datasource},"chart")
Raw
LiteCellsExport.py
# For complete examples and data files, please go to https://github.com/aspose-cells-cloud/aspose-cells-cloud-python
import os
import sys
import asposecellscloud
from asposecellscloud.apis.lite_cells_api import LiteCellsApi
api = asposecellscloud.apis.lite_cells_api.LiteCellsApi(os.getenv('CellsCloudClientId'),os.getenv('CellsCloudClientSecret'),"v3.0",os.getenv('CellsCloudApiBaseUrl'))
assemblytest = os.path.dirname(os.path.realpath(__file__)) + "C:/TestData/assemblytest.xlsx"
datasource = os.path.dirname(os.path.realpath(__file__)) + "C:/TestData/datasource.xlsx"
api.post_export({ "assemblytest.xlsx" :assemblytest, "datasource.xlsx":datasource},"chart","png")
Raw
LiteCellsMerge.py
# For complete examples and data files, please go to https://github.com/aspose-cells-cloud/aspose-cells-cloud-python
import os
import sys
import asposecellscloud
from asposecellscloud.apis.lite_cells_api import LiteCellsApi
api = asposecellscloud.apis.lite_cells_api.LiteCellsApi(os.getenv('CellsCloudClientId'),os.getenv('CellsCloudClientSecret'),"v3.0",os.getenv('CellsCloudApiBaseUrl'))
assemblytest = os.path.dirname(os.path.realpath(__file__)) + "C:/TestData/assemblytest.xlsx"
datasource = os.path.dirname(os.path.realpath(__file__)) + "C:/TestData/datasource.xlsx"
api.post_merge({ "assemblytest.xlsx" :assemblytest, "datasource.xlsx":datasource})
Raw
LiteCellsMeta-Delete.py
# For complete examples and data files, please go to https://github.com/aspose-cells-cloud/aspose-cells-cloud-python
import os
import sys
import asposecellscloud
from asposecellscloud.apis.lite_cells_api import LiteCellsApi
api = asposecellscloud.apis.lite_cells_api.LiteCellsApi(os.getenv('CellsCloudClientId'),os.getenv('CellsCloudClientSecret'),"v3.0",os.getenv('CellsCloudApiBaseUrl'))
assemblytest = os.path.dirname(os.path.realpath(__file__)) + "C:/TestData/assemblytest.xlsx"
datasource = os.path.dirname(os.path.realpath(__file__)) + "C:/TestData/datasource.xlsx"
api.delete_metadata({ "assemblytest.xlsx" :assemblytest, "datasource.xlsx":datasource})
Raw
LiteCellsMeta-Get.py
# For complete examples and data files, please go to https://github.com/aspose-cells-cloud/aspose-cells-cloud-python
import os
import sys
import asposecellscloud
from asposecellscloud.apis.lite_cells_api import LiteCellsApi
api = asposecellscloud.apis.lite_cells_api.LiteCellsApi(os.getenv('CellsCloudClientId'),os.getenv('CellsCloudClientSecret'),"v3.0",os.getenv('CellsCloudApiBaseUrl'))
assemblytest = os.path.dirname(os.path.realpath(__file__)) + "C:/TestData/assemblytest.xlsx"
datasource = os.path.dirname(os.path.realpath(__file__)) + "C:/TestData/datasource.xlsx"
api.get_metadata({ "assemblytest.xlsx" :assemblytest, "datasource.xlsx":datasource})
Raw
LiteCellsMeta-Update.py
# For complete examples and data files, please go to https://github.com/aspose-cells-cloud/aspose-cells-cloud-python
import os
import sys
import asposecellscloud
from asposecellscloud.apis.lite_cells_api import LiteCellsApi
api = asposecellscloud.apis.lite_cells_api.LiteCellsApi(os.getenv('CellsCloudClientId'),os.getenv('CellsCloudClientSecret'),"v3.0",os.getenv('CellsCloudApiBaseUrl'))
assemblytest = os.path.dirname(os.path.realpath(__file__)) + "C:/TestData/assemblytest.xlsx"
datasource = os.path.dirname(os.path.realpath(__file__)) + "C:/TestData/datasource.xlsx"
documentProperty = CellsDocumentProperty()
documentProperty.name = 'test'
documentProperty.value = 'test'
documentProperties = [documentProperty]
api.post_metadata({ "assemblytest.xlsx" :assemblytest, "datasource.xlsx":datasource},documentProperties)
Raw
LiteCellsMeta.py
# For complete examples and data files, please go to https://github.com/aspose-cells-cloud/aspose-cells-cloud-python
import os
import sys
import asposecellscloud
from asposecellscloud.apis.lite_cells_api import LiteCellsApi
api = asposecellscloud.apis.lite_cells_api.LiteCellsApi(os.getenv('CellsCloudClientId'),os.getenv('CellsCloudClientSecret'),"v3.0",os.getenv('CellsCloudApiBaseUrl'))
assemblytest = os.path.dirname(os.path.realpath(__file__)) + "C:/TestData/assemblytest.xlsx"
datasource = os.path.dirname(os.path.realpath(__file__)) + "C:/TestData/datasource.xlsx"
api.get_metadata({ "assemblytest.xlsx" :assemblytest, "datasource.xlsx":datasource})
api.delete_metadata({ "assemblytest.xlsx" :assemblytest, "datasource.xlsx":datasource})
documentProperty = CellsDocumentProperty()
documentProperty.name = 'test'
documentProperty.value = 'test'
documentProperties = [documentProperty]
api.post_metadata({ "assemblytest.xlsx" :assemblytest, "datasource.xlsx":datasource},documentProperties)
Raw
LiteCellsProtect.py
# For complete examples and data files, please go to https://github.com/aspose-cells-cloud/aspose-cells-cloud-python
import os
import sys
import asposecellscloud
from asposecellscloud.apis.lite_cells_api import LiteCellsApi
api = asposecellscloud.apis.lite_cells_api.LiteCellsApi(os.getenv('CellsCloudClientId'),os.getenv('CellsCloudClientSecret'),"v3.0",os.getenv('CellsCloudApiBaseUrl'))
assemblytest = os.path.dirname(os.path.realpath(__file__)) + "C:/TestData/assemblytest.xlsx"
datasource = os.path.dirname(os.path.realpath(__file__)) + "C:/TestData/datasource.xlsx"
api.post_protect({ "assemblytest.xlsx" :assemblytest, "datasource.xlsx":datasource},"1234556")
Raw
LiteCellsSearch.py
# For complete examples and data files, please go to https://github.com/aspose-cells-cloud/aspose-cells-cloud-python
import os
import sys
import asposecellscloud
from asposecellscloud.apis.lite_cells_api import LiteCellsApi
api = asposecellscloud.apis.lite_cells_api.LiteCellsApi(os.getenv('CellsCloudClientId'),os.getenv('CellsCloudClientSecret'),"v3.0",os.getenv('CellsCloudApiBaseUrl'))
assemblytest = os.path.dirname(os.path.realpath(__file__)) + "C:/TestData/assemblytest.xlsx"
datasource = os.path.dirname(os.path.realpath(__file__)) + "C:/TestData/datasource.xlsx"
api.post_search({ "assemblytest.xlsx" :assemblytest, "datasource.xlsx":datasource},"1")
Raw
LiteCellsSplit.py
# For complete examples and data files, please go to https://github.com/aspose-cells-cloud/aspose-cells-cloud-python
import os
import sys
import asposecellscloud
from asposecellscloud.apis.lite_cells_api import LiteCellsApi
api = asposecellscloud.apis.lite_cells_api.LiteCellsApi(os.getenv('CellsCloudClientId'),os.getenv('CellsCloudClientSecret'),"v3.0",os.getenv('CellsCloudApiBaseUrl'))
assemblytest = os.path.dirname(os.path.realpath(__file__)) + "C:/TestData/assemblytest.xlsx"
datasource = os.path.dirname(os.path.realpath(__file__)) + "C:/TestData/datasource.xlsx"
api.post_split({ "assemblytest.xlsx" :assemblytest, "datasource.xlsx":datasource},"png")
Raw
LiteCellsUnlock.py
# For complete examples and data files, please go to https://github.com/aspose-cells-cloud/aspose-cells-cloud-python
import os
import sys
import asposecellscloud
from asposecellscloud.apis.lite_cells_api import LiteCellsApi
api = asposecellscloud.apis.lite_cells_api.LiteCellsApi(os.getenv('CellsCloudClientId'),os.getenv('CellsCloudClientSecret'),"v3.0",os.getenv('CellsCloudApiBaseUrl'))
needUnlocktest = os.path.dirname(os.path.realpath(__file__)) + "C:/TestData/needUnlock.xlsx"
api.post_unlock({ "needUnlock.xlsx" :needUnlockest, "datasource.xlsx":datasource},"123456")
Raw
LiteCellsWatermark.py
# For complete examples and data files, please go to https://github.com/aspose-cells-cloud/aspose-cells-cloud-python
import os
import sys
import asposecellscloud
from asposecellscloud.apis.lite_cells_api import LiteCellsApi
api = asposecellscloud.apis.lite_cells_api.LiteCellsApi(os.getenv('CellsCloudClientId'),os.getenv('CellsCloudClientSecret'),"v3.0",os.getenv('CellsCloudApiBaseUrl'))
assemblytest = os.path.dirname(os.path.realpath(__file__)) + "C:/TestData/assemblytest.xlsx"
datasource = os.path.dirname(os.path.realpath(__file__)) + "C:/TestData/datasource.xlsx"
api.post_watermark({ "assemblytest.xlsx" :assemblytest, "datasource.xlsx":datasource},"aspose cells cloid","#fff")
Raw
MergeCellsInExcelWorksheet.py
# For complete examples and data files, please go to https://github.com/aspose-cells-cloud/aspose-cells-cloud-python
import os
import sys
import asposecellscloud
from asposecellscloud.apis.cells_api import CellsApi
api = asposecellscloud.apis.cells_api.CellsApi(os.getenv('CellsCloudClientId'),os.getenv('CellsCloudClientSecret'),"v3.0",os.getenv('CellsCloudApiBaseUrl'))
name ='Book1.xlsx'
sheet_name ='Sheet1'
startRow = 1
startColumn = 1
totalRows =10
totalColumns = 2
folder = "PythonTest"
result = api.upload_file(folder + '/' + name, "c:/TestData/" + name)
result = api.cells_post_worksheet_merge(name, sheet_name, startRow, startColumn,totalRows ,totalColumns , folder = folder)
Raw
MergeExcelWorkbooks.py
# For complete examples and data files, please go to https://github.com/aspose-cells-cloud/aspose-cells-cloud-python
import os
import sys
import asposecellscloud
from asposecellscloud.apis.cells_api import CellsApi
api = asposecellscloud.apis.cells_api.CellsApi(os.getenv('CellsCloudClientId'),os.getenv('CellsCloudClientSecret'),"v3.0",os.getenv('CellsCloudApiBaseUrl'))
name ='Book1.xlsx'
folder = "PythonTest"
formatmergeWith = "myDocument.xlsx"
result = api.upload_file(folder + '/' + name, "c:/TestData/" + name)
result = AuthUtil.Ready(api, formatmergeWith, folder)
result = api.cells_workbook_post_workbooks_merge(name,folder +'/'+ formatmergeWith, folder=folder)
Raw
MoveExcelWorksheets.py
# For complete examples and data files, please go to https://github.com/aspose-cells-cloud/aspose-cells-cloud-python
import os
import sys
import asposecellscloud
from asposecellscloud.apis.cells_api import CellsApi
api = asposecellscloud.apis.cells_api.CellsApi(os.getenv('CellsCloudClientId'),os.getenv('CellsCloudClientSecret'),"v3.0",os.getenv('CellsCloudApiBaseUrl'))
name = "Book1.xlsx"
sheet_name ='Sheet1'
moving = WorksheetMovingRequest()
moving.destination_worksheet = 'Sheet3'
moving.position = "after"
folder = "PythonTest"
result = api.upload_file(folder + '/' + name, "c:/TestData/" + name)
result = api.cells_worksheets_post_move_worksheet(name, sheet_name, moving=moving, folder=folder)
Raw
ProtectExcelWorkbooks.py
# For complete examples and data files, please go to https://github.com/aspose-cells-cloud/aspose-cells-cloud-python
import os
import sys
import asposecellscloud
from asposecellscloud.apis.cells_api import CellsApi
api = asposecellscloud.apis.cells_api.CellsApi(os.getenv('CellsCloudClientId'),os.getenv('CellsCloudClientSecret'),"v3.0",os.getenv('CellsCloudApiBaseUrl'))
name ='Book1.xlsx'
folder = "PythonTest"
protection = WorkbookProtectionRequest()
protection.password = "123"
protection.protection_type = "All"
result = api.upload_file(folder + '/' + name, "c:/TestData/" + name)
result = api.cells_workbook_post_protect_document(name, protection=protection, folder=folder)
Raw
RemoveAllDocumentProperties.py
# For complete examples and data files, please go to https://github.com/aspose-cells-cloud/aspose-cells-cloud-python
import os
import sys
import asposecellscloud
from asposecellscloud.apis.cells_api import CellsApi
api = asposecellscloud.apis.cells_api.CellsApi(os.getenv('CellsCloudClientId'),os.getenv('CellsCloudClientSecret'),"v3.0",os.getenv('CellsCloudApiBaseUrl'))
name ='Book1.xlsx'
folder = "PythonTest"
result = api.upload_file(folder + '/' + name, "c:/TestData/" + name)
result = api.cells_properties_delete_document_properties(name,folder=folder)
Raw
RemoveParticularDocumentProperty.py
# For complete examples and data files, please go to https://github.com/aspose-cells-cloud/aspose-cells-cloud-python
import os
import sys
import asposecellscloud
from asposecellscloud.apis.cells_api import CellsApi
api = asposecellscloud.apis.cells_api.CellsApi(os.getenv('CellsCloudClientId'),os.getenv('CellsCloudClientSecret'),"v3.0",os.getenv('CellsCloudApiBaseUrl'))
name ='Book1.xlsx'
propertyName = "Author"
folder = "PythonTest"
result = api.upload_file(folder + '/' + name, "c:/TestData/" + name)
result = api.cells_properties_delete_document_property(name, propertyName ,folder=folder)
Raw
RemoveWorksheetFromWorkbook.py
# For complete examples and data files, please go to https://github.com/aspose-cells-cloud/aspose-cells-cloud-python
import os
import sys
import asposecellscloud
from asposecellscloud.apis.cells_api import CellsApi
api = asposecellscloud.apis.cells_api.CellsApi(os.getenv('CellsCloudClientId'),os.getenv('CellsCloudClientSecret'),"v3.0",os.getenv('CellsCloudApiBaseUrl'))
name ='Book1.xlsx'
sheet_name ='Sheet1'
folder = "PythonTest"
result = api.upload_file(folder + '/' + name, "c:/TestData/" + name)
result = api.cells_worksheets_delete_worksheet(name, sheet_name, folder=folder)
Raw
RenameExcelWorksheet.py
# For complete examples and data files, please go to https://github.com/aspose-cells-cloud/aspose-cells-cloud-python
import os
import sys
import asposecellscloud
from asposecellscloud.apis.cells_api import CellsApi
api = asposecellscloud.apis.cells_api.CellsApi(os.getenv('CellsCloudClientId'),os.getenv('CellsCloudClientSecret'),"v3.0",os.getenv('CellsCloudApiBaseUrl'))
name = "Book1.xlsx"
sheet_name ='Sheet1'
newname = "renametest"
folder = "PythonTest"
result = api.upload_file(folder + '/' + name, "c:/TestData/" + name)
result = api.cells_worksheets_post_rename_worksheet(name, sheet_name, newname, folder=folder)
Raw
ReplaceTextInWorkbook.py
# For complete examples and data files, please go to https://github.com/aspose-cells-cloud/aspose-cells-cloud-python
import os
import sys
import asposecellscloud
from asposecellscloud.apis.cells_api import CellsApi
api = asposecellscloud.apis.cells_api.CellsApi(os.getenv('CellsCloudClientId'),os.getenv('CellsCloudClientSecret'),"v3.0",os.getenv('CellsCloudApiBaseUrl'))
name ='Book1.xlsx'
folder = "PythonTest"
oldValue = "!22"
newValue = "22"
result = api.upload_file(folder + '/' + name, "c:/TestData/" + name)
result = api.cells_workbook_post_workbooks_text_replace(name, oldValue,newValue, folder=folder)
Raw
ReplaceTextInWorksheet.py
# For complete examples and data files, please go to https://github.com/aspose-cells-cloud/aspose-cells-cloud-python
import os
import sys
import asposecellscloud
from asposecellscloud.apis.cells_api import CellsApi
api = asposecellscloud.apis.cells_api.CellsApi(os.getenv('CellsCloudClientId'),os.getenv('CellsCloudClientSecret'),"v3.0",os.getenv('CellsCloudApiBaseUrl'))
name = "Book1.xlsx"
sheet_name ='Sheet1'
oldValue = "1234"
newValue = "wewew4"
folder = "PythonTest"
result = api.upload_file(folder + '/' + name, "c:/TestData/" + name)
result = api.cells_worksheets_post_worsheet_text_replace(name, sheet_name, oldValue, newValue, folder=folder)
Raw
SetAllDocumentProperties.py
# For complete examples and data files, please go to https://github.com/aspose-cells-cloud/aspose-cells-cloud-python
import os
import sys
import asposecellscloud
from asposecellscloud.apis.cells_api import CellsApi
api = asposecellscloud.apis.cells_api.CellsApi(os.getenv('CellsCloudClientId'),os.getenv('CellsCloudClientSecret'),"v3.0",os.getenv('CellsCloudApiBaseUrl'))
name ='Book1.xlsx'
folder = "PythonTest"
result = api.upload_file(folder + '/' + name, "c:/TestData/" + name)
result = api.cells_properties_delete_document_properties(name,folder=folder)
Raw
SetBackgroundOrWatermark.py
# For complete examples and data files, please go to https://github.com/aspose-cells-cloud/aspose-cells-cloud-python
import os
import sys
import asposecellscloud
from asposecellscloud.apis.cells_api import CellsApi
api = asposecellscloud.apis.cells_api.CellsApi(os.getenv('CellsCloudClientId'),os.getenv('CellsCloudClientSecret'),"v3.0",os.getenv('CellsCloudApiBaseUrl'))
name = "Book1.xlsx"
sheet_name ='Sheet1'
isVisible = True
sheettype = "VB"
folder = "PythonTest"
result = api.upload_file(folder + '/' + name, "c:/TestData/" + name)
fullfilename = os.path.dirname(os.path.realpath(__file__)) + "/../TestData/" + "WaterMark.png"
f = open(fullfilename, 'rb')
png = f.read()
f.close()
result = api.cells_worksheets_put_worksheet_background(name, sheet_name, png, folder=folder)
Raw
SetCellStyleInExcelWorksheet.py
# For complete examples and data files, please go to https://github.com/aspose-cells-cloud/aspose-cells-cloud-python
import os
import sys
import asposecellscloud
from asposecellscloud.apis.cells_api import CellsApi
api = asposecellscloud.apis.cells_api.CellsApi(os.getenv('CellsCloudClientId'),os.getenv('CellsCloudClientSecret'),"v3.0",os.getenv('CellsCloudApiBaseUrl'))
name ='Book1.xlsx'
sheet_name ='Sheet1'
cellName = 'C1'
style = Style()
font = Font()
font.is_bold = True
font.size = 10
style.font = font
folder = "PythonTest"
result = api.upload_file(folder + '/' + name, "c:/TestData/" + name)
result = api.cells_post_update_worksheet_cell_style(name, sheet_name, cellName, style=style, folder = folder)
Raw
SetChartTitle.py
# For complete examples and data files, please go to https://github.com/aspose-cells-cloud/aspose-cells-cloud-python
import os
import sys
import asposecellscloud
from asposecellscloud.apis.cells_api import CellsApi
api = asposecellscloud.apis.cells_api.CellsApi(os.getenv('CellsCloudClientId'),os.getenv('CellsCloudClientSecret'),"v3.0",os.getenv('CellsCloudApiBaseUrl'))
name ='myDocument.xlsx'
sheet_name ='Sheet3'
chartIndex = 0
title = Title()
title.text = "test"
folder = "PythonTest"
result = api.upload_file(folder + '/' + name, "c:/TestData/" + name)
result = api.cells_charts_put_worksheet_chart_title(name, sheet_name, chartIndex ,title=title, folder=folder)
Raw
SetFormulaOfACellInWorksheet.py
# For complete examples and data files, please go to https://github.com/aspose-cells-cloud/aspose-cells-cloud-python
import os
import sys
import asposecellscloud
from asposecellscloud.apis.cells_api import CellsApi
api = asposecellscloud.apis.cells_api.CellsApi(os.getenv('CellsCloudClientId'),os.getenv('CellsCloudClientSecret'),"v3.0",os.getenv('CellsCloudApiBaseUrl'))
name ='Book1.xlsx'
sheet_name ='Sheet1'
cellName = 'C1'
folder = "PythonTest"
result = api.upload_file(folder + '/' + name, "c:/TestData/" + name)
result = api.cells_post_worksheet_cell_set_value(name, sheet_name, cellName, value="1", type="String", folder=folder)
result = api.cells_post_worksheet_cell_set_value(name, sheet_name, cellName, value="1", type="int", folder=folder)
result = api.cells_post_worksheet_cell_set_value(name, sheet_name, cellName, value="2018/10/09", type="DateTime", formula='=Now()', folder=folder)
Raw
SetModifyPassword.py
# For complete examples and data files, please go to https://github.com/aspose-cells-cloud/aspose-cells-cloud-python
import os
import sys
import asposecellscloud
from asposecellscloud.apis.cells_api import CellsApi
api = asposecellscloud.apis.cells_api.CellsApi(os.getenv('CellsCloudClientId'),os.getenv('CellsCloudClientSecret'),"v3.0",os.getenv('CellsCloudApiBaseUrl'))
name ='Book1.xlsx'
folder = "PythonTest"
password = PasswordRequest()
password.password = "123456"
result = api.upload_file(folder + '/' + name, "c:/TestData/" + name)
result = api.cells_workbook_put_document_protect_from_changes(name, password=password, folder=folder)
Raw
SetParticularDocumentProperties.py
# For complete examples and data files, please go to https://github.com/aspose-cells-cloud/aspose-cells-cloud-python
import os
import sys
import asposecellscloud
from asposecellscloud.apis.cells_api import CellsApi
api = asposecellscloud.apis.cells_api.CellsApi(os.getenv('CellsCloudClientId'),os.getenv('CellsCloudClientSecret'),"v3.0",os.getenv('CellsCloudApiBaseUrl'))
name ='Book1.xlsx'
propertyName = "Name"
_property = CellsDocumentProperty()
_property.name = "Author"
_property.value = "Val"
folder = "PythonTest"
result = api.upload_file(folder + '/' + name, "c:/TestData/" + name)
result = api.cells_properties_put_document_property(name,propertyName,_property=_property,folder=folder)
self.assertEqual(result.code,201)
Raw
SetRangeValueInExcelWorksheet.py
# For complete examples and data files, please go to https://github.com/aspose-cells-cloud/aspose-cells-cloud-python
import os
import sys
import asposecellscloud
from asposecellscloud.apis.cells_api import CellsApi
api = asposecellscloud.apis.cells_api.CellsApi(os.getenv('CellsCloudClientId'),os.getenv('CellsCloudClientSecret'),"v3.0",os.getenv('CellsCloudApiBaseUrl'))
name ='Book1.xlsx'
sheet_name ='Sheet1'
cellarea = 'A1:C10'
value = '12345'
type = 'String'
folder = "PythonTest"
result = api.upload_file(folder + '/' + name, "c:/TestData/" + name)
result = api.cells_post_set_cell_range_value(name, sheet_name, cellarea, value, type, folder = folder)
value = "1234"
type = "int"
result = api.cells_post_set_cell_range_value(name, sheet_name, cellarea, value, type, folder = folder)
Raw
SetValueOfaCellInWorksheet.py
# For complete examples and data files, please go to https://github.com/aspose-cells-cloud/aspose-cells-cloud-python
import os
import sys
import asposecellscloud
from asposecellscloud.apis.cells_api import CellsApi
api = asposecellscloud.apis.cells_api.CellsApi(os.getenv('CellsCloudClientId'),os.getenv('CellsCloudClientSecret'),"v3.0",os.getenv('CellsCloudApiBaseUrl'))
name ='Book1.xlsx'
sheet_name ='Sheet1'
cellName = 'C1'
folder = "PythonTest"
result = api.upload_file(folder + '/' + name, "c:/TestData/" + name)
result = api.cells_post_worksheet_cell_set_value(name, sheet_name, cellName, value="1", type="String", folder=folder)
result = api.cells_post_worksheet_cell_set_value(name, sheet_name, cellName, value="1", type="int", folder=folder)
result = api.cells_post_worksheet_cell_set_value(name, sheet_name, cellName, value="2018/10/09", type="DateTime", formula='=Now()', folder=folder)
Raw
ShowChartLegendInAWorksheet.py
# For complete examples and data files, please go to https://github.com/aspose-cells-cloud/aspose-cells-cloud-python
import os
import sys
import asposecellscloud
from asposecellscloud.apis.cells_api import CellsApi
api = asposecellscloud.apis.cells_api.CellsApi(os.getenv('CellsCloudClientId'),os.getenv('CellsCloudClientSecret'),"v3.0",os.getenv('CellsCloudApiBaseUrl'))
name ='myDocument.xlsx'
sheet_name ='Sheet3'
chartIndex = 0
folder = "PythonTest"
result = api.upload_file(folder + '/' + name, "c:/TestData/" + name)
result = api.cells_charts_get_worksheet_chart_legend(name, sheet_name,chartIndex, folder=folder)
Raw
SortWorkSheetData.py
# For complete examples and data files, please go to https://github.com/aspose-cells-cloud/aspose-cells-cloud-python
import os
import sys
import asposecellscloud
from asposecellscloud.apis.cells_api import CellsApi
api = asposecellscloud.apis.cells_api.CellsApi(os.getenv('CellsCloudClientId'),os.getenv('CellsCloudClientSecret'),"v3.0",os.getenv('CellsCloudApiBaseUrl'))
name = "Book1.xlsx"
sheet_name ='Sheet1'
cellArea = 'A1:E10'
dataSorter = DataSorter()
dataSorter.case_sensitive = True
folder = "PythonTest"
result = api.upload_file(folder + '/' + name, "c:/TestData/" + name)
result = api.cells_worksheets_post_worksheet_range_sort(name, sheet_name, cellArea, data_sorter=dataSorter, folder=folder)
Raw
SplitExcelWorkbooks.py
# For complete examples and data files, please go to https://github.com/aspose-cells-cloud/aspose-cells-cloud-python
import os
import sys
import asposecellscloud
from asposecellscloud.apis.cells_api import CellsApi
api = asposecellscloud.apis.cells_api.CellsApi(os.getenv('CellsCloudClientId'),os.getenv('CellsCloudClientSecret'),"v3.0",os.getenv('CellsCloudApiBaseUrl'))
name ='Book1.xlsx'
folder = "PythonTest"
format = "png"
_from = 1
to = 3
horizontalResolution = 100
verticalResolution = 90
result = api.upload_file(folder + '/' + name, "c:/TestData/" + name)
result = api.cells_workbook_post_workbook_split(name, format=format, _from=_from, to=to, horizontal_resolution=horizontalResolution, vertical_resolution=verticalResolution, folder=folder,out_folder=folder)
Raw
UnfreezePanesInExcelWorksheet.py
# For complete examples and data files, please go to https://github.com/aspose-cells-cloud/aspose-cells-cloud-python
import os
import sys
import asposecellscloud
from asposecellscloud.apis.cells_api import CellsApi
api = asposecellscloud.apis.cells_api.CellsApi(os.getenv('CellsCloudClientId'),os.getenv('CellsCloudClientSecret'),"v3.0",os.getenv('CellsCloudApiBaseUrl'))
name ='Book1.xlsx'
sheet_name ='Sheet1'
row = 1
column = 1
freezedRows = 2
freezedColumns = 2
folder = "PythonTest"
result = api.upload_file(folder + '/' + name, "c:/TestData/" + name)
result = api.cells_worksheets_delete_worksheet_freeze_panes(name, sheet_name, row, column, freezedRows, freezedColumns, folder=folder)
Raw
UngroupRowsInExcelWorksheet.py
# For complete examples and data files, please go to https://github.com/aspose-cells-cloud/aspose-cells-cloud-python
import os
import sys
import asposecellscloud
from asposecellscloud.apis.cells_api import CellsApi
api = asposecellscloud.apis.cells_api.CellsApi(os.getenv('CellsCloudClientId'),os.getenv('CellsCloudClientSecret'),"v3.0",os.getenv('CellsCloudApiBaseUrl'))
name ='Book1.xlsx'
sheet_name ='Sheet1'
firstIndex = 1
lastIndex = 10
isAll = True
folder = "PythonTest"
result = api.upload_file(folder + '/' + name, "c:/TestData/" + name)
result = api.cells_post_ungroup_worksheet_rows(name, sheet_name, firstIndex, lastIndex,is_all=isAll, folder=folder)
Raw
UnhideExcelWorksheets.py
# For complete examples and data files, please go to https://github.com/aspose-cells-cloud/aspose-cells-cloud-python
import os
import sys
import asposecellscloud
from asposecellscloud.apis.cells_api import CellsApi
api = asposecellscloud.apis.cells_api.CellsApi(os.getenv('CellsCloudClientId'),os.getenv('CellsCloudClientSecret'),"v3.0",os.getenv('CellsCloudApiBaseUrl'))
name = "Book1.xlsx"
sheet_name ='Sheet1'
isVisible = True
sheettype = "VB"
folder = "PythonTest"
result = api.upload_file(folder + '/' + name, "c:/TestData/" + name)
result = api.cells_worksheets_put_change_visibility_worksheet(name, sheet_name, isVisible, folder=folder)
Raw
UnhideRowsInExcelWorksheet.py
# For complete examples and data files, please go to https://github.com/aspose-cells-cloud/aspose-cells-cloud-python
import os
import sys
import asposecellscloud
from asposecellscloud.apis.cells_api import CellsApi
api = asposecellscloud.apis.cells_api.CellsApi(os.getenv('CellsCloudClientId'),os.getenv('CellsCloudClientSecret'),"v3.0",os.getenv('CellsCloudApiBaseUrl'))
name ='Book1.xlsx'
sheet_name ='Sheet1'
startrow = 1
totalRows = 10
height =20.0
folder = "PythonTest"
result = api.upload_file(folder + '/' + name, "c:/TestData/" + name)
result = api.cells_post_unhide_worksheet_rows(name, sheet_name, startrow, totalRows, height = height, folder=folder)
Raw
UnmergeCellsInExcelWorksheet.py
# For complete examples and data files, please go to https://github.com/aspose-cells-cloud/aspose-cells-cloud-python
import os
import sys
import asposecellscloud
from asposecellscloud.apis.cells_api import CellsApi
api = asposecellscloud.apis.cells_api.CellsApi(os.getenv('CellsCloudClientId'),os.getenv('CellsCloudClientSecret'),"v3.0",os.getenv('CellsCloudApiBaseUrl'))
name ='Book1.xlsx'
sheet_name ='Sheet1'
startRow = 1
startColumn = 1
totalRows =10
totalColumns = 2
folder = "PythonTest"
result = api.upload_file(folder + '/' + name, "c:/TestData/" + name)
result = api.cells_post_worksheet_unmerge(name, sheet_name, startRow, startColumn,totalRows ,totalColumns , folder = folder)
Raw
UnProtectExcelWorkbooks.py
# For complete examples and data files, please go to https://github.com/aspose-cells-cloud/aspose-cells-cloud-python
import os
import sys
import asposecellscloud
from asposecellscloud.apis.cells_api import CellsApi
api = asposecellscloud.apis.cells_api.CellsApi(os.getenv('CellsCloudClientId'),os.getenv('CellsCloudClientSecret'),"v3.0",os.getenv('CellsCloudApiBaseUrl'))
name ='Book1.xlsx'
folder = "PythonTest"
protection = WorkbookProtectionRequest()
protection.password = "123"
protection.protection_type = "All"
result = api.upload_file(folder + '/' + name, "c:/TestData/" + name)
result = api.cells_workbook_delete_unprotect_document(name, protection=protection, folder=folder)
Raw
UpdateChartLegendInWorksheet.py
# For complete examples and data files, please go to https://github.com/aspose-cells-cloud/aspose-cells-cloud-python
import os
import sys
import asposecellscloud
from asposecellscloud.apis.cells_api import CellsApi
api = asposecellscloud.apis.cells_api.CellsApi(os.getenv('CellsCloudClientId'),os.getenv('CellsCloudClientSecret'),"v3.0",os.getenv('CellsCloudApiBaseUrl'))
name ='myDocument.xlsx'
sheet_name ='Sheet3'
chartIndex = 0
legend = Legend()
legend.width = 10
folder = "PythonTest"
result = api.upload_file(folder + '/' + name, "c:/TestData/" + name)
result = api.cells_charts_post_worksheet_chart_legend(name, sheet_name, chartIndex , legend=legend , folder=folder)
Raw
UpdateChartTitleInExcelWorkbook.py
# For complete examples and data files, please go to https://github.com/aspose-cells-cloud/aspose-cells-cloud-python
import os
import sys
import asposecellscloud
from asposecellscloud.apis.cells_api import CellsApi
api = asposecellscloud.apis.cells_api.CellsApi(os.getenv('CellsCloudClientId'),os.getenv('CellsCloudClientSecret'),"v3.0",os.getenv('CellsCloudApiBaseUrl'))
name ='myDocument.xlsx'
sheet_name ='Sheet3'
chartIndex = 0
title = Title()
title.text = "test"
folder = "PythonTest"
result = api.upload_file(folder + '/' + name, "c:/TestData/" + name)
result = api.cells_charts_post_worksheet_chart_title(name, sheet_name, chartIndex , title = title, folder=folder)
Raw
UpdateHyperlinksInExcelWorksheet.py
# For complete examples and data files, please go to https://github.com/aspose-cells-cloud/aspose-cells-cloud-python
import os
import sys
import asposecellscloud
from asposecellscloud.apis.cells_api import CellsApi
api = asposecellscloud.apis.cells_api.CellsApi(os.getenv('CellsCloudClientId'),os.getenv('CellsCloudClientSecret'),"v3.0",os.getenv('CellsCloudApiBaseUrl'))
name ='Book1.xlsx'
sheet_name ='Sheet1'
hyperlinkIndex = 0
folder = "PythonTest"
hyperlink = Hyperlink()
hyperlink.address = 'http://wwww.aspose.com'
result = api.upload_file(folder + '/' + name, "c:/TestData/" + name)
result = api.cells_hypelinks_post_worksheet_hyperlink(name, sheet_name, hyperlinkIndex , hyperlink = hyperlink , folder=folder)
Raw
UpdateSpecificOLEObjectFromExcelWorksheet.py
# For complete examples and data files, please go to https://github.com/aspose-cells-cloud/aspose-cells-cloud-python
import os
import sys
import asposecellscloud
from asposecellscloud.apis.cells_api import CellsApi
api = asposecellscloud.apis.cells_api.CellsApi(os.getenv('CellsCloudClientId'),os.getenv('CellsCloudClientSecret'),"v3.0",os.getenv('CellsCloudApiBaseUrl'))
name ='Book1.xlsx'
sheet_name ='Sheet6'
oleObjectIndex = 0
ole = OleObject()
ole.left = 10
ole.right = 10
ole.height = 90
ole.width = 78
folder = "PythonTest"
result = api.upload_file(folder + '/' + name, "c:/TestData/" + name)
result = api.cells_ole_objects_post_update_worksheet_ole_object(name, sheet_name,oleObjectIndex,ole=ole,folder=folder)
Raw
UpdateSpecificPictureFromExcelWorksheet.py
# For complete examples and data files, please go to https://github.com/aspose-cells-cloud/aspose-cells-cloud-python
import os
import sys
import asposecellscloud
from asposecellscloud.apis.cells_api import CellsApi
api = asposecellscloud.apis.cells_api.CellsApi(os.getenv('CellsCloudClientId'),os.getenv('CellsCloudClientSecret'),"v3.0",os.getenv('CellsCloudApiBaseUrl'))
name ='Book1.xlsx'
sheet_name ='Sheet6'
pictureIndex = 0
picture = Picture()
picture.left = 10
folder = "PythonTest"
result = api.upload_file(folder + '/' + name, "c:/TestData/" + name)
result = api.cells_pictures_post_worksheet_picture(name, sheet_name, pictureIndex , picture=picture,folder=folder)
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment