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]
