JSP 中怎么把数据导到 EXCEL 中 ,请高人指点!!急 急 急 在线等!!! EXCEL是个模版分上下两个表格 只改变上面表格的数据谁做过给个全码 小弟谢了!! 解决方案 » 免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货 public static void export(List ls,HttpServletResponse response) { HSSFWorkbook wb = new HSSFWorkbook(); HSSFSheet sheet = wb.createSheet("sheet1"); for (int i = 0; i < ls.size(); i++) { HSSFRow row = sheet.createRow(i); String[] strs = (String[]) ls.get(i); for (int j = 0; j < strs.length; j++) { HSSFCell cell = row.createCell((short) j); cell.setEncoding(HSSFCell.ENCODING_UTF_16); cell.setCellValue(strs[j]); } }response.setContentType("application/x-msdownload");response.setHeader("content-disposition", "attachment; filename=dataexport.xls"); OutputStream os = response.getOutputStream(); wb.write(os); os.close();} package jp.co.toshiba.dm.mbs.classes;import java.io.FileOutputStream;import java.io.*;import java.util.Vector;import org.apache.poi.hssf.usermodel.HSSFCell;import org.apache.poi.hssf.usermodel.HSSFRow;import org.apache.poi.hssf.usermodel.HSSFSheet;import org.apache.poi.hssf.usermodel.HSSFWorkbook;public class MBSmainSearchDownload { static public void read(Vector V_Data,String[] S_T_koumoku,String S_midashi) throws Exception{ FileOutputStream fos = new FileOutputStream("C:\\sales.xls"); HSSFWorkbook wb = new HSSFWorkbook(); HSSFSheet s = wb.createSheet(); wb.setSheetName(0, "first sheet"); String[] SA_Data = new String[0]; HSSFRow row = null; HSSFCell cell = null; for(int i=0;i<V_Data.size();i++){ SA_Data=(String[])V_Data.get(i); for(int j=0;j<SA_Data.length;j++){ if(j>4){ int m = j-1; int n = i+1; row = s.createRow(n); cell = row.createCell((short) m); cell.setEncoding(HSSFCell.ENCODING_UTF_16); cell.setCellValue(SA_Data[j]); } if(j<4){ int n = i+1; row = s.createRow(n); cell = row.createCell((short) j); cell.setEncoding(HSSFCell.ENCODING_UTF_16); cell.setCellValue(SA_Data[j]); } } } wb.write(fos); fos.close(); } catch (Exception e) { System.err.println ("Error writing to file"); } }} 这是我前天写的,好用。那个poi得下载地址是http://apache.justdn.org/jakarta/poi/release/bin/ 完了,没看清题目,又发垃圾贴了。不过你重新读一遍excel然后重写也可以算是一个办法吧,另外,poi包里应该有实现你要的效果的包,你查查看吧,偶也是菜鸟,并且也正是痛苦着呢,所以没法帮你查,您先自力更生着吧。 楼上的兄弟说的对,用POI包还是很不错的,这两天我刚学会用POI,我是用它读取excel来群发邮件的。http://jakarta.apache.org/poi/hssf/images/usermodel.gif 里面是它的类里的所有函数。很爽的我的BLOG里有好多关于POI的使用:http://sparrow.blog.163.com 不创建新的excel文件,把数据附给已经存在的excel里,让excel原来的前两行的数据不边!!这个怎么实现啊!!! servlet中页面转发的问题forward和redirect javascript里表单验证用户注册问题 控制数据库并发?? 请问这种查询能不能优化一下 JSP如何截取某一字符串的前4个字符,和后4个字符 如何捕获Tomcat的关闭事件,请各位指点!!!! 又一个巨简单的问题:在jsp中String如何转换成int? 100分求解请客位大哥帮忙分不够可以加谢谢 jsp中文件下载程序的问题 为什么我用正则表达式获取img标签src就是不行呢!!! struts 标签问题 服务器同时运行IIS和Tomcat,有冲突吗?
HSSFWorkbook wb = new HSSFWorkbook();
HSSFSheet sheet = wb.createSheet("sheet1");
for (int i = 0; i < ls.size(); i++) {
HSSFRow row = sheet.createRow(i);
String[] strs = (String[]) ls.get(i);
for (int j = 0; j < strs.length; j++) {
HSSFCell cell = row.createCell((short) j);
cell.setEncoding(HSSFCell.ENCODING_UTF_16);
cell.setCellValue(strs[j]);
}
}
response.setContentType("application/x-msdownload");
response.setHeader("content-disposition",
"attachment; filename=dataexport.xls");
OutputStream os = response.getOutputStream();
wb.write(os);
os.close();
}
import java.io.*;
import java.util.Vector;import org.apache.poi.hssf.usermodel.HSSFCell;
import org.apache.poi.hssf.usermodel.HSSFRow;
import org.apache.poi.hssf.usermodel.HSSFSheet;
import org.apache.poi.hssf.usermodel.HSSFWorkbook;public class MBSmainSearchDownload {
static public void read(Vector V_Data,String[] S_T_koumoku,String S_midashi) throws Exception{ FileOutputStream fos = new FileOutputStream("C:\\sales.xls");
HSSFWorkbook wb = new HSSFWorkbook();
HSSFSheet s = wb.createSheet();
wb.setSheetName(0, "first sheet");
String[] SA_Data = new String[0];
HSSFRow row = null;
HSSFCell cell = null;
for(int i=0;i<V_Data.size();i++){
SA_Data=(String[])V_Data.get(i);
for(int j=0;j<SA_Data.length;j++){
if(j>4){
int m = j-1;
int n = i+1;
row = s.createRow(n);
cell = row.createCell((short) m);
cell.setEncoding(HSSFCell.ENCODING_UTF_16);
cell.setCellValue(SA_Data[j]);
}
if(j<4){
int n = i+1;
row = s.createRow(n);
cell = row.createCell((short) j);
cell.setEncoding(HSSFCell.ENCODING_UTF_16);
cell.setCellValue(SA_Data[j]);
}
}
}
wb.write(fos);
fos.close();
} catch (Exception e) {
System.err.println ("Error writing to file");
}
}
}
那个poi得下载地址是
http://apache.justdn.org/jakarta/poi/release/bin/
我的BLOG里有好多关于POI的使用:http://sparrow.blog.163.com