Is it possible to write Pictures into Excel file?

[Will 保哥]

Hi,

Is there any way could put images into Excel file?

I tried to use the following code to add a picture before worksheet
added to workbook.Worksheets and save, but it doesn't work.

Picture pic = new Picture()
{
ImageFormat = EscherRecordType.MsofbtBlipBitmapPNG,
ImageData = File.ReadAllBytes(@"C:\a.png"),
UpperRow = 10,
RightCol = 10,
BottomRow = 10,
LeftCol = 10
};

worksheet.Pictures.Add(new Pair<int, int>(1, 1), pic);

BR,
Will

[Jerry]

Hi

Encoding picture is not supported at the moment.

I will put a ticket in.


Cheers,
J.

[Will 保哥]

Hi Jerry,

 

I have a project needs to put images into Excel worksheet recently.  Would you tell me the time schedule you plan to put it in?  Or do you have any other related excel library (.net) solution could recommand for me?

 

Thanks a lot.

 

BR,

Will

[Jerry]

Hi Will,

I am afraid that there is no timeline for that feature as yet.

You can try Java POI + IKVM (http://cuda.net/blog/2008/06/29/poi-and-
ikvm/) approach.

Or you can try other commercial libraries.


Cheers,
Jerry