My application generates a spreadsheet with the each product image and its details in a tablular format.
When I add an image to a worksheet using XlsIO [ sheet.Pictures.AddPicture(row, column, image, 80, 80) ] the image size is not preserved.
It appears shrinked when I open the generated excel file.
I have Syncfusion Version 9.2.0.137 installed in my machine.
Sample Code:
sheet.SetRowHeightInPixels(row, 100);
image = new System.Drawing.Bitmap(OriginalImage, 100, 100);
IPictureShape picture = sheet.Pictures.AddPicture(row, column, image, 80, 80);
sheet.SetRowHeightInPixels(row, image.Height);
picture.Left = picture.Left + ((100- picture.Width) / 2);
picture.Top = picture.Top + ((100- picture.Height) / 2);
picture.IsSizeWithCell = true;
I would appreciate help and quick response.