Java Microsoft Excel API
声明：本页面是StackOverFlow热门问题的中英对照翻译，遵循CC BY-SA 4.0协议，如果您需要使用它，必须同样遵循CC BY-SA许可，注明原文地址和作者信息，同时你必须将它归于原作者（不是我）：StackOverFlow
原文地址: http://stackoverflow.com/questions/5898497/
Warning: these are provided under cc-by-sa 4.0 license. You are free to use/share it, But you must attribute it to the original authors (not me):
StackOverFlow
Java Microsoft Excel API
提问by user740005
Does anyone know if there is an API for java by Microsoft Excel?
有谁知道 Microsoft Excel 是否有适用于 Java 的 API？
回答by Johan Sj?berg
You have APache POIand JExcelApito mention two open source variants. The former supports up to version 2008 and the latter up to version 2003. Personally I prefer the syntax of the former.
你必须APache POI和JExcelApi提两个开源变体。前者最高支持2008版，后者最高支持2003版。我个人更喜欢前者的语法。
回答by Pravin
Extensive List of Products currently available:
当前可用的广泛产品列表：
Personally, POIwill be the best option, but it involves a lot of coding effort compared to JXLS, which is a wrapper over POI. In JXLSall you need to do is to create XLS template file with all required formatting, formulas etc using specific notation to indicate placement of data and then write a couple lines of code to invoke jXLS engine passing XLS template and the exported data as parameters. Catch in Jxls is the data in every cell must be a JavaBean.
就个人而言，POI将是最好的选择，但与 JXLS 相比，它涉及大量的编码工作，JXLS 是 POI 的包装器。在JXLS所有你需要做的就是创建XLS模板文件与使用特定的符号来表示数据的位置，然后编写代码通过XLS模板几行代码来调用JXLS发动机和导出的数据作为参数所有需要的格式，公式等。Jxls 中的 Catch 是每个单元格中的数据必须是JavaBean.
回答by Anthony Accioly
If you want to be able to write to / read from Microsoft Formats (including Excel) you are looking for Apache POI.
如果您希望能够写入/读取 Microsoft 格式（包括 Excel），您正在寻找Apache POI。
回答by fvu
- every elaborate API
- works with xlsx files
- 每一个精心制作的 API
- 适用于 xlsx 文件
- lightweight API, easier to learn
- MUCH faster on big spreadsheets (10000's of lines)
- no support (yet?) for Excel 2007+ xlsx files
- 轻量级API，更易学
- 在大型电子表格（10000 行）上快得多
- 不支持（还？）Excel 2007+ xlsx 文件
Have a look at jXLSas well, it's a library on top of POI that allows you to use Excel files as templates.
也看看jXLS，它是一个基于 POI 的库，允许您使用 Excel 文件作为模板。
回答by Alan Escreet
There are a few, but Apache POIis a popular and free one.
有一些，但Apache POI是一种流行且免费的。
回答by Brian
I would also recommend checking out JODConverter.
我还建议您查看 JODConverter。
