Subversion Repositories SmartDukaan

Rev

Rev 4209 | Go to most recent revision | Show entire file | Ignore whitespace | Details | Blame | Last modification | View Log | RSS feed

Rev 4209 Rev 13452
Line 87... Line 87...
87 
	    // Create the header row and put all the titles in it. Rows are 0 based.
 87 
	    // Create the header row and put all the titles in it. Rows are 0 based.
88 
	    Row headerRow = sheet.createRow((short)0);
 88 
	    Row headerRow = sheet.createRow((short)0);
89 
	    headerRow.createCell(0).setCellValue("Sl No");
 89 
	    headerRow.createCell(0).setCellValue("Sl No");
90 
	    headerRow.createCell(1).setCellValue("AWB No");
 90 
	    headerRow.createCell(1).setCellValue("AWB No");
91 
	    headerRow.createCell(2).setCellValue("AWB Date");
 91 
	    headerRow.createCell(2).setCellValue("AWB Date");
92 
	    headerRow.createCell(3).setCellValue("Order No");
 92 
	    headerRow.createCell(3).setCellValue("Saholic Order Id");
93 
	    headerRow.createCell(4).setCellValue("Name");
 93 
	    headerRow.createCell(4).setCellValue("Name");
94 
	    headerRow.createCell(5).setCellValue("Address 1");
 94 
	    headerRow.createCell(5).setCellValue("Address 1");
95 
	    headerRow.createCell(6).setCellValue("Address 2");
 95 
	    headerRow.createCell(6).setCellValue("Address 2");
96 
	    headerRow.createCell(7).setCellValue("City");
 96 
	    headerRow.createCell(7).setCellValue("City");
97 
	    headerRow.createCell(8).setCellValue("State");
 97 
	    headerRow.createCell(8).setCellValue("State");
Line 117... Line 117...
117 
		    	contentRow.createCell(0).setCellValue(serialNo);
 117 
		    	contentRow.createCell(0).setCellValue(serialNo);
118 
			    contentRow.createCell(1).setCellValue(cells.get(1).getStringCellValue());
 118 
			    contentRow.createCell(1).setCellValue(cells.get(1).getStringCellValue());
119
119
120 
			    Cell awbDateCell = contentRow.createCell(2);
 120 
			    Cell awbDateCell = contentRow.createCell(2);
121 
			    awbDateCell.setCellValue(cells.get(2).getDateCellValue());
 121 
			    awbDateCell.setCellValue(cells.get(2).getDateCellValue());
122 
			    awbDateCell.setCellStyle(dateCellStyle);
122 
			    awbDateCell.setCellStyle(dateCellStyle);
- 
 
 123 
			    if(cells.get(3).getCellType()==Cell.CELL_TYPE_NUMERIC){
123 
			    contentRow.createCell(3).setCellValue(cells.get(3).getNumericCellValue());
 124 
			    	contentRow.createCell(3).setCellValue(cells.get(3).getNumericCellValue());
- 
 
 125 
			    }
- 
 
 126 
			    if(cells.get(3).getCellType()==Cell.CELL_TYPE_STRING){
- 
 
 127 
			    	contentRow.createCell(3).setCellValue(cells.get(3).getStringCellValue());
- 
 
 128 
			    }
124 
			    contentRow.createCell(4).setCellValue(cells.get(4).getStringCellValue());
 129 
			    contentRow.createCell(4).setCellValue(cells.get(4).getStringCellValue());
125 
			    contentRow.createCell(5).setCellValue(cells.get(5).getStringCellValue());
 130 
			    contentRow.createCell(5).setCellValue(cells.get(5).getStringCellValue());
126 
			    contentRow.createCell(6).setCellValue(cells.get(6).getStringCellValue());
 131 
			    contentRow.createCell(6).setCellValue(cells.get(6).getStringCellValue());
127 
			    contentRow.createCell(7).setCellValue(cells.get(7).getStringCellValue());
 132 
			    contentRow.createCell(7).setCellValue(cells.get(7).getStringCellValue());
128 
			    contentRow.createCell(8).setCellValue(cells.get(8).getStringCellValue());
 133 
			    contentRow.createCell(8).setCellValue(cells.get(8).getStringCellValue());
Line 130... Line 135...
130 
			    contentRow.createCell(10).setCellValue(cells.get(10).getStringCellValue());
 135 
			    contentRow.createCell(10).setCellValue(cells.get(10).getStringCellValue());
131 
			    contentRow.createCell(11).setCellValue("-");
 136 
			    contentRow.createCell(11).setCellValue("-");
132 
			    contentRow.createCell(12).setCellValue(cells.get(12).getStringCellValue());
 137 
			    contentRow.createCell(12).setCellValue(cells.get(12).getStringCellValue());
133 
			    contentRow.createCell(13).setCellValue(cells.get(13).getNumericCellValue());
 138 
			    contentRow.createCell(13).setCellValue(cells.get(13).getNumericCellValue());
134 
			    contentRow.createCell(14).setCellValue(cells.get(14).getNumericCellValue());
 139 
			    contentRow.createCell(14).setCellValue(cells.get(14).getNumericCellValue());
135 
			    contentRow.createCell(15).setCellValue(cells.get(15).getNumericCellValue());
 - 
 
136 
			    Cell weightCell = contentRow.createCell(16);
 140 
			    Cell weightCell = contentRow.createCell(15);
137 
			    weightCell.setCellValue(cells.get(16).getNumericCellValue());
 141 
			    weightCell.setCellValue(cells.get(15).getNumericCellValue());
138 
			    weightCell.setCellStyle(weightStyle);
 142 
			    weightCell.setCellStyle(weightStyle);
- 
 
 143 
			    contentRow.createCell(16).setCellValue(cells.get(16).getStringCellValue());
139 
			    contentRow.createCell(17).setCellValue(cells.get(17).getStringCellValue());
 144 
			    contentRow.createCell(17).setCellValue(cells.get(17).getStringCellValue());
140 
			    contentRow.createCell(18).setCellValue(cells.get(18).getStringCellValue());
 145 
			    contentRow.createCell(18).setCellValue(cells.get(18).getStringCellValue());
141 
			    contentRow.createCell(19).setCellValue(cells.get(19).getStringCellValue());
 - 
 
142 
		    }
 146 
		    }
143 
	    }
147 
	    }
144 
		// Write the workbook to the output stream
 148 
		// Write the workbook to the output stream
145 
		try {
 149 
		try {
146 
			wb.write(baosXLS);
 150 
			wb.write(baosXLS);