tag:blogger.com,1999:blog-37642571.post3362821891492627949..comments2024-03-20T02:30:44.457-07:00Comments on Thinking In Software: Excel Workbook Encryption from JavaNestor Urquizahttp://www.blogger.com/profile/12351754666722274569noreply@blogger.comBlogger2125tag:blogger.com,1999:blog-37642571.post-56980464883395592192014-01-16T07:30:56.719-08:002014-01-16T07:30:56.719-08:00@Todesbote I don't have more code than this re...@Todesbote I don't have more code than this really. The code is just showing how you can protect the workbook manually and then use it later as a template to create the final workbook you really want. It would look to me like you are trying to load an invalid workbook. Note the HSSF is used for XLS while XSSF is used for XLSX workbooks. This example is for XLS workbooks but you should use this trick for XLSX provided you use the right POI API.Nestor Urquizahttps://www.blogger.com/profile/12351754666722274569noreply@blogger.comtag:blogger.com,1999:blog-37642571.post-83446949950508310182014-01-14T21:48:35.998-08:002014-01-14T21:48:35.998-08:00Hi, I think your code is the solution for my probl...Hi, I think your code is the solution for my problem. But if I try to use the code I get some Errors.<br />java.io.IOException: Unable to read entire header; 0 bytes read; expected 512 bytes<br /><br />at org.apache.poi.poifs.storage.HeaderBlock.alertShortRead(HeaderBlock.java:226)<br /><br />at org.apache.poi.poifs.storage.HeaderBlock.readFirst512(HeaderBlock.java:207)<br /><br />at org.apache.poi.poifs.storage.HeaderBlock.(HeaderBlock.java:104)<br /><br />at org.apache.poi.poifs.filesystem.POIFSFileSystem.(POIFSFileSystem.java:138)<br /><br />at org.apache.poi.hssf.usermodel.HSSFWorkbook.(HSSFWorkbook.java:322)<br /><br />at org.apache.poi.hssf.usermodel.HSSFWorkbook.(HSSFWorkbook.java:303)<br /><br />at XlsUtil.passwordProtect(XlsUtil.java:16)<br /><br />at XlsUtil.main(XlsUtil.java:29)<br /><br />Do I need to use the code the package com.nestorurquiza.utils?<br />Where can I get it?<br /><br />Can you help me please?<br /><br />Todesbotehttps://www.blogger.com/profile/06352377816988261042noreply@blogger.com