作者:乔山办公网日期:
返回目录:excel表格制作
简单的办法:使用js生成一个table,可以直接复制到excel中,网上有很多表格插件。
复杂的办法:js传递数据到服务器,服务器生成表格后返回一个下载链接。
<script>
function printToExcel(html) {
try{
var ExApp = new ActiveXObject("Excel.Application")
var ExWBk = ExApp.workbooks.add()
var ExWSh = ExWBk.worksheets(1)
ExApp.DisplayAlerts = false
ExApp.visible = true
}catch(e){
alert("您所设定的安全级别太高,或者您的电脑没有安装Microsoft Excel软件!")
return false
}
window.clipboardData.setData("Text", html);
ExWBk.worksheets(1).Paste;
ExWBk.worksheets(1).Columns.AutoFit;
ExWBk.worksheets(1).Rows.AutoFit;
}
function exportToExcel(table)
{
if(confirm("确认要导出吗?")){
var oXL = new ActiveXObject("Excel.Application");
var oWB = oXL.Workbooks.Add();
var oSheet = oWB.ActiveSheet;
var hang = table.rows.length;
var lie = table.rows(0).cells.length;
for (i=0;i<hang;i++)
{
for (j=0;j<lie;j++)
{
oSheet.Cells(i+1,j+1).Value = table.rows(i).cells(j).innerText;
}
}
oXL.Visible = true;
oXL.UserControl = true;
}
}
if(confirm("是否导出表格e79fa5e98193e78988e69d83334数据为 Excel?")) {
printToExcel(dataArea.innerHTML);
}
</script>
<!-- 以下为数据区 -->
<div id="dataArea">
<font color=red>test表</font>
<table border="1" cellpadding="0" style="border-collapse: collapse; " bordercolor="#000000">
<tbody>
<tr><td>1</td><td>1-1</td><td>1-2</td></tr>
<tr><td>2</td><td>2-1</td><td>2-2</td></tr>
<tr><td>3</td><td>3-1</td><td>3-2</td></tr>
<tr><td>4</td><td>4-1</td><td>4-2</td></tr>
</tbody>
</table>
</div>
if (strFile!zd=""&&strFile!=null)
{
var openDocObj = new ActiveXObject("SharePoint.OpenDocuments.1");
openDocObj.ViewDocument(strFile);
}
strFile = "";
idTmr = window.setInterval("Cleanup();",1000);
strFile是你文件所回在的路径答+文件名.xls
require_once('../baseClass/CommonQuery.php');
require_once('../baseClass/conn.php');
$sql="Select * from 'award' WHERE LEFT('AWARDDATE',4)='2010'";
$result=mysql_query($sql);
$count=mysql_num_rows($result);
if($count!=0)
{
echo "document.getElementById('awardNum').innerHTML= $count";
}
else
{
echo "document.getElementById('awardNum').innerHTML= $num";
}