Pictures suppor for Excel 2007

Questions and answers on how to use XLSReadWriteII 3/4/5.
Post Reply
mik
Posts: 15
Joined: Fri Mar 05, 2010 1:01 am

Pictures suppor for Excel 2007

Post 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
larsa
Site Admin
Posts: 926
Joined: Mon Jun 27, 2005 9:30 pm

Re: Pictures suppor for Excel 2007

Post by larsa »

Hello

Pictures are not supported in Excel 2007 yet.
Lars Arvidsson, Axolot Data
mik
Posts: 15
Joined: Fri Mar 05, 2010 1:01 am

Re: Pictures support for Excel 2007

Post 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)
mik
Posts: 15
Joined: Fri Mar 05, 2010 1:01 am

Re: Pictures support for Excel 2007

Post 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.
larsa
Site Admin
Posts: 926
Joined: Mon Jun 27, 2005 9:30 pm

Re: Pictures suppor for Excel 2007

Post 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.
Lars Arvidsson, Axolot Data
mik
Posts: 15
Joined: Fri Mar 05, 2010 1:01 am

Re: Pictures suppor for Excel 2007

Post by mik »

Lars,

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

Mik
mik
Posts: 15
Joined: Fri Mar 05, 2010 1:01 am

Re: Pictures suppor for Excel 2007

Post by mik »

are there any news or progress with this feature? thank you for not ignoring the question.
mik
Posts: 15
Joined: Fri Mar 05, 2010 1:01 am

Re: Pictures support for Excel 2007

Post by mik »

please answer the question
Post Reply