When using Win32::OLE to connect to Excel, I get most of my data put into the spreadsheet (excel). But randomly, I get the following error

Not only is this annoying, it actually puts in undef where the data ought to be – not good.

 

Is there a patch for this? Or at least a work-a-round?

 

ERROR MESSAGE: retrying default method at C:/Rational/Common/lib/perl5/site_perl/5.6.1/Win32/OLE/Lite.pm line 156.

 

 

Here is what perl –V gives me:

 

C:\dev>perl -V

Summary of my perl5 (revision 5 version 8 subversion 7) configuration:

  Platform:

    osname=MSWin32, osvers=5.0, archname=MSWin32-x86-multi-thread

    uname=''

    config_args='undef'

    hint=recommended, useposix=true, d_sigaction=undef

    usethreads=define use5005threads=undef useithreads=define usemultiplicity=define

    useperlio=define d_sfio=undef uselargefiles=define usesocks=undef

    use64bitint=undef use64bitall=undef uselongdouble=undef

    usemymalloc=n, bincompat5005=undef

  Compiler:

    cc='cl', ccflags ='-nologo -Gf -W3 -MD -Zi -DNDEBUG -O1 -DWIN32 -D_CONSOLE -DNO_STRICT -DHAVE_DES_FCRYPT -DNO_HASH_SEE

 -DUSE_SITECUSTOMIZE -DPERL_IMPLICIT_CONTEXT -DPERL_IMPLICIT_SYS -DUSE_PERLIO -DPERL_MSVCRT_READFIX',

    optimize='-MD -Zi -DNDEBUG -O1',

    cppflags='-DWIN32'

    ccversion='12.00.8804', gccversion='', gccosandvers=''

    intsize=4, longsize=4, ptrsize=4, doublesize=8, byteorder=1234

    d_longlong=undef, longlongsize=8, d_longdbl=define, longdblsize=10

    ivtype='long', ivsize=4, nvtype='double', nvsize=8, Off_t='__int64', lseeksize=8

    alignbytes=8, prototype=define

  Linker and Libraries:

    ld='link', ldflags ='-nologo -nodefaultlib -debug -opt:ref,icf  -libpath:"C:\Perl\lib\CORE"  -machine:x86'

    libpth=\lib

    libs=  oldnames.lib kernel32.lib user32.lib gdi32.lib winspool.lib  comdlg32.lib advapi32.lib shell32.lib ole32.lib ol

aut32.lib  netapi32.lib uuid.lib ws2_32.lib mpr.lib winmm.lib  version.lib odbc32.lib odbccp32.lib msvcrt.lib

    perllibs=  oldnames.lib kernel32.lib user32.lib gdi32.lib winspool.lib  comdlg32.lib advapi32.lib shell32.lib ole32.li

 oleaut32.lib  netapi32.lib uuid.lib ws2_32.lib mpr.lib winmm.lib  version.lib odbc32.lib odbccp32.lib msvcrt.lib

    libc=msvcrt.lib, so=dll, useshrplib=yes, libperl=perl58.lib

    gnulibc_version='undef'

  Dynamic Linking:

    dlsrc=dl_win32.xs, dlext=dll, d_dlsymun=undef, ccdlflags=' '

    cccdlflags=' ', lddlflags='-dll -nologo -nodefaultlib -debug -opt:ref,icf  -libpath:"C:\Perl\lib\CORE"  -machine:x86'

 

 

Characteristics of this binary (from libperl):

  Compile-time options: MULTIPLICITY USE_ITHREADS USE_LARGE_FILES

                        USE_SITECUSTOMIZE PERL_IMPLICIT_CONTEXT

                        PERL_IMPLICIT_SYS

  Locally applied patches:

        ActivePerl Build 815 [211909]

        Iin_load_module moved for compatibility with build 806

        PerlEx support in CGI::Carp

        Less verbose ExtUtils::Install and Pod::Find

        instmodsh upgraded from ExtUtils-MakeMaker-6.25

        Patch for CAN-2005-0448 from Debian with modifications

        Upgrade to Time-HiRes-1.76

        25774 Keys of %INC always use forward slashes

        25747 Accidental interpolation of $@ in Pod::Html

        25362 File::Path::mkpath resets errno

        25181 Incorrect (X)HTML generated by Pod::Html

        24999 Avoid redefinition warning for MinGW

        24699 ICMP_UNREACHABLE handling in Net::Ping

        21540 Fix backward-compatibility issues in if.pm

  Built under MSWin32

  Compiled at Nov  2 2005 08:44:52

  @INC:

    C:/Perl/lib

    C:/Perl/site/lib

    .

 

 

 

==========

Thanks,

Jerry

 

===

Recursive: noun.

     see Recursive.

 

****************************************************************************

This email may contain confidential
material. If you were not an intended recipient,
Please notify the sender and delete all copies.
We may monitor email to and from our network.

 ***************************************************************************

 
_______________________________________________
ActivePerl mailing list
[email protected]
To unsubscribe: http://listserv.ActiveState.com/mailman/mysubs

Reply via email to