Npoi读取Excel代码,CSharp代码库,德仔网

代码语言

代码分类

【CSharp】 Npoi读取Excel

作者:Dezai.CN / 发布于2011/11/1/ 5654

<div>protected void Button1_Click(object sender, EventArgs e)
{
string strName = FileUpload1.FileName;
string strPath=Server.MapPath("/UploadFiles/"+FileUpload1.FileName);
FileUpload1.SaveAs(strPath);
if (File.Exists(strPath))
{
//根据路径通过已存在的excel来创建HSSFWorkbook，即整个excel文档
FileStream file = new FileStream(strPath, FileMode.Open, FileAccess.Read);

HSSFWorkbook workbook = new HSSFWorkbook(file);
//获取excel的第一个sheet
Sheet sheet = workbook.GetSheet("员工组");

DataTable table = new DataTable();
//获取sheet的首行
Row headerRow = sheet.GetRow(0);
//一行最后一个方格的编号 即总的列数
int cellCount = headerRow.LastCellNum;

for (int i = headerRow.FirstCellNum; i < cellCount; i++)
{
DataColumn column = new DataColumn(headerRow.GetCell(i).StringCellValue);
table.Columns.Add(column);
}
//最后一列的标号 即总的行数
int rowCount = sheet.LastRowNum;

for (int i = (sheet.FirstRowNum + 1); i < sheet.LastRowNum; i++)
{
Row row = sheet.GetRow(i);
DataRow dataRow = table.NewRow();

for (int j = row.FirstCellNum; j < cellCount; j++)
{
if (row.GetCell(j) != null)
dataRow[j] = row.GetCell(j).ToString();
}

table.Rows.Add(dataRow);
}

workbook = null;
sheet = null;
StringBuilder str=new StringBuilder("<table>");
str.Append("<tr>");
for (int i = 0; i < table.Columns.Count; i++)
{
str.Append("<td>"+table.Columns[i].ColumnName+"</td>");
}
str.Append("</tr>");
for (int i = 0; i < table.Rows.Count; i++)
{
str.Append("<tr>");
for (int j = 0; j < table.Columns.Count; j++)
{
str.Append("<td>" + table.Rows[i][j].ToString()+ "</td>");
}
str.Append("</tr>");
}
str.Append("</table>");
Response.Write(str.ToString());
Response.Write(table.Rows.Count.ToString());

}
}
</div>

试试其它关键字

　Npoi读取Excel　

同语言下

可能有用的

Dezai.CN贡献的其它代码(4037)