16,721
社区成员




'输出到Excel
Private Sub Btn_OutputExcel_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles Btn_OutputExcel.Click
If dgv_DataQuery.RowCount < 2 Then
MessageBox.Show("记录为空,不能输出到EXCEL")
Exit Sub
End If
Dim fso As New SaveFileDialog
fso.Filter = "*.xls|*.xls"
fso.OverwritePrompt = True
fso.RestoreDirectory = True
fso.InitialDirectory = ""
If fso.ShowDialog() = Windows.Forms.DialogResult.OK Then
Dim ws As New System.IO.StreamWriter(fso.OpenFile, System.Text.Encoding.Default)
Dim str As String = ""
For i As Integer = 0 To Me.dgv_DataQuery.Columns.Count - 1
str += dgv_DataQuery.Columns(i).HeaderCell.Value.ToString & vbTab
Next
str += vbCrLf
For Each row As DataGridViewRow In Me.dgv_DataQuery.Rows
For i As Integer = 0 To Me.dgv_DataQuery.Columns.Count - 1
If Not row.IsNewRow Then
str += row.Cells.Item(i).Value.ToString & vbTab
End If
Next
str += vbCrLf
Next
ws.Write(str)
ws.Dispose()
ws.Close()
End If
End Sub