更新时间:2023-10-03 16:25:58
有关最小代码您可以使用NPOI将Excel文件转换为数据集:
Here's about the minimum code you can use to convert an Excel file to a DataSet using NPOI:
IWorkbook workbook;
using (var stream = new FileStream(excelFilePath, FileMode.Open, FileAccess.Read))
{
workbook = new HSSFWorkbook(stream); // XSSFWorkbook for XLSX
}
var sheet = workbook.GetSheetAt(0); // zero-based index of your target sheet
var dataTable = new DataTable(sheet.SheetName);
// write the header row
var headerRow = sheet.GetRow(0);
foreach (var headerCell in headerRow)
{
dataTable.Columns.Add(headerCell.ToString());
}
// write the rest
for(int i = 1; i< sheet.PhysicalNumberOfRows; i++)
{
var sheetRow = sheet.GetRow(i);
var dtRow = dataTable.NewRow();
dtRow.ItemArray = dataTable.Columns
.Cast<DataColumn>()
.Select(c => sheetRow.GetCell(c.Ordinal, MissingCellPolicy.CREATE_NULL_AS_BLANK).ToString())
.ToArray();
dataTable.Rows.Add(dtRow);
}