[taqi10]

getting data from System Clipboard is not difficult you can easily get data from System Clipboard and store it in a string type variable but the problem is that how will you transfer that string or write that string to the Excel, one possible solution to transfer the data to the Excel is to use teh JExcel API, search google for JExcel API,with this API you can write data or read from excel files, as far as the code for getting data from clipboard is concerened I am pasting it as below:

Code:

import java.awt.*;
import java.awt.event.*;
import java.applet.*;
import java.awt.datatransfer.*;

public class ClipTest1 extends Component  implements ClipboardOwner
{
	public static void main(String [] args)
	{
		ClipTest1 obj =new ClipTest1();
		obj.testMethod();
	}

	public void testMethod()
	{
		try
		{
			Clipboard clipboard;
			clipboard = getToolkit().getSystemClipboard();
			Transferable clipboardContent = clipboard.getContents (this);
			String tempString;
			tempString = (String) clipboardContent.getTransferData (DataFlavor.stringFlavor);
			System.out.println(tempString);
		}

		catch(Exception en)
		{
			System.out.println(en);
		}
	}

	public void lostOwnership (Clipboard parClipboard, Transferable parTransferable)
	{
	 	  System.out.println ("Lost ownership");
	}



}

Regards,
Taqi Raza.