包含配置文件生成器和DLL类库。
用配置文件生成器生成配置文件,导入配置文件然后调用DLL类库到处SQL SERVER的数据到EXCEL表格。
注意:基于MS .Net Framework 4.0
实例代码:
Dim r As New AMReport.AmReport
Dim app As New Microsoft.Office.Interop.Excel.Application
Dim book As Microsoft.Office.Interop.Excel.Workbook
Dim sheet As Microsoft.Office.Interop.Excel.Worksheet
If txtOptionFile.Text.Length > 0 Then
book = app.Workbooks.Add
sheet = book.Worksheets(1)
app.Visible = True
r.Export(sheet, "F:\newOpt.opt")
End If
book = Nothing
app = Nothing
1