Extracting bitmap from Excel using Win32::OLE

[aminnis]

Hello all,

Does anyone know how to extract a bitmap from a cell using win32::OLE
and save it to a file? Any help is appreciated.

Alan

 

[Brian Helterline]

Hello all,

Does anyone know how to extract a bitmap from a cell using win32::OLE
and save it to a file? Any help is appreciated.

Alan

Bitmaps are not in cells, they are on the "Shapes" layer within Excel.
my $bitmap = $excel->ActiveSheet->Shapes(1);
or if you want to limit the search to the selection,
my $bitmap = $excel->ActiveSheet->Selection->Shapes(1);

Then you have to
$bitmap->Copy;

to place it on the clipboard, and

use Win32::Clipboard

to retrieve it and write it to file (using binmode)