如何得到excel值非科学计数法形式?
string table0 = textBox1.Text.Trim();
string strConnection = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" + table0 + ";Extended Properties=\"Excel 8.0;HDR=No;IMEX=1\";";
OleDbConnection objConnection = new OleDbConnection(strConnection);
objConnection.Open();
OleDbDataAdapter myCommandd = new OleDbDataAdapter("select * from [招生信息$]", objConnection);
DataSet ds = new DataSet();
myCommandd.Fill(ds, "[招生信息$]");
System.Data.DataTable dt = ds.Tables["[招生信息$]"];
for (int i = 2; i < dt.Rows.Count; i++)
{
string xsname = ds.Tables["[招生信息$]"].Rows[i][0].ToString();//excel表中学生姓名
string xszkzh = ds.Tables["[招生信息$]"].Rows[i][5].ToString();//excel表中学生中考证号
}
这里得到的xszkzh是科学计数法形式,但excel表中的数字是文本形式。如何操作,使xszkzh是excel表中数值?