读取excel中的数据,按一定的数据格式写入:
static void Main(string[] args)
{
string connStr = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" + "C:/svm.xls" + ";Extended Properties='Excel 8.0;HDR=False;IMEX=1'";
StreamWriter wriStr = new StreamWriter("C:/vod1.txt", true, System.Text.Encoding.UTF8);
using(OleDbConnection conn = new OleDbConnection(connStr))
{
conn.Open();
string cmdText = "select * from [训练集$A:HI]"; //训练集 为表名;A,HI为列名
OleDbCommand cmd=new OleDbCommand(cmdText,conn);
using (OleDbDataReader dr = cmd.ExecuteReader())
{
while (dr.Read())
{
for (int i = -1; i <= 215; i++)
{
if (i != -1) wriStr.Write((i * 10 + 350).ToString() + ":");
wriStr.Write( dr[i+1].ToString());//dr[0]为可读出的第1行
wriStr.Write(" ");
}
wriStr.Write("/r/n");
}
}
}
wriStr.Close();
}
excel文件:
生成的txt文件: