Search results for query: *

hi PinkeyNBrain, i didn't get you ??? Anyway's am not trying to open a excel & append data into it. i just want to create a new excel file & put all the required data present in the array form (array element)into it. Anyway's now i got the expected result. :) Regards, Vijayarl

Hi All, i got the required result. Thanks to nitinpes & to every one who guided me. Working Script: #!/usr/bin/perl -w use strict; use Spreadsheet::ParseExcel::Simple; my $dir = 'C:\Performance_svap\INPUT_FILES\*.xls'; my @file=glob("$dir"); my @output; my $loadavg; my $str; my $str1...

Hi All, I done with almost with the required result expect for now am getting only one line in the ouput file anyone will help me out ??? #!/usr/bin/perl -w use strict; use Spreadsheet::ParseExcel::Simple; my $dir = 'C:\Performance_svap\INPUT_FILES\*.xls'; my @file=glob("$dir"); my...

Thanks sycoogtit for your reply.. i got almost the expected result(thanks to nitinpes !!!) but now i stuck with this.. not getting what is the error full script: #!/usr/bin/perl -w use strict; use Spreadsheet::ParseExcel::Simple; my $dir = 'C:\Performance_svap\INPUT_FILES\*.xls'; my...

Hi All, going forward ,i did some scripting to read the data from the excel file & put the data into an array. (used Spreadsheet-ParseExcel-Simple-1.04 module from CPAN) full script: it just reads the data & puts them into array use strict; #use Spreadsheet::ParseExcel; use...

Hi All, Requirement: i have 4 excel files, each file will have this line 18/01/2008 20:00:00 5.31 5.48 5.33 i need to search for this line & extract this line then print it another excel file. INPUT file look like this: Filename:prstat-Ls-20080118-2000.xls DD/MM/YYYY...

Thanks Sycoogtit......(3*) - stars for you..:-) Now am getting the desired result... Thanks once again for your patience reply.... :-) Regards, Raghavanv

sorry again.... # Build an array of the stats type to be collated #my @stat_type=split(/:/, $PARAMS{COLLATE_STAT_TYPES}); @stat_type=@uniq; # for each of the stats type, read the xls of each hour and write into a consolidated xls. foreach my $stat_type_token (@stat_type){ my...

hi sycoogtit, sorry for my identation... # Build an array of the stats type to be collated @stat_type=@uniq; # for each of the stats type, read the xls of each hour and write into a consolidated xls. foreach my $stat_type_token (@stat_type){ my $con_wb =...

hi syscoogtit, i still get the same output.. # Build an array of the stats type to be collated #my @stat_type=split(/:/, $PARAMS{COLLATE_STAT_TYPES}); @stat_type=@uniq; # for each of the stats type, read the xls of each hour and write into a consolidated xls. foreach my $stat_type_token...

Thanks sycoogtit for your reply... i did the changes what u have said but now i get the output without any header in output file. ie,output without header 18/01/2008 18:00:00 0.5 2.9 15 30.5 18/01/2008 18:00:00 0 0 0 0 18/01/2008 18:00:00 0.4 2.9 13.7...

Hi All, Am newbiee to perl.. i have a requirement & am trying to acheive this from past few weeks but all went in vain.. Requirement: 1.There are few stat's excel files,each of these stat files will have header content & followed by data. all i need is to merge all same stat's files into...