javascript对excel格式设置
sgguo 2004-09-23 11:07:04 在系统中需要把页面中表的数据导入到excel中,数据可以导入,但要使excel显示边框时不能实现
提示不能设置borders类的weight属性,但我在excel的vba中操作成功。不知问题在哪
var objExcel = new ActiveXObject("Excel.Application");
var objExcelBook = objExcel.Workbooks.Add();
var objExcelSheet = objExcelBook.Sheets(1);
objExcel.Application.Visible = true;
objExcelSheet.activate;
for(i=1;i<=window.tr1.cells.length;i++)
objExcelSheet.cells(1,i).value = window.tr1.cells(i-1).innerText;
objExcel.Sheets("Sheet1").Range("1:1").Borders.Weight = "xlThin";