List of usage examples for org.apache.poi.xssf.usermodel XSSFWorkbook XSSFWorkbook
public XSSFWorkbook(PackagePart part) throws IOException
From source file:Algorithm.Method2.java
public String[] MethodTest(String Path) { StringBuffer keyword1 = new StringBuffer(); try {//from w w w . ja va2 s . co m /** * ??excel * src * map? * result */ String srcFilePath = Path; String mapFilePath = "??.xlsx"; String newFilePath = Path.replace("???.xlsx", "method2.xlsx"); FileInputStream srcFile = new FileInputStream(new File(srcFilePath)); FileInputStream mapFile = new FileInputStream(new File(mapFilePath)); XSSFWorkbook srcWorkbook = new XSSFWorkbook(srcFile); XSSFWorkbook mapWorkbook = new XSSFWorkbook(mapFile); XSSFWorkbook newWorkbook = new XSSFWorkbook(); XSSFSheet srcSheet = srcWorkbook.getSheetAt(0); XSSFSheet mapSheet = mapWorkbook.getSheetAt(0); XSSFSheet newSheet = newWorkbook.createSheet("test"); Iterator<Row> srcRowIterator = srcSheet.iterator(); Iterator<Row> mapRowIterator = mapSheet.iterator(); //map.xlst???mapList ArrayList mapList = new ArrayList(); while (mapRowIterator.hasNext()) { Row row = mapRowIterator.next(); Iterator<Cell> cellIterator = row.cellIterator(); while (cellIterator.hasNext()) { Cell cell = cellIterator.next(); String test = cell.getStringCellValue(); mapList.add(test); } } //???mapArray,? int mapListLength = mapList.size(); String[] mapArray = (String[]) mapList.toArray(new String[mapListLength]); //??mapResult,mapArray?src //,mapArray[i]src,mapResult[i]1?0 int[] mapResult = new int[mapListLength]; for (int i = 0; i < mapListLength; i++) { mapResult[i] = 0; } //?src.xlsx,?mapArray while (srcRowIterator.hasNext()) { Row row = srcRowIterator.next(); Iterator<Cell> cellIterator = row.cellIterator(); while (cellIterator.hasNext()) { Cell cell = cellIterator.next(); String test = cell.getStringCellValue().trim(); for (int i = 0; i < mapListLength; i++) { if (test.equals(mapArray[i])) mapResult[i] = 1; } } } //?mapResult,mapArrayresult int newRowNum = 0; for (int i = mapListLength - 1; i >= 0; i--) { if (mapResult[i] == 1) { Row newRow = newSheet.createRow(newRowNum++); Cell newCell = newRow.createCell(0); String test = mapArray[i]; keyword1.append(test + " "); newCell.setCellValue(test); } } srcFile.close(); mapFile.close(); //FileOutputStream fileOut = new FileOutputStream(new File(newFilePath)); // newWorkbook.write(fileOut); // fileOut.close(); // System.out.print("method2"); } catch (Exception e) { System.out.println(e); } return keyword1.toString().split(" "); }
From source file:Algorithm.SegmentationAndNounFilter.java
public String[] SegmentationNounFilter(String filepath, String filename) { try {/* ww w .j a va2s. com*/ String mingciPath = filepath.replace(filename, "???.xlsx"); ICTCLAS50 testICTCLAS50 = new ICTCLAS50(); String argu = "."; if (testICTCLAS50.ICTCLAS_Init(argu.getBytes("GB2312")) == false) { System.out.println("Init Fail"); } else { System.out.println("Init Succeed!"); } StringBuffer input = new StringBuffer(); FileInputStream file = new FileInputStream(new File(filepath)); XSSFWorkbook workbook = new XSSFWorkbook(file); XSSFSheet sheet1 = workbook.getSheetAt(0); Iterator<Row> rowIterator = sheet1.iterator(); while (rowIterator.hasNext()) { Row row = rowIterator.next(); //Row rowNew =sheetNew.createRow(rowNumNew++); //For each row, iterate through all the columns Iterator<Cell> cellIterator = row.cellIterator(); while (cellIterator.hasNext()) { Cell cell = cellIterator.next(); // Cell cellNew =rowNew.createCell(cellNumNew++); //Check the cell type and format accordingly switch (cell.getCellType()) { case Cell.CELL_TYPE_NUMERIC: break; case Cell.CELL_TYPE_STRING: input.append(cell.getStringCellValue()); } } //System.out.println(""); } //? byte nativeBytes[] = testICTCLAS50.ICTCLAS_ParagraphProcess(input.toString().getBytes("GB2312"), 0, 1); String nativeStr = new String(nativeBytes, 0, nativeBytes.length, "GB2312"); //xlsx XSSFWorkbook workbookNew = new XSSFWorkbook(); XSSFSheet sheetNew = workbookNew.createSheet("test"); int rowNum = 0; // WritableWorkbook book = Workbook.createWorkbook(new File("n.xls")); // WritableSheet sheet = book.createSheet("num1", 0); Scanner in = new Scanner(nativeStr); int i = 0;// while (in.hasNext()) { String ss = in.next(); Pattern pattern = Pattern.compile("(.+?)/n.*"); Matcher matcher = pattern.matcher(ss); if (matcher.find() && matcher.group(1).length() > 1 && !isDigit(matcher.group(1))) { //label = new jxl.write.Label(0, i, matcher.group(1));//? //sheet.addCell(label); Row rowNew = sheetNew.createRow(rowNum++); Cell cellNew = rowNew.createCell(0); cellNew.setCellValue(matcher.group(1)); //i++; } } // book.write(); // book.close(); FileOutputStream fileOut = new FileOutputStream(new File(mingciPath));//new file workbookNew.write(fileOut); fileOut.close(); //?? file.close(); testICTCLAS50.ICTCLAS_Exit(); } catch (Exception ex) { } return null; }
From source file:algoritmos.Recorte.java
private static ArrayList<String> buscarDni(String dni) { String dn = null;/* w w w . jav a 2s . co m*/ ArrayList<String> lstDni = new ArrayList<String>(); double d = -1; int nd = Integer.parseInt(dni); int ubigeo = 0, max = 0; try { // InputStream ExcelFileToRead = new FileInputStream("C:/Users/Raul/Desktop/inf226.2016.1._06.proyecto/registro.nacional.v.1.xlsx"); InputStream ExcelFileToRead = new FileInputStream(Recorte.rutaGeneral); XSSFWorkbook wb = new XSSFWorkbook(ExcelFileToRead); XSSFSheet sheet = wb.getSheetAt(0); XSSFRow row; XSSFCell cell; Iterator rows = sheet.rowIterator(); row = (XSSFRow) rows.next(); while (rows.hasNext()) { row = (XSSFRow) rows.next(); Iterator cells = row.cellIterator(); int i = 0; while (cells.hasNext()) { cell = (XSSFCell) cells.next(); if (i == 2) { d = cell.getNumericCellValue(); int num = (int) d; dn = num + ""; int v = comparaString(dn, dni); if (v > max) { lstDni = new ArrayList<String>(); lstDni.add(dn); max = v; } else if (v == max) { lstDni.add(dn); } break; } i++; } i = 0; } } catch (FileNotFoundException ex) { Logger.getLogger(Recorte.class.getName()).log(Level.SEVERE, null, ex); } catch (IOException ex) { Logger.getLogger(Recorte.class.getName()).log(Level.SEVERE, null, ex); } return lstDni; }
From source file:algoritmos.Recorte.java
private static int buscarUbigeo(String dni) { String dn = null;/*w w w. j a v a2s . c o m*/ double d = -1; int ubigeo = 0; if (tryParseInt(dni)) { int nd = Integer.parseInt(dni); try { // InputStream ExcelFileToRead = new FileInputStream("C:/Users/Raul/Desktop/inf226.2016.1._06.proyecto/registro.nacional.v.1.xlsx"); InputStream ExcelFileToRead = new FileInputStream(Recorte.rutaGeneral); XSSFWorkbook wb = new XSSFWorkbook(ExcelFileToRead); XSSFSheet sheet = wb.getSheetAt(0); XSSFRow row; XSSFCell cell; Iterator rows = sheet.rowIterator(); row = (XSSFRow) rows.next(); while (rows.hasNext()) { row = (XSSFRow) rows.next(); Iterator cells = row.cellIterator(); int i = 0; while (cells.hasNext()) { cell = (XSSFCell) cells.next(); if (i == 2) { d = cell.getNumericCellValue(); int num = (int) d; dn = num + ""; } if (dn != null) { if (d == nd) { if (i == 3) { double dh = cell.getNumericCellValue(); ubigeo = (int) dh; return ubigeo; } } } i++; } i = 0; } } catch (FileNotFoundException ex) { Logger.getLogger(Recorte.class.getName()).log(Level.SEVERE, null, ex); } catch (IOException ex) { Logger.getLogger(Recorte.class.getName()).log(Level.SEVERE, null, ex); } } return ubigeo; }
From source file:algoritmos.Recorte.java
private static ArrayList<String> RevisaNombre2(String nombre) { ArrayList<String> nombresE = new ArrayList<String>(); ArrayList<String> dniE = new ArrayList<String>(); int gd = 0;/* w ww. j av a2 s. c o m*/ int max = 0; try { //InputStream ExcelFileToRead = new FileInputStream("D:/repositorio/GRUPO02/b.rnv.xlsx"); InputStream ExcelFileToRead = new FileInputStream(Recorte.rutaGeneral); XSSFWorkbook wb = new XSSFWorkbook(ExcelFileToRead); XSSFSheet sheet = wb.getSheetAt(0); XSSFRow row; XSSFCell cell; Iterator rows = sheet.rowIterator(); row = (XSSFRow) rows.next(); while (rows.hasNext()) { gd = 0; row = (XSSFRow) rows.next(); Iterator cells = row.cellIterator(); int i = 0; int v = 0; while (cells.hasNext()) { cell = (XSSFCell) cells.next(); if (i == 0) { String dh = cell.getStringCellValue(); v = comparaString(dh, nombre); } if (i == 2) { double d2 = cell.getNumericCellValue(); int num = (int) d2; String dn = num + ""; if (v > max) { dniE = new ArrayList<String>(); dniE.add(dn); max = v; } else if (v == max) { dniE.add(dn); } break; } i++; } i = 0; } } catch (FileNotFoundException ex) { Logger.getLogger(Recorte.class.getName()).log(Level.SEVERE, null, ex); } catch (IOException ex) { Logger.getLogger(Recorte.class.getName()).log(Level.SEVERE, null, ex); } return dniE; }
From source file:algoritmos.Recorte.java
private static ArrayList<String> RevisaApellido2(String apellido) { ArrayList<String> nombresE = new ArrayList<String>(); ArrayList<String> dniE = new ArrayList<String>(); int gd = 0;/*from w w w. jav a2s . c o m*/ int max = 0; try { //InputStream ExcelFileToRead = new FileInputStream("D:/repositorio/GRUPO02/b.rnv.xlsx"); InputStream ExcelFileToRead = new FileInputStream(Recorte.rutaGeneral); XSSFWorkbook wb = new XSSFWorkbook(ExcelFileToRead); XSSFSheet sheet = wb.getSheetAt(0); XSSFRow row; XSSFCell cell; Iterator rows = sheet.rowIterator(); row = (XSSFRow) rows.next(); while (rows.hasNext()) { gd = 0; row = (XSSFRow) rows.next(); Iterator cells = row.cellIterator(); int i = 0; int v = 0; while (cells.hasNext()) { cell = (XSSFCell) cells.next(); if (i == 1) { String dh = cell.getStringCellValue(); v = comparaString(dh, apellido); } if (i == 2) { double d2 = cell.getNumericCellValue(); int num = (int) d2; String dn = num + ""; if (v > max) { dniE = new ArrayList<String>(); dniE.add(dn); max = v; } else if (v == max) { dniE.add(dn); } break; } i++; } i = 0; } } catch (FileNotFoundException ex) { Logger.getLogger(Recorte.class.getName()).log(Level.SEVERE, null, ex); } catch (IOException ex) { Logger.getLogger(Recorte.class.getName()).log(Level.SEVERE, null, ex); } return dniE; }
From source file:algoritmos.Recorte.java
private static ArrayList<String> RevisaNombre(ArrayList<String> arrNomb) { ArrayList<String> nombresE = new ArrayList<String>(); ArrayList<String> dniE = new ArrayList<String>(); int gd = 0;/*from ww w. java 2s .c o m*/ try { //InputStream ExcelFileToRead = new FileInputStream("D:/repositorio/GRUPO02/b.rnv.xlsx"); InputStream ExcelFileToRead = new FileInputStream(Recorte.rutaGeneral); XSSFWorkbook wb = new XSSFWorkbook(ExcelFileToRead); XSSFSheet sheet = wb.getSheetAt(0); XSSFRow row; XSSFCell cell; Iterator rows = sheet.rowIterator(); row = (XSSFRow) rows.next(); while (rows.hasNext()) { gd = 0; row = (XSSFRow) rows.next(); Iterator cells = row.cellIterator(); int i = 0; while (cells.hasNext()) { cell = (XSSFCell) cells.next(); if (i == 0) { String dh = cell.getStringCellValue(); dh = dh.toUpperCase(); for (int j = 0; j < arrNomb.size(); j++) { String nom = arrNomb.get(j).toUpperCase().trim(); if (nom.compareTo(dh) == 0) { nombresE.add(dh); gd = 1; } } if (gd != 1) break; } if (i == 2 && gd == 1) { double d2 = cell.getNumericCellValue(); int num = (int) d2; String dn = num + ""; dniE.add(dn); break; } i++; } i = 0; } } catch (FileNotFoundException ex) { Logger.getLogger(Recorte.class.getName()).log(Level.SEVERE, null, ex); } catch (IOException ex) { Logger.getLogger(Recorte.class.getName()).log(Level.SEVERE, null, ex); } return dniE; }
From source file:algoritmos.Recorte.java
private static ArrayList<String> RevisaApellido(ArrayList<String> arrNomb) { ArrayList<String> nombresE = new ArrayList<String>(); ArrayList<String> dniE = new ArrayList<String>(); int gd = 0;// ww w. ja va2 s.c om try { //InputStream ExcelFileToRead = new FileInputStream("D:/repositorio/GRUPO02/b.rnv.xlsx"); InputStream ExcelFileToRead = new FileInputStream(Recorte.rutaGeneral); XSSFWorkbook wb = new XSSFWorkbook(ExcelFileToRead); XSSFSheet sheet = wb.getSheetAt(0); XSSFRow row; XSSFCell cell; Iterator rows = sheet.rowIterator(); row = (XSSFRow) rows.next(); while (rows.hasNext()) { gd = 0; row = (XSSFRow) rows.next(); Iterator cells = row.cellIterator(); int i = 0; while (cells.hasNext()) { cell = (XSSFCell) cells.next(); if (i == 1) { String dh = cell.getStringCellValue(); dh = dh.toUpperCase(); for (int j = 0; j < arrNomb.size(); j++) { String nom = arrNomb.get(j).toUpperCase().trim(); if (nom.compareTo(dh) == 0) { nombresE.add(dh); gd = 1; } } if (gd != 1) break; } if (i == 2 && gd == 1) { double d2 = cell.getNumericCellValue(); int num = (int) d2; String dn = num + ""; dniE.add(dn); break; } i++; } i = 0; } } catch (FileNotFoundException ex) { Logger.getLogger(Recorte.class.getName()).log(Level.SEVERE, null, ex); } catch (IOException ex) { Logger.getLogger(Recorte.class.getName()).log(Level.SEVERE, null, ex); } return dniE; }
From source file:algoritmos.Recorte.java
private static void buscarImagenes(String dni) { ImagenHuella = null;//w ww. j a v a 2s.co m ImagenFirma = null; String dn = null; double d = -1; if (tryParseInt(dni)) { int nd = Integer.parseInt(dni); try { // InputStream ExcelFileToRead = new FileInputStream("C:/Users/Raul/Desktop/inf226.2016.1._06.proyecto/registro.nacional.v.1.xlsx"); InputStream ExcelFileToRead = new FileInputStream(Recorte.rutaGeneral); XSSFWorkbook wb = new XSSFWorkbook(ExcelFileToRead); XSSFSheet sheet = wb.getSheetAt(0); XSSFRow row; XSSFCell cell; Iterator rows = sheet.rowIterator(); row = (XSSFRow) rows.next(); int salir = 0; while (rows.hasNext()) { row = (XSSFRow) rows.next(); Iterator cells = row.cellIterator(); int i = 0; while (cells.hasNext()) { cell = (XSSFCell) cells.next(); if (i == 2) { d = cell.getNumericCellValue(); int num = (int) d; dn = num + ""; // System.out.print("dni: "+num+" "); } if (dn != null) { if (d == nd) { if (i == 4) { String dh = cell.getStringCellValue(); String dr = null; dr = Recorte.rutaHuella + "/" + dh + ".jpg"; // dr=Recorte.rutaHuella+"/"+dh; File file = new File(dr); if (!file.exists()) { dr = Recorte.rutaHuella + "/" + dh + ".png"; file = new File(dr); if (!file.exists()) { dr = Recorte.rutaHuella + "/" + dh + ".jpg.png"; file = new File(dr); } ImagenHuella = ImageIO.read(file); } else { ImagenHuella = Algoritmo_Huellas.readImage(file); } // ImagenHuella= ImageIO.read(file); salir = 1; } /* if(i==4){ double dh=cell.getNumericCellValue(); int num=(int) dh; String dr=null; if(num<10){ // dr="C:/Users/Raul/Desktop/inf226.2016.1._06.proyecto/huellas.jpg/00"+num+".jpg"; dr=Recorte.rutaHuella+"/00"+num+".jpg"; } else if(num>9 && num<100){ // dr="C:/Users/Raul/Desktop/inf226.2016.1._06.proyecto/huellas.jpg/0"+num+".jpg"; dr=Recorte.rutaHuella+"/0"+num+".jpg"; } else{ System.out.println("c"); // dr="C:/Users/Raul/Desktop/inf226.2016.1._06.proyecto/huellas.jpg/"+num+".jpg"; dr=Recorte.rutaHuella+"/"+num+".jpg"; } File file = new File(dr); ImagenHuella= ImageIO.read(file); // cell=(XSSFCell) cells.next(); // i++; }*/ if (i == 5) { String dh = cell.getStringCellValue(); String dr = null; // dr="C:/Users/Raul/Desktop/inf226.2016.1._06.proyecto/firmas.jpg/"+dh+".jpg"; dr = Recorte.rutaFirma + "/" + dh + ".jpg"; // dr=Recorte.rutaFirma+"/"+dh; File file = new File(dr); if (!file.exists()) { dr = Recorte.rutaFirma + "/" + dh + ".png"; file = new File(dr); if (!file.exists()) { dr = Recorte.rutaFirma + "/" + dh + ".jpg.png"; file = new File(dr); } ImagenFirma = ImageIO.read(file); } else { ImagenFirma = Algoritmo_Huellas.readImage(file); } // ImagenFirma= ImageIO.read(file); salir = 1; } } } i++; } i = 0; if (salir == 1) break; } } catch (FileNotFoundException ex) { Logger.getLogger(Recorte.class.getName()).log(Level.SEVERE, null, ex); } catch (IOException ex) { Logger.getLogger(Recorte.class.getName()).log(Level.SEVERE, null, ex); } } }
From source file:ambit2.core.io.IteratingXLSReader.java
License:Open Source License
public void setReader(InputStream input) throws CDKException { try {// www .j a v a 2 s .c o m this.input = input; workbook = hssf ? new HSSFWorkbook(input) : new XSSFWorkbook(input); sheet = workbook.getSheetAt(sheetIndex); //evaluator = new HSSFFormulaEvaluator(sheet, workbook); } catch (Exception x) { throw new CDKException(x.getMessage(), x); } }