Tamir Bu REST API, repair
Excel dosyalarını gösterir.
XLS, XLSX, XLSM, XLSB, ODS ve benzerlerini onarın.
Çoklu dosyaları destekleyin.
Aspose.Cells Bulut Excel Onarım, bozuk Excel dosyalarındaki verileri kurulum gerektirmeden çevrimiçi kurtarır. Bozuk Excel dosyaları, onları açamayacağınız için sorun olabilir. Bozuk Excel dosyalarındaki verileri kurtarmak için Aspose.Cells Bulut Excel Onarım Uygulamasını deneyebilirsiniz.
RSET API
Copy
POST https://api.aspose.cloud/v3.0/cells/repair
İstek parametreleri şunlardır:
Parametre adı
Tip
Yol/Sorgu Dizesi/HTTPBody
Tanım
dosya
dosya
form verisi
Yüklenecek dosya
biçim
sicim
sorgu
Çıkış formatı, Varsayılan değer boştur, çıkış formatı giriş dosyası formatına eşittir.
OpenAPI Spesifikasyonu herkese açık bir programlama arayüzü tanımlar ve REST etkileşimlerini doğrudan bir web tarayıcısından gerçekleştirmenize olanak tanır.
Aspose.Cells web servislerine kolayca erişmek için cURL komut satırı aracını kullanabilirsiniz. Aşağıdaki örnekte, cURL ile Cloud API’e nasıl çağrı yapılacağı gösterilmektedir.
Bulut SDK Ailesi
SDK kullanmak, geliştirmeyi hızlandırmanın en iyi yoludur. Bir SDK, düşük düzeyli ayrıntılarla ilgilenir ve proje görevlerinize odaklanmanıza olanak tanır. Lütfen şuraya göz atın:GitHub deposu Aspose.Cells Bulut SDK’larının tam listesi için.
Aşağıdaki kod örnekleri, çeşitli SDK’ları kullanarak Aspose.Cells web hizmetlerine nasıl çağrı yapılacağını gösterir:
C#
Java
PHP
Ruby
Node.js
Android
Perl
Go
Python
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
# 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)
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
# 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 )
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
# 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)
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
# 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)
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
# 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)
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
# 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)
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
# 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)
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
# 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)
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
# 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)
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
# 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)
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
# 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)
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
# 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')
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
# 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)
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
# 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 )
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
# 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)
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
# 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)
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
# 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)
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
# 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)
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
# 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)
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
# 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 )
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
# 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)
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
# 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)
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
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)
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
# 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)
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
# 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)
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
# 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)
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
# 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)
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
# 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)
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
# 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)
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
# 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 ) )
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
# 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)
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
# 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)
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
# 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)
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
# 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)
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
# 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)
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
# 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 )
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
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)
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
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)
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
# 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)
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
# 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)
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
# 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)
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
# 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)
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
# 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)
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
# 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)
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
# 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)
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
# 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)
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
# 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)
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
# 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)
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
# 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)
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
# 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)
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
# 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 )
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
# 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)
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
# 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)
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
# 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)
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
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)
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
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)
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
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)
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
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)
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
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)
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
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)
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
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)
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
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)
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
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)
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
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)
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
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)
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
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)
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
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)
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
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)
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
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)
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
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)
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
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 )
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
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)
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
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)
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
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)
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
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 )
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
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)
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
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)
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
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)
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
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)
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
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)
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
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)
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
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)
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
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)
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
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)
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
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)
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
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)
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
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)
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
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)
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
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)
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
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)
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
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)
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
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)
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
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)
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
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)
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
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)
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
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)
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
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)
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
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 )
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
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)
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
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)
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
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)
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
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)
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
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)
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
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)
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
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)
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
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)
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
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)
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
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)
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
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)
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
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)
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
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)
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
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 )
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
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)
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
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)
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
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)
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
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)
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
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)
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
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)
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
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)
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
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)
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
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)
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
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)
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
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)
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
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)
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
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)
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
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)
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
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)
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
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)
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
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)
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
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)
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
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)
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
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)
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
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 )
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
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)
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
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)
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
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)
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
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)
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
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 )
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
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)
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
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)
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
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)
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
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)
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
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)
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
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)
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
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)
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
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)
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
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)
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
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)
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
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)
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
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)
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
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)
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
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)
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
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 )
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
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)
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
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)
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
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)
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
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)
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
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)
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
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)
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
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)
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
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)
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
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 )
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
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)
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
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)
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
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)
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
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)
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
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)
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
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 )
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
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)
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
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)
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
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)
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
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)
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
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)
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
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)
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
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)
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
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 )
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
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)
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
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)
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
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)
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
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)
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
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)
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
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)
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
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)
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
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)
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
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)
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
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)
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
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)
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
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)
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
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)
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
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)
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
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)
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
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)
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
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)
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
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)
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
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)
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
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)
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
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)
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
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)
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
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)
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
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)
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
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)
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
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)
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
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)
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
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 )
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
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)
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
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)
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
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)
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
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)
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
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)
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
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)
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
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)
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
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)
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
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)
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
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)
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
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)
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
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)
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
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)
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
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)
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
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)
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
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)
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
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)
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
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)
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
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)
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
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 )
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
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)
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
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)
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
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)
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
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)
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
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)
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
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)
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
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)
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
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)
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
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)
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
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)
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
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 )
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
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)
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
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)
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
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)
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
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)
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
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)
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
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)
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
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)
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
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)
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
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)
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
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)
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
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)
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
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)
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
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)
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
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)
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
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)
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
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)
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
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)
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
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)
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
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)
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
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)
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
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)
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
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)
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
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)
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
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)
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
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)
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
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)
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
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='')
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
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)
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
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)
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
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)
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
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)
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
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)
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
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)
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
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)
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
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)
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
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)