导入excel成功aspose

【#文档大全网# 导语】以下是®文档大全网的小编为您整理的《导入excel成功aspose》，欢迎阅读！

//导入excel

public static object[,] ReadExcel(String strFileName)

{

Workbook book = new Workbook(strFileName);

Worksheet sheet = book.Worksheets[0];

Cells cells = sheet.Cells;

var tempCells = cells.ExportArray(0, 0, cells.MaxDataRow + 1, cells.MaxDataColumn + 1);

object[] objTemp = new object[tempCells.GetLength(1)];

for (int i = 1; i <= 4; i++)

{

for (int j = 0; j < tempCells.GetLength(0); j++)

{

if (tempCells[j, i] != null)

objTemp[i] = tempCells[j, i];

else

tempCells[j, i] = objTemp[i];

if (tempCells[j, i] == null)

tempCells[j, i] = "";

}

}

for (int i = 5; i < tempCells.GetLength(1); i++)

{

for (int j = 0; j < tempCells.GetLength(0); j++)

{

if (tempCells[j, i] == null)

tempCells[j, i] = "";

}

}

return tempCells;

}

//导入excel

private void btnInExcel_Click(object sender, EventArgs e)

{

// ExportToExcel.ReadExcel(strFileName);

OpenFileDialog frm = new OpenFileDialog();

frm.Filter = "Excel文件(*.xls,xlsx)|*.xls;*.xlsx";

if (frm.ShowDialog() == DialogResult.OK)

{

string excelName = frm.FileName;

//Workbook excel = new Workbook(excelName);

//List<string[]> importyString = GetImportExcelRoute(excel);

//AsposeExcel.ExcelToDatatalbe();

var result= ExportToExcel.ReadExcel(excelName);

int columnCount = result.GetLength(1);

int rowCount = result.GetLength(0);

int start = 1;

for (int i = 3; i < rowCount; i++)

{

DBHelper.InsertSeries(result[i, 0 + start].ToString(), result[i, 1 + start].ToString(), result[i, 2 + start].ToString(), result[i, 3 + start].ToString(), result[i, 5 + start].ToString(), result[i, 4 + start].ToString(), result[i, 6 + start].ToString() == "" ? 0 : Convert.ToInt32(result[i, 6 + start].ToString()), result[i, 7 + start] == "" ? 0 : Convert.ToInt32(result[i, 7 + start].ToString()), result[i, 8 + start].ToString(), DateTime.Now);

}

}

}

本文来源：https://www.wddqxz.cn/d7d781a2b1717fd5360cba1aa8114431b90d8e7c.html