使用Lodop导出Excel和Word

导出 word 文档

IE 导出

function AllAreaWord(tableid) {var elTable = document.getElementById(tableid);
    var sel = document.body.createTextRange();
    sel.moveToElementText(elTable);
    sel.execCommand("Copy");
    var oWD = new ActiveXObject("Word.Application");
    var oDC = oWD.Documents.Add("", 0, 1);
    var orange = oDC.Range(0, 1);
    //sel.select();
    orange.Paste();
    oWD.Application.Visible = true;
    oWD = null;
}

Lodop 导出

function dcword() {var printtable = document.getElementById("print");
    var LODOP = getLodop(); // 获取 lodop
    //LODOP.SET_PRINT_MODE("FULL_WIDTH_FOR_OVERFLOW", true);// 宽度溢出缩放
    //LODOP.SET_PRINT_MODE("PRINT_PAGE_PERCENT", 'Full-Page');// 高度溢出缩放
    //LODOP.SET_PRINT_MODE("FULL_HEIGHT_FOR_OVERFLOW", true);// 宽度溢出缩放
    //LODOP.ADD_PRINT_TABLE("10mm", '10mm', "210mm", "297mm", printtable.innerHTML);
    //LODOP.ADD_PRINT_HTM("10mm", '10mm', "210mm", "287mm", printtable.innerHTML);
    LODOP.WRITE_FILE_TEXT('UTF-8', LODOP.GET_DIALOG_VALUE("LocalFileFullNameForSave", "导出.doc"), printtable.innerHTML);// 把内容 1aaa 以 utf- 8 编码写入文件
    //LODOP.PREVIEW();}

导出 Excel 表格

Lodop 导出

function SaveAsFile() {LODOP = getLodop();
    LODOP.PRINT_INIT("");
    var str = document.getElementById("print").outerHTML;
    LODOP.ADD_PRINT_TABLE(100, 20, 500, 80, str);
    LODOP.SET_SAVE_MODE("Orientation", 1); //Excel 文件的页面设置：横向打印   1- 纵向,2- 横向;
    LODOP.SET_SAVE_MODE("PaperSize", 9);  //Excel 文件的页面设置：纸张大小   9- 对应 A4
    LODOP.SET_SAVE_MODE("Zoom", 90);       //Excel 文件的页面设置：缩放比例
    LODOP.SET_SAVE_MODE("CenterHorizontally", true);//Excel 文件的页面设置：页面水平居中
    LODOP.SET_SAVE_MODE("CenterVertically", true); //Excel 文件的页面设置：页面垂直居中
    LODOP.SET_SAVE_MODE("QUICK_SAVE", true);// 快速生成（无表格样式, 数据量较大时或许用到）LODOP.SAVE_TO_FILE("导出.xls");
};

打印网页

Lodop 打印

function lodopprint() {var LODOP = getLodop();
    LODOP.PRINT_INIT("table");
    var str = document.getElementById("print").outerHTML;
    LODOP.SET_PRINT_PAGESIZE(2, 0, 0, "A4");
    LODOP.SET_PRINT_MODE("FULL_WIDTH_FOR_OVERFLOW", true);// 高度溢出缩放
    LODOP.SET_SAVE_MODE("QUICK_SAVE", true);// 快速生成（无表格样式, 数据量较大时或许用到）LODOP.ADD_PRINT_TABLE("1cm", "1cm", "95%", "95%", str);
    LODOP.PREVIEW();}