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