用PHP将数据取到本地,然后使用下面的代码来生成excel文件,不过需要把IE的安全级别里的某些ActiveX选项改为启用. <SCRIPT LANGUAGE='JavaScript'> var xlCenter=-4108; var xlbottom=-4107; var xlRight=-4152;
var oSheet; var oActiveSheet; var oApplication; try { oApplication = new ActiveXObject ('Excel.Application'); } catch(e) { alert('您必须安装Excel电子表格软件,同时浏览器须使用“ActiveX 控件”!'); } oApplication.visible = true; oApplication.Workbooks.Add;
header("Accept-Ranges: bytes");
header("Content-type: application/vnd.ms-excel");
header("Content-Disposition: attachment;filename=filename.xls");
<SCRIPT LANGUAGE='JavaScript'>
var xlCenter=-4108;
var xlbottom=-4107;
var xlRight=-4152;
var oSheet;
var oActiveSheet;
var oApplication;
try {
oApplication = new ActiveXObject ('Excel.Application');
}
catch(e)
{
alert('您必须安装Excel电子表格软件,同时浏览器须使用“ActiveX 控件”!');
}
oApplication.visible = true;
oApplication.Workbooks.Add;
oApplication.Cells(1, 1).ColumnWidth = 20.57;
setNormalCell(oApplication, 1, 1, "WebEx Communications Inc. - Monthly Telephony Statement", true, false, true, 10, 1, false, 15);
function setNormalCell(oApplication, nRow, nColumn, strText, bUnderLine, bItalic, bBold, nSize, nColor, bTitle2, nTitle2Color)
{
oApplication.Cells(nRow, nColumn).Value = strText;
oApplication.Cells(nRow, nColumn).Font.Underline = bUnderLine;
oApplication.Cells(nRow, nColumn).Font.Name = "Arial"
oApplication.Cells(nRow, nColumn).Font.Italic = bItalic;
oApplication.Cells(nRow, nColumn).Font.Bold = bBold;
oApplication.Cells(nRow, nColumn).Font.Size = nSize;
oApplication.Cells(nRow, nColumn).Font.ColorIndex = nColor;
if (bTitle2)
{
oApplication.Range("A" + nRow,"J" + nRow).Interior.ColorIndex = nTitle2Color
}
}
</SCRIPT>