【#文档大全网# 导语】以下是®文档大全网的小编为您整理的《导入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