javascript导入excel？
具体代码如下：javascript代码如下：
function CreateExcelFile(tname)
{
var fso = new ActiveXObject("Scripting.FileSystemObject");
var TemporaryFolder = 2;
var tfolder = fso.GetSpecialFolder(TemporaryFolder);
var fname=tfolder.CreateTextFile(tname+".xls");
fname.WriteLine("<HTML><body>");
fname.WriteLine(divRpt.innerHTML );
fname.WriteLine("</body></HTML>");
fname.Close();
window.open(tfolder.Path+"/"+tname+".xls" );
}
html代码如下：
<body MS_POSITIONING="GridLayout" bgcolor="#c1defe">
<DIV style="Z-INDEX: 100; LEFT: 8px; WIDTH: 100%; POSITION: absolute; TOP: 8px; HEIGHT: 10px"
ms_positioning="text2D">
<FORM id="Form1" method="post" runat="server">
<TABLE id="Table1" cellSpacing="1" width="100%" bgColor="#577bc7" border="0">
<TR>
<TD align="right" style="WIDTH: 40px"><FONT face="宋体">日期</FONT></TD>
<TD style="WIDTH: 160px"><asp:textbox id="txtDay1" runat="server" Width="136px" ReadOnly="True"></asp:textbox><IMG alt="" src="../../images/button/Ellipsis.gif" id="aPos1" onclick="return toggleDatePicker('calendar', 'txtDay1', 'aPos1');"></TD>
<TD style="WIDTH: 19px"></TD>
<TD><asp:textbox id="txtDay2" runat="server" ReadOnly="True"></asp:textbox><IMG id="aPos2" onclick="return toggleDatePicker('calendar', 'txtDay2', 'aPos2');" alt=""
src="../../images/button/Ellipsis.gif"></TD>
<TD style="WIDTH: 57px"><FONT face="宋体"></FONT></TD>
<TD>
<asp:ImageButton id="ImageButton1" runat="server" ImageUrl="../../images/button/CreateRpt.gif"></asp:ImageButton></TD>
<TD id="tdBrowse" style="DISPLAY: none"><INPUT id="btnBrows" title="导出报表" style="WIDTH: 218px; HEIGHT: 22px" type="file" size="17"
name="btnBrows"></TD>
<TD><IMG onclick="toexcel();" alt="" src="../../images/button/ExportXSL.gif"
id="IMG1" runat="server"></TD>
</TR>
</TABLE>
<P></P>
<DIV id="calendar" style="DISPLAY: inline; Z-INDEX: 103; LEFT: 80px; WIDTH: 56px; POSITION: absolute; TOP: 432px; HEIGHT: 1px"></DIV>
<asp:CheckBox id="CheckBox1" runat="server" Text="按内容分类统计"></asp:CheckBox>
<DIV id="divRpt" style="DISPLAY: none; WIDTH: 100%; HEIGHT: 46px" align="center" ms_positioning="FlowLayout"
runat="server"><FONT size="6">投诉统计报表</FONT><BR>
<asp:label id="lblDay" runat="server"></asp:label><asp:datagrid id="grdRpt" runat="server" Width="686px" ShowFooter="True" BorderColor="Gray">
<SelectedItemStyle Font-Bold="True" ForeColor="#F7F7F7" BackColor="#738A9C"></SelectedItemStyle>
<AlternatingItemStyle BackColor="#F7F7F7"></AlternatingItemStyle>
<ItemStyle ForeColor="#4A3C8C" BackColor="#DCE4F4"></ItemStyle>
<HeaderStyle Font-Bold="True" ForeColor="#F7F7F7" BackColor="#2843A7"></HeaderStyle>
<FooterStyle ForeColor="#4A3C8C" BackColor="#B5C7DE"></FooterStyle>
<PagerStyle PageButtonCount="15" Mode="NumericPages"></PagerStyle>
</asp:datagrid></DIV>
</FORM>
</DIV>
</body>
错误提示：拒绝访问，代码不感觉没错，是不是那个要设置，试了很久都老样子！ --------------------编程问答-------------------- JavaScript就只能是帮顶了 --------------------编程问答-------------------- 权限问题，现在的操作系统，默认情况下，js已经不能直接操作fso了 --------------------编程问答-------------------- 应该是权限控制问题,看路径
var strF = ''
function createXLS() {
var excel = new ActiveXObject("Excel.Application");
var wk = excel.Workbooks.Add();
wk.SaveAs(strF);
wk.Saved = true;
excel.Quit();
}
function writeXLS() {
var excel = new ActiveXObject("Excel.Application");
var wk = excel.Workbooks.Open(strF);
var sheet = wk.Worksheets(1);
sheet.Cells(1, 1).Value = ';
wk.SaveAs(strSaveLocation);
wk.Saved = true;
excel.Quit();
}
</script>
参考
--------------------编程问答-------------------- function createfile()
{
var fso=new ActiveXObject("Scripting.FileSystemObject");
var Tempora
var a=fso.CreateTextFile("c:\\test.xls",true);
a.WriteLine("this is a testaaaaa");
a.Close();
window.open("c:\\test.xls");
}
这样写也是一样的报错，说拒绝访问，不加最后一句一点问题都没有！我只想要弹出，保存，别存为，的界面，不知道应该怎么做，那位脚本高手指点下！ --------------------编程问答-------------------- 怎么没人分析下window.open()为什么提示拒绝访问！ --------------------编程问答-------------------- 浏览器安全限制, 不允许访问PC上本地文件; 把这站点加到安全设置看看
补充：.NET技术 , C#
