Read hidden Excel sheets RRS feed

  • Question

  • Hello,

    since the wizard can't see hidden Excel worksheets is there a way to use a script task in order to get to read those sheets?

    I've tried this:

    excelConnection = new OleDbConnection(connectionString);
    tablesInFile = excelConnection.GetSchema("Tables");

    but that also couldn't see the hidden worksheets.

    thanks in advance for the info.

    Tuesday, September 25, 2012 1:16 PM


  • A C# code example shown in must do the trick

    Arthur My Blog

    • Proposed as answer by btsbee Tuesday, September 25, 2012 4:40 PM
    • Marked as answer by Eileen Zhao Monday, October 1, 2012 7:08 AM
    Tuesday, September 25, 2012 1:40 PM