List of usage examples for org.apache.poi.hssf.usermodel HSSFWorkbook getSheetAt
@Override public HSSFSheet getSheetAt(int index)
From source file:fr.ens.transcriptome.aozan.io.CasavaDesignXLSReader.java
License:Open Source License
@Override public CasavaDesign read() throws IOException { // create a POIFSFileSystem object to read the data final POIFSFileSystem fs = new POIFSFileSystem(this.is); // Create a workbook out of the input stream final HSSFWorkbook wb = new HSSFWorkbook(fs); // Get a reference to the worksheet final HSSFSheet sheet = wb.getSheetAt(0); // When we have a sheet object in hand we can iterator on // each sheet's rows and on each row's cells. final Iterator<Row> rows = sheet.rowIterator(); final List<String> fields = new ArrayList<>(); while (rows.hasNext()) { final HSSFRow row = (HSSFRow) rows.next(); final Iterator<Cell> cells = row.cellIterator(); while (cells.hasNext()) { final HSSFCell cell = (HSSFCell) cells.next(); while (fields.size() != cell.getColumnIndex()) { fields.add(""); }//from w w w. j a va 2 s .com // Convert cell value to String fields.add(parseCell(cell)); } // Parse the fields if (!isFieldsEmpty(fields)) { parseLine(fields); } fields.clear(); } this.is.close(); return getDesign(); }
From source file:fr.inria.teap.dcnsacfgeneration.tools.XLSInjector.java
License:Open Source License
public Workbook inject(HSSFWorkbook xlsWorkbook) { Workbook workbook = XlsFactory.eINSTANCE.createWorkbook(); for (int i = 0; i < xlsWorkbook.getNumberOfSheets(); i++) { Sheet xlsSheet = xlsWorkbook.getSheetAt(i); workbook.getWb_worksheets().add(inject(xlsSheet)); }//from ww w .ja v a 2 s . co m return workbook; }
From source file:fr.univrouen.poste.services.ExcelParser.java
License:Apache License
public List<List<String>> getCells(InputStream xslFileInput) { List<List<String>> cellVectorHolder = new Vector<List<String>>(); try {/* w w w . j a v a 2 s. c o m*/ POIFSFileSystem fileSystem = new POIFSFileSystem(xslFileInput); HSSFWorkbook workBook = new HSSFWorkbook(fileSystem); HSSFSheet sheet = workBook.getSheetAt(0); Iterator<Row> rowIter = sheet.rowIterator(); while (rowIter.hasNext()) { HSSFRow myRow = (HSSFRow) rowIter.next(); List<String> cellStoreVector = new Vector<String>(); // take care of blank cell ! // @see http://stackoverflow.com/questions/4929646/how-to-get-an-excel-blank-cell-value-in-apache-poi int max = myRow.getLastCellNum(); for (int i = 0; i < max; i++) { HSSFCell myCell = (HSSFCell) myRow.getCell(i, Row.CREATE_NULL_AS_BLANK); if (Cell.CELL_TYPE_STRING == myCell.getCellType()) cellStoreVector.add(myCell.getStringCellValue()); else if ((Cell.CELL_TYPE_NUMERIC == myCell.getCellType())) cellStoreVector.add(Long.toString(new Double(myCell.getNumericCellValue()).longValue())); else if ((Cell.CELL_TYPE_BLANK == myCell.getCellType())) cellStoreVector.add(""); else { logger.debug("This cell is not numeric or string ... : " + myCell + " \n ... cellType : " + myCell.getCellType()); cellStoreVector.add(""); } } cellVectorHolder.add(cellStoreVector); } } catch (Exception e) { logger.error("Error during parsing the XSL File", e); throw new RuntimeException("Error during parsing the XSL File", e); } return cellVectorHolder; }
From source file:framework.retrieval.engine.index.create.impl.file.parse.ExcelFileContentParser.java
License:Apache License
public String getContent(RFileDocument document, String charsetName) { InputStream fileInputStream = null; StringBuffer content = new StringBuffer(); try {/*ww w.j a va 2 s. c om*/ fileInputStream = new FileInputStream(document.getFile()); HSSFWorkbook workbook = new HSSFWorkbook(fileInputStream);// Excel if (workbook != null) { int numSheetsNumber = workbook.getNumberOfSheets(); for (int numSheets = 0; numSheets < numSheetsNumber; numSheets++) { HSSFSheet aSheet = workbook.getSheetAt(numSheets);// sheet if (aSheet != null) { int lastRowNum = aSheet.getLastRowNum(); for (int rowNumOfSheet = 0; rowNumOfSheet <= lastRowNum; rowNumOfSheet++) { HSSFRow aRow = aSheet.getRow(rowNumOfSheet); // if (aRow != null) { int lastCellNum = aRow.getLastCellNum(); for (int cellNumOfRow = 0; cellNumOfRow <= lastCellNum; cellNumOfRow++) { HSSFCell aCell = aRow.getCell(cellNumOfRow);// if (aCell != null) { int cellType = aCell.getCellType(); if (cellType == HSSFCell.CELL_TYPE_STRING) { String value = StringClass.getString(aCell.getStringCellValue()); content.append(value); } } } } } } } } } catch (Exception e) { RetrievalUtil.errorLog(log, document.getFile().getAbsolutePath(), e); } finally { if (fileInputStream != null) { try { fileInputStream.close(); } catch (Exception e) { } } } return content.toString(); }
From source file:fsart.diffTools.gui.DiffToolsMainPanel.java
License:CeCILL license
private void appendExcelSheetInJList(String excelFile, JList listfic) { log.debug("Enter append excel sheet with " + excelFile); String type = Helper.getTypeOfFile(excelFile); Vector<String> emptyList = new Vector<String>(); listfic.setListData(emptyList);/* www.j ava2s . c o m*/ log.debug("type of file : " + type); if (type.equals("xls")) { InputStream inp = null; try { inp = new FileInputStream(excelFile); HSSFWorkbook wb = new HSSFWorkbook(inp); int sheetNb = wb.getNumberOfSheets(); if (sheetNb > 0) { Vector<String> sheetnames = new Vector<String>(); for (int i = 0; i < sheetNb; i++) { Sheet sheet = wb.getSheetAt(i); sheetnames.addElement(sheet.getSheetName()); log.debug("I find : " + sheet.getSheetName()); } listfic.setListData(sheetnames); } } catch (Exception e) { } } }
From source file:gatebass.utils.exel.POIExcelReader.java
/** * 41 This method is used to display the Excel content to command line. 42 * * * @param xlsPath//ww w . j a va 2 s . com */ @SuppressWarnings("unchecked") public void displayFromExcel(String xlsPath) { // end_row = 2242; InputStream inputStream = null; try { inputStream = new FileInputStream(xlsPath); } catch (FileNotFoundException e) { System.out.println("File not found in the specified path."); e.printStackTrace(); } POIFSFileSystem fileSystem = null; int dd = 0; try { fileSystem = new POIFSFileSystem(inputStream); HSSFWorkbook workBook = new HSSFWorkbook(fileSystem); HSSFSheet sheet = workBook.getSheetAt(0); Iterator rows = sheet.rowIterator(); List<Individuals> individualses = new ArrayList<>(); while (rows.hasNext()) { HSSFRow row = (HSSFRow) rows.next(); // if (row.getRowNum() >= end_row) { // break; // } if (row.getRowNum() <= start_row) { continue; } dd = row.getRowNum(); // if (row.getRowNum() == 0 // || row.getRowNum() < 195 || row.getRowNum() > 250 // ) { // continue; // } Individuals individuals = null; // display row number in the console. // System.out.println("Row No.: " + row.getRowNum()); // once get a row its time to iterate through cells. Iterator cells = row.cellIterator(); while (cells.hasNext()) { HSSFCell cell = (HSSFCell) cells.next(); // System.out.println("Cell No.: " + cell.getCellNum()); /* * Now we will get the cell type and display the values * accordingly. */ switch (cell.getCellNum()) { case 0: individuals = new Individuals(); // individuals = new Individuals(Integer.parseInt(cell.getRichStringCellValue().getString())); break; case 1: try { individuals.setCard_id(((long) cell.getNumericCellValue()) + ""); } catch (Exception e) { } try { individuals.setCard_id(cell.getRichStringCellValue().getString()); } catch (Exception e) { } break; // case 2: // if (!cell.getRichStringCellValue().getString().isEmpty()) { // } // break; case 3: if (!cell.getRichStringCellValue().getString().isEmpty()) { individuals.setFirst_name(cell.getRichStringCellValue().getString()); } break; case 4: if (!cell.getRichStringCellValue().getString().isEmpty()) { individuals.setLast_name(cell.getRichStringCellValue().getString()); } break; case 6: try { individuals.setNational_id(((long) cell.getNumericCellValue()) + ""); } catch (Exception e) { } try { individuals.setNational_id(cell.getRichStringCellValue().getString()); } catch (Exception e) { } break; case 10: if (!cell.getRichStringCellValue().getString().isEmpty()) { individuals.setFirst_name_ENG(cell.getRichStringCellValue().getString()); } break; case 16: try { individuals.setPostal_code(((long) cell.getNumericCellValue()) + ""); } catch (Exception e) { } try { individuals.setPostal_code(cell.getRichStringCellValue().getString()); } catch (Exception e) { } break; case 17: try { individuals.setId_number(((long) cell.getNumericCellValue()) + ""); } catch (Exception e) { } try { individuals.setId_number(cell.getRichStringCellValue().getString()); } catch (Exception e) { } break; case 18: if (!cell.getRichStringCellValue().getString().isEmpty()) { individuals.setBirth_day(databaseHelper.historyDao.getFirst("date", cell.getRichStringCellValue().getString().substring(2))); } break; case 19: if (!cell.getRichStringCellValue().getString().isEmpty()) { individuals.setFather_first_name(cell.getRichStringCellValue().getString()); } break; case 20: if (!cell.getRichStringCellValue().getString().isEmpty()) { individuals.setBirth_state(cell.getRichStringCellValue().getString()); } break; case 21: if (!cell.getRichStringCellValue().getString().isEmpty()) { individuals.setIssued(cell.getRichStringCellValue().getString()); } break; case 22: if (!cell.getRichStringCellValue().getString().isEmpty()) { individuals.setStreet_address(cell.getRichStringCellValue().getString()); } break; case 23: String ss = cell.getRichStringCellValue().getString(); individuals.setVeteran_status(BEDONE_KART); if (!ss.isEmpty()) { if (ss.contains("?")) { individuals.setVeteran_status(MOAF); } else if (ss.contains("")) { individuals.setVeteran_status(PAYAN_KHEDMAT); } } break; case 25: try { individuals.setMobile(((long) cell.getNumericCellValue()) + ""); } catch (Exception e) { } try { individuals.setMobile(cell.getRichStringCellValue().getString()); } catch (Exception e) { } break; case 26: if (!cell.getRichStringCellValue().getString().isEmpty()) { individuals.setAcademic_degree(cell.getRichStringCellValue().getString()); } break; case 27: if (!cell.getRichStringCellValue().getString().isEmpty()) { individuals.setField_of_study(cell.getRichStringCellValue().getString()); } break; case 28: if (!cell.getRichStringCellValue().getString().isEmpty()) { individuals.setReligion(cell.getRichStringCellValue().getString()); } break; case 34: if (!cell.getRichStringCellValue().getString().isEmpty()) { individuals.setHave_soe_pishine(true); } break; case 35: if (!cell.getRichStringCellValue().getString().isEmpty()) { individuals.setComments(cell.getRichStringCellValue().getString()); } break; } switch (cell.getCellType()) { case HSSFCell.CELL_TYPE_NUMERIC: { // cell type numeric. // System.out.println("Numeric value: " + cell.getNumericCellValue()); break; } case HSSFCell.CELL_TYPE_STRING: { // cell type string. HSSFRichTextString richTextString = cell.getRichStringCellValue(); // System.out.println("String value: " + richTextString.getString()); break; } default: { // types other than String and Numeric. // System.out.println("Type not supported."); break; } } } String split = FileSystems.getDefault().getSeparator(); individuals.setFilesPatch( "data" + split + "1394" + split + dd / 50 + split + individuals.getNational_id() + split); File imageFile = new File( "d://test//Images-Personal-Gatepass//" + individuals.getCard_id() + ".jpg"); if (imageFile.exists()) { individuals.setPicture_address(individuals.getNational_id() + "-pic"); copyImageFile(imageFile.getAbsolutePath(), server + individuals.getFilesPatch(), individuals.getPicture_address()); individuals.setPicture_address( individuals.getPicture_address() + getFileExtension(imageFile.getAbsolutePath())); } individualses.add(individuals); // databaseHelper.individualsDao.createOrUpdate(individuals, dd); } databaseHelper.individualsDao.insertList(individualses); } catch (Exception e) { e.printStackTrace(); } }
From source file:gatebass.utils.exel.POIExcelReader.java
@SuppressWarnings("unchecked") public void compnaiesFromExcel(String xlsPath) { InputStream inputStream = null; try {/* www. j a v a 2s . com*/ inputStream = new FileInputStream(xlsPath); } catch (FileNotFoundException e) { System.out.println("File not found in the specified path."); e.printStackTrace(); } POIFSFileSystem fileSystem = null; try { fileSystem = new POIFSFileSystem(inputStream); HSSFWorkbook workBook = new HSSFWorkbook(fileSystem); HSSFSheet sheet = workBook.getSheetAt(0); Iterator rows = sheet.rowIterator(); boolean check = false; while (rows.hasNext()) { check = false; HSSFRow row = (HSSFRow) rows.next(); // if (row.getRowNum() >= end_row) { // break; // } if (row.getRowNum() <= start_row) { continue; } Companies companies = new Companies(); // System.out.println("Row No.: " + row.getRowNum()); String companyName = row.getCell(2).getRichStringCellValue().getString(); if (!companyName.isEmpty()) { Companies companiesTEMP = databaseHelper.companiesDao.getFirst("company_fa", companyName); if (companiesTEMP == null) { check = true; companies.setCompany_fa(companyName); companies.setActive(true); } } else { continue; } try { String companyNameEn = row.getCell(9).getRichStringCellValue().getString(); if (!companyNameEn.isEmpty()) { Companies companiesTEMP = databaseHelper.companiesDao.getFirst("company_en", companyNameEn); if (companiesTEMP == null) { companies.setCompany_en(companyNameEn); } } } catch (Exception e) { } if (check) { // companieses.add(companies); Manage mm = databaseHelper.manageDao.getFirst("key", "company_folder_count"); int jj = Integer.parseInt(mm.getValue()); companies.setFolder_name("C" + jj); databaseHelper.companiesDao.createOrUpdate(companies); ++jj; mm.setValue(jj + ""); databaseHelper.manageDao.createOrUpdate(mm); } } // databaseHelper.companiesDao.insertList(companieses); } catch (Exception e) { Logger.getLogger(POIExcelReader.class.getName()).log(Level.SEVERE, e.getMessage(), e); } }
From source file:gatebass.utils.exel.POIExcelReader.java
@SuppressWarnings("unchecked") public void historyFromExcel(String xlsPath) { InputStream inputStream = null; try {//from ww w . j a v a 2 s . c o m inputStream = new FileInputStream(xlsPath); } catch (FileNotFoundException e) { System.out.println("File not found in the specified path."); e.printStackTrace(); } POIFSFileSystem fileSystem = null; try { fileSystem = new POIFSFileSystem(inputStream); HSSFWorkbook workBook = new HSSFWorkbook(fileSystem); HSSFSheet sheet = workBook.getSheetAt(0); Iterator rows = sheet.rowIterator(); boolean check; List<History> historys = new ArrayList<>(); while (rows.hasNext()) { check = false; HSSFRow row = (HSSFRow) rows.next(); if (row.getRowNum() <= start_row) { continue; } History historyH = null; // System.out.println("Row No.: " + row.getRowNum()); String history = ""; try { history = row.getCell(7).getRichStringCellValue().getString(); if (!history.isEmpty()) { history = history.substring(2); History HistoryTEMP = databaseHelper.historyDao.getFirst("date", history); if (HistoryTEMP == null) { check = true; historyH = new History(history.substring(0, history.indexOf("/")), history.substring(history.indexOf("/") + 1, history.lastIndexOf("/")), history.substring(history.lastIndexOf("/") + 1)); } } if (check) { historys.add(historyH); // databaseHelper.historyDao.createOrUpdate(historyH); } } catch (Exception e) { } check = false; historyH = null; history = ""; try { history = row.getCell(18).getRichStringCellValue().getString(); if (!history.isEmpty()) { history = history.substring(2); History HistoryTEMP = databaseHelper.historyDao.getFirst("date", history); if (HistoryTEMP == null) { check = true; historyH = new History(history.substring(0, history.indexOf("/")), history.substring(history.indexOf("/") + 1, history.lastIndexOf("/")), history.substring(history.lastIndexOf("/") + 1)); } } if (check) { historys.add(historyH); // databaseHelper.historyDao.createOrUpdate(historyH); } } catch (Exception e) { } check = false; historyH = null; history = ""; try { history = row.getCell(24).getRichStringCellValue().getString(); if (!history.isEmpty()) { history = history.substring(2); History HistoryTEMP = databaseHelper.historyDao.getFirst("date", history); if (HistoryTEMP == null) { check = true; historyH = new History(history.substring(0, history.indexOf("/")), history.substring(history.indexOf("/") + 1, history.lastIndexOf("/")), history.substring(history.lastIndexOf("/") + 1)); } } if (check) { historys.add(historyH); // databaseHelper.historyDao.createOrUpdate(historyH); } } catch (Exception e) { } check = false; historyH = null; history = ""; try { history = row.getCell(29).getRichStringCellValue().getString(); if (!history.isEmpty()) { history = history.substring(2); History HistoryTEMP = databaseHelper.historyDao.getFirst("date", history); if (HistoryTEMP == null) { check = true; historyH = new History(history.substring(0, history.indexOf("/")), history.substring(history.indexOf("/") + 1, history.lastIndexOf("/")), history.substring(history.lastIndexOf("/") + 1)); } } if (check) { historys.add(historyH); // databaseHelper.historyDao.createOrUpdate(historyH); } } catch (Exception e) { } check = false; historyH = null; history = ""; try { history = row.getCell(30).getRichStringCellValue().getString(); if (!history.isEmpty()) { history = history.substring(2); History HistoryTEMP = databaseHelper.historyDao.getFirst("date", history); if (HistoryTEMP == null) { check = true; historyH = new History(history.substring(0, history.indexOf("/")), history.substring(history.indexOf("/") + 1, history.lastIndexOf("/")), history.substring(history.lastIndexOf("/") + 1)); } } if (check) { historys.add(historyH); // databaseHelper.historyDao.createOrUpdate(historyH); } } catch (Exception e) { } check = false; historyH = null; history = ""; try { history = row.getCell(31).getRichStringCellValue().getString(); if (!history.isEmpty()) { history = history.substring(2); History HistoryTEMP = databaseHelper.historyDao.getFirst("date", history); if (HistoryTEMP == null) { check = true; historyH = new History(history.substring(0, history.indexOf("/")), history.substring(history.indexOf("/") + 1, history.lastIndexOf("/")), history.substring(history.lastIndexOf("/") + 1)); } } if (check) { historys.add(historyH); // databaseHelper.historyDao.createOrUpdate(historyH); } } catch (Exception e) { } check = false; historyH = null; history = ""; try { history = row.getCell(32).getRichStringCellValue().getString(); if (!history.isEmpty()) { history = history.substring(2); History HistoryTEMP = databaseHelper.historyDao.getFirst("date", history); if (HistoryTEMP == null) { check = true; historyH = new History(history.substring(0, history.indexOf("/")), history.substring(history.indexOf("/") + 1, history.lastIndexOf("/")), history.substring(history.lastIndexOf("/") + 1)); } } if (check) { historys.add(historyH); // databaseHelper.historyDao.createOrUpdate(historyH); } } catch (Exception e) { } check = false; historyH = null; history = ""; try { history = row.getCell(33).getRichStringCellValue().getString(); if (!history.isEmpty()) { history = history.substring(2); History HistoryTEMP = databaseHelper.historyDao.getFirst("date", history); if (HistoryTEMP == null) { check = true; historyH = new History(history.substring(0, history.indexOf("/")), history.substring(history.indexOf("/") + 1, history.lastIndexOf("/")), history.substring(history.lastIndexOf("/") + 1)); } } if (check) { historys.add(historyH); // databaseHelper.historyDao.createOrUpdate(historyH); } } catch (Exception e) { } } databaseHelper.historyDao.insertList(historys); } catch (Exception e) { e.printStackTrace(); } }
From source file:gatebass.utils.exel.POIExcelReader.java
@SuppressWarnings("unchecked") public void worksFromExcel(String xlsPath) { InputStream inputStream = null; try {/*w w w. java 2 s.co m*/ inputStream = new FileInputStream(xlsPath); } catch (FileNotFoundException e) { System.out.println("File not found in the specified path."); e.printStackTrace(); } POIFSFileSystem fileSystem = null; List<WorkHistory> historys = new ArrayList<>(); try { fileSystem = new POIFSFileSystem(inputStream); HSSFWorkbook workBook = new HSSFWorkbook(fileSystem); HSSFSheet sheet = workBook.getSheetAt(0); Iterator rows = sheet.rowIterator(); boolean check = false; while (rows.hasNext()) { check = false; HSSFRow row = (HSSFRow) rows.next(); // if (row.getRowNum() >= end_row) { // break; // } if (row.getRowNum() <= start_row) { continue; } WorkHistory workHistory = new WorkHistory(); // System.out.println("Row No.: " + row.getRowNum()); String row_value = row.getCell(2).getRichStringCellValue().getString(); if (!row_value.isEmpty()) { Companies companiesTEMP = databaseHelper.companiesDao.getFirst("company_fa", row_value); String ss1 = companiesTEMP.getCompany_fa(); if (ss1.equals(" ") || ss1.equals(" ") || ss1.equals(" ") || ss1.equals(" ") || ss1.equals(" ")) { workHistory.setGate_type(WorkHistory.EMPLOYER); } else { workHistory.setGate_type(WorkHistory.CONTRACTOR); } workHistory.setCompanies(companiesTEMP); } row_value = row.getCell(5).getRichStringCellValue().getString(); if (!row_value.isEmpty()) { workHistory.setJobTitle(row_value); } try { row_value = row.getCell(7).getRichStringCellValue().getString(); if (!row_value.isEmpty()) { row_value = row_value.substring(2); History HistoryTEMP = databaseHelper.historyDao.getFirst("date", row_value); workHistory.setCardExpirationDateId(HistoryTEMP); } } catch (Exception e) { } try { row_value = row.getCell(11).getRichStringCellValue().getString(); if (!row_value.isEmpty()) { workHistory.setJobTitleENG(row_value); } } catch (Exception e) { } try { row_value = row.getCell(24).getRichStringCellValue().getString(); if (!row_value.isEmpty()) { row_value = row_value.substring(2); History HistoryTEMP = databaseHelper.historyDao.getFirst("date", row_value); workHistory.setEmploymentDateId(HistoryTEMP); } } catch (Exception e) { } try { row_value = row.getCell(29).getRichStringCellValue().getString(); if (!row_value.isEmpty()) { row_value = row_value.substring(2); History HistoryTEMP = databaseHelper.historyDao.getFirst("date", row_value); workHistory.setCardIssuedDateId(HistoryTEMP); } } catch (Exception e) { } try { row_value = row.getCell(30).getRichStringCellValue().getString(); if (!row_value.isEmpty()) { row_value = row_value.substring(2); History HistoryTEMP = databaseHelper.historyDao.getFirst("date", row_value); workHistory.setCardIssuedDateId(HistoryTEMP); } } catch (Exception e) { } try { row_value = row.getCell(31).getRichStringCellValue().getString(); if (!row_value.isEmpty()) { row_value = row_value.substring(2); History HistoryTEMP = databaseHelper.historyDao.getFirst("date", row_value); workHistory.setCardIssuedDateId(HistoryTEMP); } } catch (Exception e) { } try { row_value = row.getCell(33).getRichStringCellValue().getString(); if (!row_value.isEmpty()) { row_value = row_value.substring(2); History HistoryTEMP = databaseHelper.historyDao.getFirst("date", row_value); workHistory.setCardDeliveryDate(HistoryTEMP); } } catch (Exception e) { } // System.out.println("Row No.: " + row.getRowNum() + " CardDelivery.: " + (workHistory.getCardDeliveryDate() == null ? "null" : workHistory.getCardDeliveryDate().getDate())); try { row_value = ((long) row.getCell(6).getNumericCellValue()) + ""; if (!row_value.isEmpty()) { Individuals individuals = databaseHelper.individualsDao.getFirst("national_id", row_value); workHistory.setIndividualsId(individuals); } } catch (Exception e) { } try { row_value = row.getCell(6).getRichStringCellValue().getString(); if (!row_value.isEmpty()) { Individuals individuals = databaseHelper.individualsDao.getFirst("national_id", row_value); workHistory.setIndividualsId(individuals); } } catch (Exception e) { } historys.add(workHistory); // databaseHelper.manageDao.createOrUpdate(mm); } databaseHelper.workHistoryDao.insertList(historys); } catch (Exception e) { Logger.getLogger(POIExcelReader.class.getName()).log(Level.SEVERE, e.getMessage(), e); } }
From source file:gatebass.utils.exel.POIExcelReader.java
@SuppressWarnings("unchecked") public void compnaiesFromExcel2(String xlsPath) { InputStream inputStream = null; try {//w w w . j av a 2 s . com inputStream = new FileInputStream(xlsPath); } catch (FileNotFoundException e) { System.out.println("File not found in the specified path."); e.printStackTrace(); } POIFSFileSystem fileSystem = null; try { fileSystem = new POIFSFileSystem(inputStream); HSSFWorkbook workBook = new HSSFWorkbook(fileSystem); HSSFSheet sheet = workBook.getSheetAt(0); Iterator rows = sheet.rowIterator(); boolean check = false; while (rows.hasNext()) { check = false; HSSFRow row = (HSSFRow) rows.next(); // if (row.getRowNum() >= end_row) { // break; // } if (row.getRowNum() <= start_row) { continue; } Companies companies = new Companies(); // System.out.println("Row No.: " + row.getRowNum()); String companyName = row.getCell(2).getRichStringCellValue().getString(); if (!companyName.isEmpty()) { Companies companiesTEMP = databaseHelper.companiesDao.getFirst("company_fa", companyName); if (companiesTEMP == null) { check = true; companies.setCompany_fa(companyName); companies.setActive(true); } } else { continue; } try { String companyNameEn = row.getCell(9).getRichStringCellValue().getString(); if (!companyNameEn.isEmpty()) { // Companies companiesTEMP = databaseHelper.companiesDao.getFirst("company_en", companyNameEn); // if (companiesTEMP == null) { // companies.setCompany_en(companyNameEn); // } } } catch (Exception e) { } if (check) { // companieses.add(companies); Manage mm = databaseHelper.manageDao.getFirst("key", "company_folder_count"); int jj = Integer.parseInt(mm.getValue()); companies.setFolder_name("C" + jj); databaseHelper.companiesDao.createOrUpdate(companies); ++jj; mm.setValue(jj + ""); databaseHelper.manageDao.createOrUpdate(mm); } } // databaseHelper.companiesDao.insertList(companieses); } catch (Exception e) { Logger.getLogger(POIExcelReader.class.getName()).log(Level.SEVERE, e.getMessage(), e); } }