How to add picture in spreadsheets ?

[michealtech]

How to add picture in spreadsheets ?

thanks

[DataExport]

You can add pictures to result excel files with the following code

CellImage img1 = new CellImage();
img1.Column = 1;
img1.PictureName = "demo";
img1.Row = 1;
cellExport1.Images.Add(img1);

CellPicture pic1= new CellPicture();
pic1.FileName = "C:\\demo.gif";
pic1.Name = "demo";
cellExport1.Pictures.Add(pic1);

cellExport1.SaveToFile();

[michealtech]

Thank you for the help , I will try.

[SquallLee]

How can I resize the image in spreadsheets?
I use the following code cannot resize:
Dim ciStyle As New DataExport.XLS.CellImage

ciStyle.Column = 0
ciStyle.PictureName = "style"
ciStyle.Row = iCurrentRow
objCellExport.Images.Add(ciStyle)

Dim cpStyle As New DataExport.XLS.CellPicture

cpStyle.FileName = Server.MapPath("~\Excel\DatelineTracking\StyleImage") + rMain(1).ToString().Replace("/", "\")
cpStyle.Name = "style"
cpStyle.Height = 90
cpStyle.Width = 100
objCellExport.Pictures.Add(cpStyle)

[Suvi.Wu]

Hi SqualLee,

Thanks for your inquiry and sorry for the inconvenience caused by us.

I am sorry for that Spire.DataExport doesn't support to resize the Image at this stage. However, our product Spire.Xls can do it perfectly, so you can use it to achieve your requirement if you'd like to. I attached a demo illustrates how to do it use Spire.Xls, please have a look.

In case of any ambiguity, please feel free to contact us.

Have a great day.

BR
Suvi
e-iceblue support