复制代码 代码如下:
function automateexcel() {
try {
//start excel and get application object.
var oxl;
try
{
oxl = new activexobject(excel.application);
}
catch(e)
{
alert(无法启动excel!\n\n如果您确信您的电脑中已经安装了excel， + 那么请调整ie的安全级别。\n具体操作：\n + 工具 → internet选项 → 安全 → 自定义级别 → 对没有标记为安全的activex进行初始化和脚本运行 → 启用);
return false;
}
//get a new workbook.
var owb = oxl.workbooks.add();
var osheet = owb.activesheet;
var table = $(#gridview1)[0];
var rows = table.rows;
var columns = table.rows(0).cells;
var codes = ;
//设置标题
var name = 第 页;
oxl.caption = name;
osheet.name = name;
//设置表头
osheet.cells(1, 1).value = 申请单编号;
osheet.cells(1, 2).value = 出货金额;
osheet.cells(1, 3).value = 营销部门;
osheet.cells(1, 4).value = 业务人员;
osheet.cells(1, 5).value = 内部合同号;
osheet.cells(1, 6).value = 客户名称;
osheet.cells(1, 7).value = 币种;
osheet.cells(1, 8).value = 客户船期;
osheet.cells(1, 9).value = 国别;
osheet.cells(1, 10).value = 核销单号;
osheet.cells(1, 11).value = 发票号码;
osheet.cells(1, 12).value = 报关日期;
//获取当前页申请单编号
for (var i = 2; i codes += ' + rows(i - 1).cells(0).innertext + ',;
}
codes += '';
//获取数据并填充数据到excel
$.post(../handlers/shippingapplyhandler.ashx,
{ action: exportdata, exportcondition: codes },
function (views) {
if (views != null) {
var beginindex = 1;
var endindex = 1;
for (var i = 0; i endindex++;
osheet.cells(i + 2, 1).value = views[i].sacode;
osheet.cells(i + 2, 2).value = views[i].amountsum;
osheet.cells(i + 2, 3).value = views[i].department;
osheet.cells(i + 2, 4).value = views[i].salesname;
osheet.cells(i + 2, 5).value = views[i].contractno;
osheet.cells(i + 2, 6).value = views[i].customername;
osheet.cells(i + 2, 7).value = views[i].currencycode;
if (views[i].customerschedule != null) {
osheet.cells(i + 2, 8).value = converttojsdate(views[i].customerschedule).format(yyyy-mm-dd);
}
osheet.cells(i + 2, 9).value = views[i].country;
osheet.cells(i + 2, 10).value = views[i].verificationnumber;
osheet.cells(i + 2, 11).value = views[i].invoicenumber;
if (views[i].customsdate != null) {
osheet.cells(i + 2, 12).value = converttojsdate(views[i].customsdate).format(yyyy-mm-dd);
}
if (i > 0 && views[i - 1].sacode == views[i].sacode) {
osheet.range(osheet.cells(beginindex, 1), osheet.cells(endindex, 1)).merge();
osheet.range(osheet.cells(beginindex, 2), osheet.cells(endindex, 2)).merge();
osheet.range(osheet.cells(beginindex, 3), osheet.cells(endindex, 3)).merge();
osheet.range(osheet.cells(beginindex, 4), osheet.cells(endindex, 4)).merge();
osheet.range(osheet.cells(beginindex, 5), osheet.cells(endindex, 5)).merge();
osheet.range(osheet.cells(beginindex, 6), osheet.cells(endindex, 6)).merge();
osheet.range(osheet.cells(beginindex, 7), osheet.cells(endindex, 7)).merge();
osheet.range(osheet.cells(beginindex, 8), osheet.cells(endindex, 8)).merge();
beginindex = endindex;
}
else {
beginindex++;
}
}
}
}, json);
//设置自动列宽
osheet.columns.autofit();
//设置excel为可见
oxl.visible = true;
//将excel交由用户控制
oxl.usercontrol = true;
//禁止提示
oxl.displayalerts = false;
//释放资源
//oxl = null;
//owb = null;
//osheet = null;
}
catch (e) {
}
}