Not able to see the content of POI Excel Header

Asked Mar 09 '17 at 11:30

Active Mar 10 '17 at 06:23

Viewed 185 times

I am creating POI Excel sheet with a header, although header is getting created but every time after downloading the excel I have to enable header to see the header content. Please help me so that when I download and open the excel sheet, I do not have to click on header option in insert tab to see the header file.

This is the code I have used to create the header .

XSSFWorkbook  workbookuse = new XSSFWorkbook();
            XSSFSheet sheetuse = workbookuse.createSheet("Usage_Report"); 
     Header header = sheetuse.getHeader();
                header.setCenter(HSSFHeader.font("Calibri", "Bold") +
                        generatedUseFileName.substring(0,11));

                    header.setLeft("Test Data");

                header.setRight("Test Data");

I am using office 2016.

edited Mar 10 '17 at 06:23

asked Mar 09 '17 at 11:30

Sunil

How are you setting the header to the sheet ?? – Srikanth Balaji Mar 09 '17 at 12:02
The above code I am using which create header for the sheet .sheetuse is the instance of sheet – Sunil Mar 09 '17 at 12:04
Code is added now . – Sunil Mar 10 '17 at 06:24

Not able to see the content of POI Excel Header

0 Answers0