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,


In reply to Re: Problem in Parsing XLSX by Athanasius
in thread Problem in Parsing XLSX by ravi45722

Title:
Use:  <p> text here (a paragraph) </p>
and:  <code> code here </code>
to format your post; it's "PerlMonks-approved HTML":