SXSSF sheets and datavalidation

2020-05-15 Thread Yoeri Smets
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 ? Gre

Re: SXSSF sheets and datavalidation

2020-05-18 Thread Yoeri Smets
late 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 +, Yoeri Smets wrote: > > Hi all, >

Re: SXSSF sheets and datavalidation

2020-05-21 Thread Yoeri Smets
ch would be to write the SXSSF first, then to > extract/open the XML sheet and to manipulate that XML sheet > incorporating your constraints. > > I understand that these are not your preferred solutions but I do not > know of a better way. > > Best regards > Andreas >