How to set Excel page view mode as "Page Layout" using Apache POI?

Question

I have created Excel file using "HSSFWorkbook" in my project.

Whenever the user opens the Excel file it should display in "Page Layout" view i.e. the user should able to view entire page info including header, footer. However, I have tried in different ways but I couldn't do.

Answer 1

Its not much clear for me, but if you want to fit the entire sheet in one page then you should do something like:

Workbook wb = new HSSFWorkbook();
Sheet sheet = wb.createSheet("format sheet");
PrintSetup ps = sheet.getPrintSetup();

sheet.setAutobreaks(true);

ps.setFitHeight((short)1);
ps.setFitWidth((short)1);