If what you mean by this is you want an image in a cell, then no. The problem is Excel per se does not support images in cells. MS hacked a solution by creating a whole new object class for graphics etc and shoehorned that into those. Implementing that graphics API is a huge undertaking and I don't think anyone is going to spend the time to do it.
If you mean something else, then look at the Excel file format, and if you can find it then let us know. I never could find such a thing. In the past someone asked for both a background image for a whole sheet, and images in cells, and there was no way to easily do either.
If you would like to refer to this comment somewhere else in this project, copy and paste the following link:
yes what I meant is having an image in a cell.
I absolutely agree that the MsoDrawingGroup is a nightmare, but I hoped that the record type 0x7F (RECTYPE_IMDATA) would
be easier. Will check if I can find more about this.
Regards: Michael
On 01.08.2013 16:26, David Hoerl wrote:
If what you mean by this is you want an image in a cell, then no. The problem is Excel per se does not support images in cells. MS hacked a solution by creating a whole new object class for graphics etc and shoehorned that into those. Implementing that graphics API is a huge undertaking and I don't think anyone is going to spend the time to do it.
If you mean something else, then look at the Excel file format, and if you can find it then let us know. I never could find such a thing. In the past someone asked for both a background image for a whole sheet, and images in cells, and there was no way to easily do either.
[bugs:#56] picture/company logo
Status: open Created: Thu Aug 01, 2013 10:50 AM UTC by mijobe Last Updated: Thu Aug 01, 2013 10:50 AM UTC Owner: nobody
is it possible (or planned) to include a picture (company logo) into the created xls-file?
So I looked at the open office spec, nothing on this, but then I found it in Microsoft's 1997 Excel Developer kit. That said, we are going to need to either just accept Windows Metafile or Windows bitmap format - I know nothing of these formats so right now more information is needed. Once we assure ourselves we can get high quality images into cells, then its not going to be all that much work to add this.
If you would like to refer to this comment somewhere else in this project, copy and paste the following link:
Wikipedia seems to have usefull information about BMP (http://en.wikipedia.org/wiki/BMP_file_format). Think that it's no problem to restrict to a given color depth (eg 24 bit) and uncompressed image data. For me it's only thought to hold a small company logo, to make the fans of "corporate identity" happy
If you would like to refer to this comment somewhere else in this project, copy and paste the following link:
I've added a discussion topic "Images". I just finished getting "notes" to work with BIFF8, and that required adding much of the MSODrawing code that I'd need for images. In your case, you want to add a simple logo or corporate image somewhere on each sheet?
If you would like to refer to this comment somewhere else in this project, copy and paste the following link:
If what you mean by this is you want an image in a cell, then no. The problem is Excel per se does not support images in cells. MS hacked a solution by creating a whole new object class for graphics etc and shoehorned that into those. Implementing that graphics API is a huge undertaking and I don't think anyone is going to spend the time to do it.
If you mean something else, then look at the Excel file format, and if you can find it then let us know. I never could find such a thing. In the past someone asked for both a background image for a whole sheet, and images in cells, and there was no way to easily do either.
Hi David,
yes what I meant is having an image in a cell.
I absolutely agree that the MsoDrawingGroup is a nightmare, but I hoped that the record type 0x7F (RECTYPE_IMDATA) would
be easier. Will check if I can find more about this.
Regards: Michael
On 01.08.2013 16:26, David Hoerl wrote:
So I looked at the open office spec, nothing on this, but then I found it in Microsoft's 1997 Excel Developer kit. That said, we are going to need to either just accept Windows Metafile or Windows bitmap format - I know nothing of these formats so right now more information is needed. Once we assure ourselves we can get high quality images into cells, then its not going to be all that much work to add this.
Wikipedia seems to have usefull information about BMP (http://en.wikipedia.org/wiki/BMP_file_format). Think that it's no problem to restrict to a given color depth (eg 24 bit) and uncompressed image data. For me it's only thought to hold a small company logo, to make the fans of "corporate identity" happy
I've added a discussion topic "Images". I just finished getting "notes" to work with BIFF8, and that required adding much of the MSODrawing code that I'd need for images. In your case, you want to add a simple logo or corporate image somewhere on each sheet?
either on each or only on the first
Ticket moved from /p/xlslib/bugs/56/
Ticket moved from /p/libxls/feature-requests/7/