There doesn't appear to be an equivalent yet for HSSF. You are on the
right track for XSSF, I use that myself when stripping down a workbook to
bare bones.
I'm not at all versed in the HSSF format, so I have no idea what it might
take to implement there. As far as I can tell the binary format shares
little to no structure with the XML format.
On Fri, Apr 26, 2019 at 8:06 AM Stuart Owen <
[hidden email]> wrote:
> Hi,
>
> I can see how to get and create new validations, but am struggling to
> see how to remove them.
>
> For an XSSFSheet I seem to be able to use:
>
>
> sheet.getCTWorksheet().getDataValidations().removeDataValidation(index);
>
> but I don't see an equivalent for HSSFSheet.
>
> Any help would be appreciated.
>
> thanks,
>
> Stuart.
>
Locked
