int failcount = 0;
int successcount = 0;
if (db != null && db.Rows.Count > 0)
{
foreach (DataRow dr in db.Rows)
{
string mobile = dr["手机号码"].ToString().Trim();
string truename = dr["姓名"].ToString().Trim();
string iskejizhuanyuan = dr["科技专员"].ToString().Trim();
string sex = dr["性别"].ToString().Trim();
/// <summary>
/// Excel文件导成Datatable
/// </summary>
/// <param name="strFilePath">Excel文件目录地址</param>
/// <param name="strTableName">Datatable表名</param>
/// <param name="iSheetIndex">Excel sheet index</param>
/// <returns></returns>
public static DataTable ExcelToDataTable(string strFilePath, string strTableName, int iSheetIndex)
{
var strExtName = Path.GetExtension(strFilePath); var dt = new DataTable();
if (!string.IsNullOrEmpty(strTableName))
{
dt.TableName = strTableName;
}
if (strExtName.Equals(".xls"))
{
using (var file = new FileStream(strFilePath, FileMode.Open, FileAccess.Read))
{
var workbook = new HSSFWorkbook(file);
var sheet = workbook.GetSheetAt(iSheetIndex);
//列头
foreach (var item in sheet.GetRow(sheet.FirstRowNum).Cells)
{
dt.Columns.Add(item.ToString(), typeof(string));
}
//写入内容
var rows = sheet.GetRowEnumerator();
while (rows.MoveNext())
{
IRow row = (HSSFRow)rows.Current;
if (row.RowNum == sheet.FirstRowNum)
{
continue;
}
var dr = dt.NewRow();
foreach (var item in row.Cells)
{
switch (item.CellType)
{
case CellType.Boolean:
dr[item.ColumnIndex] = item.BooleanCellValue;
break;
case CellType.Error:
dr[item.ColumnIndex] = ErrorEval.GetText(item.ErrorCellValue);
break;
case CellType.Formula:
switch (item.CachedFormulaResultType)
{
case CellType.Boolean:
dr[item.ColumnIndex] = item.BooleanCellValue;
break;
case CellType.Error:
dr[item.ColumnIndex] = ErrorEval.GetText(item.ErrorCellValue);
break;
case CellType.Numeric:
if (DateUtil.IsCellDateFormatted(item))
{
dr[item.ColumnIndex] = item.DateCellValue.ToString("yyyy-MM-dd hh:MM:ss");
}
else
{
dr[item.ColumnIndex] = item.NumericCellValue;
}
break;
case CellType.String:
var str = item.StringCellValue;
if (!string.IsNullOrEmpty(str))
{
dr[item.ColumnIndex] = str;
}
else
{
dr[item.ColumnIndex] = null;
}
break;
