Re: Problem in Parsing XLSX

Later I through module I came to know that MSOFFICE 2007 files cant be read by that module.

I don’t know what you mean here. The Spreadsheet::ParseXLSX module is designed to read .xlsx files, which are the default workbook files for Excel 2007 (see Microsoft_Excel#Current_file_extensions). If you need to read files in the older .xls format, use the Spreadsheet::ParseExcel module instead. If this doesn’t answer your question, please clarify the problem.

BTW, the Unix cat command returns the contents of a file as a single string. So the statement:

my @circle_mapping_list=`cat $config_dir/circle_name_2g`;
[download]

populates only the first element of the array, namely $circle_mapping_list[0]. Therefore the following foreach loop:

foreach my $entry(@circle_mapping_list)
[download]

can have at most one iteration. I doubt this is what you intended.

Update: See correction by Tux, below.

Hope that helps,

Athanasius <°(((>< contra mundum Iustus alius egestas vitae, eros Piratica,

Comment on Re: Problem in Parsing XLSX Select or Download Code

Replies are listed 'Best First'.
Re^2: Problem in Parsing XLSX by Tux (Canon) on Dec 16, 2015 at 14:42 UTC
No it does not: $ perl -wE'my @x=`ls -1`;say $#x' 102 [download] backticks are the equivalent of the `qx` operator: $ perldoc -f qx "qx/STRING/" A string which is (possibly) interpolated and then execute +d as a system command with /bin/sh or its equivalent. Shell wildc +ards, pipes, and redirections will be honored. The collected sta +ndard output of the command is returned; standard error is unaff +ected. In scalar context, it comes back as a single (potentially multi-line) string, or "undef" if the command failed. In l +ist ^^^^ +^^^ context, returns a list of lines (however you've defined l +ines ^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^ with $/ or $INPUT_RECORD_SEPARATOR), or an empty list if t +he command failed. [download] Enjoy, Have FUN! H.Merijn	[reply] [d/l] [select]

Replies are listed 'Best First'.

Re^2: Problem in Parsing XLSX
by Tux (Canon) on Dec 16, 2015 at 14:42 UTC

No it does not:

$ perl -wE'my @x=`ls -1`;say $#x'
102
[download]

backticks are the equivalent of the qx operator:

$ perldoc -f qx
    "qx/STRING/"
            A string which is (possibly) interpolated and then execute
+d as a
            system command with /bin/sh or its equivalent. Shell wildc
+ards,
            pipes, and redirections will be honored. The collected sta
+ndard
            output of the command is returned; standard error is unaff
+ected.
            In scalar context, it comes back as a single (potentially
            multi-line) string, or "undef" if the command failed. In l
+ist
                                                                  ^^^^
+^^^
            context, returns a list of lines (however you've defined l
+ines
            ^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^
            with $/ or $INPUT_RECORD_SEPARATOR), or an empty list if t
+he
            command failed.
[download]

Enjoy, Have FUN! H.Merijn

[reply]
[d/l]
[select]