错误信息如下:
......
java.lang.ArrayIndexOutOfBoundsException
at java.lang.System.arraycopy(Native Method)
at jxl.biff.StringHelper.getBytes(StringHelper.java:127)
at jxl.write.biff.WriteAccessRecord.<init>(WriteAccessRecord.java:59)
at jxl.write.biff.WritableWorkbookImpl.write(WritableWorkbookImpl.java:726)
......
神奇的是,在项目中发现该现象只有在Linux环境下才发生而Window下则正常运行。
根据错误信息的提示,发现问题出在WriteAccessRecord文件里,其源代码如下所示:
view plain
1.package jxl.write.biff;
2.
3.import jxl.Workbook;
4.import jxl.biff.StringHelper;
5.import jxl.biff.Type;
6.import jxl.biff.WritableRecordData;
7.
8./**
9. * The name used when Excel was installed.
10. * When writing worksheets, it uses the value from the WorkbookSettings object,
11. * if this is not set (null) this is hard coded as
12. * Java Excel API + Version number
13. */
14.class WriteAccessRecord extends WritableRecordData
15.{
16. /**
17. * The data to output to file
18. */
19. private byte[] data;
20.
21. // String of length 112 characters
22. /**
23. * The author of this workbook (ie. the Java Excel API)
24. */
25. private final static String authorString = "Java Excel API";
26. private String userName;
27.
28. /**
29. * Constructor
30. */
31. public WriteAccessRecord(String userName)
32. {
33. super(Type.WRITEACCESS);
34.
35. data = new byte[112];
36. String astring = userName != null ?
37. userName :
38. authorString + " v" + Workbook.getVersion();
39.
40. StringHelper.getBytes(astring, data, 0);
41.
42. // Pad out the record with space characters
43. for (int i = astring.length() ; i < data.length ;i++)
44. {
45. data[i] = 0x20;
46. }
47. }
48.
49. /**
50. * Gets the data for output to file
51. *
52. * @return the binary data
53. */
54. public byte[] getData()
55. {
56. return data;
57. }
58.}
分析上诉代码发现,byte数组data的最大长度被定义为112,当被传入的参数userName达到一定长度时就会抛错。
跟踪代码WritableWorkbookImpl发现,userName实际就是WorkbookSettings类中的writeAccess字段,亦即生成Excel是的用户信息。可能在linux环境UTF8下每个汉字的字节数为3位(Windows中是2位)的缘故,出现了上诉的奇异现象。
解决的办法如下:
1.修改JXL源代码中WriteAccessRecord文件代码,重新设置变量data的长度,例如:data = new byte[astring.getBytes().length];
2.一般我们在读取模板文件生成新的Excel时往往使用如下代码:
view plain
1.import java.io.File;
2.
3.import jxl.Workbook;
4.import jxl.write.WritableSheet;
5.import jxl.write.WritableWorkbook;
6.
7.public class Test {
8.
9. public static void main(String[] args) throws Exception {
10.
11. Workbook wb = Workbook.getWorkbook(new File("C:/data_template.xls"));
12. WritableWorkbook workbook = Workbook.createWorkbook(new File("C:/data_output.xls"), wb);
13.
14. WritableSheet sheet = workbook.getSheet(3);
15. sheet.getSettings().setSelected(true);
16.
17. workbook.write();
18. workbook.close();
19. }
20.}
只要在代码中强制设置变量WorkbookSettings.writeAccess的值即可,例如:
Workbook wb = Workbook.getWorkbook(new File("C:/data_template.xls"));
WorkbookSettings settings = new WorkbookSettings ();
settings.setWriteAccess(null);
WritableWorkbook workbook = Workbook.createWorkbook(new File("C:/data_output.xls"), wb, settings);
WritableSheet sheet = workbook.getSheet(3);
sheet.getSettings().setSelected(true);
workbook.write();
workbook.close();
使用JXL生成Excel时发生java.lang.ArrayIndexOutOfBoundsException错误
最新推荐文章于 2023-09-14 00:05:49 发布