主题：[求助]导出

Dim dt As DataTable = DataTables("订单管理")
Dim nms() As String = {"订单_编号","订单_日期","客户名称"} '要导出的列名
Dim caps() As String = {"订单_编号","订单_日期","客户名称"} '对应的列标题
Dim hlvl As Integer = 2
Dim szs() As Integer = {100,100,100,100} '对应的列宽
Dim Book As New XLS.Book '定义一个Excel工作簿
For Each mc As String In dt.GetValues("客户名称", "发货状态=true and 订单状态=true and 客户名称 is not null")
    Dim Sheet As XLS.Sheet = Book.Sheets.Add '引用工作簿的第一个工作表
    sheet.name = mc
    Dim drs = dt.Select("客户名称='" & mc & "' and 发货状态=true and 订单状态=true")
    Dim st As XLS.Style = Book.NewStyle '日期列的显示格式
    st.Format = "yyyy-MM-dd"
    For c As Integer = 0 To nms.length -1
        Sheet(0, c).Value = caps(c) '指定列标题
        Sheet.Cols(c).Width = szs(c) '指定列宽
        If dt.dataCols(nms(c)).IsDate Then '如果是日期列
            Sheet.Cols(c).Style = st '设置显示格式
        End If
    Next
   
   
   
   
   
    '================
    Dim jz As xls.style = book.NewStyle
    jz.AlignHorz = XLS.AlignHorzEnum.Center
    jz.AlignVert = XLS.AlignVertEnum.Center
    For c As Integer = 0 To nms.length -1
        Dim ary() As String = caps(c).split("_")
        For i As Integer = 0 To ary.length-1
            sheet(i, c).value = ary(i)
            sheet(i, c).Style = jz
        Next
    Next
    For i As Integer = 0 To hlvl-1
        Dim pi As Integer = 0
        For c As Integer = 0 To nms.length -2
            If sheet(i,c).text = sheet(i,c+1).text Then
                Dim flag As Boolean = True
                For k As Integer = i-1 To 0 Step -1
                    If sheet(k,c).value <> sheet(k,c+1).value Then
                        flag = False
                    End If
                Next
                If flag Then
                    pi += 1
                Else
                    pi = 0
                End If
            Else
                sheet.MergeCell(i, c-pi, 1, pi+1)
                pi = 0
            End If
        Next
        sheet.MergeCell(i, nms.length-pi-1, 1, pi+1)
    Next
   
    For c As Integer = 0 To nms.length -1
        Dim pi As Integer = 0
        For i As Integer = hlvl-1 To 0 Step -1
            If sheet(i, c).text = "" Then
                pi += 1
            Else
                sheet.MergeCell(i, c, pi+1, 1)
                Exit For
            End If
        Next
    Next
    '-----------------------
    For r As Integer = 0 To drs.Count - 1 '填入数据
        For c As Integer = 0 To nms.length -1
            Sheet(r+hlvl, c).Value = drs(r)(nms(c))
        Next
    Next
Next
book.Sheets.RemoveAt(0)
Dim f = "d:\test.xls"
Book.Save(f)
Dim Proc As New Process
Proc.File = f
Proc.Start()