poi-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Sam'" <maxoud...@gmail.com>
Subject Re: POI XSSF and ClipBoard issue
Date Thu, 22 Oct 2015 13:40:17 GMT
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 <dominik.stadler@gmx.at>:

> 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' <maxoudela@gmail.com> 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: user-unsubscribe@poi.apache.org
> For additional commands, e-mail: user-help@poi.apache.org
>
>

Mime
  • Unnamed multipart/alternative (inline, None, 0 bytes)
View raw message