Mailing-List: contact user-help@poi.apache.org; run by ezmlm
Precedence: bulk
Reply-To: "POI Users List" <user@poi.apache.org>
MIME-Version: 1.0
In-Reply-To: 
 <CABdJj55WH42Cw2LPQo57M_P7NddBLthawwoO6hq8EQUOZKkKrA@mail.gmail.com>
References: 
 <CAL3niDEbzC18JV07gRyZ=wv_sfoiz0HjY+pCM+yKzMHKRBL0MQ@mail.gmail.com>
 <CABdJj55WH42Cw2LPQo57M_P7NddBLthawwoO6hq8EQUOZKkKrA@mail.gmail.com>
From: "Sam'" <maxoudela@gmail.com>
Date: Thu, 22 Oct 2015 15:40:17 +0200
Message-ID: 
 <CAL3niDGk8yFbbM+2zo0fXQnHi88B704JgJ+mROgVuD35eLfZYg@mail.gmail.com>
Subject: Re: POI XSSF and ClipBoard issue
To: POI Users List <user@poi.apache.org>
Content-Type: multipart/alternative; boundary=001a113ad88adb4f730522b1a38f

--001a113ad88adb4f730522b1a38f
Content-Type: text/plain; charset=UTF-8

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
>
>

--001a113ad88adb4f730522b1a38f--