Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Extracting picture from excel file
Message
From
27/08/2008 10:14:24
Dragan Nedeljkovich (Online)
Now officially retired
Zrenjanin, Serbia
 
 
To
27/08/2008 09:58:16
General information
Forum:
Visual FoxPro
Category:
COM/DCOM and OLE Automation
Environment versions
Visual FoxPro:
VFP 9 SP1
OS:
Windows XP SP2
Miscellaneous
Thread ID:
01342120
Message ID:
01342188
Views:
16
This message has been marked as a message which has helped to the initial question of the thread.
>>>Dear All,
>>>
>>>Is there any way to to extract picture from excel file and save it to file on disc.
>>
>>Export as html, then it will export all the images as cryptic named jpgs - and if you got only one, you're lucky ;). The images will be in a subdirectory yourfilename_files.
>
>I need it done programmatically. Perhaps this could be done but I need to know which picture is which.

It can, I did that once. Just record the macro. You could also do a workaround (programmagically) - copy the image to clipboard, create a new sheet, save that sheet as html - take the image from there. It will be there twice, once as a thumbnail, so take the larger one ;).

>Excel can send picture clipboard, so I was thinking if picture can be somehow retrieved from there and saved to disc.
>
>BTW Can ms paint be OLE automated from VFP ? I goggled out some VB chat where somebod did solution like this
>with ms paint.

You should also be able to use a GDI+ library (Carlos, Cezar... download) to save bitmap from clipboard to disk.

back to same old

the first online autobiography, unfinished by design
What, me reckless? I'm full of recks!
Balkans, eh? Count them.
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform