WebSVN – SmartDukaan – Diff – /trunk/profitmandi-common/src/main/java/com/spice/profitmandi/common/util/ExcelUtils.java



		sheet.trackAllColumnsForAutoSizing();
 
		Row rowHeader = sheet.createRow(0);
 
		Cell cellPoDateHeader = rowHeader.createCell(1);
		cellPoDateHeader.setCellValue("GRN_Date");
 
		Cell cellSupplierNameHeader = rowHeader.createCell(2);
		cellSupplierNameHeader.setCellValue("Supplier_Name");
 
		Cell cellSupplierStateHeader = rowHeader.createCell(3);

			PurchaseInvoiceModel purchaseInvoiceModel = purchaseInvoiceModels.get(index);
 
			Row rowValues = sheet.createRow(index + 1);
 
			Cell cellPoDate = rowValues.createCell(1);
			cellPoDate.setCellValue(String.valueOf(purchaseInvoiceModel.getFormattedGrnDate()));
 
			Cell cellSupplierName = rowValues.createCell(2);
			cellSupplierName.setCellValue(purchaseInvoiceModel.getSupplierName());
 
			Cell cellSupplierState = rowValues.createCell(3);

Subversion Repositories SmartDukaan

(root)/trunk/profitmandi-common/src/main/java/com/spice/profitmandi/common/util/ExcelUtils.java – Rev 34574 → 34588

Rev 34574		Rev 34588
Line 980...		Line 980...
980	`sheet.trackAllColumnsForAutoSizing();`	980	`sheet.trackAllColumnsForAutoSizing();`
981		981
982	`Row rowHeader = sheet.createRow(0);`	982	`Row rowHeader = sheet.createRow(0);`
983		983
984	`Cell cellPoDateHeader = rowHeader.createCell(1);`	984	`Cell cellPoDateHeader = rowHeader.createCell(1);`
985	`cellPoDateHeader.setCellValue("PoDate");`	985	`cellPoDateHeader.setCellValue("GRN_Date");`
986		986
987	`Cell cellSupplierNameHeader = rowHeader.createCell(2);`	987	`Cell cellSupplierNameHeader = rowHeader.createCell(2);`
988	`cellSupplierNameHeader.setCellValue("Supplier_Name");`	988	`cellSupplierNameHeader.setCellValue("Supplier_Name");`
989		989
990	`Cell cellSupplierStateHeader = rowHeader.createCell(3);`	990	`Cell cellSupplierStateHeader = rowHeader.createCell(3);`
Line 1078...		Line 1078...
1078	`PurchaseInvoiceModel purchaseInvoiceModel = purchaseInvoiceModels.get(index);`	1078	`PurchaseInvoiceModel purchaseInvoiceModel = purchaseInvoiceModels.get(index);`
1079		1079
1080	`Row rowValues = sheet.createRow(index + 1);`	1080	`Row rowValues = sheet.createRow(index + 1);`
1081		1081
1082	`Cell cellPoDate = rowValues.createCell(1);`	1082	`Cell cellPoDate = rowValues.createCell(1);`
1083	`cellPoDate.setCellValue(String.valueOf(purchaseInvoiceModel.getFormattedPoDate()));`	1083	`cellPoDate.setCellValue(String.valueOf(purchaseInvoiceModel.getFormattedGrnDate()));`
1084		1084
1085	`Cell cellSupplierName = rowValues.createCell(2);`	1085	`Cell cellSupplierName = rowValues.createCell(2);`
1086	`cellSupplierName.setCellValue(purchaseInvoiceModel.getSupplierName());`	1086	`cellSupplierName.setCellValue(purchaseInvoiceModel.getSupplierName());`
1087		1087
1088	`Cell cellSupplierState = rowValues.createCell(3);`	1088	`Cell cellSupplierState = rowValues.createCell(3);`