import os
import sys

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

CellsCloudClientId ='....'  # get from https://dashboard.aspose.cloud/#/applications
CellsCloudClientSecret='....'  # get from https://dashboard.aspose.cloud/#/applications
api  = CellsApi(CellsCloudClientId,CellsCloudClientSecret)

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)