public DataTable transtorm(DataTable dt)
{
foreach (DataRow dr in dt.Rows)
{
foreach (DataColumn dc in dt.Columns)
{
if (dr[dc].ToString().Contains("E"))
{
try
{
double baseNum = float.Parse(dr[dc].ToString().Substring(0, dr[dc].ToString().IndexOf("E")));
double power = float.Parse(dr[dc].ToString().Substring(dr[dc].ToString().IndexOf("E") + 1));
double num = Math.Pow(10, power);
double recentNum = baseNum * num;
dr[dc] = Math.Round(recentNum, 2);
}
catch (Exception)
{
// throw; 对于包含E的非科学计数字段
}
}
}
}
return dt;
}
{
foreach (DataRow dr in dt.Rows)
{
foreach (DataColumn dc in dt.Columns)
{
if (dr[dc].ToString().Contains("E"))
{
try
{
double baseNum = float.Parse(dr[dc].ToString().Substring(0, dr[dc].ToString().IndexOf("E")));
double power = float.Parse(dr[dc].ToString().Substring(dr[dc].ToString().IndexOf("E") + 1));
double num = Math.Pow(10, power);
double recentNum = baseNum * num;
dr[dc] = Math.Round(recentNum, 2);
}
catch (Exception)
{
// throw; 对于包含E的非科学计数字段
}
}
}
}
return dt;
}