string FilePath = "C:\\Temp\\"; string FileName = "PLCTags.xlsx";
string FilePath = "C:\\Temp\\PLCTags.xlsx"";
string FilePath = @"C:\Temp\PLCTags.xlsx"";
leDbConnection olecon = new OleDbConnection();
OleDbCommand olecmd = new OleDbCommand();
string FilePath = @"C:\Temp\PLCTags.xlsx";
string connstring = ("Provider =Microsoft.ACE.OLEDB.12.0;" + ("Data Source=" + (FilePath +";" + "Extended Properties=\"Excel 12.0 Xml;HDR=YES;\"")));
olecon.ConnectionString = connstring;
olecon.Open();
olecmd.Connection = olecon;
string FEUILLE = "PLC Tags";
olecmd.CommandText = ("CREATE TABLE" + (FEUILLE + " (Name VARCHAR, Path VARCHAR, Data Type VARCHAR, Logical Address VARCHAR, Comment VARCHAR, Hmi Visible VARCHAR, Hmi Accessible VARCHAR)"));
olecmd.ExecuteNonQuery();
// ~~> Adding Data
// ~~> Close the connection
olecon.Close();
string FilePath = "C:\\Temp\\";
Vous n’avez pas trouvé la réponse que vous recherchez ?
Posez votre question
OleDbConnection MyConnection = default(OleDbConnection);
OleDbDataAdapter MyCommand = default(OleDbDataAdapter);
string FilePath = @"C:\Users\qmor\Desktop\PLCTags.xlsx";
MyConnection = new OleDbConnection("Provider = Microsoft.ACE.OLEDB.12.0; Data Source = " + FilePath + "; Extended Properties = 'Excel 12.0 XML;HDR=YES;'; ");
MyCommand = new OleDbDataAdapter("CREATE TABLE Sheet1 (F1 char(255), F2 char(255))", MyConnection);
MyConnection.Open();
//MyConnection.Close();
//Création fichier de sortie
string FilePath = @"C:\Users\qmor\Desktop\PLCTags.xlsx";
using (OleDbConnection conn = new OleDbConnection("Provider = Microsoft.ACE.OLEDB.12.0; Data Source = " + FilePath + "; Extended Properties = 'Excel 12.0 XML;HDR=YES;'; "))
{
conn.Open();
OleDbCommand cmd = new OleDbCommand();
cmd.Connection = conn;
cmd.CommandText = "CREATE TABLE table1 (id INT, name VARCHAR, [date col] DATE );";
cmd.ExecuteNonQuery();
cmd.CommandText = "INSERT INTO [table1](id,name,[date col]) VALUES(1,'AAAA','2014-01-01');";
cmd.ExecuteNonQuery();
cmd.CommandText = "INSERT INTO [table1](id,name,[date col]) VALUES(2, 'BBBB','2014-01-03');";
cmd.ExecuteNonQuery();
cmd.CommandText = "INSERT INTO [table1](id,name,[date col]) VALUES(3, 'CCCC','2014-01-03');";
cmd.ExecuteNonQuery();
cmd.CommandText = "UPDATE [table1] SET name = 'DDDD' WHERE id = 3;";
cmd.ExecuteNonQuery();
}