Репай

Этот REST API указывает на файлы repair Excel.

Ремонт XLS, XLSX, XLSM, XLSB, ODS и т. д.
Поддержка нескольких файлов.

Aspose.Cells Cloud Excel Repair восстанавливает данные из поврежденных файлов Excel онлайн без установки. Поврежденные файлы Excel могут стать проблемой, поскольку вы не сможете их открыть. Вы можете попробовать приложение Aspose.Cells Cloud Excel Repair для восстановления данных из поврежденных файлов Excel.

РСЕТ API


POST https://api.aspose.cloud/v3.0/cells/repair

Параметры запроса:

Имя параметра	Тип	Путь/строка запроса/HTTPBody	Описание
файл	файл	данные формы	Файл для загрузки
формат	нить	запрос	Формат вывода. Значение по умолчанию равно нулю, формат вывода равен формату входного файла.

Спецификация OpenAPI определяет общедоступный интерфейс программирования и позволяет выполнять взаимодействие с REST непосредственно из веб-браузера.

Вы можете использовать инструмент командной строки cURL для легкого доступа к веб-службам Aspose.Cells. В следующем примере показано, как позвонить на Cloud API с помощью cURL.

Request

 
curl -v "http://api.aspose.cloud/v3.0/cells/repair" \
-X POST \
-H "Content-Type: multipart/form-data" \
-H "Accept: application/json" \
-H "Authorization: Bearer <jwt token>" \
-F 'xxxxx1=@xxxx1.xlsx' \
-F 'xxxxx2=@xxxx2.xlsx'

Response


{
    "Files":
    [
        { 
            "Filename":"xxxx1.xlsx",
            "FileSize":274022,
            "FileContent":"-----Base64String--------"
        },
        { 
            "Filename":"xxxx2.xlsx",
            "FileSize":274022,
            "FileContent":"-----Base64String--------"
        }
    ]
}

Семейство облачных SDK

Использование SDK — лучший способ ускорить разработку. SDK заботится о деталях низкого уровня и позволяет вам сосредоточиться на задачах проекта. Пожалуйста, ознакомьтесь сРепозиторий GitHub для получения полного списка Aspose.Cells Cloud SDK.

Следующие примеры кода демонстрируют, как выполнять вызовы веб-служб Aspose.Cells с использованием различных SDK:

Java

PHP

Ruby

Node.js

Android

Perl

Python

	# For complete examples and data files, please go to https://github.com/aspose-cells-cloud/aspose-cells-cloud-python
	import os

	from asposecellscloud.apis.cells_api import CellsApi
	from asposecellscloud.requests import *

	api = CellsApi(os.getenv('CellsCloudClientId'),os.getenv('CellsCloudClientSecret'),"v3.0",os.getenv('CellsCloudApiBaseUrl'))
	request = PutWorksheetChartRequest( 'myDocument.xlsx', 'Sheet3', 'Pie' ,upper_left_row= 5,upper_left_column= 5,lower_right_row= 10,lower_right_column= 10,area= 'C7:D11',is_vertical= True,title= 'Aspose Chart',folder= 'PythonTest',storage_name= '')
	api.put_worksheet_chart(request)

view raw AddChartToWorksheet.py hosted with ❤ by GitHub

	# For complete examples and data files, please go to https://github.com/aspose-cells-cloud/aspose-cells-cloud-python
	import os

	from asposecellscloud.apis.cells_api import CellsApi
	from asposecellscloud.requests import *

	api = CellsApi(os.getenv('CellsCloudClientId'),os.getenv('CellsCloudClientSecret'),"v3.0",os.getenv('CellsCloudApiBaseUrl'))
	request = PutInsertWorksheetRowsRequest( 'Book1.xlsx', 'Sheet1', 1,total_rows= 10,update_reference= True,folder= "PythonTest",storage_name= '')
	result = api.put_insert_worksheet_row(request)

view raw AddEmptyRowInWorkSheet.py hosted with ❤ by GitHub

	# For complete examples and data files, please go to https://github.com/aspose-cells-cloud/aspose-cells-cloud-python
	import os

	from asposecellscloud.apis.cells_api import CellsApi
	from asposecellscloud.requests import *

	api = CellsApi(os.getenv('CellsCloudClientId'),os.getenv('CellsCloudClientSecret'),"v3.0",os.getenv('CellsCloudApiBaseUrl'))
	request = PutWorksheetHyperlinkRequest( 'Book1.xlsx', 'Sheet1', 1, 1, 2, 3, 'https://products.aspose.cloud/cells/',folder="PythonTest",storage_name= '')
	api.put_worksheet_hyperlink(request)

view raw AddHyperlinksFromExcelWorksheet.py hosted with ❤ by GitHub

	# For complete examples and data files, please go to https://github.com/aspose-cells-cloud/aspose-cells-cloud-python
	import os

	from asposecellscloud.apis.cells_api import CellsApi
	from asposecellscloud.requests import *

	api = CellsApi(os.getenv('CellsCloudClientId'),os.getenv('CellsCloudClientSecret'),"v3.0",os.getenv('CellsCloudApiBaseUrl'))
	request = PutAddNewWorksheetRequest( "Book1.xlsx", 'Sheet1',position= 0,sheettype= 'VB',folder= "PythonTest",storage_name= '')
	api.put_add_new_worksheet(request)

view raw AddNewExcelWorksheet.py hosted with ❤ by GitHub

	# For complete examples and data files, please go to https://github.com/aspose-cells-cloud/aspose-cells-cloud-python
	import os

	from asposecellscloud.apis.cells_api import CellsApi
	from asposecellscloud.requests import *

	api = CellsApi(os.getenv('CellsCloudClientId'),os.getenv('CellsCloudClientSecret'),"v3.0",os.getenv('CellsCloudApiBaseUrl'))
	request = PutWorksheetOleObjectRequest( 'Book1.xlsx', 'Sheet6',upper_left_row= 1,upper_left_column= 1,height= 100,width= 80,ole_file= 'OLEDoc.docx',image_file= 'word.jpg',folder= "PythonTest",storage_name= '')
	api.put_worksheet_ole_object(request)

view raw AddOLEObjectsToExcelWorksheet.py hosted with ❤ by GitHub

	# For complete examples and data files, please go to https://github.com/aspose-cells-cloud/aspose-cells-cloud-python
	import os

	from asposecellscloud.apis.cells_api import CellsApi
	from asposecellscloud.requests import *

	api = CellsApi(os.getenv('CellsCloudClientId'),os.getenv('CellsCloudClientSecret'),"v3.0",os.getenv('CellsCloudApiBaseUrl'))
	request = PutWorksheetAddPictureRequest( 'Book1.xlsx', 'Sheet6',upper_left_row= 1,upper_left_column= 1,lower_right_row= 10,lower_right_column= 10,picture_path= 'PythonTest/WaterMark.png',folder= 'PythonTest',storage_name= '')
	api.put_worksheet_add_picture(request)

view raw AddPictureToExcelWorksheet.py hosted with ❤ by GitHub

	# For complete examples and data files, please go to https://github.com/aspose-cells-cloud/aspose-cells-cloud-python
	import os

	from asposecellscloud.apis.cells_api import CellsApi
	from asposecellscloud.models import *
	from asposecellscloud.requests import *

	api = CellsApi(os.getenv('CellsCloudClientId'),os.getenv('CellsCloudClientSecret'),"v3.0",os.getenv('CellsCloudApiBaseUrl'))
	pivotTableFieldRequest = PivotTableFieldRequest(data= [0] )
	request = PutPivotTableFieldRequest( 'TestCase.xlsx', 'Sheet4', 0, 'Row', pivotTableFieldRequest,need_re_calculate= True,folder= 'PythonTest',storage_name= '')
	api.put_pivot_table_field(request)

view raw AddPivotFieldInPivotTable.py hosted with ❤ by GitHub

	# For complete examples and data files, please go to https://github.com/aspose-cells-cloud/aspose-cells-cloud-python
	import os

	from asposecellscloud.apis.cells_api import CellsApi
	from asposecellscloud.models import *
	from asposecellscloud.requests import *

	api = CellsApi(os.getenv('CellsCloudClientId'),os.getenv('CellsCloudClientSecret'),"v3.0",os.getenv('CellsCloudApiBaseUrl'))
	request = PutWorksheetPivotTableRequest( 'TestCase.xlsx', 'Sheet4',folder= 'PythonTest',source_data= '=Sheet1!C6:E13',dest_cell_name= 'C1',table_name= 'TestPivot',use_same_source= True,storage_name= '')
	api.put_worksheet_pivot_table(request)

view raw AddPivotTableInWorkSheet.py hosted with ❤ by GitHub

view raw Aspose.Cells.Cloud.SDK.Python hosted with ❤ by GitHub

	# For complete examples and data files, please go to https://github.com/aspose-cells-cloud/aspose-cells-cloud-python
	import os

	from asposecellscloud.apis.cells_api import CellsApi
	from asposecellscloud.models import *
	from asposecellscloud.requests import *

	api = CellsApi(os.getenv('CellsCloudClientId'),os.getenv('CellsCloudClientSecret'),"v3.0",os.getenv('CellsCloudApiBaseUrl'))
	request = GetWorkbookRequest( 'Book1.xlsx',format= "pdf",folder= 'PythonTest')
	api.get_workbook(request)

view raw AutoFitRowsInExcelWorksheet.py hosted with ❤ by GitHub

	# For complete examples and data files, please go to https://github.com/aspose-cells-cloud/aspose-cells-cloud-python
	import os

	from asposecellscloud.apis.cells_api import CellsApi
	from asposecellscloud.models import *
	from asposecellscloud.requests import *

	api = CellsApi(os.getenv('CellsCloudClientId'),os.getenv('CellsCloudClientSecret'),"v3.0",os.getenv('CellsCloudApiBaseUrl'))
	request = GetWorksheetCalculateFormulaRequest( 'Book1.xlsx', 'Sheet1', '=NOW()',folder= 'PythonTest',storage_name= '')
	api.get_worksheet_calculate_formula(request)

view raw CalculateFormulaInWorksheet.py hosted with ❤ by GitHub

	# For complete examples and data files, please go to https://github.com/aspose-cells-cloud/aspose-cells-cloud-python
	import os

	from asposecellscloud.apis.cells_api import CellsApi
	from asposecellscloud.models import *
	from asposecellscloud.requests import *

	api = CellsApi(os.getenv('CellsCloudClientId'),os.getenv('CellsCloudClientSecret'),"v3.0",os.getenv('CellsCloudApiBaseUrl'))
	request = PostClearFormatsRequest( 'Book1.xlsx', 'Sheet1',range= 'A1:C10',start_row= 1,start_column= 1,end_row= 3,end_column= 3,folder= 'PythonTest',storage_name= '')
	api.post_clear_formats(request)

view raw ClearCellFormattingInExcelWorksheet.py hosted with ❤ by GitHub

	# For complete examples and data files, please go to https://github.com/aspose-cells-cloud/aspose-cells-cloud-python
	import os

	from asposecellscloud.apis.cells_api import CellsApi
	from asposecellscloud.models import *
	from asposecellscloud.requests import *

	api = CellsApi(os.getenv('CellsCloudClientId'),os.getenv('CellsCloudClientSecret'),"v3.0",os.getenv('CellsCloudApiBaseUrl'))
	request = PostClearContentsRequest( 'Book1.xlsx', 'Sheet1',range= 'A1:C10',start_row= 1,start_column= 1,end_row= 3,end_column= 3,folder= 'PythonTest',storage_name= '')
	api.post_clear_contents(request)

view raw ClearContentsFromExcelWorkSheet.py hosted with ❤ by GitHub

	# For complete examples and data files, please go to https://github.com/aspose-cells-cloud/aspose-cells-cloud-python
	import os

	from asposecellscloud.apis.cells_api import CellsApi
	from asposecellscloud.models import *
	from asposecellscloud.requests import *

	api = CellsApi(os.getenv('CellsCloudClientId'),os.getenv('CellsCloudClientSecret'),"v3.0",os.getenv('CellsCloudApiBaseUrl'))
	request = DeleteUnProtectWorkbookRequest( 'Book1.xlsx', 'PythonTest',folder= 'PythonTest',storage_name= '')
	api.delete_un_protect_workbook(request)

view raw ClearModifyPassword.py hosted with ❤ by GitHub

	# 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'))
	result = api.cells_autoshapes_get_worksheet_autoshape('myDocument.xlsx', 'Sheet2',4, folder='PythonTest')

view raw ConvertAutoShapeToImage.py hosted with ❤ by GitHub

	# For complete examples and data files, please go to https://github.com/aspose-cells-cloud/aspose-cells-cloud-python
	import os

	from asposecellscloud.apis.cells_api import CellsApi
	from asposecellscloud.models import *
	from asposecellscloud.requests import *

	api = CellsApi(os.getenv('CellsCloudClientId'),os.getenv('CellsCloudClientSecret'),"v3.0",os.getenv('CellsCloudApiBaseUrl'))
	request = GetWorksheetChartsRequest( 'Book1.xlsx', 'Sheet4',folder= 'PythonTest',storage_name= '')
	api.get_worksheet_charts(request)

view raw ConvertChartToImage.py hosted with ❤ by GitHub

	# For complete examples and data files, please go to https://github.com/aspose-cells-cloud/aspose-cells-cloud-python
	import os

	from asposecellscloud.apis.cells_api import CellsApi
	from asposecellscloud.models import *
	from asposecellscloud.requests import *

	api = CellsApi(os.getenv('CellsCloudClientId'),os.getenv('CellsCloudClientSecret'),"v3.0",os.getenv('CellsCloudApiBaseUrl'))
	saveOptions = PdfSaveOptions(save_format= 'pdf' )
	request = PostWorkbookSaveAsRequest( 'Book1.xlsx', 'newbook.pdf',save_options= saveOptions,folder= 'PythonTest')
	api.post_workbook_save_as(request)

view raw ConvertExcelToVariousFormats.py hosted with ❤ by GitHub

	# For complete examples and data files, please go to https://github.com/aspose-cells-cloud/aspose-cells-cloud-python
	import os

	from asposecellscloud.apis.cells_api import CellsApi
	from asposecellscloud.models import *
	from asposecellscloud.requests import *

	api = CellsApi(os.getenv('CellsCloudClientId'),os.getenv('CellsCloudClientSecret'),"v3.0",os.getenv('CellsCloudApiBaseUrl'))
	request = PutConvertWorkbookRequest( { 'Book1.xlsx': "./Book1.xlsx" },format= 'pdf')
	api.put_convert_workbook(request)

view raw ConvertExcelToVariousFormatsWithoutStorage.py hosted with ❤ by GitHub

	# For complete examples and data files, please go to https://github.com/aspose-cells-cloud/aspose-cells-cloud-python
	import os

	from asposecellscloud.apis.cells_api import CellsApi
	from asposecellscloud.models import *
	from asposecellscloud.requests import *

	api = CellsApi(os.getenv('CellsCloudClientId'),os.getenv('CellsCloudClientSecret'),"v3.0",os.getenv('CellsCloudApiBaseUrl'))
	saveOptions = PdfSaveOptions(save_format= "pdf" )
	request = PostWorkbookSaveAsRequest( 'Book1.xlsx', 'newbook.pdf',save_options= saveOptions,folder= '' ,is_auto_fit_rows= True , is_auto_fit_columns= True)
	api.post_workbook_save_as(request)

view raw ConvertExcelWorkbookWithAdditionalSettings.py hosted with ❤ by GitHub

	# For complete examples and data files, please go to https://github.com/aspose-cells-cloud/aspose-cells-cloud-python
	import os

	from asposecellscloud.apis.cells_api import CellsApi
	from asposecellscloud.models import *
	from asposecellscloud.requests import *

	api = CellsApi(os.getenv('CellsCloudClientId'),os.getenv('CellsCloudClientSecret'),"v3.0",os.getenv('CellsCloudApiBaseUrl'))
	request = GetWorksheetOleObjectsRequest( 'Book1.xlsx', 'Sheet6',folder= "PythonTest",storage_name= '')
	api.get_worksheet_ole_objects(request)

view raw ConvertOLEObjectToImage.py hosted with ❤ by GitHub

	# For complete examples and data files, please go to https://github.com/aspose-cells-cloud/aspose-cells-cloud-python
	import os

	from asposecellscloud.apis.cells_api import CellsApi
	from asposecellscloud.models import *
	from asposecellscloud.requests import *

	api = CellsApi(os.getenv('CellsCloudClientId'),os.getenv('CellsCloudClientSecret'),"v3.0",os.getenv('CellsCloudApiBaseUrl'))
	request = GetWorksheetPicturesRequest( 'Book1.xlsx', 'Sheet6',folder= 'PythonTest',storage_name= '')
	api.get_worksheet_pictures(request)

view raw ConvertPictureToImage.py hosted with ❤ by GitHub

	# For complete examples and data files, please go to https://github.com/aspose-cells-cloud/aspose-cells-cloud-python
	import os

	from asposecellscloud.apis.cells_api import CellsApi
	from asposecellscloud.models import *
	from asposecellscloud.requests import *

	api = CellsApi(os.getenv('CellsCloudClientId'),os.getenv('CellsCloudClientSecret'),"v3.0",os.getenv('CellsCloudApiBaseUrl'))
	request = GetWorksheetsRequest( 'Book1.xlsx',folder= 'PythonTest',storage_name= '')
	api.get_worksheets(request)

view raw ConvertWorkSheetToImage.py hosted with ❤ by GitHub

	# For complete examples and data files, please go to https://github.com/aspose-cells-cloud/aspose-cells-cloud-python
	import os

	from asposecellscloud.apis.cells_api import CellsApi
	from asposecellscloud.models import *
	from asposecellscloud.requests import *

	api = CellsApi(os.getenv('CellsCloudClientId'),os.getenv('CellsCloudClientSecret'),"v3.0",os.getenv('CellsCloudApiBaseUrl'))
	options = CopyOptions(column_character_width= True )
	request = PostCopyWorksheetRequest( 'Book1.xlsx', 'Sheet151', 'Sheet6', options ,source_workbook= '',source_folder= '',folder= 'PythonTest',storage_name= '')
	api.post_copy_worksheet(request)

view raw CopyExcelWorksheet.py hosted with ❤ by GitHub

	# For complete examples and data files, please go to https://github.com/aspose-cells-cloud/aspose-cells-cloud-python
	import os

	from asposecellscloud.apis.cells_api import CellsApi
	from asposecellscloud.models import *
	from asposecellscloud.requests import *

	api = CellsApi(os.getenv('CellsCloudClientId'),os.getenv('CellsCloudClientSecret'),"v3.0",os.getenv('CellsCloudApiBaseUrl'))
	request = PostCopyWorksheetRowsRequest( 'Book1.xlsx', 'Sheet1', 1, 12, 5,worksheet= 'Sheet2',folder= 'PythonTest',storage_name= '')
	api.post_copy_worksheet_rows(request)

view raw CopyRowsInExcelWorksheet.py hosted with ❤ by GitHub

	# For complete examples and data files, please go to https://github.com/aspose-cells-cloud/aspose-cells-cloud-python
	import os

	from asposecellscloud.apis.cells_api import CellsApi
	from asposecellscloud.models import *
	from asposecellscloud.requests import *

	api = CellsApi(os.getenv('CellsCloudClientId'),os.getenv('CellsCloudClientSecret'),"v3.0",os.getenv('CellsCloudApiBaseUrl'))
	request = PutWorkbookCreateRequest( 'PutWorkbookCreate.xlsx',template_file= 'PythonTest/Book1.xlsx',data_file= 'PythonTest' + '/ReportData.xml',is_write_over= True,folder= 'PythonTest',storage_name= '',check_excel_restriction= True)
	api.put_workbook_create(request)

view raw CreateEmptyExcelWorkbook.py hosted with ❤ by GitHub

	# For complete examples and data files, please go to https://github.com/aspose-cells-cloud/aspose-cells-cloud-python
	import os

	from asposecellscloud.apis.cells_api import CellsApi
	from asposecellscloud.models import *
	from asposecellscloud.requests import *

	api = CellsApi(os.getenv('CellsCloudClientId'),os.getenv('CellsCloudClientSecret'),"v3.0",os.getenv('CellsCloudApiBaseUrl'))
	request = PutWorkbookCreateRequest( 'PutWorkbookCreate.xlsx',template_file= 'PythonTest/Book1.xlsx',data_file= 'PythonTest/ReportData.xml',is_write_over= True,folder= 'PythonTest',storage_name= '',check_excel_restriction= True)
	api.put_workbook_create(request)

view raw CreateExcelWorkbookFromSmartMarkerTemplate.py hosted with ❤ by GitHub

	# For complete examples and data files, please go to https://github.com/aspose-cells-cloud/aspose-cells-cloud-python
	import os

	from asposecellscloud.apis.cells_api import CellsApi
	from asposecellscloud.models import *
	from asposecellscloud.requests import *

	api = CellsApi(os.getenv('CellsCloudClientId'),os.getenv('CellsCloudClientSecret'),"v3.0",os.getenv('CellsCloudApiBaseUrl'))
	request = PutWorkbookCreateRequest( 'PutWorkbookCreate.xlsx',template_file= 'PythonTest/Book1.xlsx',is_write_over= True,folder= 'PythonTest',storage_name= '',check_excel_restriction= True)
	api.put_workbook_create(request)

view raw CreateExcelWorkbookFromTempateFile.py hosted with ❤ by GitHub

	import os

	from asposecellscloud.apis.cells_api import CellsApi
	from asposecellscloud.models import *
	from asposecellscloud.requests import *

	api = CellsApi(os.getenv('CellsCloudClientId'),os.getenv('CellsCloudClientSecret'),"v3.0",os.getenv('CellsCloudApiBaseUrl'))
	encryption = WorkbookEncryptionRequest(password= '123456' ,encryption_type= 'XOR' ,key_length= 128 )
	request = DeleteDecryptWorkbookRequest( 'Book1.xlsx', encryption,folder= 'PythonTest',storage_name= '')
	api.delete_decrypt_workbook(request)

view raw DecryptCloudFileWithPassword.py hosted with ❤ by GitHub

	# For complete examples and data files, please go to https://github.com/aspose-cells-cloud/aspose-cells-cloud-python
	import os

	from asposecellscloud.apis.cells_api import CellsApi
	from asposecellscloud.models import *
	from asposecellscloud.requests import *

	api = CellsApi(os.getenv('CellsCloudClientId'),os.getenv('CellsCloudClientSecret'),"v3.0",os.getenv('CellsCloudApiBaseUrl'))
	encryption = WorkbookEncryptionRequest(password= '123456' ,encryption_type= 'XOR' ,key_length= 128 )
	request = PostEncryptWorkbookRequest( 'Book1.xlsx', encryption,folder= 'PythonTest',storage_name= '')
	api.post_encrypt_workbook(request)

view raw DecryptExcelWorkbooks.py hosted with ❤ by GitHub

	# For complete examples and data files, please go to https://github.com/aspose-cells-cloud/aspose-cells-cloud-python
	import os

	from asposecellscloud.apis.cells_api import CellsApi
	from asposecellscloud.models import *
	from asposecellscloud.requests import *

	api = CellsApi(os.getenv('CellsCloudClientId'),os.getenv('CellsCloudClientSecret'),"v3.0",os.getenv('CellsCloudApiBaseUrl'))
	request = DeleteWorksheetChartsRequest( 'Book1.xlsx', 'Sheet4',folder= 'PythonTest',storage_name= '')
	api.delete_worksheet_charts(request)

view raw DeleteAllChartsFromAWorksheet.py hosted with ❤ by GitHub

	# For complete examples and data files, please go to https://github.com/aspose-cells-cloud/aspose-cells-cloud-python
	import os

	from asposecellscloud.apis.cells_api import CellsApi
	from asposecellscloud.models import *
	from asposecellscloud.requests import *

	api = CellsApi(os.getenv('CellsCloudClientId'),os.getenv('CellsCloudClientSecret'),"v3.0",os.getenv('CellsCloudApiBaseUrl'))
	request = DeleteWorksheetOleObjectsRequest( 'Book1.xlsx', 'Sheet6',folder= 'PythonTest',storage_name= '')
	api.delete_worksheet_ole_objects(request)

view raw DeleteAllObjectsFromExcelWorksheet.py hosted with ❤ by GitHub

	# For complete examples and data files, please go to https://github.com/aspose-cells-cloud/aspose-cells-cloud-python
	import os

	from asposecellscloud.apis.cells_api import CellsApi
	from asposecellscloud.models import *
	from asposecellscloud.requests import *

	api = CellsApi(os.getenv('CellsCloudClientId'),os.getenv('CellsCloudClientSecret'),"v3.0",os.getenv('CellsCloudApiBaseUrl'))
	request = DeleteWorksheetPicturesRequest( 'Book1.xlsx', 'Sheet6',folder= 'PythonTest',storage_name= '')
	api.delete_worksheet_pictures(request)

view raw DeleteAllPicturesFromExcelWorksheet.py hosted with ❤ by GitHub

	# For complete examples and data files, please go to https://github.com/aspose-cells-cloud/aspose-cells-cloud-python
	import os

	from asposecellscloud.apis.cells_api import CellsApi
	from asposecellscloud.models import *
	from asposecellscloud.requests import *

	api = CellsApi(os.getenv('CellsCloudClientId'),os.getenv('CellsCloudClientSecret'),"v3.0",os.getenv('CellsCloudApiBaseUrl'))
	request = DeleteWorksheetBackgroundRequest( 'Book1.xlsx', 'Sheet1',folder= 'PythonTest',storage_name= '')
	api.delete_worksheet_background(request)

view raw DeleteBackground.py hosted with ❤ by GitHub

	# For complete examples and data files, please go to https://github.com/aspose-cells-cloud/aspose-cells-cloud-python
	import os

	from asposecellscloud.apis.cells_api import CellsApi
	from asposecellscloud.models import *
	from asposecellscloud.requests import *

	api = CellsApi(os.getenv('CellsCloudClientId'),os.getenv('CellsCloudClientSecret'),"v3.0",os.getenv('CellsCloudApiBaseUrl'))

	request = DeleteWorksheetChartTitleRequest( 'Book1.xlsx', 'Sheet4', 0,folder= 'PythonTest',storage_name= '')
	api.delete_worksheet_chart_title(request)

view raw DeleteChartExcelWorksheet.py hosted with ❤ by GitHub

	# For complete examples and data files, please go to https://github.com/aspose-cells-cloud/aspose-cells-cloud-python
	import os

	from asposecellscloud.apis.cells_api import CellsApi
	from asposecellscloud.models import *
	from asposecellscloud.requests import *

	api = CellsApi(os.getenv('CellsCloudClientId'),os.getenv('CellsCloudClientSecret'),"v3.0",os.getenv('CellsCloudApiBaseUrl'))
	result = api.delete_worksheet_chart( DeleteWorksheetChartRequest('myDocument.xlsx', 'Sheet3',0) )

view raw DeleteChartFromWorkSheet.py hosted with ❤ by GitHub

	# For complete examples and data files, please go to https://github.com/aspose-cells-cloud/aspose-cells-cloud-python
	import os

	from asposecellscloud.apis.cells_api import CellsApi
	from asposecellscloud.models import *
	from asposecellscloud.requests import *

	api = CellsApi(os.getenv('CellsCloudClientId'),os.getenv('CellsCloudClientSecret'),"v3.0",os.getenv('CellsCloudApiBaseUrl'))
	request = DeleteWorksheetHyperlinksRequest( 'Book1.xlsx', 'Sheet1',folder= 'PythonTest',storage_name= '')
	api.delete_worksheet_hyperlinks(request)

view raw DeleteHyperlinksFromExcelWorksheet.py hosted with ❤ by GitHub

	# For complete examples and data files, please go to https://github.com/aspose-cells-cloud/aspose-cells-cloud-python
	import os

	from asposecellscloud.apis.cells_api import CellsApi
	from asposecellscloud.models import *
	from asposecellscloud.requests import *

	api = CellsApi(os.getenv('CellsCloudClientId'),os.getenv('CellsCloudClientSecret'),"v3.0",os.getenv('CellsCloudApiBaseUrl'))
	request = DeleteWorksheetRowRequest( 'Book1.xlsx', 'Sheet1', 1,folder= 'PythonTest',storage_name= '')
	api.delete_worksheet_row(request)

view raw DeleteRowsFromWorkSheet.py hosted with ❤ by GitHub

	# For complete examples and data files, please go to https://github.com/aspose-cells-cloud/aspose-cells-cloud-python
	import os

	from asposecellscloud.apis.cells_api import CellsApi
	from asposecellscloud.models import *
	from asposecellscloud.requests import *

	api = CellsApi(os.getenv('CellsCloudClientId'),os.getenv('CellsCloudClientSecret'),"v3.0",os.getenv('CellsCloudApiBaseUrl'))
	request = DeleteWorksheetPictureRequest( 'Book1.xlsx', 'Sheet6', 0,folder= 'PythonTest',storage_name= '')
	api.delete_worksheet_picture(request)

view raw DeleteSpecificPictureFromExcelWorksheet.py hosted with ❤ by GitHub

	# For complete examples and data files, please go to https://github.com/aspose-cells-cloud/aspose-cells-cloud-python
	import os

	from asposecellscloud.apis.cells_api import CellsApi
	from asposecellscloud.models import *
	from asposecellscloud.requests import *

	api = CellsApi(os.getenv('CellsCloudClientId'),os.getenv('CellsCloudClientSecret'),"v3.0",os.getenv('CellsCloudApiBaseUrl'))
	request = DeleteWorksheetPivotTablesRequest( 'Book1.xlsx', 'Sheet4',folder= 'PythonTest',storage_name= '')
	api.delete_worksheet_pivot_tables(request)

view raw DeleteWorksheetPivotTables.py hosted with ❤ by GitHub

	# For complete examples and data files, please go to https://github.com/aspose-cells-cloud/aspose-cells-cloud-python
	import os

	from asposecellscloud.apis.cells_api import CellsApi
	from asposecellscloud.models import *
	from asposecellscloud.requests import *

	api = CellsApi(os.getenv('CellsCloudClientId'),os.getenv('CellsCloudClientSecret'),"v3.0",os.getenv('CellsCloudApiBaseUrl'))
	request = DeleteWorksheetPivotTableRequest( 'PivTestFile2.xlsx', 'Sheet3', 0,folder= 'PythonTest',storage_name= '')
	api.delete_worksheet_pivot_table(request)

view raw DeleteWorksheetPivotTablesByIndex.py hosted with ❤ by GitHub

	# For complete examples and data files, please go to https://github.com/aspose-cells-cloud/aspose-cells-cloud-python
	import os

	from asposecellscloud.apis.cells_api import CellsApi
	from asposecellscloud.models import *
	from asposecellscloud.requests import *

	api = CellsApi(os.getenv('CellsCloudClientId'),os.getenv('CellsCloudClientSecret'),"v3.0",os.getenv('CellsCloudApiBaseUrl'))
	request = DeleteWorksheetOleObjectRequest( 'Book1.xlsx', 'Sheet6', 0,folder= 'PythonTest',storage_name= '')
	api.delete_worksheet_ole_object(request)

view raw DelteSpecificObjectFromOLEWorksheet.py hosted with ❤ by GitHub

	import os

	from asposecellscloud.apis.cells_api import CellsApi
	from asposecellscloud.models import *
	from asposecellscloud.requests import *

	api = CellsApi(os.getenv('CellsCloudClientId'),os.getenv('CellsCloudClientSecret'),"v3.0",os.getenv('CellsCloudApiBaseUrl'))
	request = PostDigitalSignatureRequest( 'Book1.xlsx', 'PythonTest' + '/roywang.pfx', '123456',folder= 'PythonTest',storage_name= '')
	api.post_digital_signature(request)

view raw DigitalSignature.py hosted with ❤ by GitHub

	import os

	from asposecellscloud.apis.cells_api import CellsApi
	from asposecellscloud.models import *
	from asposecellscloud.requests import *

	api = CellsApi(os.getenv('CellsCloudClientId'),os.getenv('CellsCloudClientSecret'),"v3.0",os.getenv('CellsCloudApiBaseUrl'))
	encryption = WorkbookEncryptionRequest(password= '123456' ,encryption_type= 'XOR' ,key_length= 128 )
	request = PostEncryptWorkbookRequest( 'Book1.xlsx', encryption,folder= 'PythonTest',storage_name= '')
	api.post_encrypt_workbook(request)

view raw EncryptCloudFileWithPassword.py hosted with ❤ by GitHub

	# For complete examples and data files, please go to https://github.com/aspose-cells-cloud/aspose-cells-cloud-python
	import os

	from asposecellscloud.apis.cells_api import CellsApi
	from asposecellscloud.models import *
	from asposecellscloud.requests import *

	api = CellsApi(os.getenv('CellsCloudClientId'),os.getenv('CellsCloudClientSecret'),"v3.0",os.getenv('CellsCloudApiBaseUrl'))
	request = PostClearObjectsRequest( { "book1.xlsx": "book1.xlsx" ,"datasource.xlsx": "datasource.xlsx" }, 'Background')
	api.post_clear_objects(request)

view raw Example-Clear-Background.py hosted with ❤ by GitHub

	# For complete examples and data files, please go to https://github.com/aspose-cells-cloud/aspose-cells-cloud-python
	import os

	from asposecellscloud.apis.cells_api import CellsApi
	from asposecellscloud.models import *
	from asposecellscloud.requests import *

	api = CellsApi(os.getenv('CellsCloudClientId'),os.getenv('CellsCloudClientSecret'),"v3.0",os.getenv('CellsCloudApiBaseUrl'))
	request = PostClearObjectsRequest( { "book1.xlsx": "book1.xlsx" ,"datasource.xlsx": "datasource.xlsx" }, 'BlankColumns')
	api.post_clear_objects(request)

view raw Example-Clear-BlankColumns.py hosted with ❤ by GitHub

	# For complete examples and data files, please go to https://github.com/aspose-cells-cloud/aspose-cells-cloud-python
	import os

	from asposecellscloud.apis.cells_api import CellsApi
	from asposecellscloud.models import *
	from asposecellscloud.requests import *

	api = CellsApi(os.getenv('CellsCloudClientId'),os.getenv('CellsCloudClientSecret'),"v3.0",os.getenv('CellsCloudApiBaseUrl'))
	request = PostClearObjectsRequest( { "book1.xlsx": "book1.xlsx" ,"datasource.xlsx": "datasource.xlsx" }, 'BlankRows')
	api.post_clear_objects(request)

view raw Example-Clear-BlankRows.py hosted with ❤ by GitHub

	# For complete examples and data files, please go to https://github.com/aspose-cells-cloud/aspose-cells-cloud-python
	import os

	from asposecellscloud.apis.cells_api import CellsApi
	from asposecellscloud.models import *
	from asposecellscloud.requests import *

	api = CellsApi(os.getenv('CellsCloudClientId'),os.getenv('CellsCloudClientSecret'),"v3.0",os.getenv('CellsCloudApiBaseUrl'))
	request = PostClearObjectsRequest( { "book1.xlsx": "book1.xlsx" ,"datasource.xlsx": "datasource.xlsx" }, 'Chart')
	api.post_clear_objects(request)

view raw Example-Clear-Chart.py hosted with ❤ by GitHub

	# For complete examples and data files, please go to https://github.com/aspose-cells-cloud/aspose-cells-cloud-python
	import os

	from asposecellscloud.apis.cells_api import CellsApi
	from asposecellscloud.models import *
	from asposecellscloud.requests import *

	api = CellsApi(os.getenv('CellsCloudClientId'),os.getenv('CellsCloudClientSecret'),"v3.0",os.getenv('CellsCloudApiBaseUrl'))
	request = PostClearObjectsRequest( { "book1.xlsx": "book1.xlsx" ,"datasource.xlsx": "datasource.xlsx" }, 'Comment')
	api.post_clear_objects(request)

view raw Example-Clear-Comment.py hosted with ❤ by GitHub

	# For complete examples and data files, please go to https://github.com/aspose-cells-cloud/aspose-cells-cloud-python
	import os

	from asposecellscloud.apis.cells_api import CellsApi
	from asposecellscloud.models import *
	from asposecellscloud.requests import *

	api = CellsApi(os.getenv('CellsCloudClientId'),os.getenv('CellsCloudClientSecret'),"v3.0",os.getenv('CellsCloudApiBaseUrl'))
	request = PostClearObjectsRequest( { "book1.xlsx": "book1.xlsx" ,"datasource.xlsx": "datasource.xlsx" }, 'DuplicateRows')
	api.post_clear_objects(request)

view raw Example-Clear-DuplicateRows.py hosted with ❤ by GitHub

	# For complete examples and data files, please go to https://github.com/aspose-cells-cloud/aspose-cells-cloud-python
	import os

	from asposecellscloud.apis.cells_api import CellsApi
	from asposecellscloud.models import *
	from asposecellscloud.requests import *

	api = CellsApi(os.getenv('CellsCloudClientId'),os.getenv('CellsCloudClientSecret'),"v3.0",os.getenv('CellsCloudApiBaseUrl'))
	request = PostClearObjectsRequest( { "book1.xlsx": "book1.xlsx" ,"datasource.xlsx": "datasource.xlsx" }, 'Formula')
	api.post_clear_objects(request)

view raw Example-Clear-Formula.py hosted with ❤ by GitHub

	# For complete examples and data files, please go to https://github.com/aspose-cells-cloud/aspose-cells-cloud-python
	import os

	from asposecellscloud.apis.cells_api import CellsApi
	from asposecellscloud.models import *
	from asposecellscloud.requests import *

	api = CellsApi(os.getenv('CellsCloudClientId'),os.getenv('CellsCloudClientSecret'),"v3.0",os.getenv('CellsCloudApiBaseUrl'))
	request = PostClearObjectsRequest( { "book1.xlsx": "book1.xlsx" ,"datasource.xlsx": "datasource.xlsx" }, 'Hyperlink')
	api.post_clear_objects(request)

view raw Example-Clear-Hyperlink.py hosted with ❤ by GitHub

	# For complete examples and data files, please go to https://github.com/aspose-cells-cloud/aspose-cells-cloud-python
	import os

	from asposecellscloud.apis.cells_api import CellsApi
	from asposecellscloud.models import *
	from asposecellscloud.requests import *

	api = CellsApi(os.getenv('CellsCloudClientId'),os.getenv('CellsCloudClientSecret'),"v3.0",os.getenv('CellsCloudApiBaseUrl'))
	request = PostClearObjectsRequest( { "book1.xlsx": "book1.xlsx" ,"datasource.xlsx": "datasource.xlsx" }, 'ListObject')
	api.post_clear_objects(request)

view raw Example-Clear-ListObject.py hosted with ❤ by GitHub

	# For complete examples and data files, please go to https://github.com/aspose-cells-cloud/aspose-cells-cloud-python
	import os

	from asposecellscloud.apis.cells_api import CellsApi
	from asposecellscloud.models import *
	from asposecellscloud.requests import *

	api = CellsApi(os.getenv('CellsCloudClientId'),os.getenv('CellsCloudClientSecret'),"v3.0",os.getenv('CellsCloudApiBaseUrl'))
	request = PostClearObjectsRequest( { "book1.xlsx": "book1.xlsx" ,"datasource.xlsx": "datasource.xlsx" }, 'Picture')
	api.post_clear_objects(request)

view raw Example-Clear-Picture.py hosted with ❤ by GitHub

	# For complete examples and data files, please go to https://github.com/aspose-cells-cloud/aspose-cells-cloud-python
	import os

	from asposecellscloud.apis.cells_api import CellsApi
	from asposecellscloud.models import *
	from asposecellscloud.requests import *

	api = CellsApi(os.getenv('CellsCloudClientId'),os.getenv('CellsCloudClientSecret'),"v3.0",os.getenv('CellsCloudApiBaseUrl'))
	request = PostClearObjectsRequest( { "book1.xlsx": "book1.xlsx" ,"datasource.xlsx": "datasource.xlsx" }, 'PivotTable')
	api.post_clear_objects(request)

view raw Example-Clear-PivotTable.py hosted with ❤ by GitHub

	# For complete examples and data files, please go to https://github.com/aspose-cells-cloud/aspose-cells-cloud-python
	import os

	from asposecellscloud.apis.cells_api import CellsApi
	from asposecellscloud.models import *
	from asposecellscloud.requests import *

	api = CellsApi(os.getenv('CellsCloudClientId'),os.getenv('CellsCloudClientSecret'),"v3.0",os.getenv('CellsCloudApiBaseUrl'))
	request = PostClearObjectsRequest( { "book1.xlsx": "book1.xlsx" ,"datasource.xlsx": "datasource.xlsx" }, 'Shape')
	api.post_clear_objects(request)

view raw Example-Clear-Shape.py hosted with ❤ by GitHub

	# For complete examples and data files, please go to https://github.com/aspose-cells-cloud/aspose-cells-cloud-python
	import os

	from asposecellscloud.apis.cells_api import CellsApi
	from asposecellscloud.models import *
	from asposecellscloud.requests import *

	api = CellsApi(os.getenv('CellsCloudClientId'),os.getenv('CellsCloudClientSecret'),"v3.0",os.getenv('CellsCloudApiBaseUrl'))
	request = PostClearObjectsRequest( { "book1.xlsx": "book1.xlsx" ,"datasource.xlsx": "datasource.xlsx" }, 'Style')
	api.post_clear_objects(request)

view raw Example-Clear-Style.py hosted with ❤ by GitHub

	# For complete examples and data files, please go to https://github.com/aspose-cells-cloud/aspose-cells-cloud-python
	import os

	from asposecellscloud.apis.cells_api import CellsApi
	from asposecellscloud.models import *
	from asposecellscloud.requests import *

	api = CellsApi(os.getenv('CellsCloudClientId'),os.getenv('CellsCloudClientSecret'),"v3.0",os.getenv('CellsCloudApiBaseUrl'))
	request = PostClearObjectsRequest( { "book1.xlsx": "book1.xlsx" ,"datasource.xlsx": "datasource.xlsx" }, 'Validation')
	api.post_clear_objects(request)

view raw Example-Clear-Validation.py hosted with ❤ by GitHub

	# For complete examples and data files, please go to https://github.com/aspose-cells-cloud/aspose-cells-cloud-python
	import os

	from asposecellscloud.apis.cells_api import CellsApi
	from asposecellscloud.models import *
	from asposecellscloud.requests import *

	api = CellsApi(os.getenv('CellsCloudClientId'),os.getenv('CellsCloudClientSecret'),"v3.0",os.getenv('CellsCloudApiBaseUrl'))
	request = PostMergeRequest( { 'assemblytest.xlsx': 'assemblytest.xlsx' ,'datasource.xlsx': 'datasource.xlsx' },out_format= 'pdf',merge_to_one_sheet= True)
	api.post_merge(request)

view raw Example-PostMerge.py hosted with ❤ by GitHub

	# For complete examples and data files, please go to https://github.com/aspose-cells-cloud/aspose-cells-cloud-python
	import os

	from asposecellscloud.apis.cells_api import CellsApi
	from asposecellscloud.models import *
	from asposecellscloud.requests import *

	api = CellsApi(os.getenv('CellsCloudClientId'),os.getenv('CellsCloudClientSecret'),"v3.0",os.getenv('CellsCloudApiBaseUrl'))
	request = PostWorkbookSaveAsRequest( 'Book1.xlsx', 'newbook.xlsx',save_options= SaveOptions(save_format= 'xlsx' ),folder= 'PythonTest')
	api.post_workbook_save_as(request)

view raw Example-SaveAs.py hosted with ❤ by GitHub

	# For complete examples and data files, please go to https://github.com/aspose-cells-cloud/aspose-cells-cloud-python
	import os

	from asposecellscloud.apis.cells_api import CellsApi
	from asposecellscloud.models import *
	from asposecellscloud.requests import *

	api = CellsApi(os.getenv('CellsCloudClientId'),os.getenv('CellsCloudClientSecret'),"v3.0",os.getenv('CellsCloudApiBaseUrl'))
	request = PostUnlockRequest( { "book1.xlsx": "book1.xlsx" ,"datasource.xlsx": "datasource.xlsx" }, '123456')
	api.post_unlock(request)

view raw Example-Unlock.py hosted with ❤ by GitHub

	# For complete examples and data files, please go to https://github.com/aspose-cells-cloud/aspose-cells-cloud-python
	import os

	from asposecellscloud.apis.cells_api import CellsApi
	from asposecellscloud.models import *
	from asposecellscloud.requests import *

	api = CellsApi(os.getenv('CellsCloudClientId'),os.getenv('CellsCloudClientSecret'),"v3.0",os.getenv('CellsCloudApiBaseUrl'))
	request = PostWatermarkRequest( { 'assemblytest.xlsx': 'assemblytest.xlsx' ,'datasource.xlsx': 'datasource.xlsx' }, 'aspose.cells cloud sdk', '#773322')
	api.post_watermark(request)

view raw Example-Watermark.py hosted with ❤ by GitHub

	sample.py

view raw example.py hosted with ❤ by GitHub

	import os
	import sys

	from asposecellscloud.apis.cells_api import CellsApi
	from asposecellscloud.models import *
	from asposecellscloud.requests import *

	api = CellsApi(os.getenv('CellsCloudClientId'),os.getenv('CellsCloudClientSecret'),"v3.0",os.getenv('CellsCloudApiBaseUrl'))
	request = CopyFileRequest( 'PythonTest' + '/' + 'Book1.xlsx', 'OutResult/' + 'Book1.xlsx',src_storage_name= '',dest_storage_name= '',version_id= '')
	api.copy_file(request)

view raw Example_CopyFile.py hosted with ❤ by GitHub

	import os
	import sys

	from asposecellscloud.apis.cells_api import CellsApi
	from asposecellscloud.models import *
	from asposecellscloud.requests import *

	api = CellsApi(os.getenv('CellsCloudClientId'),os.getenv('CellsCloudClientSecret'),"v3.0",os.getenv('CellsCloudApiBaseUrl'))
	request = CopyFolderRequest( 'PythonTest', 'OutResult/Create',src_storage_name= '',dest_storage_name= '')
	api.copy_folder(request)

view raw Example_CopyFolder.py hosted with ❤ by GitHub

	import os
	import sys

	from asposecellscloud.apis.cells_api import CellsApi
	from asposecellscloud.models import *
	from asposecellscloud.requests import *

	api = CellsApi(os.getenv('CellsCloudClientId'),os.getenv('CellsCloudClientSecret'),"v3.0",os.getenv('CellsCloudApiBaseUrl'))
	request = CreateFolderRequest( 'OutResult/NewFolder',storage_name= '')
	api.create_folder(request)

view raw Example_CreateFolder.py hosted with ❤ by GitHub

	import os
	import sys

	from asposecellscloud.apis.cells_api import CellsApi
	from asposecellscloud.models import *
	from asposecellscloud.requests import *

	api = CellsApi(os.getenv('CellsCloudClientId'),os.getenv('CellsCloudClientSecret'),"v3.0",os.getenv('CellsCloudApiBaseUrl'))
	encryption = WorkbookEncryptionRequest(password='123456', encryption_type='XOR', key_length=128)
	request = DeleteDecryptWorkbookRequest( 'Book1.xlsx', encryption,folder= 'PythonTest',storage_name= '')
	api.delete_decrypt_workbook(request)

view raw Example_DeleteDecryptWorkbook.py hosted with ❤ by GitHub

	import os
	import sys

	from asposecellscloud.apis.cells_api import CellsApi
	from asposecellscloud.models import *
	from asposecellscloud.requests import *

	api = CellsApi(os.getenv('CellsCloudClientId'),os.getenv('CellsCloudClientSecret'),"v3.0",os.getenv('CellsCloudApiBaseUrl'))
	request = DeleteDocumentPropertiesRequest( 'Book1.xlsx',folder= 'PythonTest',storage_name= '')
	api.delete_document_properties(request)

view raw Example_DeleteDocumentProperties.py hosted with ❤ by GitHub

	import os
	import sys

	from asposecellscloud.apis.cells_api import CellsApi
	from asposecellscloud.models import *
	from asposecellscloud.requests import *

	api = CellsApi(os.getenv('CellsCloudClientId'),os.getenv('CellsCloudClientSecret'),"v3.0",os.getenv('CellsCloudApiBaseUrl'))
	request = DeleteDocumentPropertyRequest( 'Book1.xlsx', 'Author',type= 'All',folder= 'PythonTest',storage_name= '')
	api.delete_document_property(request)

view raw Example_DeleteDocumentProperty.py hosted with ❤ by GitHub

	import os
	import sys

	from asposecellscloud.apis.cells_api import CellsApi
	from asposecellscloud.models import *
	from asposecellscloud.requests import *

	api = CellsApi(os.getenv('CellsCloudClientId'),os.getenv('CellsCloudClientSecret'),"v3.0",os.getenv('CellsCloudApiBaseUrl'))
	request = DeleteDocumentUnProtectFromChangesRequest( 'Book1.xlsx',folder= 'PythonTest',storage_name= '')
	api.delete_document_un_protect_from_changes(request)

view raw Example_DeleteDocumentUnProtectFromChanges.py hosted with ❤ by GitHub

	import os
	import sys

	from asposecellscloud.apis.cells_api import CellsApi
	from asposecellscloud.models import *
	from asposecellscloud.requests import *

	api = CellsApi(os.getenv('CellsCloudClientId'),os.getenv('CellsCloudClientSecret'),"v3.0",os.getenv('CellsCloudApiBaseUrl'))
	request = DeleteFileRequest( 'PythonTest' + '/' + 'Book1.xlsx',storage_name= '',version_id= '')
	api.delete_file(request)

view raw Example_DeleteFile.py hosted with ❤ by GitHub

	import os
	import sys

	from asposecellscloud.apis.cells_api import CellsApi
	from asposecellscloud.models import *
	from asposecellscloud.requests import *

	api = CellsApi(os.getenv('CellsCloudClientId'),os.getenv('CellsCloudClientSecret'),"v3.0",os.getenv('CellsCloudApiBaseUrl'))
	request = DeleteFolderRequest( 'OutResult/Create',storage_name= '',recursive= True)
	api.delete_folder(request)

view raw Example_DeleteFolder.py hosted with ❤ by GitHub

	import os
	import sys

	from asposecellscloud.apis.cells_api import CellsApi
	from asposecellscloud.models import *
	from asposecellscloud.requests import *

	api = CellsApi(os.getenv('CellsCloudClientId'),os.getenv('CellsCloudClientSecret'),"v3.0",os.getenv('CellsCloudApiBaseUrl'))
	request = DeleteHeaderFooterRequest( 'Book1.xlsx', 'Sheet1',folder= 'PythonTest',storage_name= '')
	api.delete_header_footer(request)

view raw Example_DeleteHeaderFooter.py hosted with ❤ by GitHub

	import os
	import sys

	from asposecellscloud.apis.cells_api import CellsApi
	from asposecellscloud.models import *
	from asposecellscloud.requests import *

	api = CellsApi(os.getenv('CellsCloudClientId'),os.getenv('CellsCloudClientSecret'),"v3.0",os.getenv('CellsCloudApiBaseUrl'))
	request = DeleteHorizontalPageBreakRequest( 'Book1.xlsx', 'Sheet1', 0,folder= 'PythonTest',storage_name= '')
	api.delete_horizontal_page_break(request)

view raw Example_DeleteHorizontalPageBreak.py hosted with ❤ by GitHub

	import os
	import sys

	from asposecellscloud.apis.cells_api import CellsApi
	from asposecellscloud.models import *
	from asposecellscloud.requests import *

	api = CellsApi(os.getenv('CellsCloudClientId'),os.getenv('CellsCloudClientSecret'),"v3.0",os.getenv('CellsCloudApiBaseUrl'))
	request = DeleteHorizontalPageBreaksRequest( 'Book1.xlsx', 'Sheet1',row= 0,folder= 'PythonTest',storage_name= '')
	api.delete_horizontal_page_breaks(request)

view raw Example_DeleteHorizontalPageBreaks.py hosted with ❤ by GitHub

	import os
	import sys

	from asposecellscloud.apis.cells_api import CellsApi
	from asposecellscloud.models import *
	from asposecellscloud.requests import *

	api = CellsApi(os.getenv('CellsCloudClientId'),os.getenv('CellsCloudClientSecret'),"v3.0",os.getenv('CellsCloudApiBaseUrl'))
	request = DeleteMetadataRequest( {'Book1.xlsx':'./Book1.xlsx'},type= 'all')
	api.delete_metadata(request)

view raw Example_DeleteMetadata.py hosted with ❤ by GitHub

	import os
	import sys

	from asposecellscloud.apis.cells_api import CellsApi
	from asposecellscloud.models import *
	from asposecellscloud.requests import *

	api = CellsApi(os.getenv('CellsCloudClientId'),os.getenv('CellsCloudClientSecret'),"v3.0",os.getenv('CellsCloudApiBaseUrl'))
	pivotTableFieldRequest = PivotTableFieldRequest(data= [0] )
	request = DeletePivotTableFieldRequest( 'Book1.xlsx', 'Sheet4', 0, 'Row', pivotTableFieldRequest,folder= 'PythonTest',storage_name= '')
	api.delete_pivot_table_field(request)

view raw Example_DeletePivotTableField.py hosted with ❤ by GitHub

	import os
	import sys

	from asposecellscloud.apis.cells_api import CellsApi
	from asposecellscloud.models import *
	from asposecellscloud.requests import *

	api = CellsApi(os.getenv('CellsCloudClientId'),os.getenv('CellsCloudClientSecret'),"v3.0",os.getenv('CellsCloudApiBaseUrl'))
	request = DeleteUnProtectWorkbookRequest( 'Book1.xlsx', 'Book1.xlsx',folder= 'PythonTest',storage_name= '')
	api.delete_un_protect_workbook(request)

view raw Example_DeleteUnProtectWorkbook.py hosted with ❤ by GitHub

	import os
	import sys

	from asposecellscloud.apis.cells_api import CellsApi
	from asposecellscloud.models import *
	from asposecellscloud.requests import *

	api = CellsApi(os.getenv('CellsCloudClientId'),os.getenv('CellsCloudClientSecret'),"v3.0",os.getenv('CellsCloudApiBaseUrl'))
	protectParameter = ProtectSheetParameter(protection_type= 'ALL' ,password= '123' )

	request = DeleteUnprotectWorksheetRequest( 'Book1.xlsx', 'Sheet1', protectParameter,folder= 'PythonTest',storage_name= '')
	api.delete_unprotect_worksheet(request)

view raw Example_DeleteUnprotectWorksheet.py hosted with ❤ by GitHub

	import os
	import sys

	from asposecellscloud.apis.cells_api import CellsApi
	from asposecellscloud.models import *
	from asposecellscloud.requests import *

	api = CellsApi(os.getenv('CellsCloudClientId'),os.getenv('CellsCloudClientSecret'),"v3.0",os.getenv('CellsCloudApiBaseUrl'))
	request = DeleteVerticalPageBreakRequest( 'Book1.xlsx', 'Sheet1', 0,folder= 'PythonTest',storage_name= '')
	api.delete_vertical_page_break(request)

view raw Example_DeleteVerticalPageBreak.py hosted with ❤ by GitHub

	import os
	import sys

	from asposecellscloud.apis.cells_api import CellsApi
	from asposecellscloud.models import *
	from asposecellscloud.requests import *

	api = CellsApi(os.getenv('CellsCloudClientId'),os.getenv('CellsCloudClientSecret'),"v3.0",os.getenv('CellsCloudApiBaseUrl'))
	request = DeleteVerticalPageBreaksRequest( 'Book1.xlsx', 'Sheet1',column= 0,folder= 'PythonTest',storage_name= '')
	api.delete_vertical_page_breaks(request)

view raw Example_DeleteVerticalPageBreaks.py hosted with ❤ by GitHub

	import os
	import sys

	from asposecellscloud.apis.cells_api import CellsApi
	from asposecellscloud.models import *
	from asposecellscloud.requests import *

	api = CellsApi(os.getenv('CellsCloudClientId'),os.getenv('CellsCloudClientSecret'),"v3.0",os.getenv('CellsCloudApiBaseUrl'))
	request = DeleteWorkbookBackgroundRequest( 'Book1.xlsx',folder= 'PythonTest',storage_name= '')
	api.delete_workbook_background(request)

view raw Example_DeleteWorkbookBackground.py hosted with ❤ by GitHub

	import os
	import sys

	from asposecellscloud.apis.cells_api import CellsApi
	from asposecellscloud.models import *
	from asposecellscloud.requests import *

	api = CellsApi(os.getenv('CellsCloudClientId'),os.getenv('CellsCloudClientSecret'),"v3.0",os.getenv('CellsCloudApiBaseUrl'))
	request = DeleteWorkbookNameRequest( 'Book1.xlsx', 'Name_2',folder= 'PythonTest',storage_name= '')
	api.delete_workbook_name(request)

view raw Example_DeleteWorkbookName.py hosted with ❤ by GitHub

	import os
	import sys

	from asposecellscloud.apis.cells_api import CellsApi
	from asposecellscloud.models import *
	from asposecellscloud.requests import *

	api = CellsApi(os.getenv('CellsCloudClientId'),os.getenv('CellsCloudClientSecret'),"v3.0",os.getenv('CellsCloudApiBaseUrl'))
	request = DeleteWorkbookNamesRequest( 'Book1.xlsx',folder= 'PythonTest',storage_name= '')
	api.delete_workbook_names(request)

view raw Example_DeleteWorkbookNames.py hosted with ❤ by GitHub

	import os
	import sys

	from asposecellscloud.apis.cells_api import CellsApi
	from asposecellscloud.models import *
	from asposecellscloud.requests import *

	api = CellsApi(os.getenv('CellsCloudClientId'),os.getenv('CellsCloudClientSecret'),"v3.0",os.getenv('CellsCloudApiBaseUrl'))
	request = DeleteWorksheetRequest( 'Book1.xlsx', 'Sheet1',folder= 'PythonTest',storage_name= '')
	api.delete_worksheet(request)

view raw Example_DeleteWorksheet.py hosted with ❤ by GitHub

	import os
	import sys

	from asposecellscloud.apis.cells_api import CellsApi
	from asposecellscloud.models import *
	from asposecellscloud.requests import *

	api = CellsApi(os.getenv('CellsCloudClientId'),os.getenv('CellsCloudClientSecret'),"v3.0",os.getenv('CellsCloudApiBaseUrl'))
	request = DeleteWorksheetBackgroundRequest( 'Book1.xlsx', 'Sheet1',folder= 'PythonTest',storage_name= '')
	api.delete_worksheet_background(request)

view raw Example_DeleteWorksheetBackground.py hosted with ❤ by GitHub

	import os
	import sys

	from asposecellscloud.apis.cells_api import CellsApi
	from asposecellscloud.models import *
	from asposecellscloud.requests import *

	api = CellsApi(os.getenv('CellsCloudClientId'),os.getenv('CellsCloudClientSecret'),"v3.0",os.getenv('CellsCloudApiBaseUrl'))
	request = DeleteWorksheetCellsRangeRequest( 'Book1.xlsx', 'Sheet1', 'A1:C6', 'Up',folder= 'PythonTest',storage_name= '')
	api.delete_worksheet_cells_range(request)

view raw Example_DeleteWorksheetCellsRange.py hosted with ❤ by GitHub

	import os
	import sys

	from asposecellscloud.apis.cells_api import CellsApi
	from asposecellscloud.models import *
	from asposecellscloud.requests import *

	api = CellsApi(os.getenv('CellsCloudClientId'),os.getenv('CellsCloudClientSecret'),"v3.0",os.getenv('CellsCloudApiBaseUrl'))
	request = DeleteWorksheetChartRequest( 'Book1.xlsx', 'Sheet4', 0,folder= 'PythonTest',storage_name= '')
	api.delete_worksheet_chart(request)

view raw Example_DeleteWorksheetChart.py hosted with ❤ by GitHub

	import os
	import sys

	from asposecellscloud.apis.cells_api import CellsApi
	from asposecellscloud.models import *
	from asposecellscloud.requests import *

	api = CellsApi(os.getenv('CellsCloudClientId'),os.getenv('CellsCloudClientSecret'),"v3.0",os.getenv('CellsCloudApiBaseUrl'))
	request = DeleteWorksheetChartLegendRequest( 'Book1.xlsx', 'Sheet4', 0,folder= 'PythonTest',storage_name= '')
	api.delete_worksheet_chart_legend(request)

view raw Example_DeleteWorksheetChartLegend.py hosted with ❤ by GitHub

	import os
	import sys

	from asposecellscloud.apis.cells_api import CellsApi
	from asposecellscloud.models import *
	from asposecellscloud.requests import *

	api = CellsApi(os.getenv('CellsCloudClientId'),os.getenv('CellsCloudClientSecret'),"v3.0",os.getenv('CellsCloudApiBaseUrl'))
	request = DeleteWorksheetChartsRequest( 'Book1.xlsx', 'Sheet4',folder= 'PythonTest',storage_name= '')
	api.delete_worksheet_charts(request)

view raw Example_DeleteWorksheetCharts.py hosted with ❤ by GitHub

	import os
	import sys

	from asposecellscloud.apis.cells_api import CellsApi
	from asposecellscloud.models import *
	from asposecellscloud.requests import *

	api = CellsApi(os.getenv('CellsCloudClientId'),os.getenv('CellsCloudClientSecret'),"v3.0",os.getenv('CellsCloudApiBaseUrl'))
	request = DeleteWorksheetChartTitleRequest( 'Book1.xlsx', 'Sheet4', 0,folder= 'PythonTest',storage_name= '')
	api.delete_worksheet_chart_title(request)

view raw Example_DeleteWorksheetChartTitle.py hosted with ❤ by GitHub

	import os
	import sys

	from asposecellscloud.apis.cells_api import CellsApi
	from asposecellscloud.models import *
	from asposecellscloud.requests import *

	api = CellsApi(os.getenv('CellsCloudClientId'),os.getenv('CellsCloudClientSecret'),"v3.0",os.getenv('CellsCloudApiBaseUrl'))
	request = DeleteWorksheetColumnsRequest( 'Book1.xlsx', 'Sheet1', 1, 10, True,folder= 'PythonTest',storage_name= '')
	api.delete_worksheet_columns(request)

view raw Example_DeleteWorksheetColumns.py hosted with ❤ by GitHub

	import os
	import sys

	from asposecellscloud.apis.cells_api import CellsApi
	from asposecellscloud.models import *
	from asposecellscloud.requests import *

	api = CellsApi(os.getenv('CellsCloudClientId'),os.getenv('CellsCloudClientSecret'),"v3.0",os.getenv('CellsCloudApiBaseUrl'))
	request = DeleteWorksheetCommentRequest( 'Book1.xlsx', 'Sheet1', 'B3',folder= 'PythonTest',storage_name= '')
	api.delete_worksheet_comment(request)

view raw Example_DeleteWorksheetComment.py hosted with ❤ by GitHub

	import os
	import sys

	from asposecellscloud.apis.cells_api import CellsApi
	from asposecellscloud.models import *
	from asposecellscloud.requests import *

	api = CellsApi(os.getenv('CellsCloudClientId'),os.getenv('CellsCloudClientSecret'),"v3.0",os.getenv('CellsCloudApiBaseUrl'))
	request = DeleteWorksheetCommentsRequest( 'Book1.xlsx', 'Sheet1',folder= 'PythonTest',storage_name= '')
	api.delete_worksheet_comments(request)

view raw Example_DeleteWorksheetComments.py hosted with ❤ by GitHub

	import os
	import sys

	from asposecellscloud.apis.cells_api import CellsApi
	from asposecellscloud.models import *
	from asposecellscloud.requests import *

	api = CellsApi(os.getenv('CellsCloudClientId'),os.getenv('CellsCloudClientSecret'),"v3.0",os.getenv('CellsCloudApiBaseUrl'))
	request = DeleteWorksheetConditionalFormattingRequest( 'Book1.xlsx', 'Sheet1', 0,folder= 'PythonTest',storage_name= '')
	api.delete_worksheet_conditional_formatting(request)

view raw Example_DeleteWorksheetConditionalFormatting.py hosted with ❤ by GitHub

	import os
	import sys

	from asposecellscloud.apis.cells_api import CellsApi
	from asposecellscloud.models import *
	from asposecellscloud.requests import *

	api = CellsApi(os.getenv('CellsCloudClientId'),os.getenv('CellsCloudClientSecret'),"v3.0",os.getenv('CellsCloudApiBaseUrl'))
	DeleteWorksheetConditionalFormattingAreaRequest( 'Book1.xlsx', 'Sheet1', 1, 1, 4, 6,folder= 'PythonTest',storage_name= '')
	api.delete_worksheet_conditional_formatting_area(request)

view raw Example_DeleteWorksheetConditionalFormattingArea.py hosted with ❤ by GitHub

	import os
	import sys

	from asposecellscloud.apis.cells_api import CellsApi
	from asposecellscloud.models import *
	from asposecellscloud.requests import *

	api = CellsApi(os.getenv('CellsCloudClientId'),os.getenv('CellsCloudClientSecret'),"v3.0",os.getenv('CellsCloudApiBaseUrl'))
	request = DeleteWorksheetConditionalFormattingsRequest( 'Book1.xlsx', 'Sheet1',folder= 'PythonTest',storage_name= '')
	api.delete_worksheet_conditional_formattings(request)

view raw Example_DeleteWorksheetConditionalFormattings.py hosted with ❤ by GitHub

	import os
	import sys

	from asposecellscloud.apis.cells_api import CellsApi
	from asposecellscloud.models import *
	from asposecellscloud.requests import *

	api = CellsApi(os.getenv('CellsCloudClientId'),os.getenv('CellsCloudClientSecret'),"v3.0",os.getenv('CellsCloudApiBaseUrl'))
	request = DeleteWorksheetDateFilterRequest( 'Book1.xlsx', 'Sheet1', 0, 'Year',year= 1920,folder= 'PythonTest',storage_name= '')
	api.delete_worksheet_date_filter(request)

view raw Example_DeleteWorksheetDateFilter.py hosted with ❤ by GitHub

	import os
	import sys

	from asposecellscloud.apis.cells_api import CellsApi
	from asposecellscloud.models import *
	from asposecellscloud.requests import *

	api = CellsApi(os.getenv('CellsCloudClientId'),os.getenv('CellsCloudClientSecret'),"v3.0",os.getenv('CellsCloudApiBaseUrl'))
	request = DeleteWorksheetFilterRequest( 'Book1.xlsx', 'Sheet1', 0,criteria= 'year',folder= 'PythonTest',storage_name= '')
	api.delete_worksheet_filter(request)

view raw Example_DeleteWorksheetFilter.py hosted with ❤ by GitHub

	import os
	import sys

	from asposecellscloud.apis.cells_api import CellsApi
	from asposecellscloud.models import *
	from asposecellscloud.requests import *

	api = CellsApi(os.getenv('CellsCloudClientId'),os.getenv('CellsCloudClientSecret'),"v3.0",os.getenv('CellsCloudApiBaseUrl'))
	request = DeleteWorksheetFreezePanesRequest( 'Book1.xlsx', 'Sheet1', 1, 1, 4, 5,folder= 'PythonTest',storage_name= '')
	api.delete_worksheet_freeze_panes(request)

view raw Example_DeleteWorksheetFreezePanes.py hosted with ❤ by GitHub

	import os
	import sys

	from asposecellscloud.apis.cells_api import CellsApi
	from asposecellscloud.models import *
	from asposecellscloud.requests import *

	api = CellsApi(os.getenv('CellsCloudClientId'),os.getenv('CellsCloudClientSecret'),"v3.0",os.getenv('CellsCloudApiBaseUrl'))
	request = DeleteWorksheetHyperlinkRequest( 'Book1.xlsx', 'Sheet1', 0,folder= 'PythonTest',storage_name= '')
	api.delete_worksheet_hyperlink(request)

view raw Example_DeleteWorksheetHyperlink.py hosted with ❤ by GitHub

	import os
	import sys

	from asposecellscloud.apis.cells_api import CellsApi
	from asposecellscloud.models import *
	from asposecellscloud.requests import *

	api = CellsApi(os.getenv('CellsCloudClientId'),os.getenv('CellsCloudClientSecret'),"v3.0",os.getenv('CellsCloudApiBaseUrl'))
	request = DeleteWorksheetHyperlinksRequest( 'Book1.xlsx', 'Sheet1',folder= 'PythonTest',storage_name= '')
	api.delete_worksheet_hyperlinks(request)

view raw Example_DeleteWorksheetHyperlinks.py hosted with ❤ by GitHub

	import os
	import sys

	from asposecellscloud.apis.cells_api import CellsApi
	from asposecellscloud.models import *
	from asposecellscloud.requests import *

	api = CellsApi(os.getenv('CellsCloudClientId'),os.getenv('CellsCloudClientSecret'),"v3.0",os.getenv('CellsCloudApiBaseUrl'))
	request = DeleteWorksheetListObjectRequest( 'Book1.xlsx', 'Sheet7', 0,folder= 'PythonTest',storage_name= '')
	api.delete_worksheet_list_object(request)

view raw Example_DeleteWorksheetListObject.py hosted with ❤ by GitHub

	import os
	import sys

	from asposecellscloud.apis.cells_api import CellsApi
	from asposecellscloud.models import *
	from asposecellscloud.requests import *

	api = CellsApi(os.getenv('CellsCloudClientId'),os.getenv('CellsCloudClientSecret'),"v3.0",os.getenv('CellsCloudApiBaseUrl'))
	request = DeleteWorksheetListObjectsRequest( 'Book1.xlsx', 'Sheet7',folder= 'PythonTest',storage_name= '')
	api.delete_worksheet_list_objects(request)

view raw Example_DeleteWorksheetListObjects.py hosted with ❤ by GitHub

	import os
	import sys

	from asposecellscloud.apis.cells_api import CellsApi
	from asposecellscloud.models import *
	from asposecellscloud.requests import *

	api = CellsApi(os.getenv('CellsCloudClientId'),os.getenv('CellsCloudClientSecret'),"v3.0",os.getenv('CellsCloudApiBaseUrl'))
	request = DeleteWorksheetOleObjectRequest( 'Book1.xlsx', 'Sheet6', 0,folder= 'PythonTest',storage_name= '')
	api.delete_worksheet_ole_object(request)

view raw Example_DeleteWorksheetOleObject.py hosted with ❤ by GitHub

	import os
	import sys

	from asposecellscloud.apis.cells_api import CellsApi
	from asposecellscloud.models import *
	from asposecellscloud.requests import *

	api = CellsApi(os.getenv('CellsCloudClientId'),os.getenv('CellsCloudClientSecret'),"v3.0",os.getenv('CellsCloudApiBaseUrl'))
	request = DeleteWorksheetOleObjectsRequest( 'Book1.xlsx', 'Sheet6',folder= 'PythonTest',storage_name= '')
	api.delete_worksheet_ole_objects(request)

view raw Example_DeleteWorksheetOleObjects.py hosted with ❤ by GitHub

	import os
	import sys

	from asposecellscloud.apis.cells_api import CellsApi
	from asposecellscloud.models import *
	from asposecellscloud.requests import *

	api = CellsApi(os.getenv('CellsCloudClientId'),os.getenv('CellsCloudClientSecret'),"v3.0",os.getenv('CellsCloudApiBaseUrl'))
	request = DeleteWorksheetPictureRequest( 'Book1.xlsx', 'Sheet6', 0,folder= 'PythonTest',storage_name= '')
	api.delete_worksheet_picture(request)

view raw Example_DeleteWorksheetPicture.py hosted with ❤ by GitHub

	import os
	import sys

	from asposecellscloud.apis.cells_api import CellsApi
	from asposecellscloud.models import *
	from asposecellscloud.requests import *

	api = CellsApi(os.getenv('CellsCloudClientId'),os.getenv('CellsCloudClientSecret'),"v3.0",os.getenv('CellsCloudApiBaseUrl'))
	request = DeleteWorksheetPicturesRequest( 'Book1.xlsx', 'Sheet6',folder= 'PythonTest',storage_name= '')
	api.delete_worksheet_pictures(request)

view raw Example_DeleteWorksheetPictures.py hosted with ❤ by GitHub

	import os
	import sys

	from asposecellscloud.apis.cells_api import CellsApi
	from asposecellscloud.models import *
	from asposecellscloud.requests import *

	api = CellsApi(os.getenv('CellsCloudClientId'),os.getenv('CellsCloudClientSecret'),"v3.0",os.getenv('CellsCloudApiBaseUrl'))
	request = DeleteWorksheetPivotTableRequest( 'TestCase.xlsx', 'Sheet3', 0,folder= 'PythonTest',storage_name= '')
	api.delete_worksheet_pivot_table(request)

view raw Example_DeleteWorksheetPivotTable.py hosted with ❤ by GitHub

	import os
	import sys

	from asposecellscloud.apis.cells_api import CellsApi
	from asposecellscloud.models import *
	from asposecellscloud.requests import *

	api = CellsApi(os.getenv('CellsCloudClientId'),os.getenv('CellsCloudClientSecret'),"v3.0",os.getenv('CellsCloudApiBaseUrl'))
	request = DeleteWorksheetPivotTableFilterRequest( 'TestCase.xlsx', 'Sheet3', 0, 0,need_re_calculate= True,folder= 'PythonTest',storage_name= '')
	api.delete_worksheet_pivot_table_filter(request)

view raw Example_DeleteWorksheetPivotTableFilter.py hosted with ❤ by GitHub

	import os
	import sys

	from asposecellscloud.apis.cells_api import CellsApi
	from asposecellscloud.models import *
	from asposecellscloud.requests import *

	api = CellsApi(os.getenv('CellsCloudClientId'),os.getenv('CellsCloudClientSecret'),"v3.0",os.getenv('CellsCloudApiBaseUrl'))
	request = DeleteWorksheetPivotTableFiltersRequest( 'TestCase.xlsx', 'Sheet3', 0,need_re_calculate= True,folder= 'PythonTest',storage_name= '')
	api.delete_worksheet_pivot_table_filters(request)

view raw Example_DeleteWorksheetPivotTableFilters.py hosted with ❤ by GitHub

	import os
	import sys

	from asposecellscloud.apis.cells_api import CellsApi
	from asposecellscloud.models import *
	from asposecellscloud.requests import *

	api = CellsApi(os.getenv('CellsCloudClientId'),os.getenv('CellsCloudClientSecret'),"v3.0",os.getenv('CellsCloudApiBaseUrl'))
	request = DeleteWorksheetPivotTablesRequest( 'Book1.xlsx', 'Sheet4',folder= 'PythonTest',storage_name= '')
	api.delete_worksheet_pivot_tables(request)

view raw Example_DeleteWorksheetPivotTables.py hosted with ❤ by GitHub

	import os
	import sys

	from asposecellscloud.apis.cells_api import CellsApi
	from asposecellscloud.models import *
	from asposecellscloud.requests import *

	api = CellsApi(os.getenv('CellsCloudClientId'),os.getenv('CellsCloudClientSecret'),"v3.0",os.getenv('CellsCloudApiBaseUrl'))
	request = DeleteWorksheetRowRequest( 'Book1.xlsx', 'Sheet1', 1,folder= 'PythonTest',storage_name= '')
	api.delete_worksheet_row(request)

view raw Example_DeleteWorksheetRow.py hosted with ❤ by GitHub

	import os
	import sys

	from asposecellscloud.apis.cells_api import CellsApi
	from asposecellscloud.models import *
	from asposecellscloud.requests import *

	api = CellsApi(os.getenv('CellsCloudClientId'),os.getenv('CellsCloudClientSecret'),"v3.0",os.getenv('CellsCloudApiBaseUrl'))
	request = DeleteWorksheetRowsRequest( 'Book1.xlsx', 'Sheet1', 1,total_rows= 10,update_reference= True,folder= 'PythonTest',storage_name= '')
	api.delete_worksheet_rows(request)

view raw Example_DeleteWorksheetRows.py hosted with ❤ by GitHub

	import os
	import sys

	from asposecellscloud.apis.cells_api import CellsApi
	from asposecellscloud.models import *
	from asposecellscloud.requests import *

	api = CellsApi(os.getenv('CellsCloudClientId'),os.getenv('CellsCloudClientSecret'),"v3.0",os.getenv('CellsCloudApiBaseUrl'))
	matchCondition = MatchConditionRequest(regex_pattern= '{*}' )
	request = DeleteWorksheetsRequest( 'Book1.xlsx',match_condition= matchCondition,folder= 'PythonTest',storage_name= '')
	api.delete_worksheets(request)

view raw Example_DeleteWorksheets.py hosted with ❤ by GitHub

	import os
	import sys

	from asposecellscloud.apis.cells_api import CellsApi
	from asposecellscloud.models import *
	from asposecellscloud.requests import *

	api = CellsApi(os.getenv('CellsCloudClientId'),os.getenv('CellsCloudClientSecret'),"v3.0",os.getenv('CellsCloudApiBaseUrl'))
	request = DeleteWorksheetShapeRequest( 'Book1.xlsx', 'Sheet1', 0,folder= 'PythonTest',storage_name= '')
	api.delete_worksheet_shape(request)

view raw Example_DeleteWorksheetShape.py hosted with ❤ by GitHub

	import os
	import sys

	from asposecellscloud.apis.cells_api import CellsApi
	from asposecellscloud.models import *
	from asposecellscloud.requests import *

	api = CellsApi(os.getenv('CellsCloudClientId'),os.getenv('CellsCloudClientSecret'),"v3.0",os.getenv('CellsCloudApiBaseUrl'))
	request = DeleteWorksheetShapesRequest( 'Book1.xlsx', 'Sheet1',folder= 'PythonTest',storage_name= '')
	api.delete_worksheet_shapes(request)

view raw Example_DeleteWorksheetShapes.py hosted with ❤ by GitHub

	import os
	import sys

	from asposecellscloud.apis.cells_api import CellsApi
	from asposecellscloud.models import *
	from asposecellscloud.requests import *

	api = CellsApi(os.getenv('CellsCloudClientId'),os.getenv('CellsCloudClientSecret'),"v3.0",os.getenv('CellsCloudApiBaseUrl'))
	request = DeleteWorksheetSparklineGroupRequest( 'Book1.xlsx', 'Sheet1', 0,folder= 'PythonTest',storage_name= '')
	api.delete_worksheet_sparkline_group(request)

view raw Example_DeleteWorksheetSparklineGroup.py hosted with ❤ by GitHub

	import os
	import sys

	from asposecellscloud.apis.cells_api import CellsApi
	from asposecellscloud.models import *
	from asposecellscloud.requests import *

	api = CellsApi(os.getenv('CellsCloudClientId'),os.getenv('CellsCloudClientSecret'),"v3.0",os.getenv('CellsCloudApiBaseUrl'))
	request = DeleteWorksheetSparklineGroupsRequest( 'Book1.xlsx', 'Sheet1',folder= 'PythonTest',storage_name= '')
	api.delete_worksheet_sparkline_groups(request)

view raw Example_DeleteWorksheetSparklineGroups.py hosted with ❤ by GitHub

	import os
	import sys

	from asposecellscloud.apis.cells_api import CellsApi
	from asposecellscloud.models import *
	from asposecellscloud.requests import *

	api = CellsApi(os.getenv('CellsCloudClientId'),os.getenv('CellsCloudClientSecret'),"v3.0",os.getenv('CellsCloudApiBaseUrl'))
	request = DeleteWorksheetValidationRequest( 'Book1.xlsx', 'Sheet1', 0,folder= 'PythonTest',storage_name= '')
	api.delete_worksheet_validation(request)

view raw Example_DeleteWorksheetValidation.py hosted with ❤ by GitHub

	import os
	import sys

	from asposecellscloud.apis.cells_api import CellsApi
	from asposecellscloud.models import *
	from asposecellscloud.requests import *

	api = CellsApi(os.getenv('CellsCloudClientId'),os.getenv('CellsCloudClientSecret'),"v3.0",os.getenv('CellsCloudApiBaseUrl'))
	request = DeleteWorksheetValidationsRequest( 'Book1.xlsx', 'Sheet1',folder= 'PythonTest',storage_name= '')
	api.delete_worksheet_validations(request)

view raw Example_DeleteWorksheetValidations.py hosted with ❤ by GitHub

	import os
	import sys

	from asposecellscloud.apis.cells_api import CellsApi
	from asposecellscloud.models import *
	from asposecellscloud.requests import *

	api = CellsApi(os.getenv('CellsCloudClientId'),os.getenv('CellsCloudClientSecret'),"v3.0",os.getenv('CellsCloudApiBaseUrl'))
	request = DownloadFileRequest( 'PythonTest' + '/' + 'Book1.xlsx',storage_name= '',version_id= '')
	api.download_file(request)

view raw Example_DownloadFile.py hosted with ❤ by GitHub

	import os
	import sys

	from asposecellscloud.apis.cells_api import CellsApi
	from asposecellscloud.models import *
	from asposecellscloud.requests import *

	api = CellsApi(os.getenv('CellsCloudClientId'),os.getenv('CellsCloudClientSecret'),"v3.0",os.getenv('CellsCloudApiBaseUrl'))
	request = GetCellHtmlStringRequest( 'Book1.xlsx', 'Sheet1', 'A1',folder= 'PythonTest',storage_name= '')
	api.get_cell_html_string(request)

view raw Example_GetCellHtmlString.py hosted with ❤ by GitHub

	import os
	import sys

	from asposecellscloud.apis.cells_api import CellsApi
	from asposecellscloud.models import *
	from asposecellscloud.requests import *

	api = CellsApi(os.getenv('CellsCloudClientId'),os.getenv('CellsCloudClientSecret'),"v3.0",os.getenv('CellsCloudApiBaseUrl'))
	request = GetCellsCloudServicesHealthCheckRequest()
	api.get_cells_cloud_services_health_check(request)

view raw Example_GetCellsCloudServicesHealthCheck.py hosted with ❤ by GitHub

	import os
	import sys

	from asposecellscloud.apis.cells_api import CellsApi
	from asposecellscloud.models import *
	from asposecellscloud.requests import *

	api = CellsApi(os.getenv('CellsCloudClientId'),os.getenv('CellsCloudClientSecret'),"v3.0",os.getenv('CellsCloudApiBaseUrl'))
	request = GetCellsCloudServiceStatusRequest()
	api.get_cells_cloud_service_status(request)

view raw Example_GetCellsCloudServiceStatus.py hosted with ❤ by GitHub

	import os
	import sys

	from asposecellscloud.apis.cells_api import CellsApi
	from asposecellscloud.models import *
	from asposecellscloud.requests import *

	api = CellsApi(os.getenv('CellsCloudClientId'),os.getenv('CellsCloudClientSecret'),"v3.0",os.getenv('CellsCloudApiBaseUrl'))
	request = GetChartAreaRequest( 'Book1.xlsx', 'Sheet4', 0,folder= 'PythonTest',storage_name= '')
	api.get_chart_area(request)

view raw Example_GetChartArea.py hosted with ❤ by GitHub

	import os
	import sys

	from asposecellscloud.apis.cells_api import CellsApi
	from asposecellscloud.models import *
	from asposecellscloud.requests import *

	api = CellsApi(os.getenv('CellsCloudClientId'),os.getenv('CellsCloudClientSecret'),"v3.0",os.getenv('CellsCloudApiBaseUrl'))
	request = GetChartAreaBorderRequest( 'Book1.xlsx', 'Sheet4', 0,folder= 'PythonTest',storage_name= '')
	api.get_chart_area_border(request)

view raw Example_GetChartAreaBorder.py hosted with ❤ by GitHub

	import os
	import sys

	from asposecellscloud.apis.cells_api import CellsApi
	from asposecellscloud.models import *
	from asposecellscloud.requests import *

	api = CellsApi(os.getenv('CellsCloudClientId'),os.getenv('CellsCloudClientSecret'),"v3.0",os.getenv('CellsCloudApiBaseUrl'))
	request = GetChartAreaFillFormatRequest( 'Book1.xlsx', 'Sheet4', 0,folder= 'PythonTest',storage_name= '')
	api.get_chart_area_fill_format(request)

view raw Example_GetChartAreaFillFormat.py hosted with ❤ by GitHub

	import os
	import sys

	from asposecellscloud.apis.cells_api import CellsApi
	from asposecellscloud.models import *
	from asposecellscloud.requests import *

	api = CellsApi(os.getenv('CellsCloudClientId'),os.getenv('CellsCloudClientSecret'),"v3.0",os.getenv('CellsCloudApiBaseUrl'))
	request = GetDiscUsageRequest(storage_name= '')
	api.get_disc_usage(request)

view raw Example_GetDiscUsage.py hosted with ❤ by GitHub

	import os
	import sys

	from asposecellscloud.apis.cells_api import CellsApi
	from asposecellscloud.models import *
	from asposecellscloud.requests import *

	api = CellsApi(os.getenv('CellsCloudClientId'),os.getenv('CellsCloudClientSecret'),"v3.0",os.getenv('CellsCloudApiBaseUrl'))
	request = GetDocumentPropertiesRequest( 'Book1.xlsx',type= 'All',folder= 'PythonTest',storage_name= '')
	api.get_document_properties(request)

view raw Example_GetDocumentProperties.py hosted with ❤ by GitHub

	import os
	import sys

	from asposecellscloud.apis.cells_api import CellsApi
	from asposecellscloud.models import *
	from asposecellscloud.requests import *

	api = CellsApi(os.getenv('CellsCloudClientId'),os.getenv('CellsCloudClientSecret'),"v3.0",os.getenv('CellsCloudApiBaseUrl'))
	request = GetDocumentPropertyRequest( 'Book1.xlsx', 'Author',folder= 'PythonTest',storage_name= '')
	api.get_document_property(request)

view raw Example_GetDocumentProperty.py hosted with ❤ by GitHub

	import os
	import sys

	from asposecellscloud.apis.cells_api import CellsApi
	from asposecellscloud.models import *
	from asposecellscloud.requests import *

	api = CellsApi(os.getenv('CellsCloudClientId'),os.getenv('CellsCloudClientSecret'),"v3.0",os.getenv('CellsCloudApiBaseUrl'))
	request = GetFilesListRequest(path= 'PythonTest',storage_name= '')
	api.get_files_list(request)

view raw Example_GetFilesList.py hosted with ❤ by GitHub

	import os
	import sys

	from asposecellscloud.apis.cells_api import CellsApi
	from asposecellscloud.models import *
	from asposecellscloud.requests import *

	api = CellsApi(os.getenv('CellsCloudClientId'),os.getenv('CellsCloudClientSecret'),"v3.0",os.getenv('CellsCloudApiBaseUrl'))
	request = GetFileVersionsRequest( 'TestData/In/Book1.xlsx',storage_name= '')
	api.get_file_versions(request)

view raw Example_GetFileVersions.py hosted with ❤ by GitHub

	import os
	import sys

	from asposecellscloud.apis.cells_api import CellsApi
	from asposecellscloud.models import *
	from asposecellscloud.requests import *

	api = CellsApi(os.getenv('CellsCloudClientId'),os.getenv('CellsCloudClientSecret'),"v3.0",os.getenv('CellsCloudApiBaseUrl'))
	request = GetFooterRequest( 'Book1.xlsx', 'Sheet1',folder= 'PythonTest',storage_name= '')
	api.get_footer(request)

view raw Example_GetFooter.py hosted with ❤ by GitHub

	import os
	import sys

	from asposecellscloud.apis.cells_api import CellsApi
	from asposecellscloud.models import *
	from asposecellscloud.requests import *

	api = CellsApi(os.getenv('CellsCloudClientId'),os.getenv('CellsCloudClientSecret'),"v3.0",os.getenv('CellsCloudApiBaseUrl'))
	request = GetHeaderRequest( 'Book1.xlsx', 'Sheet1',folder= 'PythonTest',storage_name= '')
	api.get_header(request)

view raw Example_GetHeader.py hosted with ❤ by GitHub

	import os
	import sys

	from asposecellscloud.apis.cells_api import CellsApi
	from asposecellscloud.models import *
	from asposecellscloud.requests import *

	api = CellsApi(os.getenv('CellsCloudClientId'),os.getenv('CellsCloudClientSecret'),"v3.0",os.getenv('CellsCloudApiBaseUrl'))
	request = GetHorizontalPageBreakRequest( 'Book1.xlsx', 'Sheet1', 0,folder= 'PythonTest',storage_name= '')
	api.get_horizontal_page_break(request)

view raw Example_GetHorizontalPageBreak.py hosted with ❤ by GitHub

	import os
	import sys

	from asposecellscloud.apis.cells_api import CellsApi
	from asposecellscloud.models import *
	from asposecellscloud.requests import *

	api = CellsApi(os.getenv('CellsCloudClientId'),os.getenv('CellsCloudClientSecret'),"v3.0",os.getenv('CellsCloudApiBaseUrl'))
	request = GetHorizontalPageBreaksRequest( 'Book1.xlsx', 'Sheet1',folder= 'PythonTest',storage_name= '')
	api.get_horizontal_page_breaks(request)

view raw Example_GetHorizontalPageBreaks.py hosted with ❤ by GitHub

	import os
	import sys

	from asposecellscloud.apis.cells_api import CellsApi
	from asposecellscloud.models import *
	from asposecellscloud.requests import *

	api = CellsApi(os.getenv('CellsCloudClientId'),os.getenv('CellsCloudClientSecret'),"v3.0",os.getenv('CellsCloudApiBaseUrl'))
	request = GetMetadataRequest( {'Book1.xlsx':'./Book1.xlsx'} ,type= 'all')
	api.get_metadata(request)

view raw Example_GetMetadata.py hosted with ❤ by GitHub

	import os
	import sys

	from asposecellscloud.apis.cells_api import CellsApi
	from asposecellscloud.models import *
	from asposecellscloud.requests import *

	api = CellsApi(os.getenv('CellsCloudClientId'),os.getenv('CellsCloudClientSecret'),"v3.0",os.getenv('CellsCloudApiBaseUrl'))
	request = GetNamedRangesRequest( 'Book1.xlsx',folder= 'PythonTest',storage_name= '')
	api.get_named_ranges(request)

view raw Example_GetNamedRanges.py hosted with ❤ by GitHub

	import os
	import sys

	from asposecellscloud.apis.cells_api import CellsApi
	from asposecellscloud.models import *
	from asposecellscloud.requests import *

	api = CellsApi(os.getenv('CellsCloudClientId'),os.getenv('CellsCloudClientSecret'),"v3.0",os.getenv('CellsCloudApiBaseUrl'))
	request = GetNamedRangeValueRequest( 'Book1.xlsx', 'Name_2',folder= 'PythonTest',storage_name= '')
	api.get_named_range_value(request)

view raw Example_GetNamedRangeValue.py hosted with ❤ by GitHub

	import os
	import sys

	from asposecellscloud.apis.cells_api import CellsApi
	from asposecellscloud.models import *
	from asposecellscloud.requests import *

	api = CellsApi(os.getenv('CellsCloudClientId'),os.getenv('CellsCloudClientSecret'),"v3.0",os.getenv('CellsCloudApiBaseUrl'))
	request = GetPageCountRequest( 'Book1.xlsx',folder= 'PythonTest',storage_name= '')
	api.get_page_count(request)

view raw Example_GetPageCount.py hosted with ❤ by GitHub

	import os
	import sys

	from asposecellscloud.apis.cells_api import CellsApi
	from asposecellscloud.models import *
	from asposecellscloud.requests import *

	api = CellsApi(os.getenv('CellsCloudClientId'),os.getenv('CellsCloudClientSecret'),"v3.0",os.getenv('CellsCloudApiBaseUrl'))
	request = GetPageSetupRequest( 'Book1.xlsx', 'Sheet1',folder= 'PythonTest',storage_name= '')
	api.get_page_setup(request)

view raw Example_GetPageSetup.py hosted with ❤ by GitHub

	import os
	import sys

	from asposecellscloud.apis.cells_api import CellsApi
	from asposecellscloud.models import *
	from asposecellscloud.requests import *

	api = CellsApi(os.getenv('CellsCloudClientId'),os.getenv('CellsCloudClientSecret'),"v3.0",os.getenv('CellsCloudApiBaseUrl'))
	request = GetPivotTableFieldRequest( 'TestCase.xlsx', 'Sheet4', 0, 0, 'Row',folder= 'PythonTest',storage_name= '')
	api.get_pivot_table_field(request)

view raw Example_GetPivotTableField.py hosted with ❤ by GitHub

	import os
	import sys

	from asposecellscloud.apis.cells_api import CellsApi
	from asposecellscloud.models import *
	from asposecellscloud.requests import *

	api = CellsApi(os.getenv('CellsCloudClientId'),os.getenv('CellsCloudClientSecret'),"v3.0",os.getenv('CellsCloudApiBaseUrl'))
	request = GetVerticalPageBreakRequest( 'Book1.xlsx', 'Sheet1', 0,folder= 'PythonTest',storage_name= '')
	api.get_vertical_page_break(request)

view raw Example_GetVerticalPageBreak.py hosted with ❤ by GitHub

	import os
	import sys

	from asposecellscloud.apis.cells_api import CellsApi
	from asposecellscloud.models import *
	from asposecellscloud.requests import *

	api = CellsApi(os.getenv('CellsCloudClientId'),os.getenv('CellsCloudClientSecret'),"v3.0",os.getenv('CellsCloudApiBaseUrl'))
	request = GetVerticalPageBreaksRequest( 'Book1.xlsx', 'Sheet1',folder= 'PythonTest',storage_name= '')
	api.get_vertical_page_breaks(request)

view raw Example_GetVerticalPageBreaks.py hosted with ❤ by GitHub

	import os
	import sys

	from asposecellscloud.apis.cells_api import CellsApi
	from asposecellscloud.models import *
	from asposecellscloud.requests import *

	api = CellsApi(os.getenv('CellsCloudClientId'),os.getenv('CellsCloudClientSecret'),"v3.0",os.getenv('CellsCloudApiBaseUrl'))
	request = GetWorkbookRequest( 'Book1.xlsx',format= "pdf",folder= 'PythonTest')
	api.get_workbook(request)

view raw Example_GetWorkbook.py hosted with ❤ by GitHub

	import os
	import sys

	from asposecellscloud.apis.cells_api import CellsApi
	from asposecellscloud.models import *
	from asposecellscloud.requests import *

	api = CellsApi(os.getenv('CellsCloudClientId'),os.getenv('CellsCloudClientSecret'),"v3.0",os.getenv('CellsCloudApiBaseUrl'))
	request = GetWorkbookDefaultStyleRequest( 'Book1.xlsx',folder= 'PythonTest',storage_name= '')
	api.get_workbook_default_style(request)

view raw Example_GetWorkbookDefaultStyle.py hosted with ❤ by GitHub

	import os
	import sys

	from asposecellscloud.apis.cells_api import CellsApi
	from asposecellscloud.models import *
	from asposecellscloud.requests import *

	api = CellsApi(os.getenv('CellsCloudClientId'),os.getenv('CellsCloudClientSecret'),"v3.0",os.getenv('CellsCloudApiBaseUrl'))
	request = GetWorkbookNameRequest( 'Book1.xlsx', 'Name_2',folder= 'PythonTest',storage_name= '')
	api.get_workbook_name(request)

view raw Example_GetWorkbookName.py hosted with ❤ by GitHub

	import os
	import sys

	from asposecellscloud.apis.cells_api import CellsApi
	from asposecellscloud.models import *
	from asposecellscloud.requests import *

	api = CellsApi(os.getenv('CellsCloudClientId'),os.getenv('CellsCloudClientSecret'),"v3.0",os.getenv('CellsCloudApiBaseUrl'))
	request = GetWorkbookNamesRequest( 'Book1.xlsx',folder= 'PythonTest',storage_name= '')
	api.get_workbook_names(request)

view raw Example_GetWorkbookNames.py hosted with ❤ by GitHub

	import os
	import sys

	from asposecellscloud.apis.cells_api import CellsApi
	from asposecellscloud.models import *
	from asposecellscloud.requests import *

	api = CellsApi(os.getenv('CellsCloudClientId'),os.getenv('CellsCloudClientSecret'),"v3.0",os.getenv('CellsCloudApiBaseUrl'))
	request = GetWorkbookNameValueRequest( 'Book1.xlsx', 'Name_2',folder= 'PythonTest',storage_name= '')
	api.get_workbook_name_value(request)

view raw Example_GetWorkbookNameValue.py hosted with ❤ by GitHub

	import os
	import sys

	from asposecellscloud.apis.cells_api import CellsApi
	from asposecellscloud.models import *
	from asposecellscloud.requests import *

	api = CellsApi(os.getenv('CellsCloudClientId'),os.getenv('CellsCloudClientSecret'),"v3.0",os.getenv('CellsCloudApiBaseUrl'))
	request = GetWorkbookSettingsRequest( 'Book1.xlsx',folder= 'PythonTest',storage_name= '')
	api.get_workbook_settings(request)

view raw Example_GetWorkbookSettings.py hosted with ❤ by GitHub

	import os
	import sys

	from asposecellscloud.apis.cells_api import CellsApi
	from asposecellscloud.models import *
	from asposecellscloud.requests import *

	api = CellsApi(os.getenv('CellsCloudClientId'),os.getenv('CellsCloudClientSecret'),"v3.0",os.getenv('CellsCloudApiBaseUrl'))
	request = GetWorkbookTextItemsRequest( 'Book1.xlsx',folder= 'PythonTest',storage_name= '')
	api.get_workbook_text_items(request)

view raw Example_GetWorkbookTextItems.py hosted with ❤ by GitHub

	import os
	import sys

	from asposecellscloud.apis.cells_api import CellsApi
	from asposecellscloud.models import *
	from asposecellscloud.requests import *

	api = CellsApi(os.getenv('CellsCloudClientId'),os.getenv('CellsCloudClientSecret'),"v3.0",os.getenv('CellsCloudApiBaseUrl'))
	request = GetWorksheetAutoFilterRequest( 'Book1.xlsx', 'Sheet1',folder= 'PythonTest',storage_name= '')
	api.get_worksheet_auto_filter(request)

view raw Example_GetWorksheetAutoFilter.py hosted with ❤ by GitHub

	import os
	import sys

	from asposecellscloud.apis.cells_api import CellsApi
	from asposecellscloud.models import *
	from asposecellscloud.requests import *

	api = CellsApi(os.getenv('CellsCloudClientId'),os.getenv('CellsCloudClientSecret'),"v3.0",os.getenv('CellsCloudApiBaseUrl'))
	request = GetWorksheetCalculateFormulaRequest( 'Book1.xlsx', 'Sheet1', '=NOW()',folder= 'PythonTest',storage_name= '')
	api.get_worksheet_calculate_formula(request)

view raw Example_GetWorksheetCalculateFormula.py hosted with ❤ by GitHub

	import os
	import sys

	from asposecellscloud.apis.cells_api import CellsApi
	from asposecellscloud.models import *
	from asposecellscloud.requests import *

	api = CellsApi(os.getenv('CellsCloudClientId'),os.getenv('CellsCloudClientSecret'),"v3.0",os.getenv('CellsCloudApiBaseUrl'))
	request = GetWorksheetCellRequest( 'Book1.xlsx', 'Sheet1', 'A1',folder= 'PythonTest',storage_name= '')
	api.get_worksheet_cell(request)

view raw Example_GetWorksheetCell.py hosted with ❤ by GitHub

	import os
	import sys

	from asposecellscloud.apis.cells_api import CellsApi
	from asposecellscloud.models import *
	from asposecellscloud.requests import *

	api = CellsApi(os.getenv('CellsCloudClientId'),os.getenv('CellsCloudClientSecret'),"v3.0",os.getenv('CellsCloudApiBaseUrl'))
	request = GetWorksheetCellsRequest( 'Book1.xlsx', 'Sheet1',offest= 1,count= 10,folder= 'PythonTest',storage_name= '')
	api.get_worksheet_cells(request)

view raw Example_GetWorksheetCells.py hosted with ❤ by GitHub

	import os
	import sys

	from asposecellscloud.apis.cells_api import CellsApi
	from asposecellscloud.models import *
	from asposecellscloud.requests import *

	api = CellsApi(os.getenv('CellsCloudClientId'),os.getenv('CellsCloudClientSecret'),"v3.0",os.getenv('CellsCloudApiBaseUrl'))
	request = GetWorksheetCellsRangeValueRequest( 'Book1.xlsx', 'Sheet1',namerange= 'Name_2',first_row= 0,first_column= 0,row_count= 3,column_count= 2,folder= 'PythonTest',storage_name= '')
	api.get_worksheet_cells_range_value(request)

view raw Example_GetWorksheetCellsRangeValue.py hosted with ❤ by GitHub

	import os
	import sys

	from asposecellscloud.apis.cells_api import CellsApi
	from asposecellscloud.models import *
	from asposecellscloud.requests import *

	api = CellsApi(os.getenv('CellsCloudClientId'),os.getenv('CellsCloudClientSecret'),"v3.0",os.getenv('CellsCloudApiBaseUrl'))
	request = GetWorksheetCellStyleRequest( 'Book1.xlsx', 'Sheet1', 'A1',folder= 'PythonTest',storage_name= '')
	api.get_worksheet_cell_style(request)

view raw Example_GetWorksheetCellStyle.py hosted with ❤ by GitHub

	import os
	import sys

	from asposecellscloud.apis.cells_api import CellsApi
	from asposecellscloud.models import *
	from asposecellscloud.requests import *

	api = CellsApi(os.getenv('CellsCloudClientId'),os.getenv('CellsCloudClientSecret'),"v3.0",os.getenv('CellsCloudApiBaseUrl'))
	request = GetWorksheetChartRequest( 'Book1.xlsx', 'Sheet4', 0,format= 'png',folder= 'PythonTest',storage_name= '')
	api.get_worksheet_chart(request)

view raw Example_GetWorksheetChart.py hosted with ❤ by GitHub

	import os
	import sys

	from asposecellscloud.apis.cells_api import CellsApi
	from asposecellscloud.models import *
	from asposecellscloud.requests import *

	api = CellsApi(os.getenv('CellsCloudClientId'),os.getenv('CellsCloudClientSecret'),"v3.0",os.getenv('CellsCloudApiBaseUrl'))
	request = GetWorksheetChartLegendRequest( 'Book1.xlsx', 'Sheet4', 0,folder= 'PythonTest',storage_name= '')
	api.get_worksheet_chart_legend(request)

view raw Example_GetWorksheetChartLegend.py hosted with ❤ by GitHub

	import os
	import sys

	from asposecellscloud.apis.cells_api import CellsApi
	from asposecellscloud.models import *
	from asposecellscloud.requests import *

	api = CellsApi(os.getenv('CellsCloudClientId'),os.getenv('CellsCloudClientSecret'),"v3.0",os.getenv('CellsCloudApiBaseUrl'))
	request = GetWorksheetChartsRequest( 'Book1.xlsx', 'Sheet4',folder= 'PythonTest',storage_name= '')
	api.get_worksheet_charts(request)

view raw Example_GetWorksheetCharts.py hosted with ❤ by GitHub

	import os
	import sys

	from asposecellscloud.apis.cells_api import CellsApi
	from asposecellscloud.models import *
	from asposecellscloud.requests import *

	api = CellsApi(os.getenv('CellsCloudClientId'),os.getenv('CellsCloudClientSecret'),"v3.0",os.getenv('CellsCloudApiBaseUrl'))
	request = GetWorksheetChartTitleRequest( 'Book1.xlsx', 'Sheet4', 0,folder= 'PythonTest',storage_name= '')
	api.get_worksheet_chart_title(request)

view raw Example_GetWorksheetChartTitle.py hosted with ❤ by GitHub

	import os
	import sys

	from asposecellscloud.apis.cells_api import CellsApi
	from asposecellscloud.models import *
	from asposecellscloud.requests import *

	api = CellsApi(os.getenv('CellsCloudClientId'),os.getenv('CellsCloudClientSecret'),"v3.0",os.getenv('CellsCloudApiBaseUrl'))
	request = GetWorksheetColumnRequest( 'Book1.xlsx', 'Sheet1', 1,folder= 'PythonTest',storage_name= '')
	api.get_worksheet_column(request)

view raw Example_GetWorksheetColumn.py hosted with ❤ by GitHub

	import os
	import sys

	from asposecellscloud.apis.cells_api import CellsApi
	from asposecellscloud.models import *
	from asposecellscloud.requests import *

	api = CellsApi(os.getenv('CellsCloudClientId'),os.getenv('CellsCloudClientSecret'),"v3.0",os.getenv('CellsCloudApiBaseUrl'))
	request = GetWorksheetColumnsRequest(name= 'Book1.xlsx',sheet_name= 'Sheet1',offset= 1,count= 10,folder= 'PythonTest',storage_name= '')
	api.get_worksheet_columns(request)

view raw Example_GetWorksheetColumns.py hosted with ❤ by GitHub

	import os
	import sys

	from asposecellscloud.apis.cells_api import CellsApi
	from asposecellscloud.models import *
	from asposecellscloud.requests import *

	api = CellsApi(os.getenv('CellsCloudClientId'),os.getenv('CellsCloudClientSecret'),"v3.0",os.getenv('CellsCloudApiBaseUrl'))
	request = GetWorksheetCommentRequest( 'Book1.xlsx', 'Sheet1', 'B3',folder= 'PythonTest',storage_name= '')
	api.get_worksheet_comment(request)

view raw Example_GetWorksheetComment.py hosted with ❤ by GitHub

	import os
	import sys

	from asposecellscloud.apis.cells_api import CellsApi
	from asposecellscloud.models import *
	from asposecellscloud.requests import *

	api = CellsApi(os.getenv('CellsCloudClientId'),os.getenv('CellsCloudClientSecret'),"v3.0",os.getenv('CellsCloudApiBaseUrl'))
	request = GetWorksheetCommentsRequest( 'Book1.xlsx', 'Sheet1',folder= 'PythonTest',storage_name= '')
	api.get_worksheet_comments(request)

view raw Example_GetWorksheetComments.py hosted with ❤ by GitHub

	import os
	import sys

	from asposecellscloud.apis.cells_api import CellsApi
	from asposecellscloud.models import *
	from asposecellscloud.requests import *

	api = CellsApi(os.getenv('CellsCloudClientId'),os.getenv('CellsCloudClientSecret'),"v3.0",os.getenv('CellsCloudApiBaseUrl'))
	request = GetWorksheetConditionalFormattingRequest( 'Book1.xlsx', 'Sheet1', 0,folder= 'PythonTest',storage_name= '')
	api.get_worksheet_conditional_formatting(request)

view raw Example_GetWorksheetConditionalFormatting.py hosted with ❤ by GitHub

	import os
	import sys

	from asposecellscloud.apis.cells_api import CellsApi
	from asposecellscloud.models import *
	from asposecellscloud.requests import *

	api = CellsApi(os.getenv('CellsCloudClientId'),os.getenv('CellsCloudClientSecret'),"v3.0",os.getenv('CellsCloudApiBaseUrl'))
	request = GetWorksheetConditionalFormattingsRequest( 'Book1.xlsx', 'Sheet1',folder= 'PythonTest',storage_name= '')
	api.get_worksheet_conditional_formattings(request)

view raw Example_GetWorksheetConditionalFormattings.py hosted with ❤ by GitHub

	import os
	import sys

	from asposecellscloud.apis.cells_api import CellsApi
	from asposecellscloud.models import *
	from asposecellscloud.requests import *

	api = CellsApi(os.getenv('CellsCloudClientId'),os.getenv('CellsCloudClientSecret'),"v3.0",os.getenv('CellsCloudApiBaseUrl'))
	request = GetWorksheetHyperlinkRequest( 'Book1.xlsx', 'Sheet1', 0,folder= 'PythonTest',storage_name= '')
	api.get_worksheet_hyperlink(request)

view raw Example_GetWorksheetHyperlink.py hosted with ❤ by GitHub

	import os
	import sys

	from asposecellscloud.apis.cells_api import CellsApi
	from asposecellscloud.models import *
	from asposecellscloud.requests import *

	api = CellsApi(os.getenv('CellsCloudClientId'),os.getenv('CellsCloudClientSecret'),"v3.0",os.getenv('CellsCloudApiBaseUrl'))
	request = GetWorksheetHyperlinksRequest( 'Book1.xlsx', 'Sheet1',folder= 'PythonTest',storage_name= '')
	api.get_worksheet_hyperlinks(request)

view raw Example_GetWorksheetHyperlinks.py hosted with ❤ by GitHub

	import os
	import sys

	from asposecellscloud.apis.cells_api import CellsApi
	from asposecellscloud.models import *
	from asposecellscloud.requests import *

	api = CellsApi(os.getenv('CellsCloudClientId'),os.getenv('CellsCloudClientSecret'),"v3.0",os.getenv('CellsCloudApiBaseUrl'))
	request = GetWorksheetListObjectRequest( 'Book1.xlsx', 'Sheet7', 0,format= 'pdf',folder= 'PythonTest',storage_name= '')
	api.get_worksheet_list_object(request)

view raw Example_GetWorksheetListObject.py hosted with ❤ by GitHub

	import os
	import sys

	from asposecellscloud.apis.cells_api import CellsApi
	from asposecellscloud.models import *
	from asposecellscloud.requests import *

	api = CellsApi(os.getenv('CellsCloudClientId'),os.getenv('CellsCloudClientSecret'),"v3.0",os.getenv('CellsCloudApiBaseUrl'))
	request = GetWorksheetListObjectsRequest( 'Book1.xlsx', 'Sheet7',folder= 'PythonTest',storage_name= '')
	api.get_worksheet_list_objects(request)

view raw Example_GetWorksheetListObjects.py hosted with ❤ by GitHub

	import os
	import sys

	from asposecellscloud.apis.cells_api import CellsApi
	from asposecellscloud.models import *
	from asposecellscloud.requests import *

	api = CellsApi(os.getenv('CellsCloudClientId'),os.getenv('CellsCloudClientSecret'),"v3.0",os.getenv('CellsCloudApiBaseUrl'))
	request = GetWorksheetMergedCellRequest( 'Book1.xlsx', 'Sheet1', 0,folder= 'PythonTest',storage_name= '')
	api.get_worksheet_merged_cell(request)

view raw Example_GetWorksheetMergedCell.py hosted with ❤ by GitHub

	import os
	import sys

	from asposecellscloud.apis.cells_api import CellsApi
	from asposecellscloud.models import *
	from asposecellscloud.requests import *

	api = CellsApi(os.getenv('CellsCloudClientId'),os.getenv('CellsCloudClientSecret'),"v3.0",os.getenv('CellsCloudApiBaseUrl'))
	request = GetWorksheetMergedCellsRequest( 'Book1.xlsx', 'Sheet1',folder= 'PythonTest',storage_name= '')
	api.get_worksheet_merged_cells(request)

view raw Example_GetWorksheetMergedCells.py hosted with ❤ by GitHub

	import os
	import sys

	from asposecellscloud.apis.cells_api import CellsApi
	from asposecellscloud.models import *
	from asposecellscloud.requests import *

	api = CellsApi(os.getenv('CellsCloudClientId'),os.getenv('CellsCloudClientSecret'),"v3.0",os.getenv('CellsCloudApiBaseUrl'))
	request = GetWorksheetOleObjectRequest( 'Book1.xlsx', 'Sheet6', 0,format= 'png',folder= 'PythonTest',storage_name= '')
	api.get_worksheet_ole_object(request)

view raw Example_GetWorksheetOleObject.py hosted with ❤ by GitHub

	import os
	import sys

	from asposecellscloud.apis.cells_api import CellsApi
	from asposecellscloud.models import *
	from asposecellscloud.requests import *

	api = CellsApi(os.getenv('CellsCloudClientId'),os.getenv('CellsCloudClientSecret'),"v3.0",os.getenv('CellsCloudApiBaseUrl'))
	request = GetWorksheetOleObjectsRequest( 'Book1.xlsx', 'Sheet6',folder= 'PythonTest',storage_name= '')
	api.get_worksheet_ole_objects(request)

view raw Example_GetWorksheetOleObjects.py hosted with ❤ by GitHub

	import os
	import sys

	from asposecellscloud.apis.cells_api import CellsApi
	from asposecellscloud.models import *
	from asposecellscloud.requests import *

	api = CellsApi(os.getenv('CellsCloudClientId'),os.getenv('CellsCloudClientSecret'),"v3.0",os.getenv('CellsCloudApiBaseUrl'))
	request = GetWorksheetPageCountRequest( 'Book1.xlsx', 'Sheet1',folder= 'PythonTest',storage_name= '')
	api.get_worksheet_page_count(request)

view raw Example_GetWorksheetPageCount.py hosted with ❤ by GitHub

	import os
	import sys

	from asposecellscloud.apis.cells_api import CellsApi
	from asposecellscloud.models import *
	from asposecellscloud.requests import *

	api = CellsApi(os.getenv('CellsCloudClientId'),os.getenv('CellsCloudClientSecret'),"v3.0",os.getenv('CellsCloudApiBaseUrl'))
	request = GetWorksheetPicturesRequest( 'Book1.xlsx', 'Sheet6',folder= 'PythonTest',storage_name= '')
	api.get_worksheet_pictures(request)

view raw Example_GetWorksheetPictures.py hosted with ❤ by GitHub

	import os
	import sys

	from asposecellscloud.apis.cells_api import CellsApi
	from asposecellscloud.models import *
	from asposecellscloud.requests import *

	api = CellsApi(os.getenv('CellsCloudClientId'),os.getenv('CellsCloudClientSecret'),"v3.0",os.getenv('CellsCloudApiBaseUrl'))
	request = GetWorksheetPictureWithFormatRequest( 'Book1.xlsx', 'Sheet6', 0, 'png',folder= 'PythonTest',storage_name= '')
	api.get_worksheet_picture_with_format(request)

view raw Example_GetWorksheetPictureWithFormat.py hosted with ❤ by GitHub

	import os
	import sys

	from asposecellscloud.apis.cells_api import CellsApi
	from asposecellscloud.models import *
	from asposecellscloud.requests import *

	api = CellsApi(os.getenv('CellsCloudClientId'),os.getenv('CellsCloudClientSecret'),"v3.0",os.getenv('CellsCloudApiBaseUrl'))
	request = GetWorksheetPivotTableRequest( 'TestCase.xlsx', 'Sheet3', 0,folder= 'PythonTest',storage_name= '')
	api.get_worksheet_pivot_table(request)

view raw Example_GetWorksheetPivotTable.py hosted with ❤ by GitHub

	import os
	import sys

	from asposecellscloud.apis.cells_api import CellsApi
	from asposecellscloud.models import *
	from asposecellscloud.requests import *

	api = CellsApi(os.getenv('CellsCloudClientId'),os.getenv('CellsCloudClientSecret'),"v3.0",os.getenv('CellsCloudApiBaseUrl'))
	request = GetWorksheetPivotTableFilterRequest( 'TestCase.xlsx', 'Sheet3', 0, 0,folder= 'PythonTest',storage_name= '')
	api.get_worksheet_pivot_table_filter(request)

view raw Example_GetWorksheetPivotTableFilter.py hosted with ❤ by GitHub

	import os
	import sys

	from asposecellscloud.apis.cells_api import CellsApi
	from asposecellscloud.models import *
	from asposecellscloud.requests import *

	api = CellsApi(os.getenv('CellsCloudClientId'),os.getenv('CellsCloudClientSecret'),"v3.0",os.getenv('CellsCloudApiBaseUrl'))
	request = GetWorksheetPivotTableFiltersRequest( 'TestCase.xlsx', 'Sheet3', 0,folder= 'PythonTest',storage_name= '')
	api.get_worksheet_pivot_table_filters(request)

view raw Example_GetWorksheetPivotTableFilters.py hosted with ❤ by GitHub

	import os
	import sys

	from asposecellscloud.apis.cells_api import CellsApi
	from asposecellscloud.models import *
	from asposecellscloud.requests import *

	api = CellsApi(os.getenv('CellsCloudClientId'),os.getenv('CellsCloudClientSecret'),"v3.0",os.getenv('CellsCloudApiBaseUrl'))
	request = GetWorksheetPivotTablesRequest( 'TestCase.xlsx', 'Sheet3',folder= 'PythonTest',storage_name= '')
	api.get_worksheet_pivot_tables(request)

view raw Example_GetWorksheetPivotTables.py hosted with ❤ by GitHub

	import os
	import sys

	from asposecellscloud.apis.cells_api import CellsApi
	from asposecellscloud.models import *
	from asposecellscloud.requests import *

	api = CellsApi(os.getenv('CellsCloudClientId'),os.getenv('CellsCloudClientSecret'),"v3.0",os.getenv('CellsCloudApiBaseUrl'))
	request = GetWorksheetRowRequest( 'Book1.xlsx', 'Sheet1', 1,folder= 'PythonTest',storage_name= '')
	api.get_worksheet_row(request)

view raw Example_GetWorksheetRow.py hosted with ❤ by GitHub

	import os
	import sys

	from asposecellscloud.apis.cells_api import CellsApi
	from asposecellscloud.models import *
	from asposecellscloud.requests import *

	api = CellsApi(os.getenv('CellsCloudClientId'),os.getenv('CellsCloudClientSecret'),"v3.0",os.getenv('CellsCloudApiBaseUrl'))
	request = GetWorksheetRowsRequest( 'Book1.xlsx', 'Sheet1',offset= 1,count= 10,folder= 'PythonTest',storage_name= '')
	api.get_worksheet_rows(request)

view raw Example_GetWorksheetRows.py hosted with ❤ by GitHub

	import os
	import sys

	from asposecellscloud.apis.cells_api import CellsApi
	from asposecellscloud.models import *
	from asposecellscloud.requests import *

	api = CellsApi(os.getenv('CellsCloudClientId'),os.getenv('CellsCloudClientSecret'),"v3.0",os.getenv('CellsCloudApiBaseUrl'))
	request = GetWorksheetsRequest( 'Book1.xlsx',folder= 'PythonTest',storage_name= '')
	api.get_worksheets(request)

view raw Example_GetWorksheets.py hosted with ❤ by GitHub

	import os
	import sys

	from asposecellscloud.apis.cells_api import CellsApi
	from asposecellscloud.models import *
	from asposecellscloud.requests import *

	api = CellsApi(os.getenv('CellsCloudClientId'),os.getenv('CellsCloudClientSecret'),"v3.0",os.getenv('CellsCloudApiBaseUrl'))
	request = GetWorksheetShapeRequest( 'Book1.xlsx', 'Sheet1', 0,folder= 'PythonTest',storage_name= '')
	api.get_worksheet_shape(request)

view raw Example_GetWorksheetShape.py hosted with ❤ by GitHub

	import os
	import sys

	from asposecellscloud.apis.cells_api import CellsApi
	from asposecellscloud.models import *
	from asposecellscloud.requests import *

	api = CellsApi(os.getenv('CellsCloudClientId'),os.getenv('CellsCloudClientSecret'),"v3.0",os.getenv('CellsCloudApiBaseUrl'))
	request = GetWorksheetShapesRequest( 'Book1.xlsx', 'Sheet1',folder= 'PythonTest',storage_name= '')
	api.get_worksheet_shapes(request)

view raw Example_GetWorksheetShapes.py hosted with ❤ by GitHub

	import os
	import sys

	from asposecellscloud.apis.cells_api import CellsApi
	from asposecellscloud.models import *
	from asposecellscloud.requests import *

	api = CellsApi(os.getenv('CellsCloudClientId'),os.getenv('CellsCloudClientSecret'),"v3.0",os.getenv('CellsCloudApiBaseUrl'))
	request = GetWorksheetSparklineGroupRequest( 'TestCase.xlsx', 'Sheet1', 0,folder= 'PythonTest',storage_name= '')
	api.get_worksheet_sparkline_group(request)

view raw Example_GetWorksheetSparklineGroup.py hosted with ❤ by GitHub

	import os
	import sys

	from asposecellscloud.apis.cells_api import CellsApi
	from asposecellscloud.models import *
	from asposecellscloud.requests import *

	api = CellsApi(os.getenv('CellsCloudClientId'),os.getenv('CellsCloudClientSecret'),"v3.0",os.getenv('CellsCloudApiBaseUrl'))
	request = GetWorksheetSparklineGroupsRequest( 'Book1.xlsx', 'Sheet1',folder= 'PythonTest',storage_name= '')
	api.get_worksheet_sparkline_groups(request)

view raw Example_GetWorksheetSparklineGroups.py hosted with ❤ by GitHub

	import os
	import sys

	from asposecellscloud.apis.cells_api import CellsApi
	from asposecellscloud.models import *
	from asposecellscloud.requests import *

	api = CellsApi(os.getenv('CellsCloudClientId'),os.getenv('CellsCloudClientSecret'),"v3.0",os.getenv('CellsCloudApiBaseUrl'))
	request = GetWorksheetTextItemsRequest( 'Book1.xlsx', 'Sheet1',folder= 'PythonTest',storage_name= '')
	api.get_worksheet_text_items(request)

view raw Example_GetWorksheetTextItems.py hosted with ❤ by GitHub

	import os
	import sys

	from asposecellscloud.apis.cells_api import CellsApi
	from asposecellscloud.models import *
	from asposecellscloud.requests import *

	api = CellsApi(os.getenv('CellsCloudClientId'),os.getenv('CellsCloudClientSecret'),"v3.0",os.getenv('CellsCloudApiBaseUrl'))
	request = GetWorksheetValidationRequest( 'Book1.xlsx', 'Sheet1', 0,folder= 'PythonTest',storage_name= '')
	api.get_worksheet_validation(request)

view raw Example_GetWorksheetValidation.py hosted with ❤ by GitHub

	import os
	import sys

	from asposecellscloud.apis.cells_api import CellsApi
	from asposecellscloud.models import *
	from asposecellscloud.requests import *

	api = CellsApi(os.getenv('CellsCloudClientId'),os.getenv('CellsCloudClientSecret'),"v3.0",os.getenv('CellsCloudApiBaseUrl'))
	request = GetWorksheetValidationsRequest( 'Book1.xlsx', 'Sheet1',folder= 'PythonTest',storage_name= '')
	api.get_worksheet_validations(request)

view raw Example_GetWorksheetValidations.py hosted with ❤ by GitHub

	import os
	import sys

	from asposecellscloud.apis.cells_api import CellsApi
	from asposecellscloud.models import *
	from asposecellscloud.requests import *

	api = CellsApi(os.getenv('CellsCloudClientId'),os.getenv('CellsCloudClientSecret'),"v3.0",os.getenv('CellsCloudApiBaseUrl'))
	request = GetWorksheetWithFormatRequest( 'Book1.xlsx', 'Sheet1',format= 'png',page_index= 0,folder= 'PythonTest',storage_name= '')
	api.get_worksheet_with_format(request)

view raw Example_GetWorksheetWithFormat.py hosted with ❤ by GitHub

	import os
	import sys

	from asposecellscloud.apis.cells_api import CellsApi
	from asposecellscloud.models import *
	from asposecellscloud.requests import *

	api = CellsApi(os.getenv('CellsCloudClientId'),os.getenv('CellsCloudClientSecret'),"v3.0",os.getenv('CellsCloudApiBaseUrl'))
	request = MoveFileRequest( 'PythonTest' + '/' + 'Book1.xlsx', 'OutResult/' + 'Book1.xlsx',src_storage_name= '',dest_storage_name= '',version_id= '')
	api.move_file(request)

view raw Example_MoveFile.py hosted with ❤ by GitHub

	import os
	import sys

	from asposecellscloud.apis.cells_api import CellsApi
	from asposecellscloud.models import *
	from asposecellscloud.requests import *

	api = CellsApi(os.getenv('CellsCloudClientId'),os.getenv('CellsCloudClientSecret'),"v3.0",os.getenv('CellsCloudApiBaseUrl'))
	request = MoveFolderRequest( 'OutResult/Create', 'OutResult/Move',src_storage_name= '',dest_storage_name= '')
	api.move_folder(request)

view raw Example_MoveFolder.py hosted with ❤ by GitHub

	import os
	import sys

	from asposecellscloud.apis.cells_api import CellsApi
	from asposecellscloud.models import *
	from asposecellscloud.requests import *

	api = CellsApi(os.getenv('CellsCloudClientId'),os.getenv('CellsCloudClientSecret'),"v3.0",os.getenv('CellsCloudApiBaseUrl'))
	request = ObjectExistsRequest( 'TestData/In/Book1.xlsx',storage_name= '',version_id= '')
	api.object_exists(request)

view raw Example_ObjectExists.py hosted with ❤ by GitHub

	import os
	import sys

	from asposecellscloud.apis.cells_api import CellsApi
	from asposecellscloud.models import *
	from asposecellscloud.requests import *

	api = CellsApi(os.getenv('CellsCloudClientId'),os.getenv('CellsCloudClientSecret'),"v3.0",os.getenv('CellsCloudApiBaseUrl'))
	request = PostAssembleRequest( {'assemblytest.xlsx':'assemblytest.xlsx','datasource.xlsx':'datasource.xlsx'}, 'ds',out_format= "pdf")
	api.post_assemble(request)

view raw Example_PostAssemble.py hosted with ❤ by GitHub

	import os
	import sys

	from asposecellscloud.apis.cells_api import CellsApi
	from asposecellscloud.models import *
	from asposecellscloud.requests import *

	api = CellsApi(os.getenv('CellsCloudClientId'),os.getenv('CellsCloudClientSecret'),"v3.0",os.getenv('CellsCloudApiBaseUrl'))
	request = PostAutofitWorkbookColumnsRequest( 'Book1.xlsx',start_column= 1,end_column= 20,folder= 'PythonTest',storage_name= '')
	api.post_autofit_workbook_columns(request)

view raw Example_PostAutofitWorkbookColumns.py hosted with ❤ by GitHub

	import os
	import sys

	from asposecellscloud.apis.cells_api import CellsApi
	from asposecellscloud.models import *
	from asposecellscloud.requests import *

	api = CellsApi(os.getenv('CellsCloudClientId'),os.getenv('CellsCloudClientSecret'),"v3.0",os.getenv('CellsCloudApiBaseUrl'))
	request = PostAutofitWorkbookRowsRequest( 'Book1.xlsx',start_row= 1,end_row= 100,only_auto= True,folder= 'PythonTest',storage_name= '')
	api.post_autofit_workbook_rows(request)

view raw Example_PostAutofitWorkbookRows.py hosted with ❤ by GitHub

	import os
	import sys

	from asposecellscloud.apis.cells_api import CellsApi
	from asposecellscloud.models import *
	from asposecellscloud.requests import *

	api = CellsApi(os.getenv('CellsCloudClientId'),os.getenv('CellsCloudClientSecret'),"v3.0",os.getenv('CellsCloudApiBaseUrl'))
	request = PostAutofitWorksheetColumnsRequest( 'Book1.xlsx', 'Sheet1',start_column= 1,end_column= 9,only_auto= True,folder= 'PythonTest',storage_name= '')
	api.post_autofit_worksheet_columns(request)

view raw Example_PostAutofitWorksheetColumns.py hosted with ❤ by GitHub

	import os
	import sys

	from asposecellscloud.apis.cells_api import CellsApi
	from asposecellscloud.models import *
	from asposecellscloud.requests import *

	api = CellsApi(os.getenv('CellsCloudClientId'),os.getenv('CellsCloudClientSecret'),"v3.0",os.getenv('CellsCloudApiBaseUrl'))
	request = PostAutofitWorksheetRowRequest( 'Book1.xlsx', 'Sheet1', 1, 1, 8,folder= 'PythonTest',storage_name= '')
	api.post_autofit_worksheet_row(request)

view raw Example_PostAutofitWorksheetRow.py hosted with ❤ by GitHub

	import os
	import sys

	from asposecellscloud.apis.cells_api import CellsApi
	from asposecellscloud.models import *
	from asposecellscloud.requests import *

	api = CellsApi(os.getenv('CellsCloudClientId'),os.getenv('CellsCloudClientSecret'),"v3.0",os.getenv('CellsCloudApiBaseUrl'))
	request = PostAutofitWorksheetRowsRequest( 'Book1.xlsx', 'Sheet1',start_row= 1,end_row= 9,only_auto= True,folder= 'PythonTest',storage_name= '')
	api.post_autofit_worksheet_rows(request)

view raw Example_PostAutofitWorksheetRows.py hosted with ❤ by GitHub

	import os
	import sys

	from asposecellscloud.apis.cells_api import CellsApi
	from asposecellscloud.models import *
	from asposecellscloud.requests import *

	api = CellsApi(os.getenv('CellsCloudClientId'),os.getenv('CellsCloudClientSecret'),"v3.0",os.getenv('CellsCloudApiBaseUrl'))
	batchConvertRequestMatchCondition = MatchConditionRequest(regex_pattern= '(^Book)(.+)(xlsx$)' )
	batchConvertRequest = BatchConvertRequest(source_folder= 'PythonTest' ,format= 'pdf' ,out_folder= 'OutResult' ,match_condition= batchConvertRequestMatchCondition )
	request = PostBatchConvertRequest( batchConvertRequest)
	api.post_batch_convert(request)

view raw Example_PostBatchConvert.py hosted with ❤ by GitHub

	import os
	import sys

	from asposecellscloud.apis.cells_api import CellsApi
	from asposecellscloud.models import *
	from asposecellscloud.requests import *

	api = CellsApi(os.getenv('CellsCloudClientId'),os.getenv('CellsCloudClientSecret'),"v3.0",os.getenv('CellsCloudApiBaseUrl'))
	batchLockRequestMatchCondition = MatchConditionRequest(regex_pattern= '(^Book)(.+)(xlsx$)' )
	batchLockRequest = BatchLockRequest(source_folder= 'PythonTest' ,password= '123456' ,out_folder= 'OutResult' ,match_condition= batchLockRequestMatchCondition )
	request = PostBatchLockRequest( batchLockRequest)
	api.post_batch_lock(request)

view raw Example_PostBatchLock.py hosted with ❤ by GitHub

	import os
	import sys

	from asposecellscloud.apis.cells_api import CellsApi
	from asposecellscloud.models import *
	from asposecellscloud.requests import *

	api = CellsApi(os.getenv('CellsCloudClientId'),os.getenv('CellsCloudClientSecret'),"v3.0",os.getenv('CellsCloudApiBaseUrl'))
	batchProtectRequestMatchCondition = MatchConditionRequest(regex_pattern= '(^Book)(.+)(xlsx$)' )
	batchProtectRequest = BatchProtectRequest(source_folder= 'PythonTest' ,protection_type= 'All' ,password= '123456' ,out_folder= 'OutResult' ,match_condition= batchProtectRequestMatchCondition )
	request = PostBatchProtectRequest( batchProtectRequest)
	api.post_batch_protect(request)

view raw Example_PostBatchProtect.py hosted with ❤ by GitHub

	import os
	import sys

	from asposecellscloud.apis.cells_api import CellsApi
	from asposecellscloud.models import *
	from asposecellscloud.requests import *

	api = CellsApi(os.getenv('CellsCloudClientId'),os.getenv('CellsCloudClientSecret'),"v3.0",os.getenv('CellsCloudApiBaseUrl'))
	batchLockRequestMatchCondition = MatchConditionRequest(regex_pattern= '(^Book)(.+)(xlsx$)' )
	batchLockRequest = BatchLockRequest(source_folder= 'PythonTest' ,password= '123456' ,out_folder= 'OutResult' ,match_condition= batchLockRequestMatchCondition )
	request = PostBatchUnlockRequest( batchLockRequest)
	api.post_batch_unlock(request)

view raw Example_PostBatchUnlock.py hosted with ❤ by GitHub

	import os
	import sys

	from asposecellscloud.apis.cells_api import CellsApi
	from asposecellscloud.models import *
	from asposecellscloud.requests import *

	api = CellsApi(os.getenv('CellsCloudClientId'),os.getenv('CellsCloudClientSecret'),"v3.0",os.getenv('CellsCloudApiBaseUrl'))
	options = CalculationOptions(recursive= True ,ignore_error= True )
	request = PostCellCalculateRequest( 'Book1.xlsx', 'Sheet1', 'A1',options= options,folder= 'PythonTest',storage_name= '')
	api.post_cell_calculate(request)

view raw Example_PostCellCalculate.py hosted with ❤ by GitHub

	import os
	import sys

	from asposecellscloud.apis.cells_api import CellsApi
	from asposecellscloud.models import *
	from asposecellscloud.requests import *

	api = CellsApi(os.getenv('CellsCloudClientId'),os.getenv('CellsCloudClientSecret'),"v3.0",os.getenv('CellsCloudApiBaseUrl'))
	optionsvalue0Font = Font(is_bold=True, size=16)
	optionsvalue0 = FontSetting(length=5, start_index=0, font=optionsvalue0Font)
	options = [
	optionsvalue0
	]
	request = PostCellCharactersRequest( 'Book1.xlsx', 'Sheet1', 'E36',options= options,folder= 'PythonTest',storage_name= '')
	api.post_cell_characters(request)

view raw Example_PostCellCharacters.py hosted with ❤ by GitHub

	import os
	import sys

	from asposecellscloud.apis.cells_api import CellsApi
	from asposecellscloud.models import *
	from asposecellscloud.requests import *

	api = CellsApi(os.getenv('CellsCloudClientId'),os.getenv('CellsCloudClientSecret'),"v3.0",os.getenv('CellsCloudApiBaseUrl'))
	request = PostClearContentsRequest( 'Book1.xlsx', 'Sheet1',range= 'A1:C10',start_row= 1,start_column= 1,end_row= 3,end_column= 3,folder= 'PythonTest',storage_name= '')
	api.post_clear_contents(request)

view raw Example_PostClearContents.py hosted with ❤ by GitHub

	import os
	import sys

	from asposecellscloud.apis.cells_api import CellsApi
	from asposecellscloud.models import *
	from asposecellscloud.requests import *

	api = CellsApi(os.getenv('CellsCloudClientId'),os.getenv('CellsCloudClientSecret'),"v3.0",os.getenv('CellsCloudApiBaseUrl'))
	request = PostClearFormatsRequest( 'Book1.xlsx', 'Sheet1',range= 'A1:C10',start_row= 1,start_column= 1,end_row= 3,end_column= 3,folder= 'PythonTest',storage_name= '')
	api.post_clear_formats(request)

view raw Example_PostClearFormats.py hosted with ❤ by GitHub

	import os
	import sys

	from asposecellscloud.apis.cells_api import CellsApi
	from asposecellscloud.models import *
	from asposecellscloud.requests import *

	api = CellsApi(os.getenv('CellsCloudClientId'),os.getenv('CellsCloudClientSecret'),"v3.0",os.getenv('CellsCloudApiBaseUrl'))
	request = PostClearObjectsRequest( mapFiles, objecttype)
	api.post_clear_objects(request)

view raw Example_PostClearObjects.py hosted with ❤ by GitHub

	import os
	import sys

	from asposecellscloud.apis.cells_api import CellsApi
	from asposecellscloud.models import *
	from asposecellscloud.requests import *

	api = CellsApi(os.getenv('CellsCloudClientId'),os.getenv('CellsCloudClientSecret'),"v3.0",os.getenv('CellsCloudApiBaseUrl'))
	styleFont = Font(size= 16 )
	style = Style(font= styleFont )
	request = PostColumnStyleRequest( 'Book1.xlsx', 'Sheet1', 1, style,folder= 'PythonTest',storage_name= '')
	api.post_column_style(request)

view raw Example_PostColumnStyle.py hosted with ❤ by GitHub

	import os
	import sys

	from asposecellscloud.apis.cells_api import CellsApi
	from asposecellscloud.models import *
	from asposecellscloud.requests import *

	api = CellsApi(os.getenv('CellsCloudClientId'),os.getenv('CellsCloudClientSecret'),"v3.0",os.getenv('CellsCloudApiBaseUrl'))
	request = PostCompressRequest( mapFiles,compress_level= compress_level)
	api.post_compress(request)

view raw Example_PostCompress.py hosted with ❤ by GitHub

	import os
	import sys

	from asposecellscloud.apis.cells_api import CellsApi
	from asposecellscloud.models import *
	from asposecellscloud.requests import *

	api = CellsApi(os.getenv('CellsCloudClientId'),os.getenv('CellsCloudClientSecret'),"v3.0",os.getenv('CellsCloudApiBaseUrl'))
	request = PostCopyCellIntoCellRequest( 'Book1.xlsx', 'C1', 'Sheet1', 'Sheet2',cellname= 'A1',row= 1,column= 1,folder= 'PythonTest',storage_name= '')
	api.post_copy_cell_into_cell(request)

view raw Example_PostCopyCellIntoCell.py hosted with ❤ by GitHub

	import os
	import sys

	from asposecellscloud.apis.cells_api import CellsApi
	from asposecellscloud.models import *
	from asposecellscloud.requests import *

	api = CellsApi(os.getenv('CellsCloudClientId'),os.getenv('CellsCloudClientSecret'),"v3.0",os.getenv('CellsCloudApiBaseUrl'))
	options = CopyOptions(column_character_width= True )
	request = PostCopyWorksheetRequest( 'Book1.xlsx', 'Sheet15', 'Sheet6', options,source_workbook= '',source_folder= '',folder= 'PythonTest',storage_name= '')
	api.post_copy_worksheet(request)

view raw Example_PostCopyWorksheet.py hosted with ❤ by GitHub

	import os
	import sys

	from asposecellscloud.apis.cells_api import CellsApi
	from asposecellscloud.models import *
	from asposecellscloud.requests import *

	api = CellsApi(os.getenv('CellsCloudClientId'),os.getenv('CellsCloudClientSecret'),"v3.0",os.getenv('CellsCloudApiBaseUrl'))
	request = PostCopyWorksheetColumnsRequest( 'Book1.xlsx', 'Sheet1', 1, 19, 8,worksheet= 'Sheet2',folder= 'PythonTest',storage_name= '')
	api.post_copy_worksheet_columns(request)

view raw Example_PostCopyWorksheetColumns.py hosted with ❤ by GitHub

	import os
	import sys

	from asposecellscloud.apis.cells_api import CellsApi
	from asposecellscloud.models import *
	from asposecellscloud.requests import *

	api = CellsApi(os.getenv('CellsCloudClientId'),os.getenv('CellsCloudClientSecret'),"v3.0",os.getenv('CellsCloudApiBaseUrl'))
	request = PostCopyWorksheetRowsRequest( 'Book1.xlsx', 'Sheet1', 1, 12, 5,worksheet= 'Sheet2',folder= 'PythonTest',storage_name= '')
	api.post_copy_worksheet_rows(request)

view raw Example_PostCopyWorksheetRows.py hosted with ❤ by GitHub

	import os
	import sys

	from asposecellscloud.apis.cells_api import CellsApi
	from asposecellscloud.models import *
	from asposecellscloud.requests import *

	api = CellsApi(os.getenv('CellsCloudClientId'),os.getenv('CellsCloudClientSecret'),"v3.0",os.getenv('CellsCloudApiBaseUrl'))
	request = PostDigitalSignatureRequest( 'Book1.xlsx', 'PythonTest' + '/roywang.pfx', '123456',folder= 'PythonTest',storage_name= '')
	api.post_digital_signature(request)

view raw Example_PostDigitalSignature.py hosted with ❤ by GitHub

	import os
	import sys

	from asposecellscloud.apis.cells_api import CellsApi
	from asposecellscloud.models import *
	from asposecellscloud.requests import *

	api = CellsApi(os.getenv('CellsCloudClientId'),os.getenv('CellsCloudClientSecret'),"v3.0",os.getenv('CellsCloudApiBaseUrl'))
	encryption = WorkbookEncryptionRequest(password= '123456' ,encryption_type= 'XOR' ,key_length= 128 )
	request = PostEncryptWorkbookRequest( 'Book1.xlsx', encryption,folder= 'PythonTest',storage_name= '')
	api.post_encrypt_workbook(request)

view raw Example_PostEncryptWorkbook.py hosted with ❤ by GitHub

	import os
	import sys

	from asposecellscloud.apis.cells_api import CellsApi
	from asposecellscloud.models import *
	from asposecellscloud.requests import *

	api = CellsApi(os.getenv('CellsCloudClientId'),os.getenv('CellsCloudClientSecret'),"v3.0",os.getenv('CellsCloudApiBaseUrl'))
	request = PostExportRequest( {'assemblytest.xlsx':'assemblytest.xlsx'},object_type= 'chart',format= 'png')
	api.post_export(request)

view raw Example_PostExport.py hosted with ❤ by GitHub

	import os
	import sys

	from asposecellscloud.apis.cells_api import CellsApi
	from asposecellscloud.models import *
	from asposecellscloud.requests import *

	api = CellsApi(os.getenv('CellsCloudClientId'),os.getenv('CellsCloudClientSecret'),"v3.0",os.getenv('CellsCloudApiBaseUrl'))
	request = PostFitTallToPagesRequest( 'Book1.xlsx', 'Sheet1',folder= 'PythonTest',storage_name= '')
	api.post_fit_tall_to_pages(request)

view raw Example_PostFitTallToPages.py hosted with ❤ by GitHub

	import os
	import sys

	from asposecellscloud.apis.cells_api import CellsApi
	from asposecellscloud.models import *
	from asposecellscloud.requests import *

	api = CellsApi(os.getenv('CellsCloudClientId'),os.getenv('CellsCloudClientSecret'),"v3.0",os.getenv('CellsCloudApiBaseUrl'))
	request = PostFitWideToPagesRequest( 'Book1.xlsx', 'Sheet1',folder= 'PythonTest',storage_name= '')
	api.post_fit_wide_to_pages(request)

view raw Example_PostFitWideToPages.py hosted with ❤ by GitHub

	import os
	import sys

	from asposecellscloud.apis.cells_api import CellsApi
	from asposecellscloud.models import *
	from asposecellscloud.requests import *

	api = CellsApi(os.getenv('CellsCloudClientId'),os.getenv('CellsCloudClientSecret'),"v3.0",os.getenv('CellsCloudApiBaseUrl'))
	request = PostFooterRequest( 'Book1.xlsx', 'Sheet1', 1, 'add footer script', True,folder= 'PythonTest',storage_name= '')
	api.post_footer(request)

view raw Example_PostFooter.py hosted with ❤ by GitHub

	import os
	import sys

	from asposecellscloud.apis.cells_api import CellsApi
	from asposecellscloud.models import *
	from asposecellscloud.requests import *

	api = CellsApi(os.getenv('CellsCloudClientId'),os.getenv('CellsCloudClientSecret'),"v3.0",os.getenv('CellsCloudApiBaseUrl'))
	request = PostGroupWorksheetColumnsRequest( 'Book1.xlsx', 'Sheet1', 1, 9,hide= True,folder= 'PythonTest',storage_name= '')
	api.post_group_worksheet_columns(request)

view raw Example_PostGroupWorksheetColumns.py hosted with ❤ by GitHub

	import os
	import sys

	from asposecellscloud.apis.cells_api import CellsApi
	from asposecellscloud.models import *
	from asposecellscloud.requests import *

	api = CellsApi(os.getenv('CellsCloudClientId'),os.getenv('CellsCloudClientSecret'),"v3.0",os.getenv('CellsCloudApiBaseUrl'))
	request = PostGroupWorksheetRowsRequest( 'Book1.xlsx', 'Sheet1', 1, 9,hide= True,folder= 'PythonTest',storage_name= '')
	api.post_group_worksheet_rows(request)

view raw Example_PostGroupWorksheetRows.py hosted with ❤ by GitHub

	import os
	import sys

	from asposecellscloud.apis.cells_api import CellsApi
	from asposecellscloud.models import *
	from asposecellscloud.requests import *

	api = CellsApi(os.getenv('CellsCloudClientId'),os.getenv('CellsCloudClientSecret'),"v3.0",os.getenv('CellsCloudApiBaseUrl'))
	request = PostHeaderRequest( 'Book1.xlsx', 'Sheet1', 1, 'Update add header', True,folder= 'PythonTest',storage_name= '')
	api.post_header(request)

view raw Example_PostHeader.py hosted with ❤ by GitHub

	import os
	import sys

	from asposecellscloud.apis.cells_api import CellsApi
	from asposecellscloud.models import *
	from asposecellscloud.requests import *

	api = CellsApi(os.getenv('CellsCloudClientId'),os.getenv('CellsCloudClientSecret'),"v3.0",os.getenv('CellsCloudApiBaseUrl'))
	request = PostHideWorksheetColumnsRequest( 'Book1.xlsx', 'Sheet1', 1, 10,folder= 'PythonTest',storage_name= '')
	api.post_hide_worksheet_columns(request)

view raw Example_PostHideWorksheetColumns.py hosted with ❤ by GitHub

	import os
	import sys

	from asposecellscloud.apis.cells_api import CellsApi
	from asposecellscloud.models import *
	from asposecellscloud.requests import *

	api = CellsApi(os.getenv('CellsCloudClientId'),os.getenv('CellsCloudClientSecret'),"v3.0",os.getenv('CellsCloudApiBaseUrl'))
	request = PostHideWorksheetRowsRequest( 'Book1.xlsx', 'Sheet1', 1, 6,folder= 'PythonTest',storage_name= '')
	api.post_hide_worksheet_rows(request)

view raw Example_PostHideWorksheetRows.py hosted with ❤ by GitHub

	import os
	import sys

	from asposecellscloud.apis.cells_api import CellsApi
	from asposecellscloud.models import *
	from asposecellscloud.requests import *

	api = CellsApi(os.getenv('CellsCloudClientId'),os.getenv('CellsCloudClientSecret'),"v3.0",os.getenv('CellsCloudApiBaseUrl'))
	importOption = ImportIntArrayOption(destination_worksheet= 'Sheet1' ,first_column= 1 ,first_row= 3 ,import_data_type= 'IntArray' ,is_insert= True ,is_vertical= True ,data= [1,2,3,4] )
	request = PostImportDataRequest( 'Book1.xlsx',import_option= importOption,folder= 'PythonTest',storage_name= '')
	api.post_import_data(request)

view raw Example_PostImportData.py hosted with ❤ by GitHub

	import os
	import sys

	from asposecellscloud.apis.cells_api import CellsApi
	from asposecellscloud.models import *
	from asposecellscloud.requests import *

	api = CellsApi(os.getenv('CellsCloudClientId'),os.getenv('CellsCloudClientSecret'),"v3.0",os.getenv('CellsCloudApiBaseUrl'))
	request = PostMergeRequest( {'assemblytest.xlsx':'assemblytest.xlsx','assemblytest1.xlsx':'assemblytest.xlsx'},out_format= 'pdf',merge_to_one_sheet= True)
	api.post_merge(request)

view raw Example_PostMerge.py hosted with ❤ by GitHub

	import os
	import sys

	from asposecellscloud.apis.cells_api import CellsApi
	from asposecellscloud.models import *
	from asposecellscloud.requests import *

	api = CellsApi(os.getenv('CellsCloudClientId'),os.getenv('CellsCloudClientSecret'),"v3.0",os.getenv('CellsCloudApiBaseUrl'))
	cellsDocumentscellsDocument0 = CellsDocumentProperty(name= 'Author' ,value= 'roy.wang' )
	cellsDocuments = [ cellsDocumentscellsDocument0 ]
	request = PostMetadataRequest( {'assemblytest.xlsx':'assemblytest.xlsx'}, cellsDocuments)
	api.post_metadata(request)

view raw Example_PostMetadata.py hosted with ❤ by GitHub

	import os
	import sys

	from asposecellscloud.apis.cells_api import CellsApi
	from asposecellscloud.models import *
	from asposecellscloud.requests import *

	api = CellsApi(os.getenv('CellsCloudClientId'),os.getenv('CellsCloudClientSecret'),"v3.0",os.getenv('CellsCloudApiBaseUrl'))
	moving = WorksheetMovingRequest(destination_worksheet= 'Sheet4' ,position= 'After' )
	request = PostMoveWorksheetRequest( 'Book1.xlsx', 'Sheet1', moving,folder= 'PythonTest',storage_name= '')
	api.post_move_worksheet(request)

view raw Example_PostMoveWorksheet.py hosted with ❤ by GitHub

	import os
	import sys

	from asposecellscloud.apis.cells_api import CellsApi
	from asposecellscloud.models import *
	from asposecellscloud.requests import *

	api = CellsApi(os.getenv('CellsCloudClientId'),os.getenv('CellsCloudClientSecret'),"v3.0",os.getenv('CellsCloudApiBaseUrl'))
	pageSetup = PageSetup(black_and_white= True ,center_horizontally= True ,center_vertically= True )
	request = PostPageSetupRequest( 'Book1.xlsx', 'Sheet1', pageSetup,folder= 'PythonTest',storage_name= '')
	api.post_page_setup(request)

view raw Example_PostPageSetup.py hosted with ❤ by GitHub

	import os
	import sys

	from asposecellscloud.apis.cells_api import CellsApi
	from asposecellscloud.models import *
	from asposecellscloud.requests import *

	api = CellsApi(os.getenv('CellsCloudClientId'),os.getenv('CellsCloudClientSecret'),"v3.0",os.getenv('CellsCloudApiBaseUrl'))
	styleFont = Font(size=16)
	style = Style(font=styleFont)
	request = PostPivotTableCellStyleRequest( 'TestCase.xlsx', 'Sheet4', 0, 1, 1, style,need_re_calculate= True,folder= 'PythonTest',storage_name= '')
	api.post_pivot_table_cell_style(request)

view raw Example_PostPivotTableCellStyle.py hosted with ❤ by GitHub

	import os
	import sys

	from asposecellscloud.apis.cells_api import CellsApi
	from asposecellscloud.models import *
	from asposecellscloud.requests import *

	api = CellsApi(os.getenv('CellsCloudClientId'),os.getenv('CellsCloudClientSecret'),"v3.0",os.getenv('CellsCloudApiBaseUrl'))
	request = PostPivotTableFieldHideItemRequest( 'Book1.xlsx', 'Sheet4', 0, 'Row', 0, 1, True,need_re_calculate= True,folder= 'PythonTest',storage_name= '')
	api.post_pivot_table_field_hide_item(request)

view raw Example_PostPivotTableFieldHideItem.py hosted with ❤ by GitHub

	import os
	import sys

	from asposecellscloud.apis.cells_api import CellsApi
	from asposecellscloud.models import *
	from asposecellscloud.requests import *

	api = CellsApi(os.getenv('CellsCloudClientId'),os.getenv('CellsCloudClientSecret'),"v3.0",os.getenv('CellsCloudApiBaseUrl'))
	request = PostPivotTableFieldMoveToRequest( 'TestCase.xlsx', 'Sheet4', 0, 0, 'Row', 'Column',folder= 'PythonTest',storage_name= '')
	api.post_pivot_table_field_move_to(request)

view raw Example_PostPivotTableFieldMoveTo.py hosted with ❤ by GitHub

	import os
	import sys

	from asposecellscloud.apis.cells_api import CellsApi
	from asposecellscloud.models import *
	from asposecellscloud.requests import *

	api = CellsApi(os.getenv('CellsCloudClientId'),os.getenv('CellsCloudClientSecret'),"v3.0",os.getenv('CellsCloudApiBaseUrl'))
	styleFont = Font(size=16)
	style = Style(font=styleFont)
	request = PostPivotTableStyleRequest( 'TestCase.xlsx', 'Sheet4', 0, style,need_re_calculate= True,folder= 'PythonTest',storage_name= '')
	api.post_pivot_table_style(request)

view raw Example_PostPivotTableStyle.py hosted with ❤ by GitHub

	import os
	import sys

	from asposecellscloud.apis.cells_api import CellsApi
	from asposecellscloud.models import *
	from asposecellscloud.requests import *

	api = CellsApi(os.getenv('CellsCloudClientId'),os.getenv('CellsCloudClientSecret'),"v3.0",os.getenv('CellsCloudApiBaseUrl'))
	pivotField = PivotField(show_compact= True )
	request = PostPivotTableUpdatePivotFieldRequest( 'TestCase.xlsx', 'Sheet4', 0, 0, 'Row', pivotField,need_re_calculate= True,folder= 'PythonTest',storage_name= '')
	api.post_pivot_table_update_pivot_field(request)

view raw Example_PostPivotTableUpdatePivotField.py hosted with ❤ by GitHub

	import os
	import sys

	from asposecellscloud.apis.cells_api import CellsApi
	from asposecellscloud.models import *
	from asposecellscloud.requests import *

	api = CellsApi(os.getenv('CellsCloudClientId'),os.getenv('CellsCloudClientSecret'),"v3.0",os.getenv('CellsCloudApiBaseUrl'))
	pivotField = PivotField(show_compact= True )
	request = PostPivotTableUpdatePivotFieldsRequest( 'TestCase.xlsx', 'Sheet4', 0, 'Row', pivotField,need_re_calculate= True,folder= 'PythonTest',storage_name= '')
	api.post_pivot_table_update_pivot_fields(request)

view raw Example_PostPivotTableUpdatePivotFields.py hosted with ❤ by GitHub

	import os
	import sys

	from asposecellscloud.apis.cells_api import CellsApi
	from asposecellscloud.models import *
	from asposecellscloud.requests import *

	api = CellsApi(os.getenv('CellsCloudClientId'),os.getenv('CellsCloudClientSecret'),"v3.0",os.getenv('CellsCloudApiBaseUrl'))
	request = PostProtectRequest( {'assemblytest.xlsx':'assemblytest.xlsx'}, protectWorkbookRequest,password= '123456')
	api.post_protect(request)

view raw Example_PostProtect.py hosted with ❤ by GitHub

	import os
	import sys

	from asposecellscloud.apis.cells_api import CellsApi
	from asposecellscloud.models import *
	from asposecellscloud.requests import *

	api = CellsApi(os.getenv('CellsCloudClientId'),os.getenv('CellsCloudClientSecret'),"v3.0",os.getenv('CellsCloudApiBaseUrl'))
	protectWorkbookRequest = ProtectWorkbookRequest(encrypt_with_password= '123456' ,protect_workbook_structure= 'ALL' )
	request = PostProtectWorkbookRequest( 'Book1.xlsx', protectWorkbookRequest,folder= 'PythonTest',storage_name= '')
	api.post_protect_workbook(request)

view raw Example_PostProtectWorkbook.py hosted with ❤ by GitHub

	import os
	import sys

	from asposecellscloud.apis.cells_api import CellsApi
	from asposecellscloud.models import *
	from asposecellscloud.requests import *

	api = CellsApi(os.getenv('CellsCloudClientId'),os.getenv('CellsCloudClientSecret'),"v3.0",os.getenv('CellsCloudApiBaseUrl'))
	request = PostRenameWorksheetRequest( 'Book1.xlsx', 'Sheet5', 'Sheet55',folder= 'PythonTest',storage_name= '')
	api.post_rename_worksheet(request)

view raw Example_PostRenameWorksheet.py hosted with ❤ by GitHub

	import os
	import sys

	from asposecellscloud.apis.cells_api import CellsApi
	from asposecellscloud.models import *
	from asposecellscloud.requests import *

	api = CellsApi(os.getenv('CellsCloudClientId'),os.getenv('CellsCloudClientSecret'),"v3.0",os.getenv('CellsCloudApiBaseUrl'))
	request = PostRepairRequest( {'assemblytest.xlsx':'assemblytest.xlsx'},out_format= 'pdf')
	api.post_repair(request)

view raw Example_PostRepair.py hosted with ❤ by GitHub

	import os
	import sys

	from asposecellscloud.apis.cells_api import CellsApi
	from asposecellscloud.models import *
	from asposecellscloud.requests import *

	api = CellsApi(os.getenv('CellsCloudClientId'),os.getenv('CellsCloudClientSecret'),"v3.0",os.getenv('CellsCloudApiBaseUrl'))
	request = PostReplaceRequest( {'assemblytest.xlsx':'assemblytest.xlsx'}, '12', 'newtext')
	api.post_replace(request)

view raw Example_PostReplace.py hosted with ❤ by GitHub

	import os
	import sys

	from asposecellscloud.apis.cells_api import CellsApi
	from asposecellscloud.models import *
	from asposecellscloud.requests import *

	api = CellsApi(os.getenv('CellsCloudClientId'),os.getenv('CellsCloudClientSecret'),"v3.0",os.getenv('CellsCloudApiBaseUrl'))
	request = PostReverseRequest( {'assemblytest.xlsx':'assemblytest.xlsx'}, 'rows',out_format= 'pdf')
	api.post_reverse(request)

view raw Example_PostReverse.py hosted with ❤ by GitHub

	import os
	import sys

	from asposecellscloud.apis.cells_api import CellsApi
	from asposecellscloud.models import *
	from asposecellscloud.requests import *

	api = CellsApi(os.getenv('CellsCloudClientId'),os.getenv('CellsCloudClientSecret'),"v3.0",os.getenv('CellsCloudApiBaseUrl'))
	request = PostRowStyleRequest( 'Book1.xlsx', 'Sheet1', 1, Style(number=2),folder= 'PythonTest',storage_name= '')
	api.post_row_style(request)

view raw Example_PostRowStyle.py hosted with ❤ by GitHub

	import os
	import sys

	from asposecellscloud.apis.cells_api import CellsApi
	from asposecellscloud.models import *
	from asposecellscloud.requests import *

	api = CellsApi(os.getenv('CellsCloudClientId'),os.getenv('CellsCloudClientSecret'),"v3.0",os.getenv('CellsCloudApiBaseUrl'))
	request = PostSearchRequest( {'assemblytest.xlsx':'assemblytest.xlsx'}, '12')
	api.post_search(request)

view raw Example_PostSearch.py hosted with ❤ by GitHub

	import os
	import sys

	from asposecellscloud.apis.cells_api import CellsApi
	from asposecellscloud.models import *
	from asposecellscloud.requests import *

	api = CellsApi(os.getenv('CellsCloudClientId'),os.getenv('CellsCloudClientSecret'),"v3.0",os.getenv('CellsCloudApiBaseUrl'))
	request = PostSetCellHtmlStringRequest( 'Book1.xlsx', 'Sheet1', 'A1',folder= 'PythonTest',storage_name= '')
	api.post_set_cell_html_string(request)

view raw Example_PostSetCellHtmlString.py hosted with ❤ by GitHub

	import os
	import sys

	from asposecellscloud.apis.cells_api import CellsApi
	from asposecellscloud.models import *
	from asposecellscloud.requests import *

	api = CellsApi(os.getenv('CellsCloudClientId'),os.getenv('CellsCloudClientSecret'),"v3.0",os.getenv('CellsCloudApiBaseUrl'))
	request = PostSetCellRangeValueRequest( 'Book1.xlsx', 'Sheet1', 'A1:C10', 'Test', 'string',folder= 'PythonTest',storage_name= '')
	api.post_set_cell_range_value(request)

view raw Example_PostSetCellRangeValue.py hosted with ❤ by GitHub

	import os
	import sys

	from asposecellscloud.apis.cells_api import CellsApi
	from asposecellscloud.models import *
	from asposecellscloud.requests import *

	api = CellsApi(os.getenv('CellsCloudClientId'),os.getenv('CellsCloudClientSecret'),"v3.0",os.getenv('CellsCloudApiBaseUrl'))
	request = PostSetWorksheetColumnWidthRequest( 'Book1.xlsx', 'Sheet1', 1, 10.9,count= 10,folder= 'PythonTest',storage_name= '')
	api.post_set_worksheet_column_width(request)

view raw Example_PostSetWorksheetColumnWidth.py hosted with ❤ by GitHub

	import os
	import sys

	from asposecellscloud.apis.cells_api import CellsApi
	from asposecellscloud.models import *
	from asposecellscloud.requests import *

	api = CellsApi(os.getenv('CellsCloudClientId'),os.getenv('CellsCloudClientSecret'),"v3.0",os.getenv('CellsCloudApiBaseUrl'))
	request = PostSplitRequest( { 'assemblytest.xlsx': 'assemblytest.xlsx'}, 'pdf')
	api.post_split(request)

view raw Example_PostSplit.py hosted with ❤ by GitHub

	import os
	import sys

	from asposecellscloud.apis.cells_api import CellsApi
	from asposecellscloud.models import *
	from asposecellscloud.requests import *

	api = CellsApi(os.getenv('CellsCloudClientId'),os.getenv('CellsCloudClientSecret'),"v3.0",os.getenv('CellsCloudApiBaseUrl'))
	request = PostUngroupWorksheetColumnsRequest( 'Book1.xlsx', 'Sheet1', 1, 9,folder= 'PythonTest',storage_name= '')
	api.post_ungroup_worksheet_columns(request)

view raw Example_PostUngroupWorksheetColumns.py hosted with ❤ by GitHub

	import os
	import sys

	from asposecellscloud.apis.cells_api import CellsApi
	from asposecellscloud.models import *
	from asposecellscloud.requests import *

	api = CellsApi(os.getenv('CellsCloudClientId'),os.getenv('CellsCloudClientSecret'),"v3.0",os.getenv('CellsCloudApiBaseUrl'))
	request = PostUngroupWorksheetRowsRequest( 'Book1.xlsx', 'Sheet1', 1, 9,is_all= True,folder= 'PythonTest',storage_name= '')
	api.post_ungroup_worksheet_rows(request)

view raw Example_PostUngroupWorksheetRows.py hosted with ❤ by GitHub

	import os
	import sys

	from asposecellscloud.apis.cells_api import CellsApi
	from asposecellscloud.models import *
	from asposecellscloud.requests import *

	api = CellsApi(os.getenv('CellsCloudClientId'),os.getenv('CellsCloudClientSecret'),"v3.0",os.getenv('CellsCloudApiBaseUrl'))
	request = PostUnhideWorksheetColumnsRequest( 'Book1.xlsx', 'Sheet1', 1, 10,width= 10.9,folder= 'PythonTest',storage_name= '')
	api.post_unhide_worksheet_columns(request)

view raw Example_PostUnhideWorksheetColumns.py hosted with ❤ by GitHub

	import os
	import sys

	from asposecellscloud.apis.cells_api import CellsApi
	from asposecellscloud.models import *
	from asposecellscloud.requests import *

	api = CellsApi(os.getenv('CellsCloudClientId'),os.getenv('CellsCloudClientSecret'),"v3.0",os.getenv('CellsCloudApiBaseUrl'))
	request = PostUnhideWorksheetRowsRequest( 'Book1.xlsx', 'Sheet1', 1, 8,height= 10.9,folder= 'PythonTest',storage_name= '')
	api.post_unhide_worksheet_rows(request)

view raw Example_PostUnhideWorksheetRows.py hosted with ❤ by GitHub

	import os
	import sys

	from asposecellscloud.apis.cells_api import CellsApi
	from asposecellscloud.models import *
	from asposecellscloud.requests import *

	api = CellsApi(os.getenv('CellsCloudClientId'),os.getenv('CellsCloudClientSecret'),"v3.0",os.getenv('CellsCloudApiBaseUrl'))
	request = PostUnlockRequest( {'needUnlock.xlsx':'needUnlock.xlsx'}, '123456')
	api.post_unlock(request)

view raw Example_PostUnlock.py hosted with ❤ by GitHub

	import os
	import sys

	from asposecellscloud.apis.cells_api import CellsApi
	from asposecellscloud.models import *
	from asposecellscloud.requests import *

	api = CellsApi(os.getenv('CellsCloudClientId'),os.getenv('CellsCloudClientSecret'),"v3.0",os.getenv('CellsCloudApiBaseUrl'))
	styleFont = Font(size= 16 )
	style = Style(font= styleFont )
	request = PostUpdateWorksheetCellStyleRequest( 'Book1.xlsx', 'Sheet1', 'A1', style,folder= 'PythonTest',storage_name= '')
	api.post_update_worksheet_cell_style(request)

view raw Example_PostUpdateWorksheetCellStyle.py hosted with ❤ by GitHub

	import os
	import sys

	from asposecellscloud.apis.cells_api import CellsApi
	from asposecellscloud.models import *
	from asposecellscloud.requests import *

	api = CellsApi(os.getenv('CellsCloudClientId'),os.getenv('CellsCloudClientSecret'),"v3.0",os.getenv('CellsCloudApiBaseUrl'))
	ole = OleObject(left= 10 ,right= 10 ,height= 90 ,width= 78 )
	request = PostUpdateWorksheetOleObjectRequest( 'Book1.xlsx', 'Sheet6', 0, ole,folder= 'PythonTest',storage_name= '')
	api.post_update_worksheet_ole_object(request)

view raw Example_PostUpdateWorksheetOleObject.py hosted with ❤ by GitHub

	import os
	import sys

	from asposecellscloud.apis.cells_api import CellsApi
	from asposecellscloud.models import *
	from asposecellscloud.requests import *

	api = CellsApi(os.getenv('CellsCloudClientId'),os.getenv('CellsCloudClientSecret'),"v3.0",os.getenv('CellsCloudApiBaseUrl'))
	request = PostUpdateWorksheetPropertyRequest( 'Book1.xlsx', 'Sheet5', sheet,folder= 'PythonTest',storage_name= '')
	api.post_update_worksheet_property(request)

view raw Example_PostUpdateWorksheetProperty.py hosted with ❤ by GitHub

	import os
	import sys

	from asposecellscloud.apis.cells_api import CellsApi
	from asposecellscloud.models import *
	from asposecellscloud.requests import *

	api = CellsApi(os.getenv('CellsCloudClientId'),os.getenv('CellsCloudClientSecret'),"v3.0",os.getenv('CellsCloudApiBaseUrl'))
	request = PostUpdateWorksheetRangeStyleRequest( 'Book1.xlsx', 'Sheet1', 'A1:C10', style,folder= 'PythonTest',storage_name= '')
	api.post_update_worksheet_range_style(request)

view raw Example_PostUpdateWorksheetRangeStyle.py hosted with ❤ by GitHub

	import os
	import sys

	from asposecellscloud.apis.cells_api import CellsApi
	from asposecellscloud.models import *
	from asposecellscloud.requests import *

	api = CellsApi(os.getenv('CellsCloudClientId'),os.getenv('CellsCloudClientSecret'),"v3.0",os.getenv('CellsCloudApiBaseUrl'))
	request = PostUpdateWorksheetRowRequest( 'Book1.xlsx', 'Sheet1', 1,height= 10.8,count= 9,folder= 'PythonTest',storage_name= '')
	api.post_update_worksheet_row(request)

view raw Example_PostUpdateWorksheetRow.py hosted with ❤ by GitHub

	import os
	import sys

	from asposecellscloud.apis.cells_api import CellsApi
	from asposecellscloud.models import *
	from asposecellscloud.requests import *

	api = CellsApi(os.getenv('CellsCloudClientId'),os.getenv('CellsCloudClientSecret'),"v3.0",os.getenv('CellsCloudApiBaseUrl'))
	request = PostUpdateWorksheetZoomRequest( 'Book1.xlsx', 'Sheet1', 90,folder= 'PythonTest',storage_name= '')
	api.post_update_worksheet_zoom(request)

view raw Example_PostUpdateWorksheetZoom.py hosted with ❤ by GitHub

	import os
	import sys

	from asposecellscloud.apis.cells_api import CellsApi
	from asposecellscloud.models import *
	from asposecellscloud.requests import *

	api = CellsApi(os.getenv('CellsCloudClientId'),os.getenv('CellsCloudClientSecret'),"v3.0",os.getenv('CellsCloudApiBaseUrl'))
	request = PostWatermarkRequest( { 'assemblytest.xlsx': 'assemblytest.xlsx'}, 'aspose.cells cloud sdk', '#773322')
	api.post_watermark(request)

view raw Example_PostWatermark.py hosted with ❤ by GitHub

	import os
	import sys

	from asposecellscloud.apis.cells_api import CellsApi
	from asposecellscloud.models import *
	from asposecellscloud.requests import *

	api = CellsApi(os.getenv('CellsCloudClientId'),os.getenv('CellsCloudClientSecret'),"v3.0",os.getenv('CellsCloudApiBaseUrl'))
	options = CalculationOptions(ignore_error= True ,recursive= True )
	request = PostWorkbookCalculateFormulaRequest( 'Book1.xlsx',options= options,ignore_error= True,folder= 'PythonTest',storage_name= '')
	api.post_workbook_calculate_formula(request)

view raw Example_PostWorkbookCalculateFormula.py hosted with ❤ by GitHub

	import os
	import sys

	from asposecellscloud.apis.cells_api import CellsApi
	from asposecellscloud.models import *
	from asposecellscloud.requests import *

	api = CellsApi(os.getenv('CellsCloudClientId'),os.getenv('CellsCloudClientSecret'),"v3.0",os.getenv('CellsCloudApiBaseUrl'))
	dataCleansingDataFillDataFillDefaultValue = DataFillValue(default_date= '2024-01-01' ,default_number= 0 ,default_boolean= False )
	dataCleansingDataFill = DataFill(data_fill_default_value= dataCleansingDataFillDataFillDefaultValue )
	dataCleansing = DataCleansing(need_fill_data= True ,data_fill= dataCleansingDataFill )
	request = PostWorkbookDataCleansingRequest( 'Book1.xlsx', dataCleansing,folder= 'PythonTest',storage_name= '')
	api.post_workbook_data_cleansing(request)

view raw Example_PostWorkbookDataCleansing.py hosted with ❤ by GitHub

	import os
	import sys

	from asposecellscloud.apis.cells_api import CellsApi
	from asposecellscloud.models import *
	from asposecellscloud.requests import *

	api = CellsApi(os.getenv('CellsCloudClientId'),os.getenv('CellsCloudClientSecret'),"v3.0",os.getenv('CellsCloudApiBaseUrl'))
	request = PostWorkbookDataDeduplicationRequest( 'Book1.xlsx', deduplicationRegion,folder= 'PythonTest',storage_name= '')
	api.post_workbook_data_deduplication(request)

view raw Example_PostWorkbookDataDeduplication.py hosted with ❤ by GitHub

	import os
	import sys

	from asposecellscloud.apis.cells_api import CellsApi
	from asposecellscloud.models import *
	from asposecellscloud.requests import *

	api = CellsApi(os.getenv('CellsCloudClientId'),os.getenv('CellsCloudClientSecret'),"v3.0",os.getenv('CellsCloudApiBaseUrl'))
	dataFillDataFillDefaultValue = DataFillValue(default_date= '2024-01-01' ,default_number= 0 ,default_boolean= False )
	dataFill = DataFill(data_fill_default_value= dataFillDataFillDefaultValue )
	request = PostWorkbookDataFillRequest( 'Book1.xlsx', dataFill,folder= 'PythonTest',storage_name= '')
	api.post_workbook_data_fill(request)

view raw Example_PostWorkbookDataFill.py hosted with ❤ by GitHub

	import os
	import sys

	from asposecellscloud.apis.cells_api import CellsApi
	from asposecellscloud.models import *
	from asposecellscloud.requests import *

	api = CellsApi(os.getenv('CellsCloudClientId'),os.getenv('CellsCloudClientSecret'),"v3.0",os.getenv('CellsCloudApiBaseUrl'))
	request = PostWorkbookExportXMLRequest( 'Book1.xlsx',folder= 'PythonTest',storage_name= '')
	api.post_workbook_export_xml(request)

view raw Example_PostWorkbookExportXML.py hosted with ❤ by GitHub

	import os
	import sys

	from asposecellscloud.apis.cells_api import CellsApi
	from asposecellscloud.models import *
	from asposecellscloud.requests import *

	api = CellsApi(os.getenv('CellsCloudClientId'),os.getenv('CellsCloudClientSecret'),"v3.0",os.getenv('CellsCloudApiBaseUrl'))
	request = PostWorkbookGetSmartMarkerResultRequest( 'Book1.xlsx',xml_file= 'PythonTest' + '/ReportData.xml',folder= 'PythonTest',out_path= 'OutResult/SmartMarkerResult.xlsx',storage_name= '',out_storage_name= '')
	api.post_workbook_get_smart_marker_result(request)

view raw Example_PostWorkbookGetSmartMarkerResult.py hosted with ❤ by GitHub

	import os
	import sys

	from asposecellscloud.apis.cells_api import CellsApi
	from asposecellscloud.models import *
	from asposecellscloud.requests import *

	api = CellsApi(os.getenv('CellsCloudClientId'),os.getenv('CellsCloudClientSecret'),"v3.0",os.getenv('CellsCloudApiBaseUrl'))
	importXMLRequestXMLFileSource = FileSource(file_source_type= 'CloudFileSystem' ,file_path= 'PythonTest' + '/data.xml' )
	importXMLRequestImportPosition = ImportPosition(sheet_name= 'Sheet1' ,row_index= 3 ,column_index= 4 )
	importXMLRequest = ImportXMLRequest(xml_file_source= importXMLRequestXMLFileSource ,import_position= importXMLRequestImportPosition )
	request = PostWorkbookImportXMLRequest( 'Book1.xlsx', importXMLRequest,folder= 'PythonTest',storage_name= '')
	api.post_workbook_import_xml(request)

view raw Example_PostWorkbookImportXML.py hosted with ❤ by GitHub

	import os
	import sys

	from asposecellscloud.apis.cells_api import CellsApi
	from asposecellscloud.models import *
	from asposecellscloud.requests import *

	api = CellsApi(os.getenv('CellsCloudClientId'),os.getenv('CellsCloudClientSecret'),"v3.0",os.getenv('CellsCloudApiBaseUrl'))
	newName = Name(text= 'name_1804' ,comment= 'KeepSourceFormatting' ,refers_to= '=Sheet1!$I$4' )
	request = PostWorkbookNameRequest( 'Book1.xlsx', 'Name_2', newName,folder= 'PythonTest',storage_name= '')
	api.post_workbook_name(request)

view raw Example_PostWorkbookName.py hosted with ❤ by GitHub

	import os
	import sys

	from asposecellscloud.apis.cells_api import CellsApi
	from asposecellscloud.models import *
	from asposecellscloud.requests import *

	api = CellsApi(os.getenv('CellsCloudClientId'),os.getenv('CellsCloudClientSecret'),"v3.0",os.getenv('CellsCloudApiBaseUrl'))
	request = PostWorkbookSaveAsRequest( 'Book1.xlsx', "Book1.pdf",save_options= None,folder= 'PythonTest')
	api.post_workbook_save_as(request)

view raw Example_PostWorkbookSaveAs.py hosted with ❤ by GitHub

	import os
	import sys

	from asposecellscloud.apis.cells_api import CellsApi
	from asposecellscloud.models import *
	from asposecellscloud.requests import *

	api = CellsApi(os.getenv('CellsCloudClientId'),os.getenv('CellsCloudClientSecret'),"v3.0",os.getenv('CellsCloudApiBaseUrl'))
	settings = WorkbookSettings(auto_compress_pictures= True ,hide_pivot_field_list= True )
	request = PostWorkbookSettingsRequest( 'Book1.xlsx', settings,folder= 'PythonTest',storage_name= '')
	api.post_workbook_settings(request)

view raw Example_PostWorkbookSettings.py hosted with ❤ by GitHub

	import os
	import sys

	from asposecellscloud.apis.cells_api import CellsApi
	from asposecellscloud.models import *
	from asposecellscloud.requests import *

	api = CellsApi(os.getenv('CellsCloudClientId'),os.getenv('CellsCloudClientSecret'),"v3.0",os.getenv('CellsCloudApiBaseUrl'))
	request = PostWorkbooksMergeRequest( 'Book1.xlsx', 'myDocument.xlsx',folder= 'PythonTest',storage_name= '',merged_storage_name= '')
	api.post_workbooks_merge(request)

view raw Example_PostWorkbooksMerge.py hosted with ❤ by GitHub

	import os
	import sys

	from asposecellscloud.apis.cells_api import CellsApi
	from asposecellscloud.models import *
	from asposecellscloud.requests import *

	api = CellsApi(os.getenv('CellsCloudClientId'),os.getenv('CellsCloudClientSecret'),"v3.0",os.getenv('CellsCloudApiBaseUrl'))
	request = PostWorkbookSplitRequest( 'Book1.xlsx',format= 'png',out_folder= 'OutResult',_from= 1,to= 5,horizontal_resolution= 96,vertical_resolution= 96,split_name_rule= 'sheetname',folder= 'PythonTest',storage_name= '',out_storage_name= '')
	api.post_workbook_split(request)

view raw Example_PostWorkbookSplit.py hosted with ❤ by GitHub

	import os
	import sys

	from asposecellscloud.apis.cells_api import CellsApi
	from asposecellscloud.models import *
	from asposecellscloud.requests import *

	api = CellsApi(os.getenv('CellsCloudClientId'),os.getenv('CellsCloudClientSecret'),"v3.0",os.getenv('CellsCloudApiBaseUrl'))
	request = PostWorkbooksTextSearchRequest( 'Book1.xlsx', '1234',folder= 'PythonTest',storage_name= '')
	api.post_workbooks_text_search(request)

view raw Example_PostWorkbooksTextSearch.py hosted with ❤ by GitHub

	import os
	import sys

	from asposecellscloud.apis.cells_api import CellsApi
	from asposecellscloud.models import *
	from asposecellscloud.requests import *

	api = CellsApi(os.getenv('CellsCloudClientId'),os.getenv('CellsCloudClientSecret'),"v3.0",os.getenv('CellsCloudApiBaseUrl'))
	request = PostWorkbookTextReplaceRequest( 'Book1.xlsx', '1234', '5678',folder= 'PythonTest',storage_name= '')
	api.post_workbook_text_replace(request)

view raw Example_PostWorkbookTextReplace.py hosted with ❤ by GitHub

	import os
	import sys

	from asposecellscloud.apis.cells_api import CellsApi
	from asposecellscloud.models import *
	from asposecellscloud.requests import *

	api = CellsApi(os.getenv('CellsCloudClientId'),os.getenv('CellsCloudClientSecret'),"v3.0",os.getenv('CellsCloudApiBaseUrl'))
	request = PostWorksheetAutoFilterRefreshRequest( 'Book1.xlsx', 'Sheet1',folder= 'PythonTest',storage_name= '')
	api.post_worksheet_auto_filter_refresh(request)

view raw Example_PostWorksheetAutoFilterRefresh.py hosted with ❤ by GitHub

	import os
	import sys

	from asposecellscloud.apis.cells_api import CellsApi
	from asposecellscloud.models import *
	from asposecellscloud.requests import *

	api = CellsApi(os.getenv('CellsCloudClientId'),os.getenv('CellsCloudClientSecret'),"v3.0",os.getenv('CellsCloudApiBaseUrl'))
	request = PostWorksheetCalculateFormulaRequest( 'Book1.xlsx', 'Sheet1', '=NOW()',folder= 'PythonTest',storage_name= '')
	api.post_worksheet_calculate_formula(request)

view raw Example_PostWorksheetCalculateFormula.py hosted with ❤ by GitHub

	import os
	import sys

	from asposecellscloud.apis.cells_api import CellsApi
	from asposecellscloud.models import *
	from asposecellscloud.requests import *

	api = CellsApi(os.getenv('CellsCloudClientId'),os.getenv('CellsCloudClientSecret'),"v3.0",os.getenv('CellsCloudApiBaseUrl'))
	request = PostWorksheetCellSetValueRequest( 'Book1.xlsx', 'Sheet1', 'A1',value= '1',type= 'int',folder= 'PythonTest',storage_name= '')
	api.post_worksheet_cell_set_value(request)

view raw Example_PostWorksheetCellSetValue.py hosted with ❤ by GitHub

	import os
	import sys

	from asposecellscloud.apis.cells_api import CellsApi
	from asposecellscloud.models import *
	from asposecellscloud.requests import *

	api = CellsApi(os.getenv('CellsCloudClientId'),os.getenv('CellsCloudClientSecret'),"v3.0",os.getenv('CellsCloudApiBaseUrl'))
	range = Range(column_count= 1 ,column_width= 10.0 ,first_row= 1 ,row_count= 10 )
	request = PostWorksheetCellsRangeColumnWidthRequest( 'Book1.xlsx', 'Sheet1', range, 10.7,folder= 'PythonTest',storage_name= '')
	api.post_worksheet_cells_range_column_width(request)

view raw Example_PostWorksheetCellsRangeColumnWidth.py hosted with ❤ by GitHub

	import os
	import sys

	from asposecellscloud.apis.cells_api import CellsApi
	from asposecellscloud.models import *
	from asposecellscloud.requests import *

	api = CellsApi(os.getenv('CellsCloudClientId'),os.getenv('CellsCloudClientSecret'),"v3.0",os.getenv('CellsCloudApiBaseUrl'))
	range = Range(column_count= 1 ,column_width= 10.0 ,first_row= 1 ,row_count= 10 )
	request = PostWorksheetCellsRangeMergeRequest( 'Book1.xlsx', 'Sheet1', range,folder= 'PythonTest',storage_name= '')
	api.post_worksheet_cells_range_merge(request)

view raw Example_PostWorksheetCellsRangeMerge.py hosted with ❤ by GitHub

	import os
	import sys

	from asposecellscloud.apis.cells_api import CellsApi
	from asposecellscloud.models import *
	from asposecellscloud.requests import *

	api = CellsApi(os.getenv('CellsCloudClientId'),os.getenv('CellsCloudClientSecret'),"v3.0",os.getenv('CellsCloudApiBaseUrl'))
	range = Range(column_count= 1 ,column_width= 10.0 ,first_row= 1 ,row_count= 10 )
	request = PostWorksheetCellsRangeMoveToRequest( 'Book1.xlsx', 'Sheet1', range, 10, 10,folder= 'PythonTest',storage_name= '')
	api.post_worksheet_cells_range_move_to(request)

view raw Example_PostWorksheetCellsRangeMoveTo.py hosted with ❤ by GitHub

	import os
	import sys

	from asposecellscloud.apis.cells_api import CellsApi
	from asposecellscloud.models import *
	from asposecellscloud.requests import *

	api = CellsApi(os.getenv('CellsCloudClientId'),os.getenv('CellsCloudClientSecret'),"v3.0",os.getenv('CellsCloudApiBaseUrl'))
	rangeOperateborderColor = Color(r= 48 ,g= 48 ,b= 48 )
	rangeOperateRange = Range(column_count= 1 ,column_width= 10.0 ,first_row= 1 ,row_count= 10 )
	rangeOperate = RangeSetOutlineBorderRequest(border_edge= 'LeftBorder' ,border_style= 'Dotted' ,border_color= rangeOperateborderColor ,range= rangeOperateRange )
	request = PostWorksheetCellsRangeOutlineBorderRequest( 'Book1.xlsx', 'Sheet1', rangeOperate,folder= 'PythonTest',storage_name= '')
	api.post_worksheet_cells_range_outline_border(request)

view raw Example_PostWorksheetCellsRangeOutlineBorder.py hosted with ❤ by GitHub

	import os
	import sys

	from asposecellscloud.apis.cells_api import CellsApi
	from asposecellscloud.models import *
	from asposecellscloud.requests import *

	api = CellsApi(os.getenv('CellsCloudClientId'),os.getenv('CellsCloudClientSecret'),"v3.0",os.getenv('CellsCloudApiBaseUrl'))
	range = Range(column_count= 1 ,column_width= 10.0 ,first_row= 1 ,row_count= 10 )
	request = PostWorksheetCellsRangeRowHeightRequest( 'Book1.xlsx', 'Sheet1', range, 10.9,folder= 'PythonTest',storage_name= '')
	api.post_worksheet_cells_range_row_height(request)

view raw Example_PostWorksheetCellsRangeRowHeight.py hosted with ❤ by GitHub

	import os
	import sys

	from asposecellscloud.apis.cells_api import CellsApi
	from asposecellscloud.models import *
	from asposecellscloud.requests import *

	api = CellsApi(os.getenv('CellsCloudClientId'),os.getenv('CellsCloudClientSecret'),"v3.0",os.getenv('CellsCloudApiBaseUrl'))
	rangeOperateSource = Range(column_count= 1 ,column_width= 10.0 ,first_row= 1 ,row_count= 10 )
	rangeOperateTarget = Range(column_count= 1 ,column_width= 10.0 ,first_row= 10 ,row_count= 10 )
	rangeOperate = RangeCopyRequest(operate= 'copydata' ,source= rangeOperateSource ,target= rangeOperateTarget )
	request = PostWorksheetCellsRangesCopyRequest( 'Book1.xlsx', 'Sheet1', rangeOperate,folder= 'PythonTest',storage_name= '')
	api.post_worksheet_cells_ranges_copy(request)

view raw Example_PostWorksheetCellsRangesCopy.py hosted with ❤ by GitHub

	import os
	import sys

	from asposecellscloud.apis.cells_api import CellsApi
	from asposecellscloud.models import *
	from asposecellscloud.requests import *

	api = CellsApi(os.getenv('CellsCloudClientId'),os.getenv('CellsCloudClientSecret'),"v3.0",os.getenv('CellsCloudApiBaseUrl'))

	rangeOperateSource = Range(column_count= 3 ,first_column= 8 ,first_row= 3 ,row_count= 2 )
	rangeOperateTarget = Range(column_count= 3 ,first_column= 8 ,first_row= 13 ,row_count= 2 )
	rangeOperate = RangeCopyRequest(operate= 'copydata' ,source= rangeOperateSource ,target= rangeOperateTarget )
	postWorksheetCellsRangesCopyRequest = PostWorksheetCellsRangesCopyRequest( 'Book1.xlsx', 'Sheet1', rangeOperate, folder= 'PythonTest',storage_name= '')
	api.post_worksheet_cells_ranges_copy(postWorksheetCellsRangesCopyRequest)
	putActiveWorksheetRequest = PutActiveWorksheetRequest( 'Book1.xlsx' , 'Sheet4',folder= 'PythonTest',storage_name= '')
	api.put_active_worksheet(putActiveWorksheetRequest)

view raw Example_PostWorksheetCellsRangesCopyToOtherWorkbook.py hosted with ❤ by GitHub

	import os
	import sys

	from asposecellscloud.apis.cells_api import CellsApi
	from asposecellscloud.models import *
	from asposecellscloud.requests import *

	api = CellsApi(os.getenv('CellsCloudClientId'),os.getenv('CellsCloudClientSecret'),"v3.0",os.getenv('CellsCloudApiBaseUrl'))
	rangeSortRequestDataSorter = DataSorter(case_sensitive= True )
	rangeSortRequestCellArea = Range(column_count= 3 ,first_column= 0 ,first_row= 0 ,row_count= 15 )
	rangeSortRequest = RangeSortRequest(data_sorter= rangeSortRequestDataSorter ,cell_area= rangeSortRequestCellArea )
	request = PostWorksheetCellsRangeSortRequest( 'Book1.xlsx', 'book1', rangeSortRequest,folder= 'PythonTest',storage_name= '')
	api.post_worksheet_cells_range_sort(request)

view raw Example_PostWorksheetCellsRangeSort.py hosted with ❤ by GitHub

	import os
	import sys

	from asposecellscloud.apis.cells_api import CellsApi
	from asposecellscloud.models import *
	from asposecellscloud.requests import *

	api = CellsApi(os.getenv('CellsCloudClientId'),os.getenv('CellsCloudClientSecret'),"v3.0",os.getenv('CellsCloudApiBaseUrl'))
	rangeOperateStyleFont = Font(size= 16 )
	rangeOperateStyle = Style(font= rangeOperateStyleFont )
	rangeOperateRange = Range(column_count= 1 ,column_width= 10.0 ,first_row= 1 ,row_count= 10 )
	rangeOperate = RangeSetStyleRequest(style= rangeOperateStyle ,range= rangeOperateRange )
	request = PostWorksheetCellsRangeStyleRequest( 'Book1.xlsx', 'Sheet1', rangeOperate,folder= 'PythonTest',storage_name= '')
	api.post_worksheet_cells_range_style(request)

view raw Example_PostWorksheetCellsRangeStyle.py hosted with ❤ by GitHub

	import os
	import sys

	from asposecellscloud.apis.cells_api import CellsApi
	from asposecellscloud.models import *
	from asposecellscloud.requests import *

	api = CellsApi(os.getenv('CellsCloudClientId'),os.getenv('CellsCloudClientSecret'),"v3.0",os.getenv('CellsCloudApiBaseUrl'))
	image_or_print_options = ImageOrPrintOptions(one_page_per_sheet=True)
	page_setup = PageSetup(black_and_white=True, bottom_margin=0, left_margin=0, top_margin=0, right_margin=0,
	print_headings=False)
	range_operate_source = Range(column_count=28, first_column=1, first_row=1, row_count=42)

	range_convert = RangeConvertRequest(source=range_operate_source, image_or_print_options=image_or_print_options,
	page_setup=page_setup, image_type='Png')

	request = PostWorksheetCellsRangeToImageRequest('ExampleData.xlsx', 'Retention Analysis', range_convert, folder='PythonTest',
	storage_name='')

view raw Example_PostWorksheetCellsRangeToImage.py hosted with ❤ by GitHub

	import os
	import sys

	from asposecellscloud.apis.cells_api import CellsApi
	from asposecellscloud.models import *
	from asposecellscloud.requests import *

	api = CellsApi(os.getenv('CellsCloudClientId'),os.getenv('CellsCloudClientSecret'),"v3.0",os.getenv('CellsCloudApiBaseUrl'))
	range = Range(column_count= 1 ,column_width= 10.0 ,first_row= 1 ,row_count= 10 )
	request = PostWorksheetCellsRangeUnMergeRequest( 'Book1.xlsx', 'Sheet1', range,folder= 'PythonTest',storage_name= '')
	api.post_worksheet_cells_range_un_merge(request)

view raw Example_PostWorksheetCellsRangeUnMerge.py hosted with ❤ by GitHub

	import os
	import sys

	from asposecellscloud.apis.cells_api import CellsApi
	from asposecellscloud.models import *
	from asposecellscloud.requests import *

	api = CellsApi(os.getenv('CellsCloudClientId'),os.getenv('CellsCloudClientSecret'),"v3.0",os.getenv('CellsCloudApiBaseUrl'))
	range = Range(column_count= 1 ,column_width= 10.0 ,first_row= 1 ,row_count= 10 )
	request = PostWorksheetCellsRangeValueRequest( 'Book1.xlsx', 'Sheet1', range, '100',is_converted= True,set_style= True,folder= 'PythonTest',storage_name= '')
	api.post_worksheet_cells_range_value(request)

view raw Example_PostWorksheetCellsRangeValue.py hosted with ❤ by GitHub

	import os
	import sys

	from asposecellscloud.apis.cells_api import CellsApi
	from asposecellscloud.models import *
	from asposecellscloud.requests import *

	api = CellsApi(os.getenv('CellsCloudClientId'),os.getenv('CellsCloudClientSecret'),"v3.0",os.getenv('CellsCloudApiBaseUrl'))
	chart = Chart(show_legend= True ,show_data_table= True )
	request = PostWorksheetChartRequest( 'Book1.xlsx', 'Sheet4', 0, chart,folder= 'PythonTest',storage_name= '')
	api.post_worksheet_chart(request)

view raw Example_PostWorksheetChart.py hosted with ❤ by GitHub

	import os
	import sys

	from asposecellscloud.apis.cells_api import CellsApi
	from asposecellscloud.models import *
	from asposecellscloud.requests import *

	api = CellsApi(os.getenv('CellsCloudClientId'),os.getenv('CellsCloudClientSecret'),"v3.0",os.getenv('CellsCloudApiBaseUrl'))
	legend = Legend(position= 'Top' )
	request = PostWorksheetChartLegendRequest( 'Book1.xlsx', 'Sheet4', 0, legend,folder= 'PythonTest',storage_name= '')
	api.post_worksheet_chart_legend(request)

view raw Example_PostWorksheetChartLegend.py hosted with ❤ by GitHub

	import os
	import sys

	from asposecellscloud.apis.cells_api import CellsApi
	from asposecellscloud.models import *
	from asposecellscloud.requests import *

	api = CellsApi(os.getenv('CellsCloudClientId'),os.getenv('CellsCloudClientSecret'),"v3.0",os.getenv('CellsCloudApiBaseUrl'))
	title = Title(is_visible= True )
	request = PostWorksheetChartTitleRequest( 'Book1.xlsx', 'Sheet4', 0, title,folder= 'PythonTest',storage_name= '')
	api.post_worksheet_chart_title(request)

view raw Example_PostWorksheetChartTitle.py hosted with ❤ by GitHub

	import os
	import sys

	from asposecellscloud.apis.cells_api import CellsApi
	from asposecellscloud.models import *
	from asposecellscloud.requests import *

	api = CellsApi(os.getenv('CellsCloudClientId'),os.getenv('CellsCloudClientSecret'),"v3.0",os.getenv('CellsCloudApiBaseUrl'))
	comment = Comment(author= 'aspose cells developer' ,note= 'aspose cells cloud api update comment.' )
	request = PostWorksheetCommentRequest( 'Book1.xlsx', 'Sheet1', 'B3', comment,folder= 'PythonTest',storage_name= '')
	api.post_worksheet_comment(request)

view raw Example_PostWorksheetComment.py hosted with ❤ by GitHub

	import os
	import sys

	from asposecellscloud.apis.cells_api import CellsApi
	from asposecellscloud.models import *
	from asposecellscloud.requests import *

	api = CellsApi(os.getenv('CellsCloudClientId'),os.getenv('CellsCloudClientSecret'),"v3.0",os.getenv('CellsCloudApiBaseUrl'))
	listShape = [
	0,
	1
	]
	request = PostWorksheetGroupShapeRequest( 'Book1.xlsx', 'Sheet6', listShape,folder= 'PythonTest',storage_name= '')
	api.post_worksheet_group_shape(request)

view raw Example_PostWorksheetGroupShape.py hosted with ❤ by GitHub

	import os
	import sys

	from asposecellscloud.apis.cells_api import CellsApi
	from asposecellscloud.models import *
	from asposecellscloud.requests import *

	api = CellsApi(os.getenv('CellsCloudClientId'),os.getenv('CellsCloudClientSecret'),"v3.0",os.getenv('CellsCloudApiBaseUrl'))
	hyperlink = Hyperlink(address= 'https://products.aspose.cloud/cells/' )
	request = PostWorksheetHyperlinkRequest( 'Book1.xlsx', 'Sheet1', 0, hyperlink,folder= 'PythonTest',storage_name= '')
	api.post_worksheet_hyperlink(request)

view raw Example_PostWorksheetHyperlink.py hosted with ❤ by GitHub

	import os
	import sys

	from asposecellscloud.apis.cells_api import CellsApi
	from asposecellscloud.models import *
	from asposecellscloud.requests import *

	api = CellsApi(os.getenv('CellsCloudClientId'),os.getenv('CellsCloudClientSecret'),"v3.0",os.getenv('CellsCloudApiBaseUrl'))
	listColumn = ListColumn(name= 'test cloumn' )
	request = PostWorksheetListColumnRequest( 'Book1.xlsx', 'Sheet7', 0, 0, listColumn,folder= 'PythonTest',storage_name= '')
	api.post_worksheet_list_column(request)

view raw Example_PostWorksheetListColumn.py hosted with ❤ by GitHub

	import os
	import sys

	from asposecellscloud.apis.cells_api import CellsApi
	from asposecellscloud.models import *
	from asposecellscloud.requests import *

	api = CellsApi(os.getenv('CellsCloudClientId'),os.getenv('CellsCloudClientSecret'),"v3.0",os.getenv('CellsCloudApiBaseUrl'))
	tableTotalRequeststableTotalRequest0 = TableTotalRequest(list_column_index= 1 ,totals_calculation= 'Average' )
	tableTotalRequests = [
	tableTotalRequeststableTotalRequest0
	]
	request = PostWorksheetListColumnsTotalRequest( 'Book1.xlsx', 'Sheet7', 0, tableTotalRequests,folder= 'PythonTest',storage_name= '')
	api.post_worksheet_list_columns_total(request)

view raw Example_PostWorksheetListColumnsTotal.py hosted with ❤ by GitHub

Защитить рабочую папку Сборка