Must admit that my first thought was no, this is not possible. Thinking about it again however, it all depends upon what information is stored on the clipboard, where it is stored and how you could get at it. If you are very lucky and all of the information about a cell is stored in a very small file in the BIFF8 format then it could be possible to open a stream onto that file and access it using HSSF.
I have never had to do anything like this and so I could very well be wrong but think I would begin by looking at what information is stored in the clipboard, where it is stored and in what format. Just as an aside, what happens if you try to copy between two Excel applications using the clipboard? I do not mean between two sheets within a workbook or even between two workbooks within an Excel session but between two Excel sessions (i.e. open Excel, enter a value into a cell on a worksheet, copy that cell then close down Excel,. Open Excel again and try to paste the cell onto a different worksheet)? --- On Thu, 7/17/08, neil hart <[EMAIL PROTECTED]> wrote: From: neil hart <[EMAIL PROTECTED]> Subject: Using POI to read the clipboard from Excel To: [email protected] Date: Thursday, July 17, 2008, 2:22 PM Currently we are copying data from Excel and reading it in Java through the clipboard. Our solution get only the String values for each cell. Can POI give us more of a leg up by providing the correct cell type (Number, Date, etc) in reading the clipboard. Again, we are taking clipboard, not reading a file. Thanks Neil
