DataTable To EXCEL 问题
用DataTable To EXCEL 转出的身份证变成科学计数法，能否保持字符型；两位小数的 如何保持还是 两位的小数格式，十分郁闷，搞了两天也没有找出解决办法从网上找到一个贴说是可以解决，但是 程序里的 DataTable To EXCEL总是提示找不到，我是新手，想大家帮忙
看一下，帮忙解决，我快疯掉了：
static public void TableToExcel(string excel, DataTable tb,string tbname)
{
try
{
OleDbConnection connex = GetConnFromExcel(excel); //获取到excel文件的oledb连接
string ct = "CREATE TABLE " + tbname + " ("; //以下生成一个sql命令向excel中插入一个表
foreach (DataColumn clmn in tb.Columns)
{
switch (clmn.DataType.Name) //根据不同数据类型分别处理
{
case "Decimal":
ct += clmn.ColumnName + " Decimal,";
break;
case "Double":
ct += clmn.ColumnName + " Double,";
break;
default:
ct += clmn.ColumnName + " string,";
break;
}
}
ct = ct.Substring(0, ct.Length - 1) + ")";
OleDbCommand cmd1 = new OleDbCommand(ct, connex);
cmd1.ExecuteNonQuery(); //向excel中插入一个表
foreach (DataRow r in tb.Rows) //下面向excel中一行一行写入数据
{
string fs = "", vs = "";
foreach (DataColumn clmn in tb.Columns)
{
fs += clmn.ColumnName + ",";
if (r[clmn.ColumnName] == DBNull.Value)
{
vs += "null,";
continue;
}
switch (clmn.DataType.Name) //根据不同数据类型分别处理
{
case "Decimal":
vs += ((decimal)r[clmn.ColumnName]).ToString("0.00") + ",";
break;
case "Double":
vs += ((double)r[clmn.ColumnName]).ToString("0.00") + ",";
break;
case "DateTime":
vs += "'" + ((DateTime)r[clmn.ColumnName]).ToShortDateString() + "',";
break;
default:
vs += "'" + r[clmn.ColumnName].ToString() + "',";
break;
}
}
string sqlstr = "insert into [" + tbname + "$] (" + fs.Substring(0, fs.Length - 1) + ") values (" + vs.Substring(0, vs.Length - 1) + ")";
OleDbCommand cmd = new OleDbCommand(sqlstr, connex);
cmd.ExecuteNonQuery(); //向excel中插入数据
}
connex.Close();
}
catch (Exception e)
{
throw new Exception(e.Message);
}
} Excel Visual Studio 命令提示符
补充：.NET技术 , C#
