How can i extract email ids from xls/xlsx file in java?

Ads
 

How can i extract email ids from xls/xlsx file in java?

that's the code..... i tried to extract email id;s from xls file........... but it doesn;t gives the proper output?

table is like this: bhavik [email protected] magan [email protected]

Output::: [email protected] [email protected]

please give me some hints to solve this program correctly..........

import java.io.File; import java.io.FileInputStream; import java.io.FileNotFoundException; import java.io.FileOutputStream; import java.io.IOException; import java.util.Iterator; import java.util.Scanner; import java.util.Vector;

import java.util.regex.Pattern; import org.apache.poi.hssf.usermodel.HSSFCell; import org.apache.poi.hssf.usermodel.HSSFRow; import org.apache.poi.hssf.usermodel.HSSFSheet; import org.apache.poi.hssf.usermodel.HSSFWorkbook; import org.apache.poi.poifs.filesystem.POIFSFileSystem;

public class excelread123 {

File fout = new File("data1.txt");

    public static void main(String[] args) throws FileNotFoundException, IOException {

            String fileName = "bv1.xls";
            Vector dataHolder = ReadCSV(fileName);
            printCellDataToConsole(dataHolder);
    }

    public static Vector ReadCSV(String fileName) {

            Vector cellVectorHolder = new Vector();

            try {
                    FileInputStream myInput = new FileInputStream(fileName);

                    POIFSFileSystem myFileSystem = new POIFSFileSystem(myInput);

                    HSSFWorkbook myWorkBook = new HSSFWorkbook(myFileSystem);





                    HSSFSheet mySheet = myWorkBook.getSheetAt(0);

                    Iterator rowIter = mySheet.rowIterator();

                    while (rowIter.hasNext()) {
                            HSSFRow myRow = (HSSFRow) rowIter.next();
                            Iterator cellIter = myRow.cellIterator();
                            Vector cellStoreVector = new Vector();
                            while (cellIter.hasNext()) {
                                    HSSFCell myCell = (HSSFCell) cellIter.next();
                                    cellStoreVector.addElement(myCell);
                            }
                            cellVectorHolder.addElement(cellStoreVector);
                    }
            } catch (Exception e) {
                    e.printStackTrace();
            }
            return cellVectorHolder;
    }

    private static void printCellDataToConsole(Vector dataHolder) throws FileNotFoundException, IOException {

        int n,c;
        String str = null;
        Pattern p = Pattern.compile("([\\w+|\\.?]+)\\[email protected]([\\w+|\\.?]+)\\.(\\w{2,8}\\w?)");
        File fout = new File("data1.txt");
        FileOutputStream f = new FileOutputStream(fout);
            for (int i = 0; i < dataHolder.size(); i++) {
                    Vector cellStoreVector = (Vector) dataHolder.elementAt(i);
                    for (int j = 0; j < cellStoreVector.size(); j++) {
                            HSSFCell myCell = (HSSFCell) cellStoreVector.elementAt(j);
                            String stringCellValue = myCell.toString();
                            for(int k=0;k<stringCellValue.length();k++)
                            {
                                n = stringCellValue.charAt(k);
                                f.write(n);
                            }


                    }

            }
            FileInputStream fis1 = new FileInputStream(fout);

Scanner s = new Scanner(fout); while ( (str = s.findWithinHorizon(p, 0)) != null ) while((str = s.(p)) != null) { System.out.println(str); }

  fis1.close();
    }

}

View Answers

Ads









Related Tutorials/Questions & Answers:
How can i extract email ids from xls/xlsx file in java?
How can i read a file from nth line onwards in java
Advertisements
How to extract a specific line from a text file? - IoC
Extract frames from Video File
Java code for converting between .xls to .xlsx and vice versa - Java Beginners
How to Extract SQL schema into .xsl file
how can i display a pdf file in a jtextarea
How can we extract string 'roseindia.net ' from a string http://[email protected] net using regular expression of php?
how can i export a .jar file include .mbd file?
how can i open pdf file in assest folder in android application?
How I can filling pdf file that crated by livecycle using itext
How can i pass the valus from a JSP to the action class???
How to extract details from XML? - JSP-Servlet
Javah -  Header File Generator
how can i run ASP.Net Server from netbeans IDE?
How Can I get ArrayList of Data from jsp with ajax request
How can i download these java related materials from rose india
How can i Dispose Dialog box From LWUIT Component >
Java code for conversion between .xls and .xlsx or vice versa - Development process
How to extract name,surname, doamin name from mailid
How to extract values from SOAP Response message and insert in database
extract data from HTML
How to extract the entire line with specific data from a Text in java?
How can I open my Java desktop app by clicking on its file?
Java2
how can i send a mail to a particular user from a many user dropdown list in jsp
difference between java5 and java6 - Java Beginners
how can i display the dates of one week by selecting the date randomly from the calendar?
Extract Jar File
How can I do it? .click();
How can I learn Java?

Ads