Reading Multiple worksheets from Excel workbook

if (sheet["TABLE_NAME"].ToString().IndexOf('4') == 0) // Process only if the sheet name begins with a 4
                {
                    sheetAdapter = new OleDbDataAdapter("select * from [" + sheet["TABLE_NAME"].ToString() + "]", con);
                    sheetData = new DataTable(sheet["TABLE_NAME"].ToString());
                    sheetAdapter.Fill(sheetData);
                    excelData.Tables.Add(sheetData);
                }

                                              

1:
2:
3:
4:
5:
6:
7:

        public bool ReadUploadedFile(String XLFilepath, String XLFileName)
        {
 
            //get the current file and path
            _currentFile = String.Concat(XLFilepath, XLFileName);
 
            //get the connection string
            string conStr = @"Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" + _currentFile + "; Jet OLEDB:Engine Type=5;Extended Properties=Excel 8.0;";
 
            //initiallise dat objects
            OleDbDataAdapter sheetAdapter = null;
            DataTable sheetData = null;
            DataSet excelData = new DataSet();
            OleDbConnection con = new OleDbConnection(conStr);
 
            //check the connection state
            if (con.State != System.Data.ConnectionState.Open)
            {
                con.Open();
            }
 
            //fill the datatable
            DataTable sheets = con.GetOleDbSchemaTable(OleDbSchemaGuid.Tables, new object[] { });
 
            int counter = 0;
 
            //loop through each row 
            foreach (DataRow sheet in sheets.Rows)
            {
 
                _isValidSheet = true;
                //lots of dodgy data need to make sure we only have what we need.
                _TmpTablename = sheet["TABLE_NAME"].ToString();
 
                //** was not my intention to hardcode the names but timeframes were tight
                //check to see if the view is the one that we want
              
                //make sure that we have no extra sheets for each store
                if (_TmpTablename.IndexOf('4') == 0 || _TmpTablename.EndsWith("Print_Area") || _TmpTablename.IndexOf("All Stores") == 0)
                {
                    _isValidSheet = false;
                }
 
                //if it's not valid then skip it
                if (_isValidSheet && counter <= 31)
                {
                    //SELECT FROM the current sheet 
                    sheetAdapter = new OleDbDataAdapter("select * from [" + sheet["TABLE_NAME"].ToString() + "]", con);
 
                    //create the datatable
                    sheetData = new DataTable(sheet["TABLE_NAME"].ToString());
 
                    //fill the dataadapter
                    sheetAdapter.Fill(sheetData);
 
                    //update the dataset from the datatable
                    excelData.Tables.Add(sheetData);
 
                    //DataRow[] rows = sheetData.Select();
 
                    //// Print the value one column of each DataRow.
                    //for (int i = 0; i < rows.Length; i++)
                    //{
                    //    Response.Write(rows[2]["F3"] + " <br> " + _TmpTablename + " <br> ");
                    //}
 
                    counter += 1;
                }
            }
          
 
            if (excelData.Tables.Count >0)
            {
 
               GridView1.DataSource = excelData;
                GridView1.DataBind();   
            }
 
 
            //check the connection state
            if (con.State != System.Data.ConnectionState.Closed)
            {
                con.Close();
            }
 
            return true;
        }

                                              

1:
2:
3:
4:
5:
6:
7:
8:
9:
10:
11:
12:
13:
14:
15:
16:
17:
18:
19:
20:
21:
22:
23:
24:
25:
26:
27:
28:
29:
30:
31:
32:
33:
34:
35:
36:
37:
38:
39:
40:
41:
42:
43:
44:
45:
46:
47:
48:
49:
50:
51:
52:
53:
54:
55:
56:
57:
58:
59:
60:
61:
62:
63:
64:
65:
66:
67:
68:
69:
70:
71:
72:
73:
74:
75:
76:
77:
78:
79:
80:
81:
82:
83:
84:
85:
86:
87:
88: