Re: SXSSF sheets and datavalidation

Hi Andreas,

thanks for  the thinking.
Problem is that constraints are not static so can't go with that approach.

Kind regards,
Yoeri


On 2020/05/16 06:29:58, Andreas Reichel <[email protected]> wrote: 
> Yoeri,
> 
> my advise would be to create a XLSX file with your required constraints
> and to use it as a template, which you can open with the SXSSF API in
> order to fill it with data.
> Pay attention that you will be able to fill on NEW cells (but not to
> update/overwrite existing ones).
> 
> You could either use header rows or reference sheets for separating
> template content from the variable data.
> This approach would work of course only, when your contraints
> definition is static and not depending on the particular data set.
> 
> Cheers
> Andreas
> 
> 
> On Fri, 2020-05-15 at 13:37 +0000, Yoeri Smets wrote:
> > Hi all,
> > I'm looking arround to get a dropbox with limited possible value
> > displayed on an SXSSFWorkbook.I've found several examples for the
> > XSSF api however no implementation is found to create an
> > explicitListConstraint.
> > Is ther someone out here who has managed to get this up and running ?
> > Greetz,Yoeri
> > 
> > -------------------------------------------------------------------
> > --To unsubscribe, e-mail: [email protected]
> > For additional commands, e-mail: [email protected]
> > 
> 
> 
>