excel java apache poi

Question

I want to insert excel data to the database using this code.

public class Insert {
      public static void main( String [] args ) {
        String fileName="C:\\File.xls";
        Vector dataHolder=read(fileName);
        saveToDatabase(dataHolder);
    }
        public static Vector read(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 saveToDatabase(Vector dataHolder) {
        String username="";
                String password="";
                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 st = myCell.toString();
                                 username=st.substring(0,1);
                                 password=st.substring(0);
                                                        }
                        try{
    Class.forName("com.mysql.jdbc.Driver").newInstance();
    Connection con = DriverManager.getConnection("jdbc:mysql://localhost:3306/test","root", "root");
        Statement stat=con.createStatement();
        int k=stat.executeUpdate("insert into login(username,password) value('"+username+"','"+password+"')");
        System.out.println("Data is inserted");
        stat.close();
        con.close();
        }
        catch(Exception e){}
        }
        }
      }

How do I insert this code in a button?

What type of button? A Java based GUI button or a button within Excel (macro, ...)? — Andreas Dolk
– Andreas Dolk, Commented Jan 11, 2011 at 11:46
There is so much fail here, it's difficult to get started... — Erich Kitzmueller
– Erich Kitzmueller, Commented Jan 11, 2011 at 11:54

AlexR · Accepted Answer · 2011-01-11 12:32:07Z

1

generally you have to add Action listener to button:

    Button button = new Button("click me");
    button.addActionListener(new ActionListener() {
        @Override
        public void actionPerformed(ActionEvent e) {
            // call your logic here
        }
    });

answered Jan 11, 2011 at 12:32

AlexR

116k16 gold badges137 silver badges216 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

excel java apache poi

1 Answer 1

Comments

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Related