EPPlus
using OfficeOpenXml;
// 写入到 Excel 文件 string filePath = "C:\\Users\\Administrator\\Desktop\\output.xlsx"; ExcelPackage.License.SetNonCommercialPersonal("Dang"); using (ExcelPackage excelPackage = new ExcelPackage()) { ExcelWorksheet worksheet = excelPackage.Workbook.Worksheets.Add("Data"); int row = 1; int col = 1; for (int i = 0; i < positionLst.Count; i++) { worksheet.Cells[row, col++].Value = "棒"+(i+1); for (int j = 0; j < positionLst[i].Length; j++) { worksheet.Cells[row, col].Value = positionLst[i][j]; worksheet.Cells[row, col+1].Value = microwaveLst[i][j]; row++; } col += 3 ; row = 1; } FileInfo excelFile = new FileInfo(filePath); excelPackage.SaveAs(excelFile);
}

浙公网安备 33010602011771号