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: [email protected] For additional commands, e-mail: [email protected]
