#set input file data name
filedataname = "SampleMailMergeTemplateData.txt"
#upload file to aspose cloud storage
storageApi.PutCreate(Path=filename,
file=data_folder + filename,
storage=storage)
try:
#invoke Aspose.Words Cloud SDK API to execute mail merge and populate a word document from XML data
response = wordsApi.PostDocumentExecuteMailMerge(name=filename,
withRegions=False,
file=data_folder +
filedataname,
filename=destfilename,
storage=storage)
if response.Status == "OK":
print "mail merge template has been executed successfully"
#download updated document from storage server
response = storageApi.GetDownload(Path=destfilename, storage=storage)
outfilename = "c:/temp/" + destfilename
with open(outfilename, 'wb') as f:
for chunk in response.InputStream:
f.write(chunk)
except ApiException as ex:
print "ApiException:"
print "Code:" + str(ex.code)
print "Message:" + ex.message
api_client = asposecellscloud.ApiClient.ApiClient(apiKey, appSid, True)
cellsApi = CellsApi(api_client);
#set input file name
filename = "Sample_Test_Book.xls"
sheetName = "Sheet1"
cellName = "a12"
type = "int"
formula = "sum(a5:a10)"
#upload file to aspose cloud storage
storageApi.PutCreate(Path=filename, file=data_folder + filename)
try:
#invoke Aspose.Cells Cloud SDK API to set formula for a cell in a worksheet
response = cellsApi.PostWorksheetCellSetValue(name=filename, sheetName=sheetName, cellName=cellName, type=type, formula=formula)
if response.Status == "OK":
#download updated Workbook from storage server
response = storageApi.GetDownload(Path=filename)
outfilename = "c:/temp/" + filename
with open(outfilename, 'wb') as f:
for chunk in response.InputStream:
f.write(chunk)
except ApiException as ex:
print "ApiException:"
print "Code:" + str(ex.code)
print "Message:" + ex.message
apiKey, appSid, True)
storageApi = StorageApi(storage_apiClient)
#Instantiate Aspose Slides API SDK
api_client = asposeslidescloud.ApiClient.ApiClient(apiKey, appSid, True)
slidesApi = SlidesApi(api_client)
#set input file name
name = "sample-input.pptx"
storage = "AsposeDropboxStorage"
try:
#upload file to 3rd party cloud storage
response = storageApi.PutCreate(name, data_folder + name, storage=storage)
#invoke Aspose.Slides Cloud SDK API to delete all slides from a presentation
response = slidesApi.DeleteSlidesCleanSlidesList(name, storage=storage)
if response.Status == "OK":
#download presentation from 3rd party cloud storage
response = storageApi.GetDownload(Path=name, storage=storage)
outfilename = "c:/temp/" + name
with open(outfilename, 'wb') as f:
for chunk in response.InputStream:
f.write(chunk)
except ApiException as ex:
print "ApiException:"
print "Code:" + str(ex.code)
print "Message:" + ex.message
try:
#upload file to aspose cloud storage
response = storageApi.PutCreate(name, data_folder + name)
#invoke Aspose.Pdf Cloud SDK API to split all or specific pages of a PDF
response = pdfApi.PostSplitDocument(name,
format=format,
ffrom=ffrom,
to=to)
if response.Status == "OK":
splitDocs = response.Result.Documents
#download splitted pdf from storage
for splitDoc in splitDocs:
#splittedFileName = urlString.substring(urlString.lastIndexOf('/') + 1).split("\\?")[0].split("#")[0];
urlString = splitDoc.Href
splittedFileName = urlString.split('/')[-1]
response = storageApi.GetDownload(Path=splittedFileName)
outfilename = "c:/temp/" + splittedFileName
with open(outfilename, 'wb') as f:
for chunk in response.InputStream:
f.write(chunk)
except ApiException as ex:
print "ApiException:"
print "Code:" + str(ex.code)
print "Message:" + ex.message
class TestAsposeStorage(unittest.TestCase):
def setUp(self):
with open('setup.json') as json_file:
data = json.load(json_file)
self.apiClient = ApiClient(apiKey=str(data['app_key']),
appSid=str(data['app_sid']),
debug=True,
apiServer=str(data['product_uri']))
self.storageApi = StorageApi(self.apiClient)
self.output_path = str(data['output_location'])
def testGetListFiles(self):
try:
response = self.storageApi.PutCreateFolder('list_test_folder')
response = self.storageApi.PutCreate(
'list_test_folder/SampleWordDocument.docx',
'./data/SampleWordDocument.docx')
response = self.storageApi.PutCreate(
'list_test_folder/testfile.txt', './data/testfile.txt')
response = self.storageApi.PutCreateFolder(
'list_test_folder/sub_folder')
response = self.storageApi.GetListFiles(Path='list_test_folder')
self.assertEqual(len(response.Files), 3)
self.assertEqual(response.Status, 'OK')
except ApiException as ex:
print "Exception"
print "Code: " + str(ex.code)
print "Mesage: " + ex.message
raise ex
def testGetDiscUsage(self):
try:
response = self.storageApi.GetDiscUsage()
self.assertIsInstance(response,
DiscUsageResponse.DiscUsageResponse)
self.assertEqual(response.Status, 'OK')
except ApiException as ex:
print "Exception"
print "Code: " + str(ex.code)
print "Mesage: " + ex.message
raise ex
def testPutCreate(self):
try:
response = self.storageApi.PutCreate(
'SampleWordDocument.docx', './data/SampleWordDocument.docx')
self.assertIsInstance(response, ResponseMessage.ResponseMessage)
self.assertEqual(response.Status, 'OK')
except ApiException as ex:
print "Exception"
print "Code: " + str(ex.code)
print "Mesage: " + ex.message
raise ex
def testGetDownload(self):
try:
response = self.storageApi.GetDownload('SampleWordDocument.docx')
self.assertEqual(response.Status, 'OK')
with open("./output/" + 'SampleWordDocument.docx', 'wb') as f:
for chunk in response.InputStream:
f.write(chunk)
self.assertTrue(
True, os.path.exists("./output/" + 'SampleWordDocument.docx'))
except ApiException as ex:
print "Exception"
print "Code: " + str(ex.code)
print "Mesage: " + ex.message
raise ex
def testGetIsExist(self):
try:
response = self.storageApi.GetIsExist('testfile.txt')
self.assertIsInstance(response,
FileExistResponse.FileExistResponse)
self.assertEqual(response.Status, 'OK')
except ApiException as ex:
print "Exception"
print "Code: " + str(ex.code)
print "Mesage: " + ex.message
raise ex
def testPutCreateFolder(self):
try:
response = self.storageApi.PutCreateFolder('mytestfolder')
self.assertIsInstance(response, ResponseMessage.ResponseMessage)
self.assertEqual(response.Status, 'OK')
except ApiException as ex:
print "Exception"
print "Code: " + str(ex.code)
print "Mesage: " + ex.message
raise ex
def testPostMoveFile(self):
try:
response = self.storageApi.PutCreate('testfile.txt',
'./data/testfile.txt')
response = self.storageApi.PostMoveFile(
'testfile.txt', 'mytestfolder/testfile.txt')
self.assertIsInstance(response, MoveFileResponse.MoveFileResponse)
self.assertEqual(response.Status, 'OK')
except ApiException as ex:
print "Exception"
print "Code: " + str(ex.code)
print "Mesage: " + ex.message
raise ex
def testPostMoveFolder(self):
try:
response = self.storageApi.PostMoveFolder('mytestfolder',
'mytestfolder_new')
self.assertIsInstance(response,
MoveFolderResponse.MoveFolderResponse)
self.assertEqual(response.Status, 'OK')
except ApiException as ex:
print "Exception"
print "Code: " + str(ex.code)
print "Mesage: " + ex.message
raise ex
def testPutCopy(self):
try:
response = self.storageApi.PutCreate('testfile.txt',
'./data/testfile.txt')
response = self.storageApi.PutCopy('testfile.txt',
'new_testfile.txt',
'./data/testfile.txt')
self.assertIsInstance(response, ResponseMessage.ResponseMessage)
self.assertEqual(response.Status, 'OK')
except ApiException as ex:
print "Exception"
print "Code: " + str(ex.code)
print "Mesage: " + ex.message
raise ex
def testPutCopyFolder(self):
try:
response = self.storageApi.PutCreateFolder('mytestfolder')
response = self.storageApi.PutCopyFolder('mytestfolder',
'mytestfolder1')
self.assertIsInstance(response, ResponseMessage.ResponseMessage)
self.assertEqual(response.Status, 'OK')
except ApiException as ex:
print "Exception"
print "Code: " + str(ex.code)
print "Mesage: " + ex.message
raise ex
def testGetIsStorageExist(self):
try:
response = self.storageApi.GetIsStorageExist('Aspose123')
self.assertIsInstance(response,
StorageExistResponse.StorageExistResponse)
self.assertEqual(response.Status, 'OK')
except ApiException as ex:
print "Exception"
print "Code: " + str(ex.code)
print "Mesage: " + ex.message
raise ex
def testGetListFileVersions(self):
try:
response = self.storageApi.PutCreate('testfile.txt',
'./data/testfile.txt')
response = self.storageApi.GetListFileVersions('testfile.txt')
self.assertIsInstance(response,
FileVersionsResponse.FileVersionsResponse)
self.assertEqual(response.Status, 'OK')
except ApiException as ex:
print "Exception"
print "Code: " + str(ex.code)
print "Mesage: " + ex.message
raise ex
def testDeleteFolder(self):
try:
response = self.storageApi.DeleteFolder('mytestfolder')
self.assertIsInstance(response,
RemoveFolderResponse.RemoveFolderResponse)
self.assertEqual(response.Status, 'OK')
except ApiException as ex:
print "Exception"
print "Code: " + str(ex.code)
print "Mesage: " + ex.message
raise ex
def testDeleteFile(self):
try:
response = self.storageApi.DeleteFile('testfile.txt')
self.assertIsInstance(response,
RemoveFileResponse.RemoveFileResponse)
self.assertEqual(response.Status, 'OK')
except ApiException as ex:
print "Exception"
print "Code: " + str(ex.code)
print "Mesage: " + ex.message
raise ex
api_client = asposecellscloud.ApiClient.ApiClient(apiKey, appSid, True)
cellsApi = CellsApi(api_client);
#set input file name
filename = "Sample_Book1.xlsx"
mergeWith = "Sample_Book2.xls"
#upload file to aspose cloud storage
storageApi.PutCreate(Path=filename, file=data_folder + filename)
#upload mergeWith file to aspose cloud storage
storageApi.PutCreate(Path=mergeWith, file=data_folder + mergeWith)
try:
#invoke Aspose.Cells Cloud SDK API to merge multiple workbooks into a single workbook
response = cellsApi.PostWorkbooksMerge(name=filename, mergeWith=mergeWith)
if response.Status == "OK":
destFileName = response.Workbook.FileName
print "FileName " + destFileName
#download Workbook from storage server
response = storageApi.GetDownload(Path=destFileName)
outfilename = "c:/temp/" + destFileName
with open(outfilename, 'wb') as f:
for chunk in response.InputStream:
f.write(chunk)
except ApiException as ex:
print "ApiException:"
print "Code:" + str(ex.code)
print "Message:" + ex.message
dest_file_name = "AppendWordDocumentsExample-TestFile-Destination.doc"
#upload source file to aspose cloud storage
storageApi.PutCreate(source_file_name, data_folder + source_file_name)
#upload destination file to aspose cloud storage
storageApi.PutCreate(dest_file_name, data_folder + dest_file_name)
document_entry_1 = DocumentEntry.DocumentEntry()
document_entry_1.Href = source_file_name
document_entry_1.ImportFormatMode = "KeepSourceFormatting"
body = DocumentEntryList.DocumentEntryList()
body.DocumentEntries = [document_entry_1]
#invoke Aspose.Words Cloud SDK API to append word document
response = wordsApi.PostAppendDocument(dest_file_name, body)
if (response.Status == 'OK'):
print "Documents have been appended successfully"
#download appended document from storage server
response = storageApi.GetDownload(Path=dest_file_name)
outfilename = "c:/temp/" + dest_file_name
with open(outfilename, 'wb') as f:
for chunk in response.InputStream:
f.write(chunk)
except ApiException as ex:
print "ApiException:"
print "Code:" + str(ex.code)
print "Message:" + ex.message
