以下代码已经在服务器上生成了EXCEL,可是JSP中代码如何写呢? 如何下载EXCEL文件?要求服务器上不生成文件,在内存中处理可以吗?请给出JAVA和JSP的代码.package util;import java.io.*;
import jxl.*;
import jxl.write.*;
import jxl.format.*;
import java.util.*;
import java.awt.Color;
//
public class Excel{
public static void writeExcel(OutputStream os) throws Exception {
jxl.write.WritableWorkbook wwb = Workbook.createWorkbook(os);
jxl.write.WritableSheet ws = wwb.createSheet("TestSheet1", 0);
jxl.write.Label labelC = new jxl.write.Label(0, 0, "我爱中国");
ws.addCell(labelC);
jxl.write.WritableFont wfc = new jxl.write.WritableFont(WritableFont.ARIAL,20, WritableFont.BOLD, false,
UnderlineStyle.NO_UNDERLINE, jxl.format.Colour.GREEN);
jxl.write.WritableCellFormat wcfFC = new jxl.write.WritableCellFormat(wfc);
wcfFC.setBackground(jxl.format.Colour.RED);
labelC = new jxl.write.Label(6, 0, "中国爱我",wcfFC);
ws.addCell(labelC);
wwb.write();
wwb.close();
}
public static void main(String[] args)throws Exception{
File f=new File("kk.xls");
f.createNewFile();
writeExcel(new FileOutputStream(f));
}
}
import jxl.*;
import jxl.write.*;
import jxl.format.*;
import java.util.*;
import java.awt.Color;
//
public class Excel{
public static void writeExcel(OutputStream os) throws Exception {
jxl.write.WritableWorkbook wwb = Workbook.createWorkbook(os);
jxl.write.WritableSheet ws = wwb.createSheet("TestSheet1", 0);
jxl.write.Label labelC = new jxl.write.Label(0, 0, "我爱中国");
ws.addCell(labelC);
jxl.write.WritableFont wfc = new jxl.write.WritableFont(WritableFont.ARIAL,20, WritableFont.BOLD, false,
UnderlineStyle.NO_UNDERLINE, jxl.format.Colour.GREEN);
jxl.write.WritableCellFormat wcfFC = new jxl.write.WritableCellFormat(wfc);
wcfFC.setBackground(jxl.format.Colour.RED);
labelC = new jxl.write.Label(6, 0, "中国爱我",wcfFC);
ws.addCell(labelC);
wwb.write();
wwb.close();
}
public static void main(String[] args)throws Exception{
File f=new File("kk.xls");
f.createNewFile();
writeExcel(new FileOutputStream(f));
}
}
解决方案 »
- 开着服务器部署,一下沒弄好,Tomcat沒関就挂了,再启报错.启动不了,难道只能重装?
- 查询出大量的数据,使用checkbook进行全选,如何解决效率问题
- 谁有JSP 校友录原代码啊,~可以发个么..
- 请求高手问题,急!!Ext异步请求延时,奇怪的问题
- 怎么用java实现向浏览器中添加一个功能插件?我是指Interner Explorer.
- ORACLE和TOMCAT连接时出现的错误(在线等)
- 借朋友ID问问题,JSP中文问题
- 请教servlet的配置问题!
- servlet与bean的存活期--------急!!!!!!!!!
- javaweb如何实现分页?视频,代码,链接都可以。谢谢!项目结构如下
- 使用javabean时,导入包一直提示无法解析..是什么原因? 需要配置什么吗?
- 求助:怎么样通过http发送xml文件到服务端
<%
response.reset();
response.setContentType("application/vnd.ms-excel");
Excel.writeExcel(response.getOutputStream());
%>