如何让jxl (jexcelapi) 支持更多的数据

最新推荐文章于 2021-02-16 05:38:54 发布

fins

最新推荐文章于 2021-02-16 05:38:54 发布

阅读量248

点赞数

分类专栏： java & ee 文章标签： Excel Google Bean JVM performance

java & ee 专栏收录该内容

30 篇文章 0 订阅

订阅专栏

jxl (jexcelapi) 一直是我比较喜欢的 java版excel读写组件.
主页
[url]http://www.andykhan.com/jexcelapi/index.html[/url]

网上关于 jxl使用的文章太多太多我就不再重复jxl的用法了.

决定写这篇文章有点偶然:
刚刚我用"setUseTemporaryFileDuringWrite" 做关键字,去google里面搜索,
想看看有没有这个的更多技巧(实在没有功夫去看jxl的源码)

google之后, 居然没有一条中文的结果.

这也许说明国内还没有一篇文章来介绍 jxl 的setUseTemporaryFileDuringWrite 相关内容吧.

那我就来啰嗦两句吧, 这个也不是啥高深技术, 算作一个小知识点吧.

大家可以参见 jxl 的 changehistory : ( 写本文时最新版本是 2.6.9 for jdk 1.4)
[quote]
Version 2.6.5 (Sept 2007)

Fixed a bug to allow more than one conditional format per cell
Adjusted the cells referenced by named blocks when inserting and deleting rows
Added a synchronised block when initialising the workbook to prevent race conditions in multi-threaded environments
Migrated formula parsing to the JFlex (rather than JLex) for performance reasons. This is a GPL product - see notice on main page of the website
[color=red]When writing out a file, it is now possible to write out a temporary file, rather than generate the whole thing in memory. This feature is accessible via the WorkboodSettings bean (useTemporaryFileDuringWrite) or the system property jxl.usetemporaryfileduringwrite [/color]
Set the atan function to have two arguments
Supported the copying of WritableSheets within a Workbook, as well as read only ones (this was throwing a ClassCastException)
Lists in drop downs can only be a maximum of 256 characters. If this length is exceeded truncated the string and presented a warning
Added a non-documented workaround in order to resolve a bug in some version of the JVM not recognising the character encoding "UnicodeLittle"

[/quote]

看红色字部分. 这个特性真的很不错, 但是jxl官方没有提供示例,
大家看一下我下面的这个代码片段吧
(什么是Workbook 以及如何创建一个excel文件我就不说了 )



WorkbookSettings settings=new WorkbookSettings ();

settings.setUseTemporaryFileDuringWrite(true);

WritableWorkbook workbook = Workbook.createWorkbook(outputStream, settings);

很简单.
当按示例中的写法开启 UseTemporaryFileDuringWrite 后,
jxl在生成excel文件时所支持的单个文件记录数确实提高很多.

我这边的测试结果是开启功能比不开启多支持了 10000 余行.
(当然这和列数以及每列的内容也有关. 而且开启后速度略慢 )

===========================

简单的小知识点没啥好说的了 . 希望对大家有所帮助.

over