Best books about JAVA programming:

• Head First JAVA, Second Editon
• Effective Java Programming Language Guide
• Professional Java, JDK 5 Edition
• Ivor Horton's Beginning Java 2, JDK 5 Edition

Copy and paste between Excel and JTable

Use this example to copy and paste between Microsoft Excel spreedsheet and your JTable. This example includes two files: ClipBoardDemo.java and PasteAdapter.java

PasteAdapter.java implements ActionListenr. It listens on "Ctrl +V" action on JTable,which is defined in ClipBoardDemo.java. It will check if there are enough columns and rows for pasted data. If not, it prompts a error dialog. ClipBoardDemo.java is a demo code to show how to use PasteAdapter.java.

//All copyright reserved by www.kidslovepc.com
//No redistribution is allowed without author permission and a back link to www.kidslovepc.com
// Example from http://www.kidslovepc.com
//www.kidslovepc.com is not responsible for your data loss or any damage.

import javax.swing.JFrame;
import javax.swing.JPanel;
import javax.swing.JScrollPane;
import javax.swing.JTable;
import java.awt.Dimension;
import java.awt.GridLayout;
import java.awt.event.MouseAdapter;
import java.awt.event.MouseEvent;
import javax.swing.table.*;
import javax.swing.*;
import java.awt.Color ;
import java.awt.Component;

public class ClipboardDemo extends JPanel {

public ClipboardDemo() {
super(new GridLayout(1,0));

DefaultTableModel dm = new DefaultTableModel(7 , 9);
JTable table=new JTable(dm);
table.setPreferredScrollableViewportSize(new Dimension(500, 70));
table.setRowSelectionAllowed(true) ;
table.setColumnSelectionAllowed(true) ;
PasteAdapter excel =new PasteAdapter (table);

//Create the scroll pane and add the table to it.
JScrollPane scrollPane = new JScrollPane(table);

//Add the scroll pane to this panel.
add(scrollPane);
}

public static void main(String[] args) {
//Schedule a job for the event-dispatching thread:
//creating and showing this application's GUI.
JFrame.setDefaultLookAndFeelDecorated(true);

//Create and set up the window.
JFrame frame = new JFrame("SimpleTableDemo");
frame.setDefaultCloseOperation(JFrame.EXIT_ON_CLOSE);

//Create and set up the content pane.
ClipboardDemo newContentPane = new ClipboardDemo();
newContentPane.setOpaque(true); //content panes must be opaque
frame.setContentPane(newContentPane);

//Display the window.
frame.pack();
frame.setVisible(true);
}

}