Generate excel from javascript

Question

我已经编写了所有代码以在名为 GenerateXLS.aspx 的 ASPX 页面中生成 excel，我将从 javascript 导出到 excel 调用

为

var BudgetID = document.getElementById("ctl00_ContentPlaceHolder1_CmbBudget").value;
var BudgetType = document.getElementById("ctl00_ContentPlaceHolder1_CmbBudgetType").value;
var CompanyID = document.getElementById('<% =HidCompanyID.ClientID %>').value;
var UserID = document.getElementById('<% =HidUserID.ClientID %>').value;
var BudgetName = document.getElementById("ctl00_ContentPlaceHolder1_CmbBudget").options[document.getElementById("ctl00_ContentPlaceHolder1_CmbBudget").selectedIndex].text;
var BudgetTypeName = document.getElementById("ctl00_ContentPlaceHolder1_CmbBudgetType").options[document.getElementById("ctl00_ContentPlaceHolder1_CmbBudgetType").selectedIndex].text;
document.getElementById("iFrame_Excel").src = "../Reports/GenerateXLS.aspx?Source=BudgetReport&BudgetID=" + BudgetID + "&BudgetType=" + BudgetType + "&CompanyID=" + CompanyID + "&UserID=" + UserID + "&BudgetName=" + BudgetName + "&BudgetTypeName=" + BudgetTypeName;   alert("works now");

问题是它正在生成 excel，但前提是我将警报保持在 javascript 函数的末尾。 如果我从函数中删除警报，页面将回发，但不会生成 excel 文件。可能有什么问题？为什么它仅在我保持警报时才生成 excel 文件？

Answer 1

添加e.preventDefault();以避免重新加载，如果必须在函数执行后转到特定 URL，window.location.href = your_url;