本文目录一览：

怎么把JSP页面里的查询出来的数据导出到excel

jsp页面导出excel的话，刚好有做这个功能，可以参考如下代码：

function getExplorer() {

var explorer = window.navigator.userAgent;

// ie

if (explorer.indexOf("MSIE") = 0 || (explorer.indexOf("Windows NT 6.1;") = 0 explorer.indexOf("Trident/7.0;") = 0) ) {

alert("识别你是IE浏览器1111======");

return 'ie';

}

// firefox

else if (explorer.indexOf("Firefox") = 0) {

return 'Firefox';

}

// Chrome

else if (explorer.indexOf("Chrome") = 0) {

return 'Chrome';

}

// Opera

else if (explorer.indexOf("Opera") = 0) {

return 'Opera';

}

// Safari

else if (explorer.indexOf("Safari") = 0) {

return 'Safari';

}

}

//设置导出的excel的标题

var excelTitle ="表格数据";

jsp页面内容导出到Excel中 怎么做

java  jsp 页面 通过js  导出table 的源代码

%@ page language="java" import="java.util.*" pageEncoding="UTF-8"%

taglib uri="" prefix="c" /

%@ page import="java.util.ArrayList"%

%

 path = request.getContextPath();

String basePath = request.getScheme() + "://"

+ request.getServerName() + ":" + request.getServerPort()

+ path + "/";

String gonghao = "";

%

!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN"

html

head

base href="%=basePath%"

titleMy JSP 'table.jsp' starting page/title

meta http-equiv="pragma" content="no-cache"

meta http-equiv="cache-control" content="no-cache"

meta http-equiv="expires" content="0"

meta http-equiv="keywords" content="keyword1,keyword2,keyword3"

meta http-equiv="description" content="This is my page"

script type="text/javascript"

var daochu = (function()

{

  var uri = 'data:application/vnd.ms-excel;base64,'

    , template = 'html xmlns:o="urn:schemas-microsoft-com:office:office" xmlns:x="urn:schemas-microsoft-com:office:excel" xmlns=""head!--[if gte mso 9]xmlx:ExcelWorkbookx:ExcelWorksheetsx:ExcelWorksheetx:Name{worksheet}/x:Namex:WorksheetOptionsx:DisplayGridlines//x:WorksheetOptions/x:ExcelWorksheet/x:ExcelWorksheets/x:ExcelWorkbook/xml![endif]--/headbodytable{table}/table/body/html'

    , base64 = function(s) { return window.btoa(unescape(encodeURIComponent(s))) }

    , format = function(s, c) { return s.replace(/{(/w+)}/g, function(m, p) { return c[p]; }) }

  return function(table, name){ if (!table.nodeType) table = document.getElementById(table)

    var ctx = {worksheet: name || 'Worksheet', table: table.innerHTML}

    window.location.href = uri + base64(format(template, ctx))

  }

})()/script

style type="text/css"

!--

#menu {

color: #00CCFF;

}

#mkoo {

background-image: url(bg.jpg);

background-repeat: no-repeat;

background-position: left top;

}

--

/style

/head

body background="023.jpg"

div id="mkoo"

/div

form id="form1" runat="server"

table id="excel" width="1000px" border="1" bgcolor="#0066CC"

tr align="center"

td bgcolor='#9999FF' scope='col' width="40px"

序号

/td

td bgcolor='#9999FF' scope='col' width="50px"

姓名

/td

/tr

/table

/form

input align="left" name="button" type="button"

onclick="daochu('excel')" value="导出数据" /

/body

/html

如何把JSP页面导出到Excel中

方法一： function saveCode(obj) { var winname = window.open('', '_blank', 'top=10000'); var strHTML = document.all.tableExcel.innerHTML; winname.document.open('text/html', 'replace'); winname.document.writeln(strHTML); winname.document.execCommand('saveas','','excel.xls'); winname.close(); } 方法二： // Excel导出2 /** 如果javaScript报“Automation 服务器不能创建对象”，则按下方解决。 打开Internet Explorer “工具”菜单栏中的“选项”一栏，单击“安全”栏中的“自定义级别”选项卡， 将第三项“对没有标记为安全的activex控件进行初始化和脚本运行”设置成“启用”即可。 */ function exportExecl(tableId) { var table=document.getElementById(tableId); var oXL = new ActiveXObject("Excel.Application"); var oWB = oXL.Workbooks.Add(); var oSheet = oWB.ActiveSheet; var sel=document.body.createTextRange(); sel.moveToElementText(table); sel.select(); sel.execCommand("Copy"); oSheet.P... 方法一：

function saveCode(obj) {

var winname = window.open('', '_blank', 'top=10000');

var strHTML = document.all.tableExcel.innerHTML;

winname.document.open('text/html', 'replace');

winname.document.writeln(strHTML);

winname.document.execCommand('saveas','','excel.xls');

winname.close();

}

方法二：

// Excel导出2

/**

如果javaScript报“Automation 服务器不能创建对象”，则按下方解决。

打开Internet Explorer “工具”菜单栏中的“选项”一栏，单击“安全”栏中的“自定义级别”选项卡，

将第三项“对没有标记为安全的activex控件进行初始化和脚本运行”设置成“启用”即可。

*/

function exportExecl(tableId) {

var table=document.getElementById(tableId);

var oXL = new ActiveXObject("Excel.Application");

var oWB = oXL.Workbooks.Add();

var oSheet = oWB.ActiveSheet;

var sel=document.body.createTextRange();

sel.moveToElementText(table);

sel.select();

sel.execCommand("Copy");

oSheet.Paste();

oXL.Visible = true;

}

这里的tableId为表格的id

java 如何将jsp中显示的一个表格导出为excel

String path = "";//自己定义excel的路径

File file = new File(path);

file.createnewFile();//创建一个空的excel

FileInputStream fileIn = new FileInputStream(path);//path为excel

POIFSFileSystem fs = new POIFSFileSystem(fileIn);

HSSFWorkbook wb = new HSSFWorkbook(fs);

HSSFSheet sheet = wb.getSheetAt(0);//获得第一张sheet

//下面给表的第一行第一列赋值

HSSFRow row = sheet.getRow(0);//第一行对应0

HSSFCell cell = row.getCell(0);//第一列对应0

cell.setCellValue("值");

//写回到excel

ByteArrayOutputStream baos = new ByteArrayOutputStream();

wb.write(baos);

File file = new File(path);

FileOutputStream fo = new FileOutputStream(file);

baos.writeTo(fo);

fo.flush();

fo.close();

jsp如何导出excel

类文件，导入poi包。package com.grs.exportexcel;import java.io.*;

import java.util.List;

import org.apache.poi.hssf.usermodel.*;

import javax.servlet.http.HttpServletRequest;

import javax.servlet.http.HttpServletResponse;public final class ExcelUtils

{public ExcelUtils() {

}/**

* 导出excel对外接口

*

* @param title 标题 如：同业对标分段统计报表

* @param tableData 数据表数据 如：new String[][]{{"表头1","表头2"},{"data1","data2"}}

* @param exportFileName 导出后的文件名 如：data.xls

* @param request

* @param response

*/

public static void exportExcelData(

String title,

String[][] tableData,

String exportFileName,

HttpServletRequest request,

HttpServletResponse response) {

response.reset();

String fileName = "attachment;filename=/"" + exportFileName + "/";";

response.setHeader("Content-disposition", fileName);

response.setContentType("application/vnd.ms-excel");

try {

exportExcel(title,tableData,response.getOutputStream(),createWorkbook());

response.getOutputStream().flush();

response.getOutputStream().close();

} catch (Exception e) {

e.printStackTrace();

// log.error(e.getMessage(), e);

}

}

protected static void exportExcel(

String title,

String[][] tableData,

OutputStream output,

HSSFWorkbook workbook)

throws Exception {

HSSFSheet sheet = workbook.getSheetAt(0);

HSSFCellStyle titleStyle = workbook.createCellStyle();

titleStyle.setFillBackgroundColor((short) 55);

HSSFFont hsFont = workbook.createFont();

hsFont.setBoldweight((short) 700);

String titles[] = tableData[0];

titleStyle.setFont(hsFont);

titleStyle.setAlignment((short) 2);

HSSFRow row = sheet.createRow(1); row.setHeight((short) 300);

HSSFCell cell = createCell(row, (short) 0, title, titleStyle); row = sheet.createRow(3);

row.setHeight((short) 250);

short i = 0;

for (int forI = 0; forI titles.length; forI++) {

createCell(row, i, titles[forI], titleStyle);

i++;

} int rowCount = 4; for (int rowPos = 1; rowPos tableData.length; rowPos++) {

row = sheet.createRow(rowCount++);

i = 0;

for (int colPos = 0; colPos tableData[rowPos].length; colPos++) {

createCell(row, i, tableData[rowPos][colPos], null);

i++;

}

}

try {

workbook.write(output);

} catch (Exception e) {

//throw new Exception(e);

}

} protected static HSSFCell createCell(

HSSFRow row,

short cellCount,

String value,

HSSFCellStyle titleStyle) {

HSSFCell cell = row.createCell(cellCount);

cell.setEncoding((short) 1);

if (titleStyle != null)

cell.setCellStyle(titleStyle);

cell.setCellValue(value); return cell;

}public static HSSFWorkbook createWorkbook() throws Exception {

HSSFWorkbook wb = new HSSFWorkbook();

HSSFSheet s = wb.createSheet();

return wb;

}public static HSSFWorkbook createWorkbook(int sheetCount)

throws Exception {

HSSFWorkbook wb = new HSSFWorkbook();

for (int i = 0; i sheetCount; i++) {

HSSFSheet si = wb.createSheet();

} return wb;

}public static HSSFWorkbook createWorkbook(int sheetCount, List sblxList)

throws Exception {

HSSFWorkbook wb = new HSSFWorkbook();

for (int i = 0; i sheetCount; i++) {

HSSFSheet si = wb.createSheet((String) sblxList.get(i));

wb.setSheetName(i, (String) sblxList.get(i), (short) 1);

} return wb;

}}页面代码！%@ page contentType="text/html; charset=gb2312"%

%@ page import="java.util.*"%

%@ page import="com.grs.exportexcel.*"%%

//导出在数据

String queryData[][] = new String[3][2]; //[行][列]

//列名

/***

***在此处获得请求在参数，根据参数或者调用方法得到结果

***将结果存入queryDate[][]中

***/ String exportFileName = "data.xls";//导出Excel在名称可以根据参数命名。

//导出EXCEL

ExcelUtils.exportExcelData("san", queryData, exportFileName,

request, response);

if (out != null out.getBufferSize() != 0) {

out.clearBuffer();

out = pageContext.pushBody();

}

%

jsp页面的数据怎么样导出到excel表格

方法一：

function saveCode(obj) {

var winname = window.open('', '_blank', 'top=10000');

var strHTML = document.all.tableExcel.innerHTML;

winname.document.open('text/html', 'replace');

winname.document.writeln(strHTML);

winname.document.execCommand('saveas','','excel.xls');

winname.close();

}

方法二：

// Excel导出2

/**

如果javaScript报“Automation 服务器不能创建对象”，则按下方解决。

打开Internet Explorer “工具”菜单栏中的“选项”一栏，单击“安全”栏中的“自定义级别”选项卡，

将第三项“对没有标记为安全的activex控件进行初始化和脚本运行”设置成“启用”即可。

*/

function exportExecl(tableId) {

var table=document.getElementById(tableId);

var oXL = new ActiveXObject("Excel.Application");

var oWB = oXL.Workbooks.Add();

var oSheet = oWB.ActiveSheet;

var sel=document.body.createTextRange();

sel.moveToElementText(table);

sel.select();

sel.execCommand("Copy");

oSheet.Paste();

oXL.Visible = true;

}

这里的tableId为表格的id