Пример #1
0
        private void WriteDetailSingleData(HSSFWorkbook wb, ICellStyle cellStyle, Items data,
                                           ISheet sheet1, int rowCount, int rowIndex, ICellStyle cellStyleData)
        {
            IRow row = sheet1.CreateRow(rowIndex);
            int  col = 0;

            NPOIWriter.createCellText(row, cellStyle, col++, data.ITEM_CODE);
            NPOIWriter.createCellText(row, cellStyle, col++, data.ITEM_NAME);
            NPOIWriter.createCellText(row, cellStyle, col++, data.ITEM_UM);

            sheet1.AutoSizeColumn(0);
        }
Пример #2
0
        private void WriteDetailSingleData(HSSFWorkbook wb, ICellStyle cellStyle, PakAnass data,
                                           ISheet sheet1, int rowCount, int rowIndex, ICellStyle cellStyleData)
        {
            IRow row = sheet1.CreateRow(rowIndex);
            int  col = 0;

            NPOIWriter.createCellText(row, cellStyle, col++, data.org_code);
            NPOIWriter.createCellText(row, cellStyle, col++, data.org_name);


            sheet1.AutoSizeColumn(0);
        }
Пример #3
0
        private void WriteDetailSingleData(HSSFWorkbook wb, ICellStyle cellStyle, Approval data,
                                           ISheet sheet1, int rowCount, int rowIndex, ICellStyle cellStyleData)
        {
            IRow row = sheet1.CreateRow(rowIndex);
            int  col = 0;

            NPOIWriter.createCellText(row, cellStyle, col++, data.po_no);
            NPOIWriter.createCellText(row, cellStyle, col++, data.pr_no);
            NPOIWriter.createCellText(row, cellStyle, col++, data.PO_DATE_STR);
            NPOIWriter.createCellText(row, cellStyle, col++, data.supplier_code);

            sheet1.AutoSizeColumn(0);
        }