Export the report to EXCEL and WORD lihonggen0 in the. NET environment (original)

Export the report to EXCEL and WORD lihonggen0 in the. NET environment (original)

In the VB6 development environment, I used EXCEL to make reports. In the. NET environment, I used Crystal Reports. However, VB. NET can also export reports to EXCEL and WORD for output to produce professional reports.
The procedure is as follows: (Note: first, add reference, select COM --> Microsoft Word 10.0 Object Library and Microsoft Excel 10.0 Object Library)
1. Create a able as the data source or another data source.
Private Function CreaTable () As DataTable
Dim dt As New DataTable ()
Dt. Columns. Add ("column 1", GetType (String ))
Dt. Columns. Add ("column 2", GetType (Integer ))
Dt. Columns. Add ("column 3", GetType (String ))
Dt. Columns. Add ("column 4", GetType (String ))
Dim row, row1 As DataRow
Row = dt. NewRow ()
Row! Column 1 = "Row 1"
Row! Column 2 = 1
Row! Column 3 = "d"
Row! Column 4 = ""
Dt. Rows. Add (row)
Row1 = dt. NewRow ()