package jtabletoxls;import java.io.*;
import javax.swing.*;
import org.apache.poi.hssf.eventmodel.*;
import org.apache.poi.hssf.usermodel.*;
public class JTableToXls {
public void generateXls( JTable jt,String aFileName) throws IOException{
//列
short colCount = (short)jt.getColumnCount();
//行
short rowCount = (short)jt.getRowCount(); BufferedOutputStream out =
new BufferedOutputStream(
new FileOutputStream(aFileName)); HSSFWorkbook wb = new HSSFWorkbook();
HSSFSheet s = wb.createSheet();
wb.setSheetName(0,"data");
for(short i=0; i< rowCount;i++ ){
HSSFRow row = s.createRow(i);
for( short j=0; j< colCount;j++ ){
HSSFCell cell = row.createCell(j); cell.setEncoding(HSSFCell.ENCODING_UTF_16);-----------!!!!!!!!
cell.setCellValue( jt.getValueAt(i,j).toString() ) ;
}
}
wb.write(out);
out.close();
}}
这个是我以前写的一个小程序,希望对你有帮助. ^_^
import javax.swing.*;
import org.apache.poi.hssf.eventmodel.*;
import org.apache.poi.hssf.usermodel.*;
public class JTableToXls {
public void generateXls( JTable jt,String aFileName) throws IOException{
//列
short colCount = (short)jt.getColumnCount();
//行
short rowCount = (short)jt.getRowCount(); BufferedOutputStream out =
new BufferedOutputStream(
new FileOutputStream(aFileName)); HSSFWorkbook wb = new HSSFWorkbook();
HSSFSheet s = wb.createSheet();
wb.setSheetName(0,"data");
for(short i=0; i< rowCount;i++ ){
HSSFRow row = s.createRow(i);
for( short j=0; j< colCount;j++ ){
HSSFCell cell = row.createCell(j); cell.setEncoding(HSSFCell.ENCODING_UTF_16);-----------!!!!!!!!
cell.setCellValue( jt.getValueAt(i,j).toString() ) ;
}
}
wb.write(out);
out.close();
}}
这个是我以前写的一个小程序,希望对你有帮助. ^_^
解决方案 »
- 怎么样上传文件到java的工作目录中,而不是服务器目录中(tomcat安装目录)
- 请教java web start在客户端的缓存具体存在哪里?
- spring事务简单问题
- hibernate更新老报错
- 求wssecurity.jar和tsik.jar
- 请问一个关于sitemesh的问题
- 请救..输入数组中值为1的个数
- weblogic8.1出现的一段错误,请高手来帮忙,成功再加50分!
- 菜鸟问题?盼回复
- 对JAVAbean的类上注解是@XmlClass 类里的字段上的注解是 @XmlAttribute
- 请教BCD编码与UNICODE编码的字符转换问题
- JSP及Struts开发工具:JSPStudio下载:ftp://210.36.70.51
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
又长见识了