最近在使用C#对Excel进行操作,遇到了一些诡异的问题...
首先是一些代码,很容易看懂,实际上是用了一些SQL语句
这是写操作:
try
{
string strConn = "Provider=Microsoft.Jet.OLEDB.4.0;" + "Data Source=" + filePath + ";" + "Extended Properties=Excel 8.0;";
OleDbConnection conn = new OleDbConnection(strConn);
conn.Open();
System.Data.OleDb.OleDbCommand cmd = new OleDbCommand();
cmd.Connection = conn;
for (int i = 0; i < DataList.Count; i++)
{
DataStruct d = DataList[i];
string sql = "INSERT INTO [Sheet1$] (日期,时间,时刻,极端量,Pi,Pi开盘价,Pi最高价,Pi最低价,Pi结束价,Pj,P止盈,P止损,T止盈,T止损,类型) VALUES(";
//string sql = "INSERT INTO [Sheet1$] (Data,Tim,Ti,Q,Pi,PiOpen,PiMax,P