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;