Well, I would start with man unzip and find how to get a file listing of the xlsx on stdout so I could filter out which are text-like, usually xml. Then I can use unzip to extract each of those files to stdout, where I can used sed to find and strip out the URLs I want. First look at it in pg or the like. Find the URL you know you want. There may be many URLs on a line, so you need to separate them onto different lines and dispose of non-URL lines and line bits. Something like
If you want to stay in PERL, there are unzip APIs http://perldoc.perl.org/IO/Uncompress/Unzip.html
Hi ,
can any one tell me,"How to extract the same format from existing excel file to new excel file " using Spreadsheet::WriteExcel or Spreadsheet::ParseExcel module ???
Example_pgm:
Below program is used to read existing excel file..In this program "my $cell = $_;" line is used to... (0 Replies)
Hi folks,
I am working on assignment that captures all the records(2 columns one column contains names and other contain date of birth) from excel sheet stored in a directory and checks for current date and month.
If it matches current date and month then the matched records are printed as... (1 Reply)
I have a excel sheet with contains the records as below..
also uploaded the input excelsheet and the output excel sheet(expected output).
322mpls32.net.xyz.comBW: 44.0 M Hrly Avg (IN /... (1 Reply)
I have an Excel 2007 excel sheet on windows machine and using
Spreadsheet::XLSX I had written a script to read the excel sheet and was successful.
My requirement is I need to generate another excel sheet from the old excel 2007 sheet on unix machine.
Now is it possible to read the excel... (2 Replies)
There is a perl scriptwhich will read Excel sheet and create one file(.v) .
Excel sheet:::
A B C D
1 cpu_dailog 2 3 4
Perl will create the file(.v) like thsi :::
assert (cpu_dailog_iso ==2) ;
assert (cpu_dailog_reset ==3);
assert (cpu_dailog_idle... (3 Replies)
Thourgh Perl scripting, Is it possible to upload excel sheet to sharepoint portal ?
If the answer is YES.. Could you please share your thoughts and required CPAN modules or any examples to proceed further?
Regards,
Giridhar S
---------- Post updated at 04:26 AM ---------- Previous update... (0 Replies)
Hi Folks,
Can you please advise for any script in unix such that for example , i have 3 different excel sheet at the location /ppt/gfr/exc so the name s of the excel sheet are
1excel.xslx
2excel.xslx
3excel.xslx
now in these 3 different excel sheet there is lot of data for example each... (3 Replies)