将数据库中的数据导入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的,刚实现过,不过在公司! 如果仅栈序列为e1,e2,e3,e4则出栈序列是? 指针式钟表表盘上添加一个文本框,文本框显示电子时间 用jxl修改了excel表后,不能再次读取 jsp里如何调用php? 谁能告诉我Draw2d如何画点和直线? java的数据库问题 socket中传输图片的问题 java新手,诚心求教! 关于JTextArea() JAVA撰写FTP服务器中出现的一些问题,大侠帮帮忙! 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,很简单的
楼主可以去看看
参考一下这里的实现