Hi, since we have a logo placed in the top right corner and Excel sheet columns width variates from export to export, sometimes the logo gets out of print area. Is there a way to place a free floating image by using position (cm/pixel) instead of using upper left row and upper left column?
thanks & regards
rale
Workbook wb = new Workbook();
wb.Worksheets.Clear();
Worksheet ws = wb.Worksheets.Add("New");
using (MemoryStream stream = new MemoryStream())
{
AsposeTest.Properties.Resources.Logo.Save(stream, ImageFormat.Jpeg);
int logopicture = ws.Pictures.Add(1, 10, stream);
Aspose.Cells.Picture picture = ws.Pictures[logopicture];
picture.HeightCM = 1.3;
picture.WidthCM = 6.94;
picture.WidthScale = 75;
picture.HeightScale = 75;
picture.IsLockAspectRatio = true;
picture.RelativeToOriginalPictureSize = true;
picture.Placement = PlacementType.FreeFloating;
picture.Left = 113; // This can't be done
stream.Close();
}
wb.Save(@"Result.xlsx", FileFormatType.Excel2007Xlsx);