| Line 595... |
Line 595... |
| 595 |
weightStyle.setDataFormat(createHelper.createDataFormat().getFormat("0.000"));
|
595 |
weightStyle.setDataFormat(createHelper.createDataFormat().getFormat("0.000"));
|
| 596 |
|
596 |
|
| 597 |
|
597 |
|
| 598 |
|
598 |
|
| 599 |
Row headerRow = sheet.createRow((short)0);
|
599 |
Row headerRow = sheet.createRow((short)0);
|
| 600 |
int i = -1;
|
600 |
int i = 0;
|
| 601 |
headerRow.createCell(i++).setCellValue("Airwaybill");
|
601 |
headerRow.createCell(i++).setCellValue("Airwaybill");
|
| 602 |
headerRow.createCell(i++).setCellValue("Type"); //Values : "COD" / "NONCOD"
|
602 |
headerRow.createCell(i++).setCellValue("Type"); //Values : "COD" / "NONCOD"
|
| 603 |
headerRow.createCell(i++).setCellValue("Reference Number"); //OrderId
|
603 |
headerRow.createCell(i++).setCellValue("Reference Number"); //OrderId
|
| 604 |
headerRow.createCell(i++).setCellValue("Sender / Store name"); //"Spice Online retail pvt ltd"
|
604 |
headerRow.createCell(i++).setCellValue("Sender / Store name"); //"Spice Online retail pvt ltd"
|
| 605 |
headerRow.createCell(i++).setCellValue("attention"); //Customer name
|
605 |
headerRow.createCell(i++).setCellValue("attention"); //Customer name
|
| Line 638... |
Line 638... |
| 638 |
// 22 Length ( Cms ) 23 Breadth ( Cms ) 24 Height ( Cms )
|
638 |
// 22 Length ( Cms ) 23 Breadth ( Cms ) 24 Height ( Cms )
|
| 639 |
// 25 Pieces 26 Area_customer_code 27 Handover Date ( DD/MM/YYYY ) 28 Handover Time ( 24 hrs format )
|
639 |
// 25 Pieces 26 Area_customer_code 27 Handover Date ( DD/MM/YYYY ) 28 Handover Time ( 24 hrs format )
|
| 640 |
|
640 |
|
| 641 |
serialNo++;
|
641 |
serialNo++;
|
| 642 |
Row contentRow = sheet.createRow((short)serialNo);
|
642 |
Row contentRow = sheet.createRow((short)serialNo);
|
| 643 |
i=-1;
|
643 |
i=0;
|
| 644 |
contentRow.createCell(i++).setCellValue(awbDetail.getAwbNumber());
|
644 |
contentRow.createCell(i++).setCellValue(awbDetail.getAwbNumber());
|
| 645 |
contentRow.createCell(i++).setCellValue(awbDetail.getPaymentMode().equals("COD") ? "COD" : "NONCOD");
|
645 |
contentRow.createCell(i++).setCellValue(awbDetail.getPaymentMode().equals("COD") ? "COD" : "NONCOD");
|
| 646 |
contentRow.createCell(i++).setCellValue(awbDetail.getMasterOrderId());
|
646 |
contentRow.createCell(i++).setCellValue(awbDetail.getMasterOrderId());
|
| 647 |
contentRow.createCell(i++).setCellValue("Hotspot Sales & Solutions Pvt Ltd");
|
647 |
contentRow.createCell(i++).setCellValue("Hotspot Sales & Solutions Pvt Ltd");
|
| 648 |
contentRow.createCell(i++).setCellValue(awbDetail.getCustomerName());
|
648 |
contentRow.createCell(i++).setCellValue(awbDetail.getCustomerName());
|