现有一个excel文件 ,设置密码为123,用jxl怎么读取。????常规读取会报
Exception in thread "main" jxl.read.biff.PasswordException: The workbook is password protected
at jxl.read.biff.WorkbookParser.parse(WorkbookParser.java:582)
at jxl.Workbook.getWorkbook(Workbook.java:237)
at jxl.Workbook.getWorkbook(Workbook.java:198)
at Test.main(Test.java:29)
Exception in thread "main" jxl.read.biff.PasswordException: The workbook is password protected
at jxl.read.biff.WorkbookParser.parse(WorkbookParser.java:582)
at jxl.Workbook.getWorkbook(Workbook.java:237)
at jxl.Workbook.getWorkbook(Workbook.java:198)
at Test.main(Test.java:29)
解决方案 »
- twitter api如何使用?在线等~~
- java swing 的 JComboBox 能像html中的select一样将显示值和实际值对应吗?
- Hibernate事务问题
- oracle 语法问题,如何搜索一个表中的字段里包含'aa'的行
- JAVA 抛异常问题
- SQL语句少见问题,过往者都来看看,说不定你也会碰到!
- 紧急求救!为什么我的tomcat服务器过一段时间就会死掉,重起后就正常了
- 同一账户用不同浏览器登录或不同电脑登录,session问题?
- 两个项目,在不同的服务器,都有上传图片功能,图片如何通用?
- JAVA通过ssh协议连接思科路由器和交换机
- iframe中js改变css样式问题
- java如何获得当前java程序所产生的进程号
WritableSheet ws = wwb.createSheet("Test Sheet 1", 0);
SheetSettings ss = ws.getSettings();
ss.setPassword("12345678");
ss.setProtected(true);
。。我说的是整个工作薄的密码
/**
* Does the hard work of building up the object graph from the excel bytes
*
* @exception BiffException
* @exception PasswordException if the workbook is password protected
*/
protected void parse() throws BiffException, PasswordException
{
……
}
不支持带密码的workbook。
只支持带密码的worksheet,用法如:workbook.getSheet(0).getSettings().setPassword("123"); 源码参见WorkbookParser.java