in reply to Re^2: How to read the value of a variable (read from a Excel file converted Into text file) and put then back into Excel column
in thread How to read the value of a variable (read from a Excel file converted Into text file) and put then back into Excel column

Which Operating System ?. If windows then Win32::OLE perhaps

poj
  • Comment on Re^3: How to read the value of a variable (read from a Excel file converted Into text file) and put then back into Excel column

Replies are listed 'Best First'.
Re^4: How to read the value of a variable (read from a Excel file converted Into text file) and put then back into Excel column
by rockyurock (Acolyte) on Feb 23, 2017 at 07:37 UTC
    yes. It;s Windows 7
[reply]
      on win32::OLE only reads .xls application but Iam using Windows 7 with .xlsx format. Is there any similar Utility In windows 7 as well ?
[reply]
        win32::OLE only reads .xls

        What error message do you get with .xlsx ?

        Run this to show your versions

        #!perl
use strict;
use warnings;
use Win32::OLE;
 
# get already active Excel application or open new
my $Excel = Win32::OLE->GetActiveObject('Excel.Application')
|| Win32::OLE->new('Excel.Application', 'Quit'); 
 
print "Perl $] Win32::OLE Version ${Win32::OLE::VERSION}\n";
print "Running  Excel $Excel->{'Version'} on $Excel->{'OperatingSystem
+'}\n";

        [download]
        poj
[reply]
[d/l]

In Section Seekers of Perl Wisdom