Java导入导出Excel、Word数据 要用Java实现导入导出Excel、Word数据 解决方案 » 免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货 http://hi.baidu.com/xiami9910/blog/item/00d5b56044f0cfd98cb10d20.html一部分代码import org.apache.poi.hssf.usermodel.HSSFWorkbook;import org.apache.poi.hssf.usermodel.HSSFSheet;import org.apache.poi.hssf.usermodel.HSSFRow;import org.apache.poi.hssf.usermodel.HSSFCell;import java.io.FileOutputStream;import java.io.FileInputStream;public class CreateXL { public static String xlsFile="test.xls"; //产生的Excel文件的名称 public static void main(String args[]) { try { HSSFWorkbook workbook = new HSSFWorkbook(); //产生工作簿对象 HSSFSheet sheet = workbook.createSheet(); //产生工作表对象 //设置第一个工作表的名称为firstSheet //为了工作表能支持中文,设置字符编码为UTF_16 workbook.setSheetName(0,"firstSheet",HSSFWorkbook.ENCODING_UTF_16); //产生一行 HSSFRow row = sheet.createRow((short)0); //产生第一个单元格 HSSFCell cell = row.createCell((short) 0); //设置单元格内容为字符串型 cell.setCellType(HSSFCell.CELL_TYPE_STRING); //为了能在单元格中写入中文,设置字符编码为UTF_16。 cell.setEncoding(HSSFCell.ENCODING_UTF_16); //往第一个单元格中写入信息 cell.setCellValue("测试成功"); FileOutputStream fOut = new FileOutputStream(xlsFile); workbook.write(fOut); fOut.flush(); fOut.close(); System.out.println("文件生成..."); //以下语句读取生成的Excel文件内容 FileInputStream fIn=new FileInputStream(xlsFile); HSSFWorkbook readWorkBook= new HSSFWorkbook(fIn); HSSFSheet readSheet= readWorkBook.getSheet("firstSheet"); HSSFRow readRow =readSheet.getRow(0); HSSFCell readCell = readRow.getCell((short)0); System.out.println("第一个单元是:" + readCell.getStringCellValue()); } catch(Exception e) { System.out.println(e); } }} public static void resultSetToExcel(ResultSet rs,String xlsName,String sheetName) throws Exception{ HSSFWorkbook workbook = new HSSFWorkbook(); HSSFSheet sheet = workbook.createSheet(); workbook.setSheetName(0,sheetName,HSSFWorkbook.ENCODING_UTF_16); HSSFRow row= sheet.createRow((short)0);; HSSFCell cell; ResultSetMetaData md=rs.getMetaData(); int nColumn=md.getColumnCount(); //写入各个字段的名称 for(int i=1;i<=nColumn;i++) { cell = row.createCell((short)(i-1)); cell.setCellType(HSSFCell.CELL_TYPE_STRING); cell.setEncoding(HSSFCell.ENCODING_UTF_16); cell.setCellValue(md.getColumnLabel(i)); } int iRow=1; //写入各条记录,每条记录对应Excel中的一行 while(rs.next()) {row= sheet.createRow((short)iRow);; for(int j=1;j<=nColumn;j++) { cell = row.createCell((short)(j-1)); cell.setCellType(HSSFCell.CELL_TYPE_STRING); cell.setEncoding(HSSFCell.ENCODING_UTF_16); cell.setCellValue(rs.getObject(j).toString()); } iRow++; } FileOutputStream fOut = new FileOutputStream(xlsName); workbook.write(fOut); fOut.flush(); fOut.close(); JOptionPane.showMessageDialog(null,"导出数据成功!");} Java操作PDF http://www.lowagie.com/ Java操作Word,Excel,Access 参考: http://danadler.com/jacob/ http://jakarta.apache.org/poi/ http://www.onjava.com/pub/a/onjava/2003/01/22/poi.html http://www.csdn.net/develop/article/15/15311.shtm http://forum.java.sun.com/thread.jsp?forum=40&thread=382666&tstart=0&trange=15 POIhttp://poi.apache.org/spreadsheet/quick-guide.html 貌似poi操作word还不是很方便,excel倒不错,也可以考虑用jacob 导出Excel推荐用jxl,导出word推荐用itext 如果要将JFreeChart生成的图片导入Excel怎么做啊? 我用过POI,挺好用的,不过我只是导出了Excel,没有导出,也没有操作word 请高手指点关于字符串中包含的日期部分的取得的问题 jdbc创建视图 用java遍历修改文件? 如何利用JTABLE显示数据 求具体代码? java 新建文件的问题。 讨论:就一道scjp题目与大家探讨关于“静态内部类”,感谢参与! 怎么样来判断两个时间内相差多少天 我的代码有问题,急! Applet里的字符串比对问题。请援手!!!(急) 关于点对点连接问题! 复数类的toString方法找错 请教高手解析I/O流
一部分代码
import org.apache.poi.hssf.usermodel.HSSFWorkbook;
import org.apache.poi.hssf.usermodel.HSSFSheet;
import org.apache.poi.hssf.usermodel.HSSFRow;
import org.apache.poi.hssf.usermodel.HSSFCell;
import java.io.FileOutputStream;
import java.io.FileInputStream;public class CreateXL
{
public static String xlsFile="test.xls"; //产生的Excel文件的名称
public static void main(String args[])
{
try
{
HSSFWorkbook workbook = new HSSFWorkbook(); //产生工作簿对象
HSSFSheet sheet = workbook.createSheet(); //产生工作表对象
//设置第一个工作表的名称为firstSheet
//为了工作表能支持中文,设置字符编码为UTF_16
workbook.setSheetName(0,"firstSheet",HSSFWorkbook.ENCODING_UTF_16);
//产生一行
HSSFRow row = sheet.createRow((short)0);
//产生第一个单元格
HSSFCell cell = row.createCell((short) 0);
//设置单元格内容为字符串型
cell.setCellType(HSSFCell.CELL_TYPE_STRING);
//为了能在单元格中写入中文,设置字符编码为UTF_16。
cell.setEncoding(HSSFCell.ENCODING_UTF_16);
//往第一个单元格中写入信息
cell.setCellValue("测试成功");
FileOutputStream fOut = new FileOutputStream(xlsFile);
workbook.write(fOut);
fOut.flush();
fOut.close();
System.out.println("文件生成...");
//以下语句读取生成的Excel文件内容
FileInputStream fIn=new FileInputStream(xlsFile);
HSSFWorkbook readWorkBook= new HSSFWorkbook(fIn);
HSSFSheet readSheet= readWorkBook.getSheet("firstSheet");
HSSFRow readRow =readSheet.getRow(0);
HSSFCell readCell = readRow.getCell((short)0);
System.out.println("第一个单元是:" + readCell.getStringCellValue());
}
catch(Exception e)
{
System.out.println(e);
}
}
}
{
HSSFWorkbook workbook = new HSSFWorkbook();
HSSFSheet sheet = workbook.createSheet();
workbook.setSheetName(0,sheetName,HSSFWorkbook.ENCODING_UTF_16);
HSSFRow row= sheet.createRow((short)0);;
HSSFCell cell;
ResultSetMetaData md=rs.getMetaData();
int nColumn=md.getColumnCount();
//写入各个字段的名称
for(int i=1;i<=nColumn;i++)
{
cell = row.createCell((short)(i-1));
cell.setCellType(HSSFCell.CELL_TYPE_STRING);
cell.setEncoding(HSSFCell.ENCODING_UTF_16);
cell.setCellValue(md.getColumnLabel(i));
} int iRow=1;
//写入各条记录,每条记录对应Excel中的一行
while(rs.next())
{row= sheet.createRow((short)iRow);;
for(int j=1;j<=nColumn;j++)
{
cell = row.createCell((short)(j-1));
cell.setCellType(HSSFCell.CELL_TYPE_STRING);
cell.setEncoding(HSSFCell.ENCODING_UTF_16);
cell.setCellValue(rs.getObject(j).toString());
}
iRow++;
}
FileOutputStream fOut = new FileOutputStream(xlsName);
workbook.write(fOut);
fOut.flush();
fOut.close();
JOptionPane.showMessageDialog(null,"导出数据成功!");
}
Java操作Word,Excel,Access
参考:
http://danadler.com/jacob/
http://jakarta.apache.org/poi/
http://www.onjava.com/pub/a/onjava/2003/01/22/poi.html
http://www.csdn.net/develop/article/15/15311.shtm
http://forum.java.sun.com/thread.jsp?forum=40&thread=382666&tstart=0&trange=15
http://poi.apache.org/spreadsheet/quick-guide.html