#region 给定目录读取数据 返回一个实体
public Air_Tightness_Test findData(String path)
{
Air_Tightness_Test a = new Air_Tightness_Test();
StringBuilder sbr = new StringBuilder();
using (FileStream fs = File.OpenRead(path)) //打开myxls.xls文件
{
HSSFWorkbook wk = new HSSFWorkbook(fs); //把xls文件中的数据写入wk中
for (int i = 0; i < wk.NumberOfSheets; i++) //NumberOfSheets是myxls.xls中总共的表数
{
ISheet sheet = wk.GetSheetAt(i); //读取当前表数据
for (int j = 0; j <= sheet.LastRowNum; j++) //LastRowNum 是当前表的总行数
{
IRow row = sheet.GetRow(j); //读取当前行数据
if (row != null)
{
sbr.Append("-------------------------------------\r\n"); //读取行与行之间的提示界限
public Air_Tightness_Test findData(String path)
{
Air_Tightness_Test a = new Air_Tightness_Test();
StringBuilder sbr = new StringBuilder();
using (FileStream fs = File.OpenRead(path)) //打开myxls.xls文件
{
HSSFWorkbook wk = new HSSFWorkbook(fs); //把xls文件中的数据写入wk中
for (int i = 0; i < wk.NumberOfSheets; i++) //NumberOfSheets是myxls.xls中总共的表数
{
ISheet sheet = wk.GetSheetAt(i); //读取当前表数据
for (int j = 0; j <= sheet.LastRowNum; j++) //LastRowNum 是当前表的总行数
{
IRow row = sheet.GetRow(j); //读取当前行数据
if (row != null)
{
sbr.Append("-------------------------------------\r\n"); //读取行与行之间的提示界限
for (int k = 0; k <= row.LastCellNum; k++) //LastCellNum 是当前行的总列数
{
ICell cell = row.GetCell(k); //当前表格
if (cell != null)
{
sbr.Append(cell.ToString()); //获取表格中的数据并转换为字符串类型
{
ICell cell = row.GetCell(k); //当前表格
if (cell != null)
{
sbr.Append(cell.ToString()); //获取表格中的数据并转换为字符串类型
}
if (j == 4 && k == 1)
{
//MessageBox.Show("检测单位:" + cell.ToString());//检测单位
a.Detection_unit = cell.ToString();
}
if (j == 4 && k == 5)
{
//MessageBox.Show("试验模式:" + cell.ToString());//试验模式
a.Test_pattern = cell.ToString();
}
if (j == 5 && k == 1)
{
//MessageBox.Show("检测项目:" + cell.ToString());//检测项目
a.test_item = cell.ToString();
}
if (j == 5 && k == 5)
{
//MessageBox.Show("保压压力(Kpa):" + cell.ToString());//检测项目
a.Holding_pressure = Convert.ToDecimal(cell.ToString());
}
if (j == 6 && k == 1)
{
//MessageBox.Show("产品序号:" + cell.ToString());
a.serial_number = cell.ToString();
}
if (j == 6 && k == 5)
{
//MessageBox.Show("保压时间(S):" + cell.ToString());
a.Holding_time = Convert.ToDecimal(cell.ToString());
}
if (j == 7 && k == 1)
{
//MessageBox.Show("检测人员:" + cell.ToString());
a.Inspection_personnel = cell.ToString();
}
if (j == 7 && k == 5)
{
//MessageBox.Show("气压下限(Kpa):" + cell.ToString());
a.Lower_pressure = Convert.ToDecimal(cell.ToString());
}
if (j == 8 && k == 1)
{
//MessageBox.Show(cell.DateCellValue.ToString());
a.Test_date = Convert.ToDateTime(cell.DateCellValue);
}
if (j == 8 && k == 5)
{
//MessageBox.Show("实际压降(Kpa):" + cell.ToString());
a.Actual_pressure_drop = Convert.ToDecimal(cell.ToString());
}
if (j == 9 && k == 1)
{
//MessageBox.Show("产品型号:" + cell.ToString());
a.Product_model = cell.ToString();
}
if (j == 9 && k == 5)
{
//MessageBox.Show("检测结果:" + cell.ToString());
a.detection_result = cell.ToString();
}
}
}
}
}
}
}
if (j == 8 && k == 5)
{
//MessageBox.Show("实际压降(Kpa):" + cell.ToString());
a.Actual_pressure_drop = Convert.ToDecimal(cell.ToString());
}
if (j == 9 && k == 1)
{
//MessageBox.Show("产品型号:" + cell.ToString());
a.Product_model = cell.ToString();
}
if (j == 9 && k == 5)
{
//MessageBox.Show("检测结果:" + cell.ToString());
a.detection_result = cell.ToString();
}
}
}
}
}
}
return a;
}
#endregion
#endregion