C#

PIEBALDconsult wrote:

Use an XmlDocument.

Bob Dole

The internet is a great way to get on the net.

2.0.82.7292 SP6a

for (int j = 0; j < excelSheets.Length; j++)
{
    if (excelSheets[j] == "Sheet1$")
    {
        Match = true;
        break;
    }
}

if (Match == true)
    return true;
else
    return false;

return Match;

int i = 0;
foreach (DataRow row in dt.Rows)
{
    excelSheets[i] = row["TABLE_NAME"].ToString();
    if (excelSheets[i] == "Sheet1$")
    {
        Match = true;
        break;
    }
    i++;
}

private Boolean SheetExists(string strFilename)
{
    String connString = "Provider=Microsoft.Jet.OLEDB.4.0;" +
        "Data Source=" + strFilename + ";Extended Properties=Excel 8.0;";
    using (OleDbConnection objConn = new OleDbConnection(connString))
    {
      objConn.Open();
      using (System.Data.DataTable dt = objConn.GetOleDbSchemaTable(OleDbSchemaGuid.Tables, null))
      {
        foreach (DataRow row in dt.Rows)
        {
            if (row["TABLE_NAME"].ToString() == "Sheet1$")
            {
                return true;
            }
        }
        return false;
      }
    }
}

if (row["TABLE_NAME"].ToString() == "Sheet1$")
{
    return true;
}

string tableName = row["TABLE_NAME"].ToString();
if (tableName == "Sheet1$" ||
    tableName == "Sheet2$")
{
    return true;
}

if (SheetNames.Contains(row["TABLE_NAME"].ToString()))
{
    return true;
}

switch (SuppCode)
{
    case "COR1":
        Sheet1Name = "Sheet1";
        Sheet2Name = null;
        Sheet3Name = null;
        break;
    case "HAV1":
        Sheet1Name = "Summary";
        Sheet2Name = "Unit_Rates";
        Sheet3Name = "Other_Charges";
        break;
}

string tableName = row["TABLE_NAME"].ToString();
if (tableName == Sheet1Name ||
    tableName == Sheet2Name ||
    tableName == Sheet3Name)
{
    return true;
}

foreach (DataRow row in dt.Rows)
{
    string tableName = row["TABLE_NAME"].ToString();
    if (tableName == Sheet1Name + "$" ||
        tableName == Sheet2Name + "$" ||
        tableName == Sheet3Name + "$")
    {
        Exists = true;
    }
}
if (Exists == true)
{
    MessageBox.Show("Match");
}
else
    MessageBox.Show("No Match");

if (Exists == true)

if (Sheet1Name != null)
{
    foreach (DataRow row in dt.Rows)
    {
        if (row["TABLE_NAME"].ToString() == Sheet1Name+"$")
        {
            Exists = true;
        }
    }
}
if (Sheet2Name != null)
{
    Exists = false;
    foreach (DataRow row in dt.Rows)
    {
        if (row["TABLE_NAME"].ToString() == Sheet2Name + "$")
        {
            Exists = true;
        }
    }
}
if (Sheet3Name != null)
{
    Exists = false;
    foreach (DataRow row in dt.Rows)
    {
        if (row["TABLE_NAME"].ToString() == Sheet3Name + "$")
        {
            Exists = true;
        }
    }
}
if (Exists == true)
{
    MessageBox.Show("Match");
}
else
    MessageBox.Show("No Match");

// Initialize these so null Sheet?Names pass the checking
bool Exists1 = Sheet1Name == null;
bool Exists2 = Sheet2Name == null;
bool Exists3 = Sheet3Name == null;
string Sheet1NameSuffix = (Sheet1Name ?? "") + "$";
string Sheet2NameSuffix = (Sheet2Name ?? "") + "$";
string Sheet3NameSuffix = (Sheet3Name ?? "") + "$";
foreach (DataRow row in dt.Rows)
{
    string tableName = row["TABLE_NAME"].ToString();
    if (tableName == Sheet1NameSuffix)
    {
        Exists1 = true;
    }
    if (tableName == Sheet2NameSuffix)
    {
        Exists2 = true;
    }
    if (tableName == Sheet3NameSuffix)
    {
        Exists3 = true;
    }
}
if (Exists1 && Exists2 && Exists3)
{
    MessageBox.Show("Match");
}
else
    MessageBox.Show("No Match");