Re^2: Win32::OLE - is it the best option?

This is a great link thanks. The code in the link is giving me a spot of difficulty when it comes to:


$Excel->ActiveSheet->Pictures->Insert(<http://perlmonks.org/images/use
+rmonkpics/httptech.gif>);

#And now for a brief example using a Variant data type and it's method
+s. Update: Added other variant as per example in this node 
    

my $dt = Variant(VT_DATE, $Sheet->Range("a1")->{Value});  ## This is t
+he line that give me the ERROR
[download]

where I get the error message:


Win32::OLE(0.1701) error 0x80020005: "Type mismatch" at Perl_program.p
+l line 87
[download]

Comment on Re^2: Win32::OLE - is it the best option? Select or Download Code

Replies are listed 'Best First'.
Re^3: Win32::OLE - is it the best option? by marto (Cardinal) on Jan 20, 2006 at 15:32 UTC
Win, You have been a user here for quite some time and should know by now that providing sample data your working with, in addition to the code thats causing problems helps to point out what the cause of the problem and any possible solutions. What is the value of: `$Sheet->Range("a1")->{Value}` Martin	[reply] [d/l]
A reply falls below the community's threshold of quality. You may see it by logging in.