| Line 21... |
Line 21... |
| 21 |
import javax.servlet.http.HttpServletRequest;
|
21 |
import javax.servlet.http.HttpServletRequest;
|
| 22 |
import javax.servlet.http.HttpSession;
|
22 |
import javax.servlet.http.HttpSession;
|
| 23 |
|
23 |
|
| 24 |
import org.apache.commons.io.FileUtils;
|
24 |
import org.apache.commons.io.FileUtils;
|
| 25 |
import org.apache.poi.hssf.usermodel.HSSFWorkbook;
|
25 |
import org.apache.poi.hssf.usermodel.HSSFWorkbook;
|
| - |
|
26 |
import org.apache.poi.ss.usermodel.Cell;
|
| 26 |
import org.apache.poi.ss.usermodel.Row;
|
27 |
import org.apache.poi.ss.usermodel.Row;
|
| 27 |
import org.apache.poi.ss.usermodel.Sheet;
|
28 |
import org.apache.poi.ss.usermodel.Sheet;
|
| 28 |
import org.apache.poi.ss.usermodel.Workbook;
|
29 |
import org.apache.poi.ss.usermodel.Workbook;
|
| 29 |
import org.apache.struts2.convention.annotation.InterceptorRef;
|
30 |
import org.apache.struts2.convention.annotation.InterceptorRef;
|
| 30 |
import org.apache.struts2.convention.annotation.InterceptorRefs;
|
31 |
import org.apache.struts2.convention.annotation.InterceptorRefs;
|
| Line 112... |
Line 113... |
| 112 |
logger.info("Last row number is:" + sheet.getLastRowNum());
|
113 |
logger.info("Last row number is:" + sheet.getLastRowNum());
|
| 113 |
for (Row row : sheet) {
|
114 |
for (Row row : sheet) {
|
| 114 |
if(row.equals(firstRow))
|
115 |
if(row.equals(firstRow))
|
| 115 |
continue;
|
116 |
continue;
|
| 116 |
logger.info("Row no. " + row.getRowNum());
|
117 |
logger.info("Row no. " + row.getRowNum());
|
| - |
|
118 |
row.getCell(0).setCellType(Cell.CELL_TYPE_STRING);
|
| 117 |
String awb = row.getCell(0).getStringCellValue();
|
119 |
String awb = row.getCell(0).getStringCellValue();
|
| - |
|
120 |
if(awb.length()==0)
|
| - |
|
121 |
break;
|
| - |
|
122 |
row.getCell(1).setCellType(Cell.CELL_TYPE_NUMERIC);
|
| 118 |
double collectedAmount = row.getCell(1).getNumericCellValue();
|
123 |
double collectedAmount = row.getCell(1).getNumericCellValue();
|
| 119 |
collectedAmountMap.put(awb, collectedAmount);
|
124 |
collectedAmountMap.put(awb, collectedAmount);
|
| 120 |
}
|
125 |
}
|
| 121 |
|
126 |
|
| 122 |
TransactionClient tsc = null;
|
127 |
TransactionClient tsc = null;
|