Hi, I'm sorry if I'm not clear enough.
Yes the attachment is in XSSF format. I produced the file without POI. That means I opened Excel on my computer, then fill the cell and add a comment and saved it. Then I opened it again, clicked on the first cell and did a copy of it. Then after, I do a "paste" in my Java application and I'm trying to decode what's in it, and give it to POI. So technically, I am not providing a full spreadsheet file. Simply extracting what Excel has put into the clipboard. And apparently something was put in it into a Biff8 format. And that "something" was ok for POI. Now that if I'm extracting from the clipboard the "XML Spreadsheet" content and I give it to POI, it's not working. But maybe the cause is that : what is inside the clipboard is not a fully constructed content and POI doesn't recognize that as an Excel file. I hope that it's clearer for you.. I can provide you some simple test applications to run if you want to play around the copy/paste content. I have the feeling that people are using POI in order to construct or read files, but not many have tried to use it with the Clipboard. Regards, 2015-10-22 15:31 GMT+02:00 Dominik Stadler <[email protected]>: > Hi, > > I am still confused because the attachment you provided is in XSSF > format, how did you produce this out of the Clipboard-Data when you > state that you work with .xls/Biff8/HSSF formatted data? > > POI can read XSSF and HSSF just fine and as long as the data is a full > spreadsheet file, it should not matter where it comes from, so you can > try the "XML Spreadsheet" format listed. > > Dominik. > > On Thu, Oct 22, 2015 at 10:18 AM, Sam' <[email protected]> wrote: > > Hi guys, > > > > I initially opened this bug ( > > https://bz.apache.org/bugzilla/show_bug.cgi?id=58510) but apparently the > > user list suits better. > > > > What I want is to be able to read the content of the system clipboard > > (after someone copied something from Excel). I was doing that with POI > > (HSSF). I was finding the "Biff8" format inside the clipboard (among > > others) and giving it to POI and everything was fine. > > > > Apparently the Biff8 format is for Excel 97-2007. So my question is, is > it > > still possible to use POI for reading clipboard out of newer version of > > Excel? Has anyone attempted that? > > > > I know you people are used to open files directly with POI so my needs > are > > a bit different. Here is a list Formats available when copying (XML > > Spreadsheet, text/rtf, cf5, cf4,cf129, Biff5 , Biff12, text/plain, > > Link,text/html, Biff8, Object Descriptor, Csv, Link Source Descriptor). > > > > Thank you, > > Sam' > > --------------------------------------------------------------------- > To unsubscribe, e-mail: [email protected] > For additional commands, e-mail: [email protected] > >
