We're sorry Aspose doesn't work properply without JavaScript enabled.

Free Support Forum - aspose.com

How to extract only Visible sheets in excel?

I found this piece of code helpful

But this has changed in latest verion. DO we have an replacement to this in Java?

Aspose.Cells allows you to skip data in invisible worksheets while loading a workbook. To do this, create a custom function that inherits the LoadFilter class.

LoadOptions loadOptions = new LoadOptions();
loadOptions.setLoadFilter(new CustomLoad());
Workbook loadWorkbook = new Workbook("Test.xlsx", loadOptions);

Here is the implementation of the CustomLoad class referenced in the above snippet.

public class CustomLoad extends LoadFilter {

    public void startSheet(Worksheet sheet)
        if (sheet.isVisible())
            // Load everything from visible worksheet
            // Load nothing

Let us know your feedback.