/// <summary> /// 从第1行填值 /// </summary> /// <param name="sheet"></param> private void SetValueByRow(ref ISheet sheet, TrayInfoInExcel trayInfoInExcel, ICellStyle style) { int nextRowNum = sheet.LastRowNum + 1; IRow sheetRow = sheet.CreateRow(nextRowNum); int column = 0; ICell cell = sheetRow.CreateCell(column); //创建Excel的ICell单元格实例 cell.SetCellValue(nextRowNum); cell.CellStyle = style; //单元格格式 column++; cell = sheetRow.CreateCell(column); //创建Excel的ICell单元格实例 cell.SetCellValue(trayInfoInExcel.sn); //赋值 sn cell.CellStyle = style; //单元格格式 column++; cell = sheetRow.CreateCell(column); //创建Excel的ICell单元格实例 cell.SetCellValue(trayInfoInExcel.imei); //赋值 imei cell.CellStyle = style; //单元格格式 column++; cell = sheetRow.CreateCell(column); //创建Excel的ICell单元格实例 //cell.SetCellValue(casingInfoList[i].station); //赋值 eid cell.SetCellValue(trayInfoInExcel.eid); cell.CellStyle = style; //单元格格式 column++; cell = sheetRow.CreateCell(column); //创建Excel的ICell单元格实例 cell.SetCellValue(trayInfoInExcel.iccid); //赋值 iccid cell.CellStyle = style; //单元格格式 column++; cell = sheetRow.CreateCell(column); //创建Excel的ICell单元格实例 cell.SetCellValue(trayInfoInExcel.cuatomerName); //cell.SetCellValue(casingInfoList[i].factory); //赋值 客户名称 cell.CellStyle = style; //单元格格式 }
public int ExportExcelOneByOne(TrayInfoInExcel trayInfoInExcel) { int ret = -1; //获取excel文件信息 FileInfo file = new FileInfo(excelFullName); //检测文件是否存在 if (!File.Exists(excelFullName)) { if (CreatExcel() != 0) { return(ret); } } else { file.IsReadOnly = false; } HSSFWorkbook workbook = null; try { using (FileStream fs1 = File.OpenRead(excelFullName)) { workbook = new HSSFWorkbook(fs1); //实例化Excel工作薄类 ISheet sheet = workbook.GetSheet("Sheet1"); ICellStyle cellstyle = workbook.CreateCellStyle(); //设置垂直居中 cellstyle.Alignment = NPOI.SS.UserModel.HorizontalAlignment.Center; //SetValueByRow中自动设序号 +1 //int rowCount = sheet.LastRowNum; //trayInfoInExcel.num = rowCount; //设定值 SetValueByRow(ref sheet, trayInfoInExcel, cellstyle); SetSheetAutoSize(ref sheet); fs1.Close(); using (FileStream fs2 = File.OpenWrite(excelFullName)) { workbook.Write(fs2); workbook.Close(); } ret = 0; } } catch (Exception ex) { MessageBox.Show(ex.ToString()); } finally { if (workbook != null) { workbook.Close(); } file.IsReadOnly = true; } return(ret); }