in reply to Re^7: Append new line in excel sheets
in thread Append new line in excel sheets

Hi CountZero thanks a lot for this very useful suggestion :) I surly will report this as a bug on their forum.

Replies are listed 'Best First'.
Re^9: Append new line in excel sheets
by perl_new_b (Novice) on Jul 21, 2014 at 13:19 UTC

    If I installed Excel Viewer, then would it be possible to use WIn32::OLE?? Currently, I'm using :

    my $Excel = Win32::OLE->new('Excel.Application') or die "oops\n";

    But for the above case of Excel.Application it dies, can I use some other call for that instead of Excel.Application???

      Honestly, I have no idea. You will have to check the documentation, but as it is "only" a viewer I really doubt it can even export, let alone change, the data in Excel.

      CountZero

      A program should be light and agile, its subroutines connected like a string of pearls. The spirit and intent of the program should be retained throughout. There should be neither too little or too much, neither needless loops nor useless variables, neither lack of structure nor overwhelming rigidity." - The Tao of Programming, 4.1 - Geoffrey James

      My blog: Imperial Deltronics