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);
}
}