Watch this visual how-to video as you learn to use Open XML file formats to retrieve information about hidden rows and columns in an Excel worksheet. Author: Ken Getz (MVP)
Here is the original post:
Video: Retrieving Lists of Hidden Rows or Columns in Excel 2010 Workbooks by Using the Open XML SDK 2.0