public static List<KeyValuePair<string, string>> ReadExcelHead()
{
OpenFileDialog openFileDialog = new OpenFileDialog();
openFileDialog.Filter = "XLS file|*.xls|XLSX file|*.xlsx";
openFileDialog.CheckFileExists = true;
if (openFileDialog.ShowDialog() == DialogResult.OK)
{
List<KeyValuePair<string, string>> keyValuePairs = new List<KeyValuePair<string, string>>();
string filePath = openFileDialog.FileName;
//把xls文件读入workbook变量里,之后就可以关闭了
if (openFileDialog.FileName.EndsWith(".xlsx"))
{
var wk = new XSSFWorkbook(filePath);
ISheet sheet = wk.GetSheetAt(0);
int lastRowCount = sheet.LastRowNum;
for (int i = 0; i <= lastRowCount; i++)
{
IRow row = sheet.GetRow(i);
int cloumNum = row.LastCellNum;
if (cloumNum < 2)
{
continue;
}
keyValuePairs.Add(new KeyValuePair<string, string>(row.Cells[0].StringCellValue, row.Cells[1].StringCellValue));
}
}
else
{
using (FileStream fs = File.Open(filePath, FileMode.Open,
FileAccess.Read, FileShare.ReadWrite))
{
var wk = new HSSFWorkbook(fs);
fs.Close();
ISheet sheet = wk.GetSheetAt(0);
int lastRowCount = sheet.LastRowNum;
for (int i = 0; i <= lastRowCount; i++)
{
IRow row = sheet.GetRow(i);
int cloumNum = row.LastCellNum;
if (cloumNum < 2)
{
continue;
}
keyValuePairs.Add(new KeyValuePair<string, string>(row.Cells[0].StringCellValue, row.Cells[1].StringCellValue));
}
}
}
return keyValuePairs;
}
else
{
return null;
}
}
```
NPOI读取xls和xlsx格式
于 2022-09-29 11:14:43 首次发布