解决方案 »
- JSP 网页中如何去掉radio每个选项前的那个小圆圈
- 我现在要把目录下的所有图片显示到页面上 不知道咋办 有啥好建议吗
- 就一个JS正则表达式
- 父节点display为none,如何得到子节点的宽高
- 一个关于用JAVASCRIPT动态的生成一个新表格在IE中看不见的问题~~我是新手
- 请问netscape在执行getYear的时候为什么就要在年份上加1900??
- js中响应ocx控件事件的问题??
- javascript函数声明异同
- 简单问题:各位帮看一下
- 关于onclick事件如何在最后验证成功后跳到下一个页面。
- javascript 在不同的服务器上运行的问题
- jquery中的click如何传递不同的参数?
function f_excel() {var f = window.document.form1;if(!valid(form1)) return;
f.target = "hidden";
f.action = "/servlet/DownloadSVL?cmd=lass.dispute.mgt.cmd.DisputeRelatedDebtToExcelCMD";
f.submit();f.target = "detail";
f.action = "/servlet/JspChannelSVL?cmd=lass.dispute.mgt.cmd.RetrieveDisputeRelatedDebtListCMD";
}
function convertCSV(fileLink, fileName, filePassword) {// browser detection
if (navigator.appName != "Microsoft Internet Explorer") {
alert("This service is Internet Explorer Only");
return false;
}// validation
if (!validate(fileName, filePassword)) return false;// Create Excel Object
try {
var Excel = new ActiveXObject("Excel.Application");} catch (E) {
alert("To enable this service, confirm your browser security setting: " +
"Tools→Internet Options→Security→Custom Level→ActiveX Controls and plug-ins→Initialize and script ActiveX controls not maked ... " +
"should be checked as [Enable] or [Prompt]");
return false;
}try {
// Convert XLSX/CSV -> XLSX
var ExcelWorkbook = Excel.Workbooks.Open(fileLink, false);
ExcelWorkbook.SaveAs(fileName, 51, filePassword);
// 51 = File Format number for OpenXML Excel Workbook Spreadsheet (xlOpenXMLWorkbook = 51)
// For more information, follow the link: http://msdn.microsoft.com/en-us/library/microsoft.office.interop.excel.xlfileformat.aspx} catch(E) {
alert(" invalid CSV file link or conversion error)");
Excel.Application.Quit();
return false;
}Excel.Application.Quit();
return true;
}
function validate(fileName, filePassword) {// field / argument validation
if (filePassword == "") {
alert(" Password is empty");
return false;
}if (fileName == "" || fileName == null) {
alert("invalid file name)");
return false;
} else if (fileName.length < 6 || getExtension(fileName) != ".xlsx") {
fileName += ".xlsx";
}return true;
}
function getExtension(fileName) {
var ext = fileName.substr(fileName.length - 5, 5);
return ext;
}
/// <reference path="jquery-1.6.2.js" />
/// <reference path="CsvConverter.js" />$(document).ready(function () {
status("ready...");
});function status(msg) {
$("#status").append("<br />\n<span>" + msg + "</span>");
}function doConvert(fileLink, fileName, filePassword) {
status("now converting file..");if (convertCSV(fileLink, fileName, filePassword)) {
status("converting succeeded");
} else {
status("converting failed");
}
}