poi-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From 行健 <duanxingj...@gmail.com>
Subject Re: setAutoFilter in BIgGridDemo
Date Fri, 01 Apr 2011 01:14:11 GMT
I do find a way to realize autofilter for BigGridDemo, if anyone interested,
I can share the code

But basically you need to register at both the specific sheet
(e.g.,sheet2.xml) file and the workbook, there is almost no overhead, but
you have to know the cell range of data.

On Thu, Mar 3, 2011 at 3:06 AM, Mark Beardsley <markbrdsly@tiscali.co.uk>wrote:

> Morning Jack,
>
> I am by no means an expert with the BigGridDemo approach but, if I
> understand it correctly, the answer to your question is not really.
>
> When Yegor created the example, I understood that in order to use the
> approach you created a template file using Excel and then simply populated
> it using the BigGrid 'approach'. If that is true then I think your main
> recourse would be to create the autofilter when you build the template; I
> am
> not convinced it can be done when you populate the workbook.
>
> Now, having said that, it may be possible to work around the problem. The
> autofilter will simply be some xml markup inserted into the file. The best
> thing for you to do is to create a simple workbook using Excel and set an
> autofilter on the data. After you have saved the file to disc, change it's
> extension to .zip and unzip the file into a directory so that you can
> examine the files contents. Now, locate where the markup for the sutofilter
> is, work out what the various attributes are and use that as a guide
> allowing you to re-create the same when building a file using the BigGrid
> technique. You may even be able to adopt a 'combined' approach; use Excel
> to
> include the autofilter into the file when yo create the template and modify
> it's attributes when you merge data and template together. To my mind, this
> is the 'better' approach as Excel will have built al of the necessary - if
> indedd there are any - relationships.
>
> You may well want to wait for someone who is better qualified than I to
> reply, that cannot hurt.
>
> Yours
>
> Mark B
>
> PS If you do manage to make this work, would you be willing to post the
> solution on the list so that other members cna see and benefit from your
> work?
>
> --
> View this message in context:
> http://apache-poi.1045710.n5.nabble.com/setAutoFilter-in-BIgGridDemo-tp3407436p3407616.html
> Sent from the POI - User mailing list archive at Nabble.com.
>
> ---------------------------------------------------------------------
> 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