Pages

Total Pageviews

Add This

Showing posts with label Microsoft Excel. Show all posts
Showing posts with label Microsoft Excel. Show all posts

Monday, August 1, 2011

Export Listview to CSV

If you want to export the Listview Data to CSV in Visual Basic 2010 use the function bellow:


Function ExportListview2Excel(ByVal lstview As ListView) As Boolean

    Dim csvFileContents As New System.Text.StringBuilder
    Dim CurrLine As String = String.Empty


    For columnIndex As Int32 = 0 To lstview.Columns.Count - 1

    CurrLine &= (String.Format("{0};", lstview.Columns(columnIndex).Text))

    Next


    csvFileContents.AppendLine(CurrLine.Substring(0, CurrLine.Length - 1))

    CurrLine = String.Empty


    For Each item As ListViewItem In lstview.Items


    For Each subItem As ListViewItem.ListViewSubItem In item.SubItems


    CurrLine &= (String.Format("{0};", subItem.Text))


    Next

    csvFileContents.AppendLine(CurrLine.Substring(0, CurrLine.Length - 1))


    CurrLine = String.Empty


    Next


    Dim Sys As New System.IO.StreamWriter("C:\Test.csv")


    Sys.WriteLine(csvFileContents.ToString)


    Sys.Flush()


    Sys.Dispose()


End Function

 

Friday, June 17, 2011

Export DataGrid to Microsoft Excel

If you want to export DataGrid to Microsoft Excel write the code bellow:

Imports Excel = Microsoft.Office.Interop.Excel
Imports System.Data
Imports System.Windows.Forms

Public Class Form1

 
    Private Sub Button1_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles Button1.Click
        Dim xlApp As Excel.Application
        Dim xlWorkBook As Excel.Workbook
        Dim xlWorkSheet As Excel.Worksheet
        Dim misValue As Object = System.Reflection.Missing.Value
        Dim i As Integer
        Dim j As Integer

        xlApp = New Excel.Application
        xlWorkBook = xlApp.Workbooks.Add(misValue)
        xlWorkSheet = xlWorkBook.Sheets("sheet1")

        For i = 0 To DataGridView1.RowCount - 2
            For j = 0 To DataGridView1.ColumnCount - 1
                xlWorkSheet.Cells(i + 1, j + 1) = _
                    DataGridView1(j, i).Value.ToString()
            Next
        Next

        xlWorkSheet.SaveAs("C:\test.xlsx")
        xlWorkBook.Close()
        xlApp.Quit()

        releaseObject(xlApp)
        releaseObject(xlWorkBook)
        releaseObject(xlWorkSheet)

        MsgBox("You can find the file C:\test.xlsx")
    End Sub

    Private Sub releaseObject(ByVal obj As Object)
        Try
            System.Runtime.InteropServices.Marshal.ReleaseComObject(obj)
            obj = Nothing
        Catch ex As Exception
            obj = Nothing
        Finally
            GC.Collect()
        End Try
    End Sub
End Class