Apache POI 和 Excel VBA 性能比较
就性能速度比较而言，在不考虑开发时间的情况下，
执行相同任务时，Excel VBA 总是比 Apache POI 更快吗？
例如 - 填充背景颜色/字体格式 - 将 csv 转换为 Excel 文件
in term of performance speed comparsion and without consider the development time
is that Excel VBA always faster than Apache POI when perform same task?
e.g. - fill background color/font formatting
- convert csv into excel file
如果你对这篇内容有疑问，欢迎到本站社区发帖提问 参与讨论，获取更多帮助，或者扫码二维码加入 Web 技术交流群。
绑定邮箱获取回复消息
由于您还没有绑定你的真实邮箱，如果其他用户或者作者回复了您的评论，将不能在第一时间通知您！
发布评论
评论（1）
我经常听到比我聪明的人说：这要看情况。您必须自己进行一些测试，看看什么可以为您想要完成的任务提供最佳性能。
如果我必须猜测的话，我会选择 VBA。您可能能够做的事情比 POI 中提供的更多。最终的选择也会受到经验和架构的影响......
As I hear people smarter than me say all the time: it depends. You will have to go through some testing yourself to see what gives you the best performance for the tasks you want to accomplish.
If I would have to guess than I'd go for VBA. Chances are you'll be able to do much more than is available in POI too. The choice in the end will also be influenced by experience and architecture and ...