How to extract only Visible sheets in excel?

Aspose.Cells Product Family
1

I found this piece of code helpful

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

2

@manoj.h,
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 {

    @Override
    public void startSheet(Worksheet sheet)
    {
        if (sheet.isVisible())
        {
            // Load everything from visible worksheet
            this.setLoadDataFilterOptions(LoadDataFilterOptions.ALL);
        }
        else
        {
            // Load nothing
            this.setLoadDataFilterOptions(LoadDataFilterOptions.NONE);
        }
    }
}

Let us know your feedback.