在項(xiàng)目中經(jīng)常遇到讀寫EXCEL文件的需求。其實(shí)讀取EXCEL很簡單, 首先使用命名空間NExcel,然后加載文件到Workbook,循環(huán)讀取就行了。
using NExcel;
Workbook wb = Workbook.getWorkbook(fileStream);
Sheet sheet = wb.Sheets[0];
int rowsCount = sheet.Rows;
for (int row = 2; row < rowsCount; row++)
{
string sheet.getCell(0, row).Contents;
decimal TotalPrice = Convert.ToDecimal(sheet.getCell(1, row).Value);
}