Bug 46660 - How to unhide a hidden Workbook?
Summary: How to unhide a hidden Workbook?
Status: RESOLVED FIXED
Alias: None
Product: POI
Classification: Unclassified
Component: HSSF (show other bugs)
Version: 3.5-dev
Hardware: PC Windows XP
: P2 normal (vote)
Target Milestone: ---
Assignee: POI Developers List
URL:
Keywords:
Depends on:
Blocks:
 
Reported: 2009-02-04 00:18 UTC by Matthew
Modified: 2009-02-13 13:50 UTC (History)
0 users


Attachments
sample hidden workbook (15.00 KB, application/vnd.ms-excel)
2009-02-04 00:18 UTC, Matthew 		Details
View All Add an attachment (proposed patch, testcase, etc.)

Note You need to log in before you can comment on or make changes to this bug.
Description Matthew 2009-02-04 00:18:36 UTC 
Created attachment 23223 [details]
sample hidden workbook

I have an Excel file (please check the attachment) which is hidden when opening by MS Excel. Is it possible to make it unhide by POI? Thanks a lot!
Comment 1 Josh Micich 2009-02-13 13:50:54 UTC 
Added in svn r744253

New methods were added to Workbook interface

Some sample code:

InputStream is = new FileInputStream("HiddenTest.xls");
HSSFWorkbook wb = new HSSFWorkbook(is);
System.out.println("original hidden flag: " + wb.isHidden());
wb.setHidden(false);
OutputStream os = new FileOutputStream("NotHiddenNow.xls");
wb.write(os);
os.close();