Greetings Monks, I am parsing an excel book using Parseexcel. One of the sheets has a column full of links to other sheets in the same book. I need to follow the links and process those other sheets. My code sort of looks like this. Note where I am printing the name of the link. I would like to get a pointer to the link it is pointing to.

my $excel = Spreadsheet::ParseExcel::Workbook->Parse($file);
  foreach my $sheet (@{$excel->{Worksheet}}) {
    ...
    $link = $sheet->{Cells}[$row][$colWithLink]->{Val};
    print $link."\n";
    $linkToSheet = $sheet->{Cells}[$row][$colWithLink]->{WHATTOPUTHERE
+};
# or
    $linkToSheet = getLink($sheet->{Cells}[$row][$colWithLink]);
# or
#    ...
  }
[download]