Javascript设置Excel文档的页眉页脚
调用如下Javacript函数就可以设置NTKOOFFICE文档控件中打开的Excel文件的页眉或页脚.
function setpageHeadAndFoot()
{
TANGER_OCX_OBJ.ActiveDocument.Application.ActiveSheet.pagesetup.LeftHeader = "页眉左边";
TANGER_OCX_OBJ.ActiveDocument.Application.ActiveSheet.pagesetup.CenterHeader = "页眉中间";
TANGER_OCX_OBJ.ActiveDocument.Application.ActiveSheet.pagesetup.RightHeader = "页眉右边";
TANGER_OCX_OBJ.ActiveDocument.Application.ActiveSheet.pagesetup.CenterFooter = "页脚中间";
TANGER_OCX_OBJ.ActiveDocument.Application.ActiveSheet.pagesetup.RightFooter = "页脚右边";
TANGER_OCX_OBJ.ActiveDocument.Application.ActiveSheet.pagesetup.LeftFooter = "页脚左边";
}
如果要获取当前Excel文档的这些属性,可以使用如下javascript代码:
var leftHeader=TANGER_OCX_OBJ.ActiveDocument.Application.ActiveSheet.pagesetup.LeftHeader;
注意:在设置或获取Excel文档的页眉页脚时,应该保证NTKO OFFICE文档控件已经打开了一个excel文件,否则会因找不到对象出错.
|