I havent heard of anybody using POI for such a purpose, but its very interesting, and if you can get it done, i'm sure many people will find it useful.
In general, if you are doing this, ensure that you are using the latest CVS code from the REL_2_BRANCH .. you might be hitting an already fixed bug. (DONT use head for the moment). Also, to start out, dont have any unicode or special characters in your text strings, try it first with simple english strings. Once you have tested in these situations, and it still doesnt work, maybe you can save the bytearray to a file and share it here, so that people can play around with it. -------Original Message------- > From: nate <[EMAIL PROTECTED]> > Subject: Can I use POI to read Biff8 off the clipboard? > Sent: 29 Oct 2003 19:35:20 > > Greetings all. > One of the formats Excel puts on the clipboard is Biff8, which I > understand to be their native file format. I would like to use POI to > convert this data into an HSSWorkbook. Having got a > ByteArrayInputStream from the clipboard I have tried: > POIFSFileSystem fs = new POIFSFileSystem(stream); > HSSFWorkbook wb = new HSSFWorkbook(fs); > My results have been encouraging, but not fully satisfactory. > Specifically, I have success if all the cells pasted to the clipboard > are number cells, but have errors when some of the cells are text cells. > These errors vary from having the row containing the cell read in but > "drop" the cell, to a ClassCastException being thrown from > ValueRecordsAggregate.insertCell. > > My question is this: Can POI be used to read Excel-generated Biff8 > streams from the clipboard, or is this an unsupported use? > Thank you. > Nate > > > > --------------------------------------------------------------------- > To unsubscribe, e-mail: [EMAIL PROTECTED] > For additional commands, e-mail: [EMAIL PROTECTED] -------Original Message-------
