主题：[求助]报表多层表头

可以看看这里的示例二：

http://www.foxtable.com/webhelp/scr/1148.htm

 

你可以先常规生成，生成后再删除多余的列：

http://www.foxtable.com/webhelp/scr/1157.htm

例如生成后，删除对于的第5列和第3列：

Dim tbl As Table = Tables("订单")
Dim hdr As Integer = tbl.HeaderRows '获得表头的层数
Dim cnt As Integer
Dim Book As New XLS.Book
Dim Sheet As XLS.Sheet = Book.Sheets(0)
tbl.CreateSheetHeader(Sheet) '生成表头
For c As Integer = 0 To tbl.Cols.Count - 1
    If tbl.Cols(c).Visible Then
        For r As Integer = 0 To tbl.Rows.Count - 1
            sheet(r + hdr,cnt).value = tbl(r,c)
        Next
        cnt = cnt + 1
    End If
Next
Sheet.Cols.RemoveAt(4)
Sheet.Cols.RemoveAt(2)
Book.Save("c:\reports\test.xls")
Dim Proc As New Process
Proc.File = "c:\reports\test.xls"
Proc.Start()

注意先删除靠后的列

 我打开基本功能演示文件，利用其中的多层表头这个表进行测试，在命令窗口输入下面的代码测试：

Dim tbl As Table = Tables("多层表头")
Dim hdr As Integer = tbl.HeaderRows '获得表头的层数
Dim cnt As Integer
Dim Book As New XLS.Book
Dim Sheet As XLS.Sheet = Book.Sheets(0)
tbl.CreateSheetHeader(Sheet) '生成表头
For c As Integer = 0 To tbl.Cols.Count - 1
    If tbl.Cols(c).Visible Then
        For r As Integer = 0 To tbl.Rows.Count - 1
            sheet(r + hdr,cnt).value = tbl(r,c)
        Next
        cnt = cnt + 1
    End If
Next
Sheet.Cols.RemoveAt(2)
Book.Save("c:\reports\test.xls")
Dim Proc As New Process
Proc.File = "c:\reports\test.xls"
Proc.Start()

没有发现问题啊

 不行就做个例子上来嘛