static void Main() { string dataDir = Common.GetDataDir(System.Reflection.MethodBase.GetCurrentMethod().DeclaringType); string input = "sample1.xlsx"; string pic = "picture.png"; string output = "output.xlsx"; Common.StorageService.File.UploadFile(dataDir + input, input, storage: Common.STORAGE); Common.StorageService.File.UploadFile(dataDir + pic, pic, storage: Common.STORAGE); string sheetName = "Sheet1"; CellsPicturesResponse CellsPicturesResponse = Common.CellsService.Pictures.ReadWorksheetPictures(input, sheetName, Common.FOLDER, storage: Common.STORAGE); CellsPicture cellsPicture = new CellsPicture(); cellsPicture.AlternativeText = "Aspose"; cellsPicture.BorderLineColor = new Color(5, 5, 5, 5); cellsPicture.BorderWeight = 2; cellsPicture.Height = 100; cellsPicture.Width = 100; cellsPicture.SourceFullName = "picture.png"; Common.CellsService.Pictures.AddANewWorksheetPicture(input, sheetName, 1, 1, 5, 5, "picture.png", cellsPicture, Common.FOLDER, storage: Common.STORAGE); Common.StorageService.File.DownloadFile(input, dataDir + output, storage: Common.STORAGE); }
public void Cells_Pictures_Tests() { try { storageService.File.CopyFile(Utils.CloudStorage_Input_Folder + "/cells-sample.xlsx", Utils.CloudStorage_Output_Folder + "/cells-sample.xlsx"); CellsPicturesResponse CellsPicturesResponse = cellsService.Pictures.ReadWorksheetPictures(name, "sheet3", Utils.CloudStorage_Output_Folder); CellsPicture cellsPicture = new CellsPicture(); cellsPicture.AlternativeText = "Aspose"; cellsPicture.BorderLineColor = new Color(5, 5, 5, 5); cellsPicture.BorderWeight = 2; cellsPicture.Height = 100; cellsPicture.Width = 100; cellsPicture.SourceFullName = Utils.CloudStorage_Input_Folder + "/signature.jpg"; CellsPicturesResponse CellsPicturesResponse2 = cellsService.Pictures.AddANewWorksheetPicture(name, "sheet1", 1, 1, 5, 5, Utils.CloudStorage_Input_Folder + "/signature.jpg", cellsPicture, Utils.CloudStorage_Output_Folder); cellsService.Pictures.GetWorksheetPictureByNumber(name, "sheet3", 0, CellsPictureFormat.Png, Utils.Local_Output_Path + "cells-picture-out.png", Utils.CloudStorage_Output_Folder); CellsPicture cellsPicture2 = new CellsPicture(); cellsPicture2.BorderLineColor = new Color(5, 5, 5, 5); cellsPicture2.BorderWeight = 2; cellsPicture2.OriginalHeight = 100; cellsPicture2.OriginalWidth = 5; cellsPicture2.ImageFormat = "Png"; cellsPicture2.SourceFullName = Utils.CloudStorage_Input_Folder + "/signature.jpg"; cellsPicture2.Name = "Aspose"; cellsPicture2.MsoDrawingType = string.Empty; cellsPicture2.AutoShapeType = string.Empty; cellsPicture2.Placement = string.Empty; cellsPicture2.UpperLeftRow = 100; cellsPicture2.Top = 100; cellsPicture2.UpperLeftColumn = 100; cellsPicture2.Left = 100; cellsPicture2.LowerRightRow = 100; cellsPicture2.Bottom = 100; cellsPicture2.LowerRightColumn = 100; cellsPicture2.Right = 100; cellsPicture2.Width = 100; cellsPicture2.Height = 100; cellsPicture2.X = 100; cellsPicture2.Y = 100; cellsPicture2.RotationAngle = 190; cellsPicture2.HtmlText = string.Empty; cellsPicture2.Text = string.Empty; cellsPicture2.AlternativeText = string.Empty; cellsPicture2.TextHorizontalAlignment = string.Empty; cellsPicture2.TextHorizontalOverflow = string.Empty; cellsPicture2.TextOrientationType = string.Empty; cellsPicture2.TextVerticalAlignment = string.Empty; cellsPicture2.TextVerticalOverflow = string.Empty; cellsPicture2.IsGroup = false; cellsPicture2.IsHidden = false; cellsPicture2.IsLockAspectRatio = false; cellsPicture2.IsLocked = false; cellsPicture2.IsPrintable = false; cellsPicture2.IsTextWrapped = false; cellsPicture2.IsWordArt = false; cellsPicture2.LinkedCell = string.Empty; cellsPicture2.ZOrderPosition = 0; //cellsService.Pictures.UpdateWorksheetPictureByIndex(name, "sheet3", 0, Utils.CloudStorage_Output_Folder, cellsPicture2); cellsService.Pictures.DeleteAPictureObjectInWorksheet(name, "sheet3", 0, Utils.CloudStorage_Output_Folder); cellsService.Pictures.DeleteAllPicturesInWorksheet(name, "sheet3", Utils.CloudStorage_Output_Folder); storageService.File.DownloadFile(Utils.CloudStorage_Output_Folder + "/cells-sample.xlsx", Utils.Local_Output_Path + "/cells-sample.xlsx"); } catch (Exception ex) { Assert.Fail(ex.Message); } }
static void Main() { string dataDir = Common.GetDataDir(System.Reflection.MethodBase.GetCurrentMethod().DeclaringType); string input = "sample1.xlsx"; string output = "output.xlsx"; string pic = "picture.png"; Common.StorageService.File.UploadFile(dataDir + input, input, storage: Common.STORAGE); Common.StorageService.File.UploadFile(dataDir + pic, pic, storage: Common.STORAGE); string sheetName = "Sheet1"; CellsPicturesResponse CellsPicturesResponse = Common.CellsService.Pictures.ReadWorksheetPictures(input, sheetName, Common.FOLDER, storage: Common.STORAGE); CellsPicture cellsPicture2 = new CellsPicture(); cellsPicture2.BorderLineColor = new Color(5, 5, 5, 5); cellsPicture2.BorderWeight = 2; cellsPicture2.OriginalHeight = 100; cellsPicture2.OriginalWidth = 5; cellsPicture2.ImageFormat = "Png"; cellsPicture2.SourceFullName = pic; cellsPicture2.Name = "Aspose"; cellsPicture2.MsoDrawingType = string.Empty; cellsPicture2.AutoShapeType = string.Empty; cellsPicture2.Placement = string.Empty; cellsPicture2.UpperLeftRow = 100; cellsPicture2.Top = 100; cellsPicture2.UpperLeftColumn = 100; cellsPicture2.Left = 100; cellsPicture2.LowerRightRow = 100; cellsPicture2.Bottom = 100; cellsPicture2.LowerRightColumn = 100; cellsPicture2.Right = 100; cellsPicture2.Width = 100; cellsPicture2.Height = 100; cellsPicture2.X = 100; cellsPicture2.Y = 100; cellsPicture2.RotationAngle = 190; cellsPicture2.HtmlText = string.Empty; cellsPicture2.Text = string.Empty; cellsPicture2.AlternativeText = string.Empty; cellsPicture2.TextHorizontalAlignment = string.Empty; cellsPicture2.TextHorizontalOverflow = string.Empty; cellsPicture2.TextOrientationType = string.Empty; cellsPicture2.TextVerticalAlignment = string.Empty; cellsPicture2.TextVerticalOverflow = string.Empty; cellsPicture2.IsGroup = false; cellsPicture2.IsHidden = false; cellsPicture2.IsLockAspectRatio = false; cellsPicture2.IsLocked = false; cellsPicture2.IsPrintable = false; cellsPicture2.IsTextWrapped = false; cellsPicture2.IsWordArt = false; cellsPicture2.LinkedCell = string.Empty; cellsPicture2.ZOrderPosition = 0; Common.CellsService.Pictures.UpdateWorksheetPictureByIndex(input, sheetName, 0, Common.FOLDER, cellsPicture2, storage: Common.STORAGE); Common.StorageService.File.DownloadFile(input, dataDir + output, storage: Common.STORAGE); }