If you want to read the contents of merged cells, treat them like a normal cell, just remember to supply the address of the upper-left cell of the merged range.

If you don't know how to read any cells from an Excel spreadsheet file, look at the modules Spreadsheet::ParseExcel or Spreadsheet::XLSX, depending of the Excel version that you (or anyone who provided you the input data) is using.

regards,
Luke Jefferson