write spreadsheet

Ads

 
 

Share on Google+Share on Google+

faith kay
write spreadsheet
1 Answer(s)      5 years and 5 months ago
Posted in : Java Beginners

what is the java code to write a spreadsheet to database

Ads
View Answers

May 4, 2012 at 11:44 AM


  import java.io.*;
  import java.sql.*;
  import java.util.*;
  import java.util.regex.*;
  import org.apache.poi.hssf.usermodel.*;
  import org.apache.poi.poifs.filesystem.POIFSFileSystem;

  public class InsertExcelFileData {
  public static void main( String [] args ) {
    String fileName="c:/data.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 name="";
            String address="";
            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();
                             name=st.substring(0,1);
                             address=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 data(name,address) value('"+name+"','"+address+"')");
    System.out.println("Data is inserted");
    stat.close();
    con.close();
    }
    catch(Exception e){}
    }
    }
  }

In the above code we have defined a file data.xls. This file contains two columns Name and Address.


Ads









Related Tutorials/Questions & Answers:
write spreadsheet
write spreadsheet  what is the java code to write a spreadsheet to database
write spreadsheet
write spreadsheet  what is the java code to write a spreadsheet to database
Advertisements
connect jdbc to an Excel spreadsheet
connect jdbc to an Excel spreadsheet  hello, How can I connect to an Excel spreadsheet file using jdbc?   Hello Friend, Follow these steps: Open Data Sources (Start->Settings->Control Panel->Administrative
Version of com.supwisdom>spreadsheet-mapper-parent dependency
List of Version of com.supwisdom>spreadsheet-mapper-parent dependency
Create SpreadSheet same as excel using java applet
Create SpreadSheet same as excel using java applet  Hi Ji, May i know to create new excel sheet using java Applet
Create SpreadSheet same as excel using java applet
Create SpreadSheet same as excel using java applet  Hi Ji, May i know to create new excel sheet using java Applet
Maven Dependency spreadsheet-mapper-parent >> 1.0.0
You should include the dependency code given in this page to add Maven Dependency of com.supwisdom >> spreadsheet-mapper-parent version1.0.0 in your project
Maven Dependency spreadsheet-mapper-parent >> 1.0.1
You should include the dependency code given in this page to add Maven Dependency of com.supwisdom >> spreadsheet-mapper-parent version1.0.1 in your project
Maven Dependency spreadsheet-mapper-parent >> 1.0.2
You should include the dependency code given in this page to add Maven Dependency of com.supwisdom >> spreadsheet-mapper-parent version1.0.2 in your project
Maven Dependency spreadsheet-mapper-parent >> 1.0.3
You should include the dependency code given in this page to add Maven Dependency of com.supwisdom >> spreadsheet-mapper-parent version1.0.3 in your project
Maven Dependency spreadsheet-mapper-parent >> 1.0.4
You should include the dependency code given in this page to add Maven Dependency of com.supwisdom >> spreadsheet-mapper-parent version1.0.4 in your project
Maven Dependency spreadsheet-mapper-parent >> 1.0.5
You should include the dependency code given in this page to add Maven Dependency of com.supwisdom >> spreadsheet-mapper-parent version1.0.5 in your project
Maven Dependency spreadsheet-mapper-parent >> 1.0.6
You should include the dependency code given in this page to add Maven Dependency of com.supwisdom >> spreadsheet-mapper-parent version1.0.6 in your project
Possibility of Creating a Spreadsheet in Java? - Java Beginners
Possibility of Creating a Spreadsheet in Java?  Is it possible to create a spreadsheet (like MS Excel) in java?   hi friend This code really works for you. To run the given code, you have to download the poi
How to retrieve file name and path of an excel spreadsheet imported into Oracle Database
How to retrieve file name and path of an excel spreadsheet imported into Oracle Database  I imported an excel spreadsheet using sql developer into my... table for each spreadsheet but I want to obtain the path and filename of each
How to insert rows from Excel spreadsheet into database by browsing the excel file?
How to insert rows from Excel spreadsheet into database by browsing the excel file?  I want to insert rows from excel sheet to database.for this i have connected both the database using ODBC and inserted. but i need to select
write a program
write a program  write a program add 2 no.s without use arithmetic,unary operaters in java
WRITE AND TEST
WRITE AND TEST   WRITE AND TEST PROGRAM TO ACCEPT A STRING? 1).WHICH STARTS WITH 'S' OR 's' 2).ENDS WITH "nd" 3) THE LENGTH OF THE STRING SHOULD BE 10 OR LESS
Write to PDF
Write to PDF  Hi, Fairly new to this. I want to create a PDF file as a server call, with text/images sent to the app. Seeing that this will have to be a plugin, how do I go about making it a valid plugin for the server
how to write quesry results into spread sheet
how to write quesry results into spread sheet   Hello sir/madam, I need a solution/code for the below scenario. In jsp, based on the date range selection we need to pull the records from the table and to write into spreadsheet
Read Write
Read Write  Hi; How can I read certain line of say 10 text files and write to one text file   Java Read Multiple Files and store the data into another text file The given code reads all the text files of the directory
Ajax Write
Ajax Write       ajaxWrite is a web-based word processor that can read and write Microsoft Word and other standard document formats Read full Description
write a java program
write a java program  write a program to print '*' in a circular form
write data to plist
write data to plist  How to write data to plist file in XCode
Java Write To File CSV
Java Write To File CSV In this tutorial you will learn how to write to file... a simple example which will demonstrate you how to write to csv file. To achieve... into which I have passed a file name to write a stream of characters. Next I
How to write Java Program
How to write Java Program  how to write a program to find average of 5 student marks
Write String in Word document
Write String in Word document  How to read and write strings in word document
Write data in doc file
Write data in doc file  How to write data or string in word file
How to write in File in Java
How to write in File in Java  Hi, How to write in File in Java. Please suggest and give example of this program. thanks
Read and write file
Read and write file  HI, How to read and write file from Java program? Thanks   Hi, See the following tutorials: Java Write To File Read File Thanks
write a programm using java
write a programm using java  print the following using java programming

Ads

 
Advertisement null

Ads