Re: Re: Troubles transposing a range in Excel with Win32::OLE


Welcome to the Monastery
	PerlMonks

Re: Re: Troubles transposing a range in Excel with Win32::OLE

by guha (Priest)

on Jan 10, 2002 at 14:10 UTC ( [id://137703]=note: print w/replies, xml )

Need Help??

in reply to Re: Troubles transposing a range in Excel with Win32::OLE
in thread Troubles transposing a range in Excel with Win32::OLE

Problem Solved

Should this be considered a bug in OLE ?
Knowing that c-era could replicate the problem in VB, why was there no refs of this found in google ?
Is Transpose such a rare creature or is it just me ??

Kudos to jmcnamara and c-era!

Thanks²

Comment on Re: Re: Troubles transposing a range in Excel with Win32::OLE

Replies are listed 'Best First'.

Re:(3) Troubles transposing a range in Excel with Win32::OLE
by jmcnamara (Monsignor) on Jan 10, 2002 at 19:10 UTC

However, it is often hard to match Perl's variable types with those expected by VBA. That is why the Win32::OLE::Variant module is so useful.

A good resource for Win32::OLE related information is the ActiveState mailing lists. In particular the perl-win32-users list. Jan Dubois, the author of Win32::OLE, often answers questions there.

As an aside, Win32::OLE is an extremely powerful module and potentially very useful. However, it is let down by a lack of comprehensive documentation and examples.

--
John.

[reply]

In Section Seekers of Perl Wisdom