Welcome to the Java Programming Forums


The professional, friendly Java community. 21,500 members and growing!


The Java Programming Forums are a community of Java programmers from all around the World. Our members have a wide range of skills and they all have one thing in common: A passion to learn and code Java. We invite beginner Java programmers right through to Java professionals to post here and share your knowledge. Become a part of the community, help others, expand your knowledge of Java and enjoy talking with like minded people. Registration is quick and best of all free. We look forward to meeting you.


>> REGISTER NOW TO START POSTING


Members have full access to the forums. Advertisements are removed for registered users.

Results 1 to 2 of 2

Thread: inserting problem in excel sheet for Java using Eclips

  1. #1
    Junior Member
    Join Date
    Oct 2011
    Posts
    4
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Unhappy inserting problem in excel sheet for Java using Eclips

    dear all,
    I have a problem that I can't insert data in my excel sheet (already made from MS excel).
    can any one help me please?

    here is the full code:


    package write;

    import java.io.File;
    import java.io.IOException;
    import java.util.Locale;

    import jxl.CellView;
    import jxl.Workbook;
    import jxl.WorkbookSettings;
    import jxl.format.UnderlineStyle;
    import jxl.write.Formula;
    import jxl.write.Label;
    import jxl.write.Number;
    import jxl.write.WritableCellFormat;
    import jxl.write.WritableFont;
    import jxl.write.WritableSheet;
    import jxl.write.WritableWorkbook;
    import jxl.write.WriteException;
    import jxl.write.biff.RowsExceededException;

    import java.awt.BorderLayout;
    import java.awt.Component;
    import java.awt.EventQueue;
    import java.awt.Frame;

    import javax.swing.JFrame;
    import javax.swing.JPanel;
    import javax.swing.border.EmptyBorder;
    import javax.swing.ButtonGroup;
    import javax.swing.JLabel;
    import javax.swing.JOptionPane;
    import javax.swing.SwingConstants;
    import javax.swing.JTextField;
    import javax.swing.JComboBox;
    import javax.swing.JRadioButton;
    import java.awt.Font;
    import javax.swing.JCheckBox;
    import javax.swing.JSplitPane;
    import javax.swing.JToolBar;
    import javax.swing.JInternalFrame;
    import javax.swing.JLayeredPane;
    import java.awt.Panel;
    import javax.swing.JRadioButtonMenuItem;
    import javax.swing.JButton;
    import java.awt.event.ActionListener;
    import java.awt.event.ActionEvent;
    import java.awt.event.KeyEvent;
    import java.sql.Connection;
    import java.sql.DriverManager;
    import java.sql.ResultSet;
    import java.sql.SQLException;
    import java.sql.Statement;

    import javax.swing.DefaultComboBoxModel;


    public class Lib_Mngt extends JFrame {

    private JPanel contentPane;
    private JTextField textName;
    private JTextField textRoad;
    private JTextField textZIP;
    private JTextField textState;
    private JTextField textMbl;

    /**
    * Launch the application.
    */
    public static void main(String[] args)
    {
    EventQueue.invokeLater(new Runnable()
    {
    public void run()
    {
    try
    {
    Lib_Mngt frame = new Lib_Mngt();
    frame.setVisible(true);
    }
    catch (Exception e)
    {
    e.printStackTrace();
    }
    }
    });
    }

    /**
    * Create the frame.
    */


    void saveData() throws Exception
    {
    Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
    String myDB = "jdbcdbcriver={Microsoft Excel Driver (*.xls)};DBQ=I:/Java/Library Mangement/bin/LMS.xls;" + "DriverID=22;READONLY=false";
    Connection con = DriverManager.getConnection(myDB, "", "");
    Statement stmt = null;
    ResultSet rs = null;

    stmt = con.createStatement();
    String excelQuery = "select * from [Sheet1$]";
    rs = stmt.executeQuery(excelQuery);

    while (rs.next())
    {
    System.out.println(rs.getString("ID") );
    //System.out.println(rs.getString("ID") + " " + rs.getString("Name") + " " + rs.getString("Road") + " " + rs.getString("ZIP") + " " + rs.getString("State") + " " + rs.getString("Country") + " " + rs.getString("Marritial Status") + " " + rs.getString("Book Types") + " " + rs.getString("Mobile"));
    }

    try
    {
    rs.close();
    stmt.close();
    con.close();

    }
    catch (SQLException e)

    {
    e.printStackTrace();
    }

    }




    public Lib_Mngt()
    {

    setTitle("Library Management");
    setDefaultCloseOperation(JFrame.EXIT_ON_CLOSE);
    setBounds(100, 100, 576, 266);
    contentPane = new JPanel();
    contentPane.setBorder(new EmptyBorder(5, 5, 5, 5));
    setContentPane(contentPane);
    contentPane.setLayout(null);

    JPanel panel = new JPanel();
    panel.setBounds(9, 44, 537, 140);
    contentPane.add(panel);
    panel.setLayout(null);

    JLabel lblNewLabel = new JLabel("Name:");
    lblNewLabel.setFont(new Font("Tahoma", Font.BOLD, 11));
    lblNewLabel.setHorizontalAlignment(SwingConstants. RIGHT);
    lblNewLabel.setBounds(-30, 11, 89, 14);
    panel.add(lblNewLabel);

    JLabel lblNewLabel_1 = new JLabel("Road:");
    lblNewLabel_1.setFont(new Font("Tahoma", Font.BOLD, 11));
    lblNewLabel_1.setHorizontalAlignment(SwingConstant s.RIGHT);
    lblNewLabel_1.setBounds(-30, 36, 89, 14);
    panel.add(lblNewLabel_1);

    JLabel lblNewLabel_2 = new JLabel("Mobile:");
    lblNewLabel_2.setFont(new Font("Tahoma", Font.BOLD, 11));
    lblNewLabel_2.setHorizontalAlignment(SwingConstant s.RIGHT);
    lblNewLabel_2.setBounds(196, 61, 89, 14);
    panel.add(lblNewLabel_2);

    JLabel lblNewLabel_3 = new JLabel("ZIP:");
    lblNewLabel_3.setFont(new Font("Tahoma", Font.BOLD, 11));
    lblNewLabel_3.setHorizontalAlignment(SwingConstant s.RIGHT);
    lblNewLabel_3.setBounds(-30, 61, 89, 14);
    panel.add(lblNewLabel_3);

    JLabel lblNewLabel_4 = new JLabel("State:");
    lblNewLabel_4.setFont(new Font("Tahoma", Font.BOLD, 11));
    lblNewLabel_4.setHorizontalAlignment(SwingConstant s.RIGHT);
    lblNewLabel_4.setBounds(-30, 86, 89, 14);
    panel.add(lblNewLabel_4);

    JLabel lblNewLabel_5 = new JLabel("Country:");
    lblNewLabel_5.setFont(new Font("Tahoma", Font.BOLD, 11));
    lblNewLabel_5.setHorizontalAlignment(SwingConstant s.RIGHT);
    lblNewLabel_5.setBounds(-30, 111, 89, 14);
    panel.add(lblNewLabel_5);

    textName = new JTextField();
    textName.setHorizontalAlignment(SwingConstants.LEF T);
    textName.setBounds(63, 11, 126, 20);
    panel.add(textName);
    textName.setColumns(10);

    textRoad = new JTextField();
    textRoad.setHorizontalAlignment(SwingConstants.LEF T);
    textRoad.setBounds(63, 36, 126, 20);
    panel.add(textRoad);
    textRoad.setColumns(10);

    textZIP = new JTextField();
    textZIP.setHorizontalAlignment(SwingConstants.LEFT );
    textZIP.setBounds(63, 61, 126, 20);
    panel.add(textZIP);
    textZIP.setColumns(10);

    textState = new JTextField();
    textState.setHorizontalAlignment(SwingConstants.LE FT);
    textState.setBounds(63, 86, 126, 20);
    panel.add(textState);
    textState.setColumns(10);

    textMbl = new JTextField();
    textMbl.setHorizontalAlignment(SwingConstants.LEFT );
    textMbl.setBounds(294, 61, 150, 20);
    panel.add(textMbl);
    textMbl.setColumns(10);

    JComboBox comboBoxCntry = new JComboBox();
    comboBoxCntry.setModel(new DefaultComboBoxModel(new String[] {"Bangladesh", "Sweden", "Italy", "Germany", "Pakistan", "India", "Others..."}));
    comboBoxCntry.setBounds(63, 111, 126, 20);
    panel.add(comboBoxCntry);

    JLabel lblNewLabel_6 = new JLabel("Maritial Status:");
    lblNewLabel_6.setHorizontalAlignment(SwingConstant s.RIGHT);
    lblNewLabel_6.setFont(new Font("Tahoma", Font.BOLD, 11));
    lblNewLabel_6.setBounds(195, 12, 89, 14);
    panel.add(lblNewLabel_6);

    JLabel lblNewLabel_7 = new JLabel("Book Types:");
    lblNewLabel_7.setHorizontalAlignment(SwingConstant s.RIGHT);
    lblNewLabel_7.setFont(new Font("Tahoma", Font.BOLD, 11));
    lblNewLabel_7.setBounds(195, 37, 89, 14);
    panel.add(lblNewLabel_7);

    JCheckBox chckbxNewCheckPoem = new JCheckBox("Poem");
    chckbxNewCheckPoem.setFont(new Font("Tahoma", Font.BOLD, 11));
    chckbxNewCheckPoem.setBounds(452, 33, 57, 23);
    panel.add(chckbxNewCheckPoem);

    JCheckBox chckbxNewCheckHistry = new JCheckBox("History");
    chckbxNewCheckHistry.setFont(new Font("Tahoma", Font.BOLD, 11));
    chckbxNewCheckHistry.setBounds(369, 33, 75, 23);
    panel.add(chckbxNewCheckHistry);

    JCheckBox chckbxNewCheckRmnt = new JCheckBox("Romantic");
    chckbxNewCheckRmnt.setFont(new Font("Tahoma", Font.BOLD, 11));
    chckbxNewCheckRmnt.setBounds(290, 33, 89, 23);
    panel.add(chckbxNewCheckRmnt);

    JRadioButton radioBtnMarried = new JRadioButton("Married");
    radioBtnMarried.setFont(new Font("Tahoma", Font.BOLD, 11));
    radioBtnMarried.setBounds(369, 7, 75, 23);
    panel.add(radioBtnMarried);
    radioBtnMarried.setMnemonic(KeyEvent.VK_1);
    radioBtnMarried.setActionCommand(getTitle());

    JRadioButton radioBtnUnmrd = new JRadioButton("Unmaried");
    radioBtnUnmrd.setFont(new Font("Tahoma", Font.BOLD, 11));
    radioBtnUnmrd.setBounds(290, 7, 83, 23);
    panel.add(radioBtnUnmrd);
    radioBtnUnmrd.setMnemonic(KeyEvent.VK_2);
    radioBtnUnmrd.setActionCommand(getTitle());

    JRadioButton radioBtnDvrc = new JRadioButton("Divorced");
    radioBtnDvrc.setFont(new Font("Tahoma", Font.BOLD, 11));
    radioBtnDvrc.setBounds(452, 9, 90, 23);
    panel.add(radioBtnDvrc);
    radioBtnDvrc.setMnemonic(KeyEvent.VK_3);
    radioBtnDvrc.setActionCommand(getTitle());

    ButtonGroup group = new ButtonGroup();
    group.add(radioBtnMarried);
    group.add(radioBtnUnmrd);
    group.add(radioBtnDvrc);

    JLabel lblNewLabel_8 = new JLabel("Personal Library Management System");
    lblNewLabel_8.setFont(new Font("Times New Roman", Font.BOLD, 18));
    lblNewLabel_8.setBounds(125, 11, 305, 28);
    contentPane.add(lblNewLabel_8);

    JButton btnClose = new JButton("Close");
    btnClose.setFont(new Font("Tahoma", Font.BOLD, 11));
    btnClose.addActionListener(new ActionListener() {
    public void actionPerformed(ActionEvent arg0)
    {
    //String strClos = JOptionPane.showConfirmDialog(frame ,"Would You Like to Exit ?", "Exit ?", JOptionPane.YES_NO_OPTION);

    System.exit(0);
    }
    });
    btnClose.setBounds(438, 195, 108, 23);
    contentPane.add(btnClose);

    JButton btnShowData = new JButton("Show Data");
    btnShowData.setFont(new Font("Tahoma", Font.BOLD, 11));
    btnShowData.addActionListener(new ActionListener() {
    public void actionPerformed(ActionEvent arg0)
    {
    try {
    showData();
    } catch (Exception e) {
    // TODO Auto-generated catch block
    e.printStackTrace();
    }

    }
    });
    btnShowData.setBounds(322, 195, 108, 23);
    contentPane.add(btnShowData);

    JButton btnSave = new JButton("Save");
    btnSave.setFont(new Font("Tahoma", Font.BOLD, 11));
    btnSave.addActionListener(new ActionListener() {
    public void actionPerformed(ActionEvent e)
    {
    try {
    saveData();
    } catch (Exception e1) {
    // TODO Auto-generated catch block
    e1.printStackTrace();
    }

    }
    });
    btnSave.setBounds(204, 195, 108, 23);
    contentPane.add(btnSave);

    JButton btnNew = new JButton("New");
    btnNew.setFont(new Font("Tahoma", Font.BOLD, 11));
    btnNew.setBounds(86, 195, 108, 23);
    contentPane.add(btnNew);
    }
    }


  2. #2
    Administrator copeg's Avatar
    Join Date
    Oct 2009
    Location
    US
    Posts
    5,354
    Thanks
    182
    Thanked 832 Times in 775 Posts
    Blog Entries
    5

    Default Re: inserting problem in excel sheet for Java using Eclips

    This thread has been cross posted here:

    http://www.java-forums.org/database/50746-java-excel-insert-update-delete-view.html

    Although cross posting is allowed, for everyone's benefit, please read:

    Java Programming Forums Cross Posting Rules

    The Problems With Cross Posting


Similar Threads

  1. profiling java programs in eclips (Linux Ubuntu)
    By sagar474 in forum Java IDEs
    Replies: 4
    Last Post: October 1st, 2011, 12:09 PM
  2. How to convert java executed pgm in eclipse to excel sheet..
    By rajeshwari in forum What's Wrong With My Code?
    Replies: 1
    Last Post: June 17th, 2011, 08:32 AM
  3. appending from shell script to excel sheet
    By krishnamohan in forum Java Theory & Questions
    Replies: 1
    Last Post: August 16th, 2010, 11:01 AM
  4. insert(embed) a file object (.txt file) in MS excel sheet using java.
    By jyoti.dce in forum What's Wrong With My Code?
    Replies: 1
    Last Post: August 12th, 2010, 09:16 AM
  5. how to copy cells to a new sheet of excel with JexcelAPI??
    By 19world in forum File I/O & Other I/O Streams
    Replies: 0
    Last Post: June 15th, 2010, 04:49 AM