将数据库中的数据导入excel 我将从数据库中查询到的记录放在一个List中,然后想将list中的数据导入到excel中,求这样一个方法??? 解决方案 » 免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货 import org.apache.poi.hssf.usermodel.HSSFCell;import org.apache.poi.hssf.usermodel.HSSFRichTextString;import org.apache.poi.hssf.usermodel.HSSFRow;import org.apache.poi.hssf.usermodel.HSSFSheet;import org.apache.poi.hssf.usermodel.HSSFWorkbook;import org.apache.poi.hssf.util.CellRangeAddress;/** * @author idle~` * @version 0.1 * @date 2008-11-4 */public class POITest { public static String outputFile="E:/TEMP/idleTest.xls"; public static void main(String argv[]){ try{ HSSFWorkbook workbook = new HSSFWorkbook(); // create sheet HSSFSheet sheet = workbook.createSheet("test"); // create row at line 0 HSSFRow row = sheet.createRow(0); // create cell at row 0 HSSFCell cell = row.createCell(0); // set cell value type cell.setCellType(HSSFCell.CELL_TYPE_STRING); // set cell value cell.setCellValue(new HSSFRichTextString("")); cell.setCellStyle(POIStyleUtil.getTitleStyle(workbook)); // merge row and column from row 0 to row 0,column 0 to column 7 sheet.addMergedRegion(new CellRangeAddress(0,0,0,7)); for(int i = 1; i < 10; i++){ HSSFRow rows = sheet.createRow(i); for(int j = 0; j < 8; j ++){ HSSFCell cells = rows.createCell(j); cells.setCellType(HSSFCell.CELL_TYPE_STRING); cells.setCellValue(new HSSFRichTextString("" + i + " : " + j)); cells.setCellStyle(POIStyleUtil.getColumnTitleStyle(workbook)); } } FileOutputStream fOut = new FileOutputStream(outputFile); workbook.write(fOut); fOut.flush(); fOut.close(); System.out.println(""); }catch(Exception e) { System.out.println("问题是" + e ); } } }POI,很简单的 我的资源里有份 将数据库数据导入excel源代码,下载后即可使用楼主可以去看看 http://kingsui.javaeye.com/blog/154712参考一下这里的实现 用POI吧, 这个最方便, 到Apache的主页上去找 支持POI的,刚实现过,不过在公司! 百分求助:java參數中的空格問題 用java怎么实现定时运行某个程序? Jbulider 连不上 SQL SEVER2000 为何跳转到servlet会有异常????-----急----- J2EE面试 判断文件有空行 今天面试的上机题,帮忙看看 swing的设置背景问题 有个问题向高手请教。 把程序打包成可执行的jar后,双击运行时找不到源程序访问的图片了,该怎么办?解决立即给分 JAVA桌面应用程序如何调用数据库内容 登陆界面如何进入到主界面?
import org.apache.poi.hssf.usermodel.HSSFRichTextString;
import org.apache.poi.hssf.usermodel.HSSFRow;
import org.apache.poi.hssf.usermodel.HSSFSheet;
import org.apache.poi.hssf.usermodel.HSSFWorkbook;
import org.apache.poi.hssf.util.CellRangeAddress;/**
* @author idle~`
* @version 0.1
* @date 2008-11-4
*/
public class POITest {
public static String outputFile="E:/TEMP/idleTest.xls";
public static void main(String argv[]){
try{
HSSFWorkbook workbook = new HSSFWorkbook();
// create sheet
HSSFSheet sheet = workbook.createSheet("test");
// create row at line 0
HSSFRow row = sheet.createRow(0);
// create cell at row 0
HSSFCell cell = row.createCell(0);
// set cell value type
cell.setCellType(HSSFCell.CELL_TYPE_STRING);
// set cell value
cell.setCellValue(new HSSFRichTextString(""));
cell.setCellStyle(POIStyleUtil.getTitleStyle(workbook));
// merge row and column from row 0 to row 0,column 0 to column 7
sheet.addMergedRegion(new CellRangeAddress(0,0,0,7));
for(int i = 1; i < 10; i++){
HSSFRow rows = sheet.createRow(i);
for(int j = 0; j < 8; j ++){
HSSFCell cells = rows.createCell(j);
cells.setCellType(HSSFCell.CELL_TYPE_STRING);
cells.setCellValue(new HSSFRichTextString("" + i + " : " + j));
cells.setCellStyle(POIStyleUtil.getColumnTitleStyle(workbook));
}
}
FileOutputStream fOut = new FileOutputStream(outputFile);
workbook.write(fOut);
fOut.flush();
fOut.close();
System.out.println("");
}catch(Exception e) {
System.out.println("问题是" + e );
}
} }POI,很简单的
楼主可以去看看
参考一下这里的实现