使用Java创建Excel [英] create excel using Java

问题描述

我对Java非常陌生.我试图从数据库中获取一些数据，结果集显示在excel中.我能够吸引数据库.但是我应该如何继续将数据插入excel表格中呢?它是简单的Java程序，将来我希望生成其他格式的文件，例如PDF，doc等. 我正在寻找一种方法，它可以减轻CPU负载，提高速度.

I am very new to java. I am trying to fetch some data from a database and the result set is displayed in excel. I am able to inetract with database. But how should I go ahead for inserting data into excel sheet.Its simple Java program and in future I would like to generate files in other format say PDF, doc etc. I am looking for an approach with lesser load on CPU, faster.

预先感谢您的帮助.

推荐答案

只需吐出一个CSV文件.它轻巧便携.我认为您可以从Apache Commons那里找一个csv作家，但花10分钟写一个可能也很不错.

Just spit out a CSV file. It's lightweight and portable. You can grab a csv writer from Apache commons I think but spending the 10 min it would take to write one might be a good learning exercise as well.

这篇关于使用Java创建Excel的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！