Re: SXSSF sheets and datavalidation

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