VB/VB. NET/C # How to export data to Excel

In the VB project, reference "Microsoft Excel 11.0 Object" 11.0 as the version number. It is not important. The Excel2000 is 9.0.

Declarative Variables

Dim xlApp As Excel. Application
Dim xlBook As Excel. Workbook
Dim xlSheet As Excel. Worksheet
Set xlApp = CreateObject ("Excel. Application ")

Use Template
Set xlBook = xlApp. Workbooks. Open (App. Path & "common .xls ")
On Error GoTo 0
Set xlSheet = xlBook. Worksheets (1)
XlApp. Visible = False
XlSheet. Activate

Process data and fill in an Excel table
XlSheet. Cells (3, 4) = TextQuery. Text Product Name

......

//////////////



XlApp. Visible = True display table
Set xlApp = Nothing return control to Excel
Set xlBoook = Nothing
Set xlSheet = Nothing

At this point, export to Excel is complete. In. NET, you only need to change a little to run, but the C # syntax is somewhat different.