ASP:Export to Excel (1)
来源:互联网 发布:自动扫矿软件 编辑:程序博客网 时间:2024/04/30 13:57
<SCRIPT LANGUAGE="javascript">
<!--
function AutomateExcel()
{
// Start Excel and get Application object.
var oXL = new ActiveXObject("Excel.Application");
// Get a new workbook.
var oWB = oXL.Workbooks.Add();
var oSheet = oWB.ActiveSheet;
var table = document.all.data;
var hang = table.rows.length;
var lie = table.rows(0).cells.length;
// Add table headers going cell by cell.
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;
}
//-->
</SCRIPT>
<%
On Error Resume Next
strAddr = Server.MapPath(".")
set objExcelApp = CreateObject("Excel.Application")
objExcelApp.DisplayAlerts = false
objExcelApp.Application.Visible = false
objExcelApp.WorkBooks.Open(strAddr & "/temp.xls")
set objExcelBook = objExcelApp.ActiveWorkBook
set objExcelSheets = objExcelBook.Worksheets
set objExcelSheet = objExcelBook.Sheets(2)
objExcelSheet.Range("A"&i&":C"&i&"").Value = Array("222", "21321", "0")
'关闭另存excel
objExcelBook.SaveAs strAddr & "/Temp/"&date()&"-gongzi-ribao.xls"
objExcelApp.Quit
set objExcelApp = Nothing
%>
- ASP:Export to Excel (1)
- ASP: Export to Excel (2)
- Export ASP.NET DataGrid To Excel
- 5 Solutions to Export Data to Excel for ASP.NET
- Export DataSets to Excel...
- export to excel
- Export GridView to Excel
- Export to excel
- Export to Excel
- EXCEL export to TXT
- Export to excel
- Proceduce Export Table To Excel
- Export to Excel user Control
- Export to Excel from Repeater
- excel export to latex table
- csharp: Export DataTable to Excel using OpenXml 2.5 in asp.net
- export grid to excel fast and wyswyg
- export data from DataGrid to Excel
- 讨武瞾檄
- JS: window.open and window.showModelessDialog
- JS:常用正則表達式
- 讨曹操檄
- .NET 关于区别TimeOut后迁移到TimeOut画面与直接通过URL迁移到其他画面(没通过login画面)的解决方案
- ASP:Export to Excel (1)
- 女性一生应当拥有的20种品质
- 百度之星程序设计大赛试题
- java 中关于*号的通配符使用
- 颜色 爱情
- Java正则表达式的总结
- 序列化有event的类会是什么效果?
- python一句代码干掉你三天良性睡眠(关于代码缩进)
- 魔高一尺,道高一丈