in reply to Re^4: Read excel column and compare with array
in thread Read excel column and compare with array

Hello snehit.ar,

Are you getting an error? Is it not working? What is the problem? (I have not run your updated code).

Update: I just found that you are copying pasting the example given from the module Spreadsheet::XLSX. You can not mix modules and expect them to work. The methods do not apply on both modes. Decide which module you want to use and create your solution.

Hint: read again module Spreadsheet::Read/sheets and find the line my $sheets = $book->sheets; I think this is what you are looking for.

BR, Thanos1983.

Seeking for Perl wisdom...on the process of learning...not there...yet!

Replies are listed 'Best First'.
Re^6: Read excel column and compare with array
by snehit.ar (Beadle) on Jul 17, 2017 at 11:17 UTC
    Yes @Thanos1983 -You are wight i am using same code ... As u suggested i will explore on "Spreadsheet::Read/sheets"...
[reply]

      Hello again snehit.ar,

      Did you manage to figure it out?

      Let us know if you got stuck somewhere. It should be easy from here you have all the data.

      Seeking for Perl wisdom...on the process of learning...not there...yet!
[reply]
[d/l]
[select]
        Hello thanos1983, I manage to get the required solution . I will sure let you know if any further help is required . Thanks again !
[reply]

In Section Seekers of Perl Wisdom