public static void Run() { // ExStart:1 CellsApi cellsApi = new CellsApi(Common.APP_KEY, Common.APP_SID, Common.BASEPATH); StorageApi storageApi = new StorageApi(Common.APP_KEY, Common.APP_SID, Common.BASEPATH); String fileName = "Sample_Book1.xlsx"; String propertyName = "Author"; String storage = ""; String folder = ""; try { // Upload source file to aspose cloud storage storageApi.PutCreate(fileName, "", "", System.IO.File.ReadAllBytes(Common.GetDataDir() + fileName)); // Invoke Aspose.Cells Cloud SDK API to get particular property CellsDocumentPropertyResponse apiResponse = cellsApi.GetDocumentProperty(fileName, propertyName, storage, folder); if (apiResponse != null && apiResponse.Status.Equals("OK")) { CellsDocumentProperty docProperty = apiResponse.DocumentProperty; Console.WriteLine("Name: " + docProperty.Name); Console.WriteLine("Value: " + docProperty.Value); Console.WriteLine("BuiltIn: " + docProperty.BuiltIn); Console.ReadKey(); } } catch (Exception ex) { System.Diagnostics.Debug.WriteLine("error:" + ex.Message + "\n" + ex.StackTrace); } // ExEnd:1 }
public void CellsPropertiesPutDocumentPropertyTest() { string name = "Book1.xlsx"; string propertyName = "Name"; CellsDocumentProperty property = new CellsDocumentProperty(); //(null, "Author", "Val" property.Name = "Author"; property.Value = "Val"; string folder = null; new Config().UpdateDataFile(folder, name); var response = instance.CellsPropertiesPutDocumentProperty(name, propertyName, property, folder); Console.WriteLine(response); }
public void CellsPropertiesPutDocumentPropertyTest() { // TODO uncomment below to test the method and replace null with proper value string name = BOOK1; string propertyName = "Name"; CellsDocumentProperty property = new CellsDocumentProperty(); //(null, "Author", "Val" property.Name = "Author"; property.Value = "Val"; string folder = TEMPFOLDER; UpdateDataFile(folder, name); var response = instance.CellsPropertiesPutDocumentProperty(name, propertyName, property, folder); Assert.IsInstanceOf <CellsDocumentPropertyResponse>(response, "response is CellsDocumentPropertyResponse"); Assert.AreEqual(response.Code, 201); }
public static void Run() { // ExStart:1 CellsApi cellsApi = new CellsApi(Common.APP_KEY, Common.APP_SID, Common.BASEPATH); StorageApi storageApi = new StorageApi(Common.APP_KEY, Common.APP_SID, Common.BASEPATH); // Set input file name String fileName = "Sample_Book1.xlsx"; String propertyName = "AsposeAuthor"; String storage = ""; String folder = ""; CellsDocumentProperty body = new CellsDocumentProperty(); body.Name = "AsposeAuthor"; body.Value = "Aspose Plugin Developer"; body.BuiltIn = "false"; try { // Upload source file to aspose cloud storage storageApi.PutCreate(fileName, "", "", System.IO.File.ReadAllBytes(Common.GetDataDir() + fileName)); // Invoke Aspose.Cells Cloud SDK API to set particular property CellsDocumentPropertyResponse apiResponse = cellsApi.PutDocumentProperty(fileName, propertyName, storage, folder, body); if (apiResponse != null) { Console.WriteLine("New values for the Property have been changed!"); Console.ReadKey(); } } catch (Exception ex) { System.Diagnostics.Debug.WriteLine("error:" + ex.Message + "\n" + ex.StackTrace); } // ExEnd:1 }