Find Hidden Worksheet

The following example shows you how to find hidden worksheet .

import com.independentsoft.office.spreadsheet.Sheet;
import com.independentsoft.office.spreadsheet.SheetVisibilityType;
import com.independentsoft.office.spreadsheet.Workbook;

public class Example {

    public static void main(String[] args)
    {
        try
        {
            Workbook book = new Workbook("c:\\test\\input.xlsx");

            for(Sheet sheet : book.getSheets())
            {
                if(sheet.getVisibilityState() == SheetVisibilityType.HIDDEN)
                {
                	System.out.println("Hidden sheet: " + sheet.getName());
                }
            }
        }
        catch (Exception e)
        {
            System.out.println(e.getMessage());
            e.printStackTrace();
        }
    }
}

Independentsoft - any library, any programming language

JSpreadsheet > Tutorial > Find Hidden Worksheet

Need help? Ask our developers: