Extract Excel sheet name. Sort NOT alphabetically

Collapse
X
 
  • Time
  • Show
Clear All
new posts
  • todubhai
    New Member
    • Oct 2008
    • 1

    #1

    Extract Excel sheet name. Sort NOT alphabetically

    I am using the following code to extract the sheet names from excel: (See attached code)

    private String[] GetExcelSheetNa mes(string sConnectionStri ng)
    {
    OleDbConnection objConn = null;
    System.Data.Dat aTable dt = null;

    try
    {
    // Create connection object by using the preceding connection string.
    objConn = new OleDbConnection (sConnectionStr ing);
    // Open connection with the database.
    objConn.Open();
    // Get the data table containg the schema guid.
    dt = objConn.GetOleD bSchemaTable(Ol eDbSchemaGuid.T ables, null);

    if (dt == null)
    {
    return null;
    }

    String[] excelSheets = new String[dt.Rows.Count];
    int i = 0;

    // Add the sheet name to the string array.
    foreach (DataRow row in dt.Rows)
    {
    excelSheets[i] = row["TABLE_NAME "].ToString();
    i++;
    }

    // Loop through all of the sheets if you want too...
    for (int j = 0; j < excelSheets.Len gth; j++)
    {
    // Query each excel sheet.
    }

    return excelSheets;
    }
    catch (Exception ex)
    {
    return null;
    }
    finally
    {
    // Clean up.
    if (objConn != null)
    {
    objConn.Close() ;
    objConn.Dispose ();
    }
    if (dt != null)
    {
    dt.Dispose();
    }
    }
    }

    But the data is returned sorted by the NAMES of the sheets, and this is the issue. I need to extract the name of the first sheet, by index.. how to do this.?
    Last edited by todubhai; Oct 14 '08, 07:14 AM. Reason: forgot to add the code
Working...