<%@ page language="java" import="java.util.*" pageEncoding="UTF-8"%>
<taglib uri="http://java.sun.com/jstl/core" 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%>">
<title>My 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="http://www.w3.org/TR/REC-html40"><head><!--[if gte mso 9]><xml><x:ExcelWorkbook><x:ExcelWorksheets><x:ExcelWorksheet><x:Name>{worksheet}</x:Name><x:WorksheetOptions><x:DisplayGridlines/></x:WorksheetOptions></x:ExcelWorksheet></x:ExcelWorksheets></x:ExcelWorkbook></xml><![endif]--></head><body><table>{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>
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 ="表格数据";
function toOutPutExcel(tableid,title) {// 整个表格拷贝到EXCEL中
excelTitle =title;
if (getExplorer() == 'ie') {
var curTbl = document.getElementById(tableid);
var oXL = new ActiveXObject("Excel.Application");
// 创建AX对象excel
var oWB = oXL.Workbooks.Add();
// 获取workbook对象
var xlsheet = oWB.Worksheets(1);
// 激活当前sheet
var sel = document.body.createTextRange();
sel.moveToElementText(curTbl);
// 把表格中的内容移到TextRange中
sel.select;
// 全选TextRange中内容
sel.execCommand("Copy");
// 复制TextRange中内容
xlsheet.Paste();
// 粘贴到活动的EXCEL中
oXL.Visible = true;
// 设置excel可见属性
try {
var fname = oXL.Application.GetSaveAsFilename("Excel.xls",
"Excel Spreadsheets (*.xls), *.xls");
} catch (e) {
print("Nested catch caught " + e);
} finally {
oWB.SaveAs(fname);
oWB.Close(savechanges = false);
// xls.visible = false;
oXL.Quit();
oXL = null;
// 结束excel进程，退出完成
// window.setInterval("Cleanup();",1);
idTmr = window.setInterval("Cleanup();", 1);
}
} else {
tableToExcel(tableid);
}
}
function Cleanup() {
window.clearInterval(idTmr);
CollectGarbage();
}
var tableToExcel = (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="http://www.w3.org/TR/REC-html40"><head><!--[if gte mso 9]><xml><x:ExcelWorkbook><x:ExcelWorksheets><x:ExcelWorksheet><x:Name>{worksheet}</x:Name><x:WorksheetOptions><x:DisplayGridlines/></x:WorksheetOptions></x:ExcelWorksheet></x:ExcelWorksheets></x:ExcelWorkbook></xml><![endif]--></head><body><table>{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 : excelTitle || 'Worksheet',
table : table.innerHTML
}
//window.location.href = uri + base64(format(template, ctx))
var titleDate= new Date().Format("yyyy-MM-dd hh-mm-ss");
document.getElementById("dlink").href = uri + base64(format(template, ctx));
document.getElementById("dlink").download = excelTitle+titleDate+".xls";
document.getElementById("dlink").click();
}
})()本回答被网友采纳
如何把JSP页面导出到Excel中jsp怎么导出文件
.方法一：functionsaveCode(obj){varwinname=window.open('','_blank','top=10000');varstrHTML=document.all.tableExcel.innerHTML;winname.document.open('text\/html','replace');winname.document.writeln(strHTML);winname.document.execCommand('saveas','','excel.xls');winname.close();}...
怎么从jsp页面的表格导出到Excel
\/\/方法接受两个参数，一个是list，这个地方我用了泛型。另一个参数是HttpServletResponse response public static void toExcelBy(List<AccessLog> list,HttpServletResponse response) { \/\/ 创建工作表 WritableWorkbook book=null;response.reset();\/\/ 创建工作流 OutputStream os =null;try { \/\/ 设...
jsp页面中的表格导出到excel,如何做?请高手指点,谢谢
比如说我要把 s1,s2,s3这三个 数据导入到表格中那么就 要 这样写代码 out.println("\\ts1\\ts2\\ts3") ;这样数据就 自动到每一个单元格了
怎么从网页导出execl js
<TITLE>将页面中指定表格的数据导入到Excel中<\/TITLE> <SCRIPT LANGUAGE="javascript"> function AutomateExcel1(){var oXL = new ActiveXObject("Excel.Application"); \/\/创建应该对象var oWB = oXL.Workbooks.Add();\/\/新建一个Excel工作簿var oSheet = oWB.ActiveSheet;\/\/指定要写入内容的工作表为...
如何将jsp页面的table报表转换到excel报表导出
用链接表试一下能抓取到吗？Dim myQuery With ActiveSheet .Cells.Delete .[a1] = "Conneting, Please Wait..."Set myQuery = ActiveSheet.QueryTables _.Add(Connection:="URL;http:\/\/网址", _Destination:=.Cells(1, 1))End With With myQuery .Refresh End With ...
在jsp中如何实现导出exceal
param filename 待输出的默认文件名 param sheetname 工作表名称 param titles 标题数组 param list 数据 return 输出文件流至客户端 throws Exception \/ public static boolean exportToExcel(HttpServletResponse response, String filename,String sheetname, String[] titles, List list) throws Exception...
如何将jsp页面的table报表转换到excel报表导出
在jsp页面上面加一句：<%@ page contentType="application\/vnd.ms-excel;charset=ISO-8859-1" %> 数据直接写成html表格就可以了。如果有中文问题，就把charset=ISO-8859-1改成gb2312试试
jsp如何将xml文件数据导出到excel中
第一步，通过java把数据从xml文件中读出来。这个在Java中是一个很普通很普遍的问题，使用任意一个Java的xml解析库(比如jdom,dom4j等)都可以完成。第二步，数据从xml文件读出后，就需要把数据写入excel文件。这个问题其实就是在java如何操作excel文件。在Java中操作Excel文件，目前大致有三种方法。第一种，...
如何将jsp页面表格另存为excel格式报表,或通过打印生成.xsl报表_百度...
jsp页面的表格数据可以另存为excel表格的。JSP从数据库导出数据到Excel下载的实现关键代码:<%@ page contentType="application\/msexcel" %><% \/\/response.setHeader("Content-disposition","inline; filename=videos.xls"); response.setHeader("Content-disposition","attachment; filename=test.xls"); \/\/以上这...
如何将jsp 中的数据导入到excel表格 中
\/\/ 创建新的Excel 工作簿 HSSFWorkbook wb = new HSSFWorkbook();\/\/ 在Excel 工作簿中建一工作表 HSSFSheet s = wb.createSheet();String sheetName = year+"-"+month+"-"+day;wb.setSheetName(0, sheetName);\/\/在索引0的位置创建行（第一行）HSSFRow row = s.createRow((short)0);HSSF...
