MrGrj

Bine ca s-a redeschis topic-ul. @danyweb09 felicitari pentru munca depusa. Am apucat sa testez foarte putin aplicatia si pare ok. Ma voi uita si prin sursa pentru a aduce imbunatatiri / raporta eventuale bug-uri

Am facut recent un mic proiect in Java, care exporta anumite date(nume,prenume,sex,telefon,email,limbi straine cunoscute) dintr-un PDF ( in cazul meu un CV de pe Ejobs sau BestJobs) intr-un Excel. De mentionat ca functioneaza doar in cazul CV-urilor downloadate de catre angajator Aveti mai jos codul. Poate este util cuiva. package elance.pdf.cv; import java.awt.Desktop; import java.awt.Point; import java.awt.event.MouseAdapter; import java.awt.event.MouseEvent; import java.awt.event.MouseMotionAdapter; import java.io.File; import java.io.IOException; import java.net.URI; import java.util.ArrayList; import java.util.prefs.Preferences; import javax.imageio.ImageIO; import javax.swing.Action; import javax.swing.ImageIcon; import javax.swing.JButton; import javax.swing.JFileChooser; import javax.swing.JOptionPane; import javax.swing.JTextField; import jxl.Sheet; import jxl.Workbook; import jxl.read.biff.BiffException; import jxl.write.Label; import jxl.write.WritableSheet; import jxl.write.WritableWorkbook; import jxl.write.WriteException; import org.apache.pdfbox.pdmodel.PDDocument; import org.apache.pdfbox.util.PDFTextStripper; public class win extends javax.swing.JFrame { private Preferences pref = Preferences.userNodeForPackage(getClass()); private Point initialClick; private final String cv0 = "Nici un CV gasit"; private final String cv1 = "1 CV"; private ArrayList<String[]> details_best = new ArrayList<>(); private ArrayList<String[]> details_ejobs = new ArrayList<>(); public win() { super("Aplicatie PDF to Excel"); setResizable(false); setUndecorated(true); setLocation(100, 100); initComponents(); moveUndecoratedFrame(); imageButton(jButton1, "close.png", "close2.png"); imageButton(jButton2, "best2.png", "best3.png"); imageButton(jButton3, "ejobs2.png", "ejobs3.png"); imageButton(jButton4, "loadfolder.png", "loadfolder2.png"); imageButton(jButton5, "loadfolder.png", "loadfolder2.png"); imageButton(jButton6, "openfile.png", "openfile2.png"); imageButton(jButton7, "opencv.png", "opencv2.png"); imageButton(jButton8, "openfile.png", "openfile2.png"); imageButton(jButton9, "opencv.png", "opencv2.png"); imageButton(jButton10, "loadfiles.png", "loadfiles2.png"); imageButton(jButton11, "loadfiles.png", "loadfiles2.png"); jTextField1.setText(pref.get("best", "")); jTextField2.setText(pref.get("ejobs", "")); try { if (jTextField1.getText().length() > 0) { numberOfCVs(jTextField3, jTextField1.getText()); } if (jTextField2.getText().length() > 0) { numberOfCVs(jTextField4, jTextField2.getText()); } } catch (Exception ex) { } } @SuppressWarnings("unchecked") // <editor-fold defaultstate="collapsed" desc="Generated Code">//GEN-BEGIN:initComponents private void initComponents() { jPanel1 = new javax.swing.JPanel(); jButton1 = new javax.swing.JButton(); jPanel2 = new javax.swing.JPanel(); jButton2 = new javax.swing.JButton(); jTextField1 = new javax.swing.JTextField(); jButton4 = new javax.swing.JButton(); jTextField3 = new javax.swing.JTextField(); jButton6 = new javax.swing.JButton(); jButton7 = new javax.swing.JButton(); jButton10 = new javax.swing.JButton(); jPanel3 = new javax.swing.JPanel(); jButton3 = new javax.swing.JButton(); jTextField2 = new javax.swing.JTextField(); jButton5 = new javax.swing.JButton(); jTextField4 = new javax.swing.JTextField(); jButton8 = new javax.swing.JButton(); jButton9 = new javax.swing.JButton(); jButton11 = new javax.swing.JButton(); setDefaultCloseOperation(javax.swing.WindowConstants.EXIT_ON_CLOSE); jPanel1.setBackground(new java.awt.Color(255, 255, 255)); jPanel1.setBorder(javax.swing.BorderFactory.createLineBorder(new java.awt.Color(0, 0, 0))); jButton1.setBackground(new java.awt.Color(255, 255, 255)); jButton1.setBorder(null); jButton1.setMargin(new java.awt.Insets(0, 0, 0, 0)); jButton1.setPreferredSize(new java.awt.Dimension(20, 20)); jButton1.addActionListener(new java.awt.event.ActionListener() { public void actionPerformed(java.awt.event.ActionEvent evt) { jButton1ActionPerformed(evt); } }); jPanel2.setBackground(new java.awt.Color(255, 255, 255)); jPanel2.setBorder(javax.swing.BorderFactory.createTitledBorder("BestJobs")); jButton2.setBorder(null); jButton2.setMargin(new java.awt.Insets(0, 0, 0, 0)); jButton2.setPreferredSize(new java.awt.Dimension(223, 55)); jButton2.addActionListener(new java.awt.event.ActionListener() { public void actionPerformed(java.awt.event.ActionEvent evt) { jButton2ActionPerformed(evt); } }); jTextField1.setEditable(false); jTextField1.setMaximumSize(new java.awt.Dimension(216, 20)); jTextField1.setPreferredSize(new java.awt.Dimension(216, 20)); jButton4.setBackground(new java.awt.Color(255, 255, 255)); jButton4.setBorder(null); jButton4.setMargin(new java.awt.Insets(0, 0, 0, 0)); jButton4.setPreferredSize(new java.awt.Dimension(90, 20)); jButton4.addActionListener(new java.awt.event.ActionListener() { public void actionPerformed(java.awt.event.ActionEvent evt) { jButton4ActionPerformed(evt); } }); jTextField3.setEditable(false); jTextField3.setBackground(new java.awt.Color(255, 255, 255)); jTextField3.setText("Status"); jButton6.setBackground(new java.awt.Color(255, 255, 255)); jButton6.setBorder(null); jButton6.setMargin(new java.awt.Insets(0, 0, 0, 0)); jButton6.setPreferredSize(new java.awt.Dimension(90, 20)); jButton6.addActionListener(new java.awt.event.ActionListener() { public void actionPerformed(java.awt.event.ActionEvent evt) { jButton6ActionPerformed(evt); } }); jButton7.setBackground(new java.awt.Color(255, 255, 255)); jButton7.setBorder(null); jButton7.setMargin(new java.awt.Insets(0, 0, 0, 0)); jButton7.setPreferredSize(new java.awt.Dimension(90, 20)); jButton7.addActionListener(new java.awt.event.ActionListener() { public void actionPerformed(java.awt.event.ActionEvent evt) { jButton7ActionPerformed(evt); } }); jButton10.setBackground(new java.awt.Color(255, 255, 255)); jButton10.setBorder(null); jButton10.setMargin(new java.awt.Insets(0, 0, 0, 0)); jButton10.setPreferredSize(new java.awt.Dimension(90, 20)); jButton10.addActionListener(new java.awt.event.ActionListener() { public void actionPerformed(java.awt.event.ActionEvent evt) { jButton10ActionPerformed(evt); } }); javax.swing.GroupLayout jPanel2Layout = new javax.swing.GroupLayout(jPanel2); jPanel2.setLayout(jPanel2Layout); jPanel2Layout.setHorizontalGroup( jPanel2Layout.createParallelGroup(javax.swing.GroupLayout.Alignment.LEADING) .addGroup(jPanel2Layout.createSequentialGroup() .addContainerGap() .addGroup(jPanel2Layout.createParallelGroup(javax.swing.GroupLayout.Alignment.LEADING) .addComponent(jButton2, javax.swing.GroupLayout.DEFAULT_SIZE, javax.swing.GroupLayout.DEFAULT_SIZE, Short.MAX_VALUE) .addComponent(jTextField3) .addComponent(jTextField1, javax.swing.GroupLayout.Alignment.TRAILING, javax.swing.GroupLayout.DEFAULT_SIZE, javax.swing.GroupLayout.DEFAULT_SIZE, Short.MAX_VALUE)) .addPreferredGap(javax.swing.LayoutStyle.ComponentPlacement.RELATED) .addGroup(jPanel2Layout.createParallelGroup(javax.swing.GroupLayout.Alignment.LEADING, false) .addComponent(jButton6, javax.swing.GroupLayout.Alignment.TRAILING, javax.swing.GroupLayout.DEFAULT_SIZE, javax.swing.GroupLayout.DEFAULT_SIZE, Short.MAX_VALUE) .addComponent(jButton7, javax.swing.GroupLayout.Alignment.TRAILING, javax.swing.GroupLayout.DEFAULT_SIZE, javax.swing.GroupLayout.DEFAULT_SIZE, Short.MAX_VALUE) .addComponent(jButton4, javax.swing.GroupLayout.Alignment.TRAILING, javax.swing.GroupLayout.DEFAULT_SIZE, javax.swing.GroupLayout.DEFAULT_SIZE, Short.MAX_VALUE) .addComponent(jButton10, javax.swing.GroupLayout.DEFAULT_SIZE, javax.swing.GroupLayout.DEFAULT_SIZE, Short.MAX_VALUE)) .addContainerGap()) ); jPanel2Layout.setVerticalGroup( jPanel2Layout.createParallelGroup(javax.swing.GroupLayout.Alignment.LEADING) .addGroup(javax.swing.GroupLayout.Alignment.TRAILING, jPanel2Layout.createSequentialGroup() .addGroup(jPanel2Layout.createParallelGroup(javax.swing.GroupLayout.Alignment.LEADING) .addComponent(jTextField1, javax.swing.GroupLayout.PREFERRED_SIZE, javax.swing.GroupLayout.DEFAULT_SIZE, javax.swing.GroupLayout.PREFERRED_SIZE) .addComponent(jButton4, javax.swing.GroupLayout.PREFERRED_SIZE, javax.swing.GroupLayout.DEFAULT_SIZE, javax.swing.GroupLayout.PREFERRED_SIZE)) .addPreferredGap(javax.swing.LayoutStyle.ComponentPlacement.RELATED) .addGroup(jPanel2Layout.createParallelGroup(javax.swing.GroupLayout.Alignment.LEADING) .addComponent(jTextField3, javax.swing.GroupLayout.PREFERRED_SIZE, javax.swing.GroupLayout.DEFAULT_SIZE, javax.swing.GroupLayout.PREFERRED_SIZE) .addComponent(jButton10, javax.swing.GroupLayout.PREFERRED_SIZE, javax.swing.GroupLayout.DEFAULT_SIZE, javax.swing.GroupLayout.PREFERRED_SIZE)) .addPreferredGap(javax.swing.LayoutStyle.ComponentPlacement.RELATED) .addGroup(jPanel2Layout.createParallelGroup(javax.swing.GroupLayout.Alignment.TRAILING) .addComponent(jButton2, javax.swing.GroupLayout.PREFERRED_SIZE, javax.swing.GroupLayout.DEFAULT_SIZE, javax.swing.GroupLayout.PREFERRED_SIZE) .addGroup(jPanel2Layout.createSequentialGroup() .addComponent(jButton6, javax.swing.GroupLayout.PREFERRED_SIZE, javax.swing.GroupLayout.DEFAULT_SIZE, javax.swing.GroupLayout.PREFERRED_SIZE) .addPreferredGap(javax.swing.LayoutStyle.ComponentPlacement.RELATED) .addComponent(jButton7, javax.swing.GroupLayout.PREFERRED_SIZE, javax.swing.GroupLayout.DEFAULT_SIZE, javax.swing.GroupLayout.PREFERRED_SIZE))) .addContainerGap(javax.swing.GroupLayout.DEFAULT_SIZE, Short.MAX_VALUE)) ); jPanel3.setBackground(new java.awt.Color(255, 255, 255)); jPanel3.setBorder(javax.swing.BorderFactory.createTitledBorder("EJobs")); jButton3.setBorder(null); jButton3.setMargin(new java.awt.Insets(0, 0, 0, 0)); jButton3.setPreferredSize(new java.awt.Dimension(223, 55)); jButton3.addActionListener(new java.awt.event.ActionListener() { public void actionPerformed(java.awt.event.ActionEvent evt) { jButton3ActionPerformed(evt); } }); jTextField2.setEditable(false); jTextField2.setMaximumSize(new java.awt.Dimension(216, 20)); jTextField2.setPreferredSize(new java.awt.Dimension(216, 20)); jButton5.setBackground(new java.awt.Color(255, 255, 255)); jButton5.setBorder(null); jButton5.setMargin(new java.awt.Insets(0, 0, 0, 0)); jButton5.setPreferredSize(new java.awt.Dimension(90, 20)); jButton5.addActionListener(new java.awt.event.ActionListener() { public void actionPerformed(java.awt.event.ActionEvent evt) { jButton5ActionPerformed(evt); } }); jTextField4.setEditable(false); jTextField4.setBackground(new java.awt.Color(255, 255, 255)); jTextField4.setText("Status"); jButton8.setBackground(new java.awt.Color(255, 255, 255)); jButton8.setBorder(null); jButton8.setMargin(new java.awt.Insets(0, 0, 0, 0)); jButton8.setPreferredSize(new java.awt.Dimension(90, 20)); jButton8.addActionListener(new java.awt.event.ActionListener() { public void actionPerformed(java.awt.event.ActionEvent evt) { jButton8ActionPerformed(evt); } }); jButton9.setBackground(new java.awt.Color(255, 255, 255)); jButton9.setBorder(null); jButton9.setMargin(new java.awt.Insets(0, 0, 0, 0)); jButton9.setPreferredSize(new java.awt.Dimension(90, 20)); jButton9.addActionListener(new java.awt.event.ActionListener() { public void actionPerformed(java.awt.event.ActionEvent evt) { jButton9ActionPerformed(evt); } }); jButton11.setBackground(new java.awt.Color(255, 255, 255)); jButton11.setBorder(null); jButton11.setMargin(new java.awt.Insets(0, 0, 0, 0)); jButton11.setPreferredSize(new java.awt.Dimension(90, 20)); jButton11.addActionListener(new java.awt.event.ActionListener() { public void actionPerformed(java.awt.event.ActionEvent evt) { jButton11ActionPerformed(evt); } }); javax.swing.GroupLayout jPanel3Layout = new javax.swing.GroupLayout(jPanel3); jPanel3.setLayout(jPanel3Layout); jPanel3Layout.setHorizontalGroup( jPanel3Layout.createParallelGroup(javax.swing.GroupLayout.Alignment.LEADING) .addGroup(jPanel3Layout.createSequentialGroup() .addContainerGap() .addGroup(jPanel3Layout.createParallelGroup(javax.swing.GroupLayout.Alignment.LEADING, false) .addComponent(jButton3, javax.swing.GroupLayout.DEFAULT_SIZE, javax.swing.GroupLayout.DEFAULT_SIZE, Short.MAX_VALUE) .addComponent(jTextField4) .addComponent(jTextField2, javax.swing.GroupLayout.DEFAULT_SIZE, javax.swing.GroupLayout.DEFAULT_SIZE, Short.MAX_VALUE)) .addPreferredGap(javax.swing.LayoutStyle.ComponentPlacement.RELATED) .addGroup(jPanel3Layout.createParallelGroup(javax.swing.GroupLayout.Alignment.LEADING) .addGroup(jPanel3Layout.createSequentialGroup() .addGroup(jPanel3Layout.createParallelGroup(javax.swing.GroupLayout.Alignment.LEADING) .addGroup(jPanel3Layout.createParallelGroup(javax.swing.GroupLayout.Alignment.LEADING, false) .addComponent(jButton5, javax.swing.GroupLayout.DEFAULT_SIZE, javax.swing.GroupLayout.DEFAULT_SIZE, Short.MAX_VALUE) .addComponent(jButton8, javax.swing.GroupLayout.DEFAULT_SIZE, javax.swing.GroupLayout.DEFAULT_SIZE, Short.MAX_VALUE)) .addComponent(jButton9, javax.swing.GroupLayout.DEFAULT_SIZE, javax.swing.GroupLayout.DEFAULT_SIZE, Short.MAX_VALUE)) .addGap(0, 0, Short.MAX_VALUE)) .addComponent(jButton11, javax.swing.GroupLayout.Alignment.TRAILING, javax.swing.GroupLayout.DEFAULT_SIZE, javax.swing.GroupLayout.DEFAULT_SIZE, Short.MAX_VALUE)) .addContainerGap()) ); jPanel3Layout.setVerticalGroup( jPanel3Layout.createParallelGroup(javax.swing.GroupLayout.Alignment.LEADING) .addGroup(javax.swing.GroupLayout.Alignment.TRAILING, jPanel3Layout.createSequentialGroup() .addGroup(jPanel3Layout.createParallelGroup(javax.swing.GroupLayout.Alignment.LEADING) .addComponent(jTextField2, javax.swing.GroupLayout.PREFERRED_SIZE, javax.swing.GroupLayout.DEFAULT_SIZE, javax.swing.GroupLayout.PREFERRED_SIZE) .addComponent(jButton5, javax.swing.GroupLayout.PREFERRED_SIZE, javax.swing.GroupLayout.DEFAULT_SIZE, javax.swing.GroupLayout.PREFERRED_SIZE)) .addPreferredGap(javax.swing.LayoutStyle.ComponentPlacement.RELATED) .addGroup(jPanel3Layout.createParallelGroup(javax.swing.GroupLayout.Alignment.LEADING) .addComponent(jTextField4, javax.swing.GroupLayout.PREFERRED_SIZE, javax.swing.GroupLayout.DEFAULT_SIZE, javax.swing.GroupLayout.PREFERRED_SIZE) .addComponent(jButton11, javax.swing.GroupLayout.PREFERRED_SIZE, javax.swing.GroupLayout.DEFAULT_SIZE, javax.swing.GroupLayout.PREFERRED_SIZE)) .addPreferredGap(javax.swing.LayoutStyle.ComponentPlacement.RELATED) .addGroup(jPanel3Layout.createParallelGroup(javax.swing.GroupLayout.Alignment.TRAILING) .addComponent(jButton3, javax.swing.GroupLayout.PREFERRED_SIZE, javax.swing.GroupLayout.DEFAULT_SIZE, javax.swing.GroupLayout.PREFERRED_SIZE) .addGroup(jPanel3Layout.createSequentialGroup() .addComponent(jButton8, javax.swing.GroupLayout.PREFERRED_SIZE, javax.swing.GroupLayout.DEFAULT_SIZE, javax.swing.GroupLayout.PREFERRED_SIZE) .addPreferredGap(javax.swing.LayoutStyle.ComponentPlacement.RELATED) .addComponent(jButton9, javax.swing.GroupLayout.PREFERRED_SIZE, javax.swing.GroupLayout.DEFAULT_SIZE, javax.swing.GroupLayout.PREFERRED_SIZE))) .addContainerGap(javax.swing.GroupLayout.DEFAULT_SIZE, Short.MAX_VALUE)) ); javax.swing.GroupLayout jPanel1Layout = new javax.swing.GroupLayout(jPanel1); jPanel1.setLayout(jPanel1Layout); jPanel1Layout.setHorizontalGroup( jPanel1Layout.createParallelGroup(javax.swing.GroupLayout.Alignment.LEADING) .addGroup(jPanel1Layout.createSequentialGroup() .addContainerGap() .addGroup(jPanel1Layout.createParallelGroup(javax.swing.GroupLayout.Alignment.LEADING, false) .addComponent(jPanel2, javax.swing.GroupLayout.DEFAULT_SIZE, javax.swing.GroupLayout.DEFAULT_SIZE, Short.MAX_VALUE) .addComponent(jPanel3, javax.swing.GroupLayout.DEFAULT_SIZE, javax.swing.GroupLayout.DEFAULT_SIZE, Short.MAX_VALUE)) .addPreferredGap(javax.swing.LayoutStyle.ComponentPlacement.RELATED, javax.swing.GroupLayout.DEFAULT_SIZE, Short.MAX_VALUE) .addComponent(jButton1, javax.swing.GroupLayout.PREFERRED_SIZE, javax.swing.GroupLayout.DEFAULT_SIZE, javax.swing.GroupLayout.PREFERRED_SIZE)) ); jPanel1Layout.setVerticalGroup( jPanel1Layout.createParallelGroup(javax.swing.GroupLayout.Alignment.LEADING) .addGroup(jPanel1Layout.createSequentialGroup() .addGroup(jPanel1Layout.createParallelGroup(javax.swing.GroupLayout.Alignment.LEADING) .addComponent(jButton1, javax.swing.GroupLayout.PREFERRED_SIZE, javax.swing.GroupLayout.DEFAULT_SIZE, javax.swing.GroupLayout.PREFERRED_SIZE) .addGroup(jPanel1Layout.createSequentialGroup() .addContainerGap() .addComponent(jPanel2, javax.swing.GroupLayout.PREFERRED_SIZE, javax.swing.GroupLayout.DEFAULT_SIZE, javax.swing.GroupLayout.PREFERRED_SIZE))) .addPreferredGap(javax.swing.LayoutStyle.ComponentPlacement.RELATED) .addComponent(jPanel3, javax.swing.GroupLayout.PREFERRED_SIZE, javax.swing.GroupLayout.DEFAULT_SIZE, javax.swing.GroupLayout.PREFERRED_SIZE) .addContainerGap(javax.swing.GroupLayout.DEFAULT_SIZE, Short.MAX_VALUE)) ); javax.swing.GroupLayout layout = new javax.swing.GroupLayout(getContentPane()); getContentPane().setLayout(layout); layout.setHorizontalGroup( layout.createParallelGroup(javax.swing.GroupLayout.Alignment.LEADING) .addComponent(jPanel1, javax.swing.GroupLayout.PREFERRED_SIZE, javax.swing.GroupLayout.DEFAULT_SIZE, javax.swing.GroupLayout.PREFERRED_SIZE) ); layout.setVerticalGroup( layout.createParallelGroup(javax.swing.GroupLayout.Alignment.LEADING) .addGroup(layout.createSequentialGroup() .addComponent(jPanel1, javax.swing.GroupLayout.PREFERRED_SIZE, javax.swing.GroupLayout.DEFAULT_SIZE, javax.swing.GroupLayout.PREFERRED_SIZE) .addGap(0, 0, Short.MAX_VALUE)) ); pack(); }// </editor-fold>//GEN-END:initComponents private void jButton1ActionPerformed(java.awt.event.ActionEvent evt) {//GEN-FIRST:event_jButton1ActionPerformed System.exit(0); }//GEN-LAST:event_jButton1ActionPerformed private void jButton4ActionPerformed(java.awt.event.ActionEvent evt) {//GEN-FIRST:event_jButton4ActionPerformed String x = loadFolder(); jTextField1.setText(x); pref.put("best", x); numberOfCVs(jTextField3, x); }//GEN-LAST:event_jButton4ActionPerformed private void jButton5ActionPerformed(java.awt.event.ActionEvent evt) {//GEN-FIRST:event_jButton5ActionPerformed String x = loadFolder(); jTextField2.setText(x); pref.put("ejobs", x); numberOfCVs(jTextField4, x); }//GEN-LAST:event_jButton5ActionPerformed private void jButton2ActionPerformed(java.awt.event.ActionEvent evt) {//GEN-FIRST:event_jButton2ActionPerformed details_best.clear(); String folder = jTextField1.getText(); if (folder.length() < 1) { return; } if (jTextField3.getText().equalsIgnoreCase(cv0)) { message("Nici un CV gasit in folderul respectiv"); return; } else { ArrayList<String> files = new ArrayList<>(); if (new File(folder).isDirectory()) { files = getCVsFromFolder(folder); } else { for (String h : folder.split(";")) { files.add(h); } folder = new File(folder.split(";")[0]).getParent().toString(); } for (String f : files) { String nume = ""; String sex = ""; String telefon = ""; String mail = ""; String limbi = ""; String[] det = new String[6]; String x = readPDFasText(f); String[] x2 = x.split("\n"); for (int i = 0; i < x2.length; i++) { // nume = x2[0].replace("\n", ""); // sex = getSex(x2[1]); int indexTelefon=0; if (x2[i].toLowerCase().indexOf("mobil:") == 0) { telefon = getTelefon(x2[i]); indexTelefon=i; } int indexNume=0; for(int j=indexTelefon;j>0;j--){ if(getSex(x2[j]).length()>0){ sex=getSex(x2[j]); indexNume=j; } } if(indexNume>0){ nume = x2[indexNume-1].replace("\n", ""); } if (x2[i].toLowerCase().indexOf("email:") == 0) { mail = getMail(x2[i]); } if (x2[i].toLowerCase().indexOf("limbi straine") == 0) { for (int j = 1; j < x2.length - i; j++) { if (x2[i + j].toLowerCase().indexOf("certificari") == 0) { break; } limbi += x2[i + j].trim() + " "; } } } det[0] = "0"; det[1] = nume.trim(); det[2] = sex.trim(); det[3] = telefon.trim(); det[4] = mail.trim(); det[5] = limbi.trim(); details_best.add(det); } String[][] table = new String[details_best.size() + 1][5]; String[] headers = new String[]{"ID", "Nume", "Sex", "Telefon", "Email", "Limbi straine"}; table[0] = headers; for (int i = 1; i < table.length; i++) { table[i] = details_best.get(i - 1); table[i][0] = i + ""; } // determina celalat fisier String dir = jTextField2.getText(); if (!new File(dir).isDirectory()) { dir = new File(dir.split(";")[0]).getParent().toString(); } String othertable = dir + File.separator + "Candidati Ejobs.xls"; if (new File(othertable).exists()) { verificaDubluri(table, readsheet(othertable)); } try { scriefisier(table, folder + File.separator + "Candidati BestJobs.xls"); jTextField3.setText("fisier pregatit"); } catch (Exception ex) { ex.printStackTrace(); } } }//GEN-LAST:event_jButton2ActionPerformed private void jButton6ActionPerformed(java.awt.event.ActionEvent evt) {//GEN-FIRST:event_jButton6ActionPerformed String dir = jTextField1.getText(); if (!new File(dir).isDirectory()) { dir = new File(dir.split(";")[0]).getParent().toString(); } openFile(dir + File.separator + "Candidati BestJobs.xls"); }//GEN-LAST:event_jButton6ActionPerformed private void jButton3ActionPerformed(java.awt.event.ActionEvent evt) {//GEN-FIRST:event_jButton3ActionPerformed details_ejobs.clear(); String folder = jTextField2.getText(); if (folder.length() < 1) { return; } if (jTextField4.getText().equalsIgnoreCase(cv0)) { message("Nici un CV gasit in folderul respectiv"); return; } else { ArrayList<String> files = new ArrayList<>(); if (new File(folder).isDirectory()) { files = getCVsFromFolder(folder); } else { for (String h : folder.split(";")) { files.add(h); } folder = new File(folder.split(";")[0]).getParent().toString(); } for (String f : files) { String nume = ""; String sex = ""; String telefon = ""; String mail = ""; String limbi = ""; String[] det = new String[6]; String x = readPDFasText(f); String[] x2 = x.split("\n"); for (int i = 0; i < x2.length; i++) { nume = x2[0].replace("\n", ""); sex = getSex_ejobs(x2[3].trim()); if (x2[i].trim().toLowerCase().indexOf("telefon:") == 0) { telefon = getTelefon(x2[i]); } if (x2[i].trim().toLowerCase().indexOf("email") == 0) { mail = getMail_ejobs(x2[i].trim()); } if (x2[i].toLowerCase().indexOf("limbi straine (nivel cunoastere):") >= 0) { for (int j = 1; j < x2.length - i; j++) { if (x2[i + j].trim().toLowerCase().indexOf("abilitati") == 0) { break; } limbi += x2[i + j].trim() + " "; } } } det[0] = "0"; det[1] = nume.trim(); det[2] = sex.trim(); det[3] = telefon.trim(); det[4] = mail.trim(); det[5] = limbi.trim(); details_ejobs.add(det); } String[][] table = new String[details_ejobs.size() + 1][5]; String[] headers = new String[]{"ID", "Nume", "Sex", "Telefon", "Email", "Limbi straine"}; table[0] = headers; for (int i = 1; i < table.length; i++) { table[i] = details_ejobs.get(i - 1); table[i][0] = i + ""; } // determina celalat fisier String dir = jTextField1.getText(); if (!new File(dir).isDirectory()) { dir = new File(dir.split(";")[0]).getParent().toString(); } String othertable = dir + File.separator + "Candidati BestJobs.xls"; if (new File(othertable).exists()) { verificaDubluri(table, readsheet(othertable)); } try { scriefisier(table, folder + File.separator + "Candidati Ejobs.xls"); jTextField4.setText("fisier pregatit"); } catch (Exception ex) { ex.printStackTrace(); } } }//GEN-LAST:event_jButton3ActionPerformed private void jButton7ActionPerformed(java.awt.event.ActionEvent evt) {//GEN-FIRST:event_jButton7ActionPerformed details_best.clear(); String folder = jTextField1.getText(); ArrayList<String> files = new ArrayList<>(); if (new File(folder).isDirectory()) { files = getCVsFromFolder(folder); } else { for (String h : folder.split(";")) { files.add(h); } folder = new File(folder.split(";")[0]).getParent().toString(); } if (folder.length() < 1) { return; } for (String f : files) { String nume = ""; String sex = ""; String telefon = ""; String mail = ""; String limbi = ""; String[] det = new String[6]; String x = readPDFasText(f); String[] x2 = x.split("\n"); for (int i = 0; i < x2.length; i++) { nume = x2[0].replace("\n", ""); sex = getSex(x2[1]); if (x2[i].toLowerCase().indexOf("mobil:") == 0) { telefon = getTelefon(x2[i]); } if (x2[i].toLowerCase().indexOf("email:") == 0) { mail = getMail(x2[i]); } if (x2[i].toLowerCase().indexOf("limbi straine") == 0) { for (int j = 1; j < x2.length - i; j++) { if (x2[i + j].toLowerCase().indexOf("certificari") == 0) { break; } limbi += x2[i + j].trim() + " "; } } } det[0] = "0"; det[1] = nume.trim(); det[2] = sex.trim(); det[3] = telefon.trim(); det[4] = mail.trim(); det[5] = limbi.trim(); details_best.add(det); } int x = -1; if (details_best.size() < 1) { return; } else if (details_best.size() == 1) { openFile(files.get(0)); return; } String t = JOptionPane.showInputDialog(null, "Introdu ID-ul! (intre 1 - " + details_best.size() + ")", ""); try { x = Integer.parseInt(t); x = Math.abs(x); } catch (Exception ex) { } if (x < 0 || x > details_best.size()) { return; } // ArrayList<String> files = getCVsFromFolder(jTextField1.getText()); openFile(files.get(x - 1)); }//GEN-LAST:event_jButton7ActionPerformed private void jButton9ActionPerformed(java.awt.event.ActionEvent evt) {//GEN-FIRST:event_jButton9ActionPerformed details_ejobs.clear(); String folder = jTextField2.getText(); if (folder.length() < 1) { return; } ArrayList<String> files = new ArrayList<>(); if (new File(folder).isDirectory()) { files = getCVsFromFolder(folder); } else { for (String h : folder.split(";")) { files.add(h); } folder = new File(folder.split(";")[0]).getParent().toString(); } for (String f : files) { String nume = ""; String sex = ""; String telefon = ""; String mail = ""; String limbi = ""; String[] det = new String[6]; String x = readPDFasText(f); String[] x2 = x.split("\n"); for (int i = 0; i < x2.length; i++) { nume = x2[0].replace("\n", ""); sex = getSex_ejobs(x2[3].trim()); if (x2[i].trim().toLowerCase().indexOf("telefon:") == 0) { telefon = getTelefon(x2[i]); } if (x2[i].trim().toLowerCase().indexOf("email") == 0) { mail = getMail_ejobs(x2[i].trim()); } if (x2[i].toLowerCase().indexOf("limbi straine (nivel cunoastere):") >= 0) { for (int j = 1; j < x2.length - i; j++) { if (x2[i + j].trim().toLowerCase().indexOf("abilitati") == 0) { break; } limbi += x2[i + j].trim() + " "; } } } det[0] = "0"; det[1] = nume.trim(); det[2] = sex.trim(); det[3] = telefon.trim(); det[4] = mail.trim(); det[5] = limbi.trim(); details_ejobs.add(det); } int x = -1; if (details_ejobs.size() < 1) { return; } else if (details_ejobs.size() == 1) { openFile(files.get(0)); return; } String t = JOptionPane.showInputDialog(null, "Introdu ID-ul! (intre 1 - " + details_ejobs.size() + ")", ""); try { x = Integer.parseInt(t); x = Math.abs(x); } catch (Exception ex) { } if (x < 0 || x > details_ejobs.size()) { return; } openFile(files.get(x - 1)); }//GEN-LAST:event_jButton9ActionPerformed private void jButton8ActionPerformed(java.awt.event.ActionEvent evt) {//GEN-FIRST:event_jButton8ActionPerformed String dir = jTextField2.getText(); if (!new File(dir).isDirectory()) { dir = new File(dir.split(";")[0]).getParent().toString(); } openFile(dir + File.separator + "Candidati Ejobs.xls"); }//GEN-LAST:event_jButton8ActionPerformed private void jButton10ActionPerformed(java.awt.event.ActionEvent evt) {//GEN-FIRST:event_jButton10ActionPerformed String x = loadfile(); jTextField1.setText(x); String[] files = x.split(";"); if (files.length == 0) { jTextField3.setText(cv0); } else if (files.length == 1) { jTextField3.setText(cv1); } else { jTextField3.setText(files.length + " CV-uri"); } pref.put("best", x); }//GEN-LAST:event_jButton10ActionPerformed private void jButton11ActionPerformed(java.awt.event.ActionEvent evt) {//GEN-FIRST:event_jButton11ActionPerformed String x = loadfile(); jTextField2.setText(x); pref.put("ejobs", x); numberOfCVs(jTextField4, x); }//GEN-LAST:event_jButton11ActionPerformed public static void run() { java.awt.EventQueue.invokeLater(new Runnable() { public void run() { new win().setVisible(true); } }); } private void moveUndecoratedFrame() { this.addMouseListener(new MouseAdapter() { public void mousePressed(MouseEvent e) { initialClick = e.getPoint(); getComponentAt(initialClick); } }); this.addMouseMotionListener(new MouseMotionAdapter() { @Override public void mouseDragged(MouseEvent e) { // get location of Window int thisX = getLocation().x; int thisY = getLocation().y; // Determine how much the mouse moved since the initial click int xMoved = (thisX + e.getX()) - (thisX + initialClick.x); int yMoved = (thisY + e.getY()) - (thisY + initialClick.y); // Move window to this position int X = thisX + xMoved; int Y = thisY + yMoved; setLocation(X, Y); } }); } private String readPDFasText(String pdfFile) { String result = ""; PDDocument doc; try { // doc = new PDDocument(); doc = PDDocument.load(pdfFile); PDFTextStripper textStripper = new PDFTextStripper(); result = textStripper.getText(doc); doc.close(); } catch (Exception ex) { System.out.println("readPDFasText - " + ex.getMessage()); } // System.out.println(result); return result; } private String loadfile() { JFileChooser choose = new JFileChooser(System.getProperty("user.home") + File.separator + "Desktop"); choose.setMultiSelectionEnabled(true); Action details = choose.getActionMap().get("viewTypeDetails"); details.actionPerformed(null); choose.showOpenDialog(null); File[] files = choose.getSelectedFiles(); String x = ""; if (files.length > 1) { for (File f : files) { x += f.getPath() + ";"; } x = x.substring(0, x.length() - 1); } else { try { x = choose.getSelectedFile().getPath(); } catch (Exception ex) { } } return x; } private static void openurl(String url) { try { Desktop.getDesktop().browse(new URI(url)); } catch (Exception ex) { } } private void openFile(String file) { try { Desktop.getDesktop().open(new File(file)); } catch (Exception ex) { } } private void imageButton(JButton but, String image1, String image2) { try { but.setRolloverIcon(new ImageIcon(ImageIO.read(getClass().getResource("/" + image2)))); but.setRolloverEnabled(true); but.setIcon(new ImageIcon(ImageIO.read(getClass().getResource("/" + image1)))); } catch (Exception ex) { } } public static void scriefisier(String[][] tabel, String nume) throws IOException, WriteException { try { WritableWorkbook wb = Workbook.createWorkbook(new File(nume)); WritableSheet sheet = wb.createSheet("Sheet1", 0); int[] columns = new int[tabel[0].length]; for (int i = 0; i < columns.length; i++) { columns[i] = 5; } for (int i = 0; i < tabel.length; i++) { for (int j = 0; j < tabel[i].length; j++) { sheet.addCell(new Label(j, i, tabel[i][j])); columns[j] = Math.max(columns[j], tabel[i][j].length() + 3); } } for (int i = 0; i < columns.length; i++) { sheet.setColumnView(i, columns[i]); } wb.write(); wb.close(); } catch (Exception ex) { } } private String loadFolder() { JFileChooser choose = new JFileChooser(); choose.setFileSelectionMode(JFileChooser.DIRECTORIES_ONLY); choose.showOpenDialog(null); String x = ""; try { x = choose.getSelectedFile().getPath(); } catch (Exception ex) { } return x; } private ArrayList<String> getCVsFromFolder(String folder) { // returneaza toate pdfurile din folderul respectiv // asa se poate afla numarul lor si adresa dintr-o singure metoda ArrayList<String> result = new ArrayList<>(); File f = new File(folder); if (f.isDirectory()) { File[] all = f.listFiles(); for (File g : all) { String name = g.toString(); if (name.substring(name.length() - 4).equalsIgnoreCase(".pdf")) { result.add(name); } } } return result; } private void message(String message) { JOptionPane.showMessageDialog(null, message, "", JOptionPane.ERROR_MESSAGE); } private void p(Object t) { System.out.println(t); } private void numberOfCVs(JTextField displayResult, String folder) { ArrayList<String> files = new ArrayList<>(); if (new File(folder).isDirectory()) { files = getCVsFromFolder(folder); } else { for (String h : folder.split(";")) { files.add(h); } folder = new File(folder.split(";")[0]).getParent().toString(); } if (files.size() == 0) { displayResult.setText(cv0); } else if (files.size() == 1) { displayResult.setText(cv1); } else { displayResult.setText(files.size() + " CV-uri"); } } private String getSex(String text) { String result = ""; if (text.indexOf("(") == 0) { text = text.substring(1); if (text.toLowerCase().indexOf("m") == 0/*mascul, masculin*/ || text.toLowerCase().indexOf("b") == 0/*barbat*/) { result = "masculin"; } else if (text.toLowerCase().indexOf("f") == 0) { result = "feminin"; } } return result; } private String getSex_ejobs(String text) { String result = ""; if (text.toLowerCase().indexOf("m") == 0/*mascul, masculin*/ || text.toLowerCase().indexOf("b") == 0/*barbat*/) { result = "masculin"; } else if (text.toLowerCase().indexOf("f") == 0) { result = "feminin"; } return result; } private String getTelefon(String text) { String result = ""; result = text.substring(text.indexOf(":") + 1); return result; } private String getMail(String text) { String result = ""; result = text.substring(text.indexOf(":") + 1); return result; } private String getMail_ejobs(String text) { String result = ""; result = text.substring(text.indexOf(" ") + 1); return result.trim(); } private String[][] readsheet(String file) { //reads the first sheet from an excel file String[][] tt; // the file in table format Workbook workbook; Sheet sheet = null; try { workbook = Workbook.getWorkbook(new File(file)); sheet = workbook.getSheet(0); // 0 is the first sheet } catch (IOException | IndexOutOfBoundsException | BiffException exec) { JOptionPane.showMessageDialog(null, exec, "not working!!", JOptionPane.ERROR_MESSAGE); } int x = sheet.getRows(); int y = sheet.getColumns(); tt = new String[x][y]; for (int i = 0; i < tt.length; i++) { for (int j = 0; j < tt[0].length; j++) { try { tt[i][j] = sheet.getCell(j, i).getContents().toString() + ""; } catch (Exception ex) { } } } return tt; } private void verificaDubluri(String[][] candidatiNoi, String[][] candidatiVechi) { for (int i = 1; i < candidatiNoi.length; i++) { for (int j = 0; j < candidatiVechi.length; j++) { if (candidatiNoi[i][3].equals(candidatiVechi[j][3])) { message("Telefon duplicat pentru candidatul\n" + candidatiNoi[i][1].toUpperCase()); break; } } } } // Variables declaration - do not modify//GEN-BEGIN:variables private javax.swing.JButton jButton1; private javax.swing.JButton jButton10; private javax.swing.JButton jButton11; private javax.swing.JButton jButton2; private javax.swing.JButton jButton3; private javax.swing.JButton jButton4; private javax.swing.JButton jButton5; private javax.swing.JButton jButton6; private javax.swing.JButton jButton7; private javax.swing.JButton jButton8; private javax.swing.JButton jButton9; private javax.swing.JPanel jPanel1; private javax.swing.JPanel jPanel2; private javax.swing.JPanel jPanel3; private javax.swing.JTextField jTextField1; private javax.swing.JTextField jTextField2; private javax.swing.JTextField jTextField3; private javax.swing.JTextField jTextField4; // End of variables declaration//GEN-END:variables } Sursa aplicatie: FileShare Download Sursa-program-PDF-to-Excel.rar Aplicatia propriu-zisa: FileShare Download Aplicatie PDF to Excel - final.rar

Nu vreau sa generalizez sau sa vorbesc urat, dar ... muie ti**nilor !

@Romania- , tutorialul este ok insa am si eu o intrebare: Care e diferenta dintre printf si printf_s ?

Still better than Windows though

Nu inteleg de ce este atat de importanta intrebarea asta cu: "Oare ce pica la subiectul III ? " . Acum ceva ani a picat Basmul vreo 3 ani consecutiv. Asa ca lasati vrajeala asta cu " nu pica asta ca s-a dat in x an, nu ne da ailalta ca Eminescu-i deja mort" etc. Invata sau copiaza. As simple as that. [incurajez invatatul] In loc sa stai sa faci pronosticuri si sa iti faci sperante false crezand ca va pica Iona sau Morometii, mai bine iei dracu' cartea aia si dai un fget la randurile respective. Sau daca nu ai chef/timp... copiezi si te limitezi la asta. E doar o parere proprie si personala. ON: Succes tuturor.

[sarcasm] Romania, tara democrata ?! [/sarcasm]

Daca te plictisesti, poti incepe un topic util, nu unul de cacat. A mai fost un astfel de sondaj acum nu mult timp.

Nu ai pentru ce

Asta ar fi o varianta: void split(ListNode *head,ListNode **ptrOddList,ListNode **ptrEvenList){ int remainder; int countO=0; int countE=0; ListNode *tempO,*tempE; if (head==NULL) return; else{ (*ptrOddList)=(struct node*)malloc(sizeof(ListNode)); (*ptrEvenList)=(struct node*)malloc(sizeof(ListNode)); while(head!=NULL){ remainder=head->item%2; if(remainder==0){ if(countE>0){ tempE->next=head; tempE=tempE->next; } else tempE=*ptrOddList; tempE->item=head->item; countE++; } else{ if(countO>0){ tempO->next=head; tempO=tempO->next; } else tempO=*ptrOddList; tempO->item=head->item; countO++; } head=head->next; } tempE->next=NULL; tempO->next=NULL; printf("Lista para:"); printNode((*ptrEvenList)); printf("Lista impara:"); printNode((*ptrOddList)); } } In loc de printf, pui tu acolo cout<<"Lista para:"; si la fel si pentru cea impara

Nu se dramatizeaza. Insa asta e adevarul. Nu spune nimeni ca trebuie sa fii constrans de tehnologie si ca gata: "Nu mai intru pe net 10 ani". Ideea e ca in ultimii 5 ani,poate chiar mai bine, toata lumea e atat de obsedata de tehnologie incat se uita ceva poate nu atat de important, insa vital: sa fii om si sa iti traiesti viata, sa deschizi ochii si sa te bucuri de emotii. 85% din parintii din ziua de azi gandesc in felul urmator: " ii cumpar un iPad printisorului ca sa nu mai planga si sa fie cuminte " in loc sa il educe si sa ii arate unde a gresit Ideea nu e in nici un caz: "am o afacere de care trebuie sa am grija, dar e rau sa stau pe net. Renunt".

Mie unul mi-a placut filmuletul si din pacate asta e adevarul. Oricat vei incerca sa-l negi, asta este. Majoritatea insa asa sunt crescuti. Tehnologia evolueaza insa oamenii involueaza. Sad.

A fost postat de dimineata un thread pe subiectul asta

V-am dat si eu un share pe facebook astfel incat sa fim cat mai multi.

A mai fost postat

(a*b*c+d*e*f)%g = (-3*7*9 + 2*11*1)%77=(-189+22)%77 = (-167) % 77 = 2 rest -13. Code Blocks are dreptate; % este functia "modulo" in C/C++/etc - adica restul impartirii lui 77 la -189 care evident este -13

Am multe de US ramase. Da-mi un PM cu cate vrei si cat poti sa oferi. (YAHOO/AOL/GMAIL/HOTMAIL)

Daca vezi doar 10 oameni ai baut mai mult ca ei inainte sa postezi

Schimb 59$ PayPal pt. 150 lei cash. Am nevoie urgent azi. Doar pt. cei cu vechime pe RST / seriosi. Nu am chef de glume / tepe etc.

Folosesti proxy ? E posibil sa fie de la asta. Aveam si eu problema asta pe Chrome. Scoate proxy-ul si va functiona.

Uhm, erau astia prin poli cu cartele de 8 euro. Si era ceva gen pret promotional. Treci maine daca ai timp si esti din Buc

Sold out

Geez' , si eu care voiam sa ma culc. Dai fiecaruia parola criptata cu un algoritm diferit (creeat de tine). Lui "Gigel x" ii spui ca algoritmul de decriptare este algoritmul a(care de fapt e algoritmul potrivit pentru algoritmul lui Gigel Y) iar lui "Gigel Y" ii spui ca algoritmul de decriptare este algoritmul b(care de fapt e algoritmul potrivit pentru algoritmul lui "Gigel x") Cand vei muri, vor vorbi si vor incerca sa schimbe algoritmii, afland astfel parola initiala.

Bine ai venit. Sper sa invatam lucruri multe si bune de la tine.

@indianul mi-a facut seara mai buna . De ce va panicati atat ? Pana la urma, nu o sa schimbati nimic daca va declarati nationalismul aici. Ce-o fii o fii . Nu e ca si cand ati putea face ceva daca e razboi sau ne f*t rusii in cur. Alte griji, alte probleme ? Ma pis pe ele de probleme. Am destule.