Salve mi serve aiuto, non so cosa mettere in command.text dove sta scritto sheet, grazie in anticipo
codice:
DataTable dt = new DataTable();
string fileName = @"C:\Users\Domenico.DESKTOP-KDBNQN1\Downloads\prova.xlt";
using (OleDbConnection conn = new OleDbConnection())
{
conn.ConnectionString = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" + fileName + ";" + "Extended Properties='Excel 8.0;HDR=YES;'";
using (OleDbCommand comm = new OleDbCommand())
{
comm.CommandText = "SELECT Id,Nome,Cognome FROM[Sheet1$]";
comm.Connection = conn;
using (OleDbDataAdapter da = new OleDbDataAdapter())
{
da.SelectCommand = comm;
da.Fill(dt);
}
}
}
}