-- 作者:有点甜
-- 发布时间:2019/4/9 12:46:00
--
冻结表头比较麻烦的,参考代码
Select Case e.Path Case "test.htm", "" Dim wb As New WeUI With wb.AddTable("","Table2") .head.AddRow("部门","姓名","年龄","电话","地址").Attribute="style=\'position:fixed;\'" \'表头 End With With wb.AddTable("","Table1") .head.AddRow("部门","姓名","年龄","电话","地址") .body.AddRow("技术部","张三","36","110","中国北京") \'数据 .body.AddRow("技术部","李四","38","110","中国上海") .body.AddRow("技术部","王五","39","110","中国深圳") .body.AddRow("生产部","赵六","39","110","中国深圳") .body.AddRow("生产部","刘七","39","110","中国深圳") .body.AddRow("技术部","张三","36","110","中国北京") \'数据 .body.AddRow("技术部","李四","38","110","中国上海") .body.AddRow("技术部","王五","39","110","中国深圳") .body.AddRow("生产部","赵六","39","110","中国深圳") .body.AddRow("生产部","刘七","39","110","中国深圳") .body.AddRow("技术部","张三","36","110","中国北京") \'数据 .body.AddRow("技术部","李四","38","110","中国上海") .body.AddRow("技术部","王五","39","110","中国深圳") .body.AddRow("生产部","赵六","39","110","中国深圳") .body.AddRow("生产部","刘七","39","110","中国深圳") .body.AddRow("技术部","张三","36","110","中国北京") \'数据 .body.AddRow("技术部","李四","38","110","中国上海") .body.AddRow("技术部","王五","39","110","中国深圳") .body.AddRow("生产部","赵六","39","110","中国深圳") .body.AddRow("生产部","刘七","39","110","中国深圳") .body.AddRow("技术部","张三","36","110","中国北京") \'数据 .body.AddRow("技术部","李四","38","110","中国上海") .body.AddRow("技术部","王五","39","110","中国深圳") .body.AddRow("生产部","赵六","39","110","中国深圳") .body.AddRow("生产部","刘七","39","110","中国深圳") .body.AddRow("技术部","张三","36","110","中国北京") \'数据 .body.AddRow("技术部","李四","38","110","中国上海") .body.AddRow("技术部","王五","39","110","中国深圳") .body.AddRow("生产部","赵六","39","110","中国深圳") .body.AddRow("生产部","刘七","39","110","中国深圳") .body.AddRow("技术部","张三","36","110","中国北京") \'数据 .body.AddRow("技术部","李四","38","110","中国上海") .body.AddRow("技术部","王五","39","110","中国深圳") .body.AddRow("生产部","赵六","39","110","中国深圳") .body.AddRow("生产部","刘七","39","110","中国深圳") .body.AddRow("技术部","张三","36","110","中国北京") \'数据 .body.AddRow("技术部","李四","38","110","中国上海") .body.AddRow("技术部","王五","39","110","中国深圳") .body.AddRow("生产部","赵六","39","110","中国深圳") .body.AddRow("生产部","刘七","39","110","中国深圳") End With wb.InsertHTML("<script>for(var i=0; i<table1.rows[0].cells.length; i++) { alert(i);table2.rows[0].cells[i].style.width = table1.rows[1].cells[i].offsetWidth + \'px\';}</script>") e.WriteString(wb.Build) End Select
|