write spreadsheet

write spreadsheet

what is the java code to write a spreadsheet to database

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.









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
ModuleNotFoundError: No module named 'spreadsheet'
ModuleNotFoundError: No module named 'spreadsheet'  Hi, My Python... 'spreadsheet' How to remove the ModuleNotFoundError: No module named 'spreadsheet' error? Thanks   Hi, In your python environment
ModuleNotFoundError: No module named 'spreadsheet'
ModuleNotFoundError: No module named 'spreadsheet'  Hi, My Python... 'spreadsheet' How to remove the ModuleNotFoundError: No module named 'spreadsheet' error? Thanks   Hi, In your python environment
ModuleNotFoundError: No module named 'bluesky-spreadsheet'
ModuleNotFoundError: No module named 'bluesky-spreadsheet'  Hi, My... named 'bluesky-spreadsheet' How to remove the ModuleNotFoundError: No module named 'bluesky-spreadsheet' error? Thanks   Hi
ModuleNotFoundError: No module named 'google_spreadsheet'
ModuleNotFoundError: No module named 'google_spreadsheet'  Hi, My... named 'google_spreadsheet' How to remove the ModuleNotFoundError: No module named 'google_spreadsheet' error? Thanks   Hi, In your
ModuleNotFoundError: No module named 'google_spreadsheet'
ModuleNotFoundError: No module named 'google_spreadsheet'  Hi, My... named 'google_spreadsheet' How to remove the ModuleNotFoundError: No module named 'google_spreadsheet' error? Thanks   Hi, In your
ModuleNotFoundError: No module named 'google_spreadsheet'
ModuleNotFoundError: No module named 'google_spreadsheet'  Hi, My... named 'google_spreadsheet' How to remove the ModuleNotFoundError: No module named 'google_spreadsheet' error? Thanks   Hi, In your
ModuleNotFoundError: No module named 'o2-google-spreadsheet'
ModuleNotFoundError: No module named 'o2-google-spreadsheet'  Hi...: No module named 'o2-google-spreadsheet' How to remove the ModuleNotFoundError: No module named 'o2-google-spreadsheet' error? Thanks   Hi
ModuleNotFoundError: No module named 'spreadsheet-maker'
ModuleNotFoundError: No module named 'spreadsheet-maker'  Hi, My... named 'spreadsheet-maker' How to remove the ModuleNotFoundError: No module named 'spreadsheet-maker' error? Thanks   Hi, In your
ModuleNotFoundError: No module named 'Spreadsheet-HTML'
ModuleNotFoundError: No module named 'Spreadsheet-HTML'  Hi, My... named 'Spreadsheet-HTML' How to remove the ModuleNotFoundError: No module named 'Spreadsheet-HTML' error? Thanks   Hi, In your
ModuleNotFoundError: No module named 'spreadsheet-maker'
ModuleNotFoundError: No module named 'spreadsheet-maker'  Hi, My... named 'spreadsheet-maker' How to remove the ModuleNotFoundError: No module named 'spreadsheet-maker' error? Thanks   Hi, In your
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,ADS_TO_REPLACE_1 Follow these steps: Open Data Sources (Start->Settings->Control Panel->
Version of com.supwisdom>spreadsheet-mapper-parent dependency
List of Version of com.supwisdom>spreadsheet-mapper-parent dependency
ModuleNotFoundError: No module named 'django-spreadsheet-reports'
ModuleNotFoundError: No module named 'django-spreadsheet-reports'  Hi...: No module named 'django-spreadsheet-reports' How to remove the ModuleNotFoundError: No module named 'django-spreadsheet-reports' error? Thanks
ModuleNotFoundError: No module named 'google-spreadsheet-py'
ModuleNotFoundError: No module named 'google-spreadsheet-py'  Hi...: No module named 'google-spreadsheet-py' How to remove the ModuleNotFoundError: No module named 'google-spreadsheet-py' error? Thanks   Hi
ModuleNotFoundError: No module named 'python-google-spreadsheet'
ModuleNotFoundError: No module named 'python-google-spreadsheet'  Hi...: No module named 'python-google-spreadsheet' How to remove the ModuleNotFoundError: No module named 'python-google-spreadsheet' error? Thanks  
ModuleNotFoundError: No module named 'django-spreadsheet-reports'
ModuleNotFoundError: No module named 'django-spreadsheet-reports'  Hi...: No module named 'django-spreadsheet-reports' How to remove the ModuleNotFoundError: No module named 'django-spreadsheet-reports' error? Thanks
ModuleNotFoundError: No module named 'django-spreadsheet-reports'
ModuleNotFoundError: No module named 'django-spreadsheet-reports'  Hi...: No module named 'django-spreadsheet-reports' How to remove the ModuleNotFoundError: No module named 'django-spreadsheet-reports' error? Thanks
ModuleNotFoundError: No module named 'domdf-spreadsheet-tools'
ModuleNotFoundError: No module named 'domdf-spreadsheet-tools'  Hi...: No module named 'domdf-spreadsheet-tools' How to remove the ModuleNotFoundError: No module named 'domdf-spreadsheet-tools' error? Thanks   
ModuleNotFoundError: No module named 'domdf-spreadsheet-tools'
ModuleNotFoundError: No module named 'domdf-spreadsheet-tools'  Hi...: No module named 'domdf-spreadsheet-tools' How to remove the ModuleNotFoundError: No module named 'domdf-spreadsheet-tools' error? Thanks   
ModuleNotFoundError: No module named 'google-spreadsheet-py'
ModuleNotFoundError: No module named 'google-spreadsheet-py'  Hi...: No module named 'google-spreadsheet-py' How to remove the ModuleNotFoundError: No module named 'google-spreadsheet-py' error? Thanks   Hi
ModuleNotFoundError: No module named 'google-spreadsheet-py'
ModuleNotFoundError: No module named 'google-spreadsheet-py'  Hi...: No module named 'google-spreadsheet-py' How to remove the ModuleNotFoundError: No module named 'google-spreadsheet-py' error? Thanks   Hi
ModuleNotFoundError: No module named 'python-barcode-spreadSheet'
ModuleNotFoundError: No module named 'python-barcode-spreadSheet'  Hi...: No module named 'python-barcode-spreadSheet' How to remove the ModuleNotFoundError: No module named 'python-barcode-spreadSheet' error? Thanks
ModuleNotFoundError: No module named 'python-google-spreadsheet'
ModuleNotFoundError: No module named 'python-google-spreadsheet'  Hi...: No module named 'python-google-spreadsheet' How to remove the ModuleNotFoundError: No module named 'python-google-spreadsheet' error? Thanks  
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.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.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
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.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
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
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
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 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 ADS_TO_REPLACE_1
write data to plist
write data to plist  How to write data to plist file in XCode
write a java program
write a java program  write a program to print '*' in a circular form
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
ModuleNotFoundError: No module named 'write'
ModuleNotFoundError: No module named 'write'  Hi, My Python program is throwing following error: ModuleNotFoundError: No module named 'write' How to remove the ModuleNotFoundError: No module named 'write'

Ads