Page 1 of 1

Pictures suppor for Excel 2007

Posted: Fri Mar 05, 2010 1:08 am
by mik
Please let me know if current version 4 supports the following for Excel 2007 .xlsx format

1. retrieving the list of pictures on a worksheet, something like this:
for i := 0 to XLS.Sheets.Count - 1 do
begin
sheet := XLS.Sheets[i];
for j := 0 to sheet.SheetPictures.Count - 1 do
Name := sheet.SheetPictures[j].ShapeName;
end;
end;

2. Retrieve the picture, like:
...
sheet := XLS.Sheets[i];
shtPic := sheet.SheetPictures.FindPicture(PicName);
xlsPic := shtPic.XLSPicture;
LoadFromFile(xlsPic.Filename);

thank you

Re: Pictures suppor for Excel 2007

Posted: Fri Mar 05, 2010 9:34 am
by larsa
Hello

Pictures are not supported in Excel 2007 yet.

Re: Pictures support for Excel 2007

Posted: Fri Mar 05, 2010 4:34 pm
by mik
Thank you.
a couple of follow-up questions:
- if picture support is already in works in your development version, then perhaps estimates of the release can be shared with us;
- am I correct that in this case essentially for Excel 2007 XlsMini covers everything that XLSReadWriteII does? if not, could you please list the most important difference in functionality for these two (in regards to Excel 2007)

Re: Pictures support for Excel 2007

Posted: Mon Mar 08, 2010 7:18 pm
by mik
Lars, can I please have answers to the two follow-up questions below? These are key questions to make my purchasing decision. Thanks.

Re: Pictures suppor for Excel 2007

Posted: Wed Mar 10, 2010 8:24 am
by larsa
Hello

1. There is no picture support available now, anywhere. It's however not difficult to read the picture files from Excel 2007 files. An Excel 2007 file is a zip file (you can change the extension and open it with WinZIP). And all pictures are stored as files in a directory in the zip. But you can't get any info about where in the workbook the pictures are.
Improved Excel 2007 support is the subject for the next major update that we are working on now.

2. XLSMini don't supports Excel 2007 files, and will not do so in a near future.

Re: Pictures suppor for Excel 2007

Posted: Fri Mar 11, 2011 7:31 pm
by mik
Lars,

Is there any progress for pictures support for Excel 2007?
it's been a year since I asked :)

Mik

Re: Pictures suppor for Excel 2007

Posted: Wed Jun 29, 2011 3:43 pm
by mik
are there any news or progress with this feature? thank you for not ignoring the question.

Re: Pictures support for Excel 2007

Posted: Tue Dec 06, 2011 10:09 pm
by mik
please answer the question