Comments by Member 12962919 (Top 12 by date)

The query problem is solved but it add some additional columns in table like Table_catalog,table_schema,table type

I used this but this gives me error in query
here is code

OleDbConnection connection = null;

try
{
string excelConnectionString = string.Format("Provider=Microsoft.ACE.OLEDB.12.0;Data Source={0};Extended Properties='Excel 8.0;HDR=Yes'", path);
connection = new OleDbConnection();
connection.ConnectionString = excelConnectionString;
connection.Open();
DataTable table = new DataTable("Customers");
table = connection.GetOleDbSchemaTable(OleDbSchemaGuid.Tables, null);
String[] excelSheets = new String[table.Rows.Count];
int i = 0;

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

string query = "select * from" + Sheet;
OleDbCommand command = new OleDbCommand(query, connection);

DbDataReader dr = command.ExecuteReader();

table.Load(dr);

thanks problem solved

but if i used ClosedXML then it should be necessary that excel is installed on client system like interop.