[求助]导出报表 - 专家坐堂 - Foxtable(狐表) - 新一代数据库软件，完美融合Access、Foxpro、Excel、vb.net之优势，人人都能掌握的快速软件开发工具!

Dim dlg As New SaveFileDialog
dlg.Filter = "Excel文件|*.xls"
If dlg.ShowDialog = DialogResult.OK Then
    With Tables(Args(0))
        Dim dyl_L As List(Of String) = .DataTable.Getvalues(Args(1)) '第二个参数为"列名"
        For Each dyl_ As String In dyl_L
            .Filter = Args(1) & " = '" & dyl_ & "'"
            .SaveExcel(dlg.FileName,dyl_)
        Next
        Dim App As New MSExcel.Application
        Dim Wb As MSExcel.WorkBook = App.WorkBooks.Open(dlg.FileName)

        For Each Ws As MSExcel.WorkSheet In Wb.WorkSheets
            Dim Rg As MSExcel.Range = Ws.UsedRange
            Rg.Borders.Linestyle = MSExcel.XlLineStyle.xlContinuous '边框线型
            Rg.Borders.Weight = MSExcel.XlBorderWeight.xlThin'边框粗细
            Rg.Borders.ColorIndex = 3'边框颜色
            Rg = Ws.Rows("1")
            With Rg.Font
                .Name = "黑体" '字体
                .Size = 12 '字号
                .Bold = True   '加粗
                .Italic = True '斜体
                .ColorIndex = 3'颜色
            End With
            Ws.UsedRange.WrapText = True
            Ws.UsedRange.EntireRow.AutoFit '自动调整行高
        Next
        App.Visible = True
    End With
End If

主题：[求助]导出报表