Skip the hidden excel sheets while reading excel using oledb

See more:

C#5.0

Hi,


I want to skip reading those excel sheets which are hidden , while importing data from excel. I am using the code as below, but i have not added the code here . Can anyone please help me

using (OleDbConnection conn = new OleDbConnection(oledbConn))
            {
                if (conn.State != Data.ConnectionState.Open)
                    conn.Open();

                OleDbCommand cmd = new OleDbCommand();
                cmd.Connection = conn;


                // Get all Sheets in Excel File
                Data.DataTable dtSheet = conn.GetOleDbSchemaTable(OleDbSchemaGuid.Tables,null);

                // Loop through all Sheets to get data
                foreach (Data.DataRow dr in dtSheet.Rows)
                {
                    sheetName = dr["TABLE_NAME"].ToString();

                    if (!sheetName.EndsWith("$") || sheetName.StartsWith("VSTS_Validation"))
                        continue;

                    // Get all rows from the Sheet
                    cmd.CommandText = "SELECT * FROM [" + sheetName + "]";

                    Data.DataTable dt = new Data.DataTable();
                    dt.TableName = sheetName;


                    OleDbDataAdapter da = new OleDbDataAdapter(cmd);
                    da.Fill(dt);

                    dsWorkitems.Tables.Add(dt);
                }