Subversion Repositories SmartDukaan

Rev

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

Rev 21242 Rev 21244
Line 11... Line 11...
11
import java.util.ArrayList;
11
import java.util.ArrayList;
12
import java.util.HashMap;
12
import java.util.HashMap;
13
import java.util.List;
13
import java.util.List;
14
import java.util.Map;
14
import java.util.Map;
15
 
15
 
-
 
16
import org.apache.poi.hssf.usermodel.HSSFCell;
16
import org.apache.poi.hssf.usermodel.HSSFSheet;
17
import org.apache.poi.hssf.usermodel.HSSFSheet;
17
import org.apache.poi.hssf.usermodel.HSSFWorkbook;
18
import org.apache.poi.hssf.usermodel.HSSFWorkbook;
-
 
19
import org.apache.poi.ss.usermodel.DataFormatter;
18
import org.slf4j.Logger;
20
import org.slf4j.Logger;
19
import org.slf4j.LoggerFactory;
21
import org.slf4j.LoggerFactory;
20
 
22
 
21
import com.google.gwt.user.client.ui.TextBox;
-
 
22
 
23
 
23
public class ProcessBulkBilling{
24
public class ProcessBulkBilling{
24
	private static  Logger logger = LoggerFactory.getLogger(ProcessBulkBilling.class);
25
	private static  Logger logger = LoggerFactory.getLogger(ProcessBulkBilling.class);
25
 
26
 
26
	private String fileName;
27
	private String fileName;
Line 43... Line 44...
43
		try{
44
		try{
44
 
45
 
45
			FileInputStream iFile = new FileInputStream(new File(fileName));
46
			FileInputStream iFile = new FileInputStream(new File(fileName));
46
			HSSFWorkbook workbook = new HSSFWorkbook(iFile);
47
			HSSFWorkbook workbook = new HSSFWorkbook(iFile);
47
			HSSFSheet sheet = workbook.getSheetAt(0);
48
			HSSFSheet sheet = workbook.getSheetAt(0);
48
 
-
 
-
 
49
			DataFormatter formatter = new DataFormatter();
49
			for (int iterator=sheet.getFirstRowNum()+1;iterator<=sheet.getLastRowNum();iterator++){
50
			for (int iterator=sheet.getFirstRowNum()+1;iterator<=sheet.getLastRowNum();iterator++){
-
 
51
				HSSFCell imei_cell = sheet.getRow(iterator).getCell(0);
50
				String imei = (sheet.getRow(iterator).getCell(0).getStringCellValue()).trim();
52
				String imei = formatter.formatCellValue(imei_cell).trim();
51
				if (imei == null || imei.isEmpty()){
53
				if (imei == null || imei.isEmpty()){
52
					break;
54
					break;
53
				}
55
				}
54
				if (imei_list.contains(imei)){
56
				if (imei_list.contains(imei)){
55
					return false;
57
					return false;