static void Handle(DataSet ds)
{
DataTable dt = ds.Tables[0];
//Header项
//foreach (DataColumn dc in dt.Rows[1].Table.Columns)
//{
// //MessageBox.Show(row[dc].ToString());
// GLog.D(dc.ColumnName);
//}
////遍历
////列项
//foreach (DataRow row in dt.Rows)
//{
// //横项
// foreach (DataColumn dc in row.Table.Columns)
// {
// GLog.D(row[dc].ToString());
// }
//}
//列项
foreach (DataRow row in dt.Rows)
{
var regCode = row["注册代码"].ToString();
var startTime = row["故障发生时间"].ToString();
var endTime = row["故障恢复时间"].ToString();
//横项
foreach (DataColumn dc in row.Table.Columns)
{
if (dc.ColumnName.Equals("是否困人"))
{
GLog.D(row[dc].ToString());
}
if (dc.ColumnName.Equals("处置信息"))
{
GLog.D(row[dc].ToString());
}
}
}
}//static void Handle(DataSet ds)
static void Main(string[] args)
{
string path = "d:\\tmp\\1.xlsx";
string path2 = "d:\\tmp\\1_tr.xlsx";
//Util.WriteExcelFile();
//Util.DF();
//Util.Up();
Util.UpdateExcel(path);
Console.ReadLine();
return;
var dt = Util.ExcelToDS(path);
GLog.D("" + dt);
//Handle(dt);
//Util.DSToExcel(path, dt);
Util.ExcuteSQL(dt, "Sheet1", path2);
Console.ReadLine();
}
