in reply to Problem in Parsing XLSX

Hello ravi45722,

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`;

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

foreach my $entry(@circle_mapping_list)

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,

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

    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.

    Enjoy, Have FUN! H.Merijn