请教如何将搜索到的DataGrid数据导出保存为Excel文件？

[xmjcwo]

请教如何将搜索到的DataGrid数据导出保存为Excel文件？能不能讲详细一点，我是新手多谢了！

[NoReady]

只要把DATAGRID中的数据读出，然后写入excel的单元格就行了，以下为写入excel的过程，仅作参考：

-----------------
'new the excel application
ExlApp = New Excel.Application
ExlApp.Visible = True

'create the sheet
WSheet = ExlApp.Workbooks.Add.Worksheets.Add

Dim i, j As Integer
'fill the cells
For i = 1 To 10
For j = 1 To 10
WSheet.Cells(i, j) = i * j
Next
Next
'format the cells
For i = 1 To 10
For j = 1 To 10
If i Mod 2 = 0 And j Mod 2 = 0 Then
WSheet.Cells(i, j).Select()
ExlApp.Selection.font.color = Color.Red
End If
Next
Next