Search code examples
javaexcelhyperlinkapache-poi

How to create hyperlink to a filter on other sheet using Apache poi in Java?

I want to create a hyperlink from a field 'Name' on Sheet1 (Summary) to the AutoFilter on column 'Name' on Sheet2 (Details), in order to display the details of that particular name only on the Sheet2.

I have imported :

import org.apache.poi.ss.usermodel.Hyperlink;
import org.apache.poi.ss.usermodel.CreationHelper;

Hyperlink to filter on other sheet.

I have done this using VB macro, but want to implement this using Java POI.

Solution

  • Not supported with JAVA POI - Till what I found..