我使用javascript 触发file控件,从excel文档中读取内容到一个text上,可是当提交这个text时候出现“拒绝访问”的错误,而且还要多次点击(大概三次以上)提交按钮,才能提交过去。我感觉问题出在file控件上,如果我直接在text上输入内容,不会报这个错误,而且点击之后立即提交过去了。请问这个问题怎么解决,已经弄了很久,望哪位高人指点迷津。谢谢各位哥哥姐姐帮忙了!~~
<HTML>
<HEAD>
<script>function getxlsurl(){
var uploadfile = document.getElementById("uploadfile");
uploadfile.click();
var fileurl = document.getElementById("fileurl").value;
alert(fileurl);
var oXL = new ActiveXObject("Excel.Application");
try {
var oWB = oXL.Workbooks.open(fileurl);
} catch (e) {
alert('打开文件失败!');
}
var oSheet = oWB.ActiveSheet;
var columns = oSheet.usedrange.columns.count; //得到行数
var rows = oSheet.usedrange.rows.count; //得到列数
var uurl = "";
for (var i=0; i<rows; i++) {
if (oSheet.Cells(i+1,messagetype).value != null) {
uurl += oSheet.Cells(i+1,messagetype).value + ";";
}
}
document.getElementById("allMessage").value = uurl;
oSheet=null;
oWB.close();
oXL=null;
}
function url(){
document.getElementById("fileurl").value=document.getElementById("uploadfile").value;
}function sendMessage(){
document.form1.action="../admin/recommendSubjectAction!sendnMail.action"; //这个我提交的action
document.form1.submit();
}</script>
</HEAD><BODY>
<form name="form1">
<input type="text" name="allMessage" id="allMessage"/>
<input type="button" value="上传名单" onclick="getxlsurl()" />
<input type="file" name="file" id="uploadfile" style="display:none" onchange="url();" />
<input type="hidden" name="fileurl" id="fileurl"/>
<input type="button" name="button" onclick="sendMessage();"/>
</form>
</BODY>
</HTML>
<HTML>
<HEAD>
<script>function getxlsurl(){
var uploadfile = document.getElementById("uploadfile");
uploadfile.click();
var fileurl = document.getElementById("fileurl").value;
alert(fileurl);
var oXL = new ActiveXObject("Excel.Application");
try {
var oWB = oXL.Workbooks.open(fileurl);
} catch (e) {
alert('打开文件失败!');
}
var oSheet = oWB.ActiveSheet;
var columns = oSheet.usedrange.columns.count; //得到行数
var rows = oSheet.usedrange.rows.count; //得到列数
var uurl = "";
for (var i=0; i<rows; i++) {
if (oSheet.Cells(i+1,messagetype).value != null) {
uurl += oSheet.Cells(i+1,messagetype).value + ";";
}
}
document.getElementById("allMessage").value = uurl;
oSheet=null;
oWB.close();
oXL=null;
}
function url(){
document.getElementById("fileurl").value=document.getElementById("uploadfile").value;
}function sendMessage(){
document.form1.action="../admin/recommendSubjectAction!sendnMail.action"; //这个我提交的action
document.form1.submit();
}</script>
</HEAD><BODY>
<form name="form1">
<input type="text" name="allMessage" id="allMessage"/>
<input type="button" value="上传名单" onclick="getxlsurl()" />
<input type="file" name="file" id="uploadfile" style="display:none" onchange="url();" />
<input type="hidden" name="fileurl" id="fileurl"/>
<input type="button" name="button" onclick="sendMessage();"/>
</form>
</BODY>
</HTML>
<HEAD>
<script>
function set(){
var a1 = document.getElementById("a1");
a1.click();
var str = document.getElementById("a4").value;
alert(str);
}function get(){
document.getElementById("a4").value=document.getElementById("a1").value;
}function send(){
document.form1.action="../admin/recommendSubjectAction!sendnMail.action";
document.form1.submit();
}</script>
</HEAD><BODY>
<form action="" name="form1">
<input type="file" name="a1" id="a1" style="display:none" onchange="get();"/>
<input type="button" name="a2" id="a2" value="浏览" onclick="set();"/>
<input type="text" name="a3" id="a3"/>
<input type="hidden" name="a4" id="a4"/>
<hr/>
<input type="button" name="button" value="提交" onclick="send();">
</form>
</BODY>
</HTML>