現在的代碼如下所述，在時間列和本次列下面我想第二條曲線讀取從第5行開始 怎么設定啊 大神們
private void button1_Click(object sender, EventArgs e)
{
OpenFileDialog fileDialog = new OpenFileDialog();
fileDialog.Multiselect = true;
fileDialog.Title = "請選擇檔案";
fileDialog.Filter = "所有檔案(*xls*)|*.xls*"; //設定要選擇的檔案的型別
if (fileDialog.ShowDialog() == DialogResult.OK)
{
string file = fileDialog.FileName;//回傳檔案的完整路徑
}
chart1.DataSource = dt;
chart1.DataBind();
string a, b;
dataSet1 = ExcelToDataSet(fileDialog.FileName);//讀取選取檔案
foreach (DataRow dr in dataSet1.Tables[0].Rows)
{
a = dr["時間"].ToString();
b = dr["本次"].ToString();
if (a == "")
{
break;
}
if (b == "")
{
break;
}
chart1.Series[0].Points.AddXY(Convert.ToString(a), Convert.ToString(b));
chart1.Series[1].Points.AddXY(Convert.ToString(a), Convert.ToString(b));
}
}
static public DataSet ExcelToDataSet(string filename)
{
DataSet ds;
string strCon = "Provider=Microsoft.Jet.OLEDB.4.0;" +
"Extended Properties=Excel 8.0;" +
"data source=" + filename;
OleDbConnection myConn = new OleDbConnection(strCon);
string strCom = " SELECT * FROM [工程資料表$A3:J1000]";
myConn.Open();
OleDbDataAdapter myCommand = new OleDbDataAdapter(strCom, myConn);
ds = new DataSet();
myCommand.Fill(ds);
myConn.Close();
return ds;
}
轉載請註明出處，本文鏈接：https://www.uj5u.com/houduan/41125.html
標籤：基礎類
上一篇：小白求解