public void WriteDetail(HSSFWorkbook wb, ISheet sheet1, int startRow, ICellStyle cellStyleHeader, ICellStyle cellStyleData, IList <PakAnass> employeeList) { int rowIdx = startRow; int itemCount = 0; NPOIWriter.CreateSingleColHeader(wb, sheet1, 0, 0, cellStyleHeader, "org_code"); NPOIWriter.CreateSingleColHeader(wb, sheet1, 0, 1, cellStyleHeader, "org_name"); rowIdx = 1; foreach (PakAnass st in employeeList) { WriteDetailSingleData(wb, cellStyleData, st, sheet1, ++itemCount, rowIdx++, cellStyleData); } }
public void WriteDetail(HSSFWorkbook wb, ISheet sheet1, int startRow, ICellStyle cellStyleHeader, ICellStyle cellStyleData, IList <Items> ItemList) { int rowIdx = startRow; int itemCount = 0; NPOIWriter.CreateSingleColHeader(wb, sheet1, 0, 0, cellStyleHeader, "Item Code"); NPOIWriter.CreateSingleColHeader(wb, sheet1, 0, 1, cellStyleHeader, "Item Name"); NPOIWriter.CreateSingleColHeader(wb, sheet1, 0, 2, cellStyleHeader, "Item Um"); rowIdx = 1; foreach (Items st in ItemList) { WriteDetailSingleData(wb, cellStyleData, st, sheet1, ++itemCount, rowIdx++, cellStyleData); } }
public void WriteDetail(HSSFWorkbook wb, ISheet sheet1, int startRow, ICellStyle cellStyleHeader, ICellStyle cellStyleData, IList <Approval> PoList) { int rowIdx = startRow; int itemCount = 0; NPOIWriter.CreateSingleColHeader(wb, sheet1, 0, 0, cellStyleHeader, "Purchase Order No"); NPOIWriter.CreateSingleColHeader(wb, sheet1, 0, 1, cellStyleHeader, "Purchase Repeat No"); NPOIWriter.CreateSingleColHeader(wb, sheet1, 0, 2, cellStyleHeader, "Purchase Order Date"); NPOIWriter.CreateSingleColHeader(wb, sheet1, 0, 3, cellStyleHeader, "Supplier Code"); rowIdx = 1; foreach (Approval st in PoList) { WriteDetailSingleData(wb, cellStyleData, st, sheet1, ++itemCount, rowIdx++, cellStyleData); } }