package test;
import java.io.FileOutputStream;
import java.io.IOException;

import org.apache.poi.ss.usermodel.Cell;
import org.apache.poi.ss.usermodel.Row;
import org.apache.poi.ss.usermodel.Sheet;
import org.apache.poi.ss.usermodel.Workbook;
import org.apache.poi.xssf.usermodel.XSSFWorkbook;

public class HiddenSheetTest {

	public static final int ROW_NUMBER = 15;
	public static final int COLUMN_NUMBER = 10;
	
	public static void main(String[] args) {

        Workbook wb = new XSSFWorkbook(); 
        Sheet hiddenSheet = wb.createSheet("HiddenSheet"); 
        Sheet dataSheet = wb.createSheet("DataSheet"); 
        Sheet dataSheet2 = wb.createSheet("DataSheet 2"); 
        populateSheetWithNumber(hiddenSheet, 5);
        populateSheetWithNumber(dataSheet, 10);
        populateSheetWithNumber(dataSheet2, 20);

        // Hide "hiddenSheet"
        wb.setSheetHidden(0, true);

        // set Active Sheet "DataSheet"
        wb.setActiveSheet(1);
        
        try {
          	FileOutputStream out = new FileOutputStream("WBTest.xlsx");
          	wb.write(out);
        	out.close();
			wb.close();
		} catch (IOException e) {
			e.printStackTrace();
		}
	}

	private static void populateSheetWithNumber(Sheet sheet, int number)
	{
		for(int i = 0; i < ROW_NUMBER; i++)
		{
			Row row = sheet.createRow(i);
			for(int j = 0;  j < COLUMN_NUMBER; j++)
			{
				Cell cell = row.createCell(j);
				cell.setCellValue(number);
			}
		}
	}
}