in reply to Perl Excel Help

You may wish to try the module DBD::Excel. That way, you can also use SQL to query the spreadsheet.

I don't know if that's what you're trying to accomplish, but it's worth a shot.

~Thomas~

Replies are listed 'Best First'.
Re^2: Perl Excel Help
by kishore.lakshman (Initiate) on Dec 30, 2011 at 10:38 UTC
    i tried the DBD module, getting a output something like, Use of reference "Spreadsheet::ParseExcel::SaveParser::Worksheet=HASH(0x248efc4)" as array index at C:/Perl/site/lib/Spreadsheet/ParseExcel.pm line 2430. Use of reference "Spreadsheet::ParseExcel::SaveParser::Worksheet=HASH(0x248efc4)" as array index at C:/Perl/site/lib/Spreadsheet/ParseExcel.pm line 1208. Use of reference "Spreadsheet::ParseExcel::SaveParser::Worksheet=HASH(0x248efc4)" as array index at C:/Perl/site/lib/Spreadsheet/ParseExcel.pm line 1208. Use of reference "Spreadsheet::ParseExcel::SaveParser::Worksheet=HASH(0x248efc4)" as array index at C:/Perl/site/lib/Spreadsheet/ParseExcel.pm line 1213. Use of reference "Spreadsheet::ParseExcel::SaveParser::Worksheet=HASH(0x248efc4)" as array index at C:/Perl/site/lib/Spreadsheet/ParseExcel.pm line 1213. Use of reference "Spreadsheet::ParseExcel::SaveParser::Worksheet=HASH(0x248efc4)" as array index at C:/Perl/site/lib/Spreadsheet/ParseExcel.pm line 1218. Use of reference "Spreadsheet::ParseExcel::SaveParser::Worksheet=HASH(0x248efc4)" as array index at C:/Perl/site/lib/Spreadsheet/ParseExcel.pm line 1218. Use of reference "Spreadsheet::ParseExcel::SaveParser::Worksheet=HASH(0x248efc4)" as array index at C:/Perl/site/lib/Spreadsheet/ParseExcel.pm line 1223. Use of reference "Spreadsheet::ParseExcel::SaveParser::Worksheet=HASH(0x248efc4)" as array index at C:/Perl/site/lib/Spreadsheet/ParseExcel.pm line 1223. Use of reference "Spreadsheet::ParseExcel::SaveParser::Worksheet=HASH(0x248efc4)" as array index at C:/Perl/site/lib/Spreadsheet/ParseExcel.pm line 1223. Use of reference "Spreadsheet::ParseExcel::SaveParser::Worksheet=HASH(0x248efc4)" as array index at C:/Perl/site/lib/Spreadsheet/ParseExcel.pm line 2430. Use of reference "Spreadsheet::ParseExcel::SaveParser::Worksheet=HASH(0x248efc4)" as array index at C:/Perl/site/lib/Spreadsheet/ParseExcel.pm line 1208. Use of reference "Spreadsheet::ParseExcel::SaveParser::Worksheet=HASH(0x248efc4)" as array index at C:/Perl/site/lib/Spreadsheet/ParseExcel.pm line 1208. Use of reference "Spreadsheet::ParseExcel::SaveParser::Worksheet=HASH(0x248efc4)" as array index at C:/Perl/site/lib/Spreadsheet/ParseExcel.pm line 1213. Use of reference "Spreadsheet::ParseExcel::SaveParser::Worksheet=HASH(0x248efc4)" as array index at C:/Perl/site/lib/Spreadsheet/ParseExcel.pm line 1213. Use of reference "Spreadsheet::ParseExcel::SaveParser::Worksheet=HASH(0x248efc4)" as array index at C:/Perl/site/lib/Spreadsheet/ParseExcel.pm line 1213. Use of reference "Spreadsheet::ParseExcel::SaveParser::Worksheet=HASH(0x248efc4)" as array index at C:/Perl/site/lib/Spreadsheet/ParseExcel.pm line 1218. Use of reference "Spreadsheet::ParseExcel::SaveParser::Worksheet=HASH(0x248efc4)" as array index at C:/Perl/site/lib/Spreadsheet/ParseExcel.pm line 1218. Use of reference "Spreadsheet::ParseExcel::SaveParser::Worksheet=HASH(0x248efc4)" as array index at C:/Perl/site/lib/Spreadsheet/ParseExcel.pm line 1223. Use of reference "Spreadsheet::ParseExcel::SaveParser::Worksheet=HASH(0x248efc4)" as array index at C:/Perl/site/lib/Spreadsheet/ParseExcel.pm line 1223. Use of reference "Spreadsheet::ParseExcel::SaveParser::Worksheet=HASH(0x248efc4)" as array index at C:/Perl/site/lib/Spreadsheet/ParseExcel.pm line 1223.
[reply]

In Section Seekers of Perl Wisdom