none
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);
    
    excelConnection.Open();
    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

Answers

  • A C# code example shown in http://july-code.blogspot.mx/2008/02/hidden-worksheet-in-excel-file.html 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
    Moderator