This is a migrated thread and some comments may be shown as answers.

Import from Excel or CSV

10 Answers 1437 Views

GridView

This is a migrated thread and some comments may be shown as answers.

10 Answers, 1 is accepted

answered on 30 Jan 2009, 05:50 PM

Hi Patrick,

RadGridView supports only export to Excel functionality, however you cannot import data from Excel into RadGridView. You can find the Export to Excel example in our Quick Start Framework application (a.k.a. Examples), section RadGridView >> Export to Excel. As to the CSV format, you can copy and paste rows in CSV format from one RadGridView to another when both have the same data strcture. An example of the CSV approach you can find in this Knowledge Base article: Copy/Pasting rows in and between RadGridViews (CSV format)

Sincerely yours,

Nikolay
the Telerik team

Check out Telerik Trainer, the state of the art learning tool for Telerik products.

answered on 06 Jun 2009, 06:48 PM

This will let you import a .CSV file...

Dim fname As String = ""

        If (OpenFileDialog1.ShowDialog() = Windows.Forms.DialogResult.OK) Then
            fname = OpenFileDialog1.FileName
        End If

Dim TextLine As String = ""
Dim SplitLine() As String

If System.IO.File.Exists(fname) = True Then
Dim objReader As New System.IO.StreamReader(fname)

Do While objReader.Peek() <> -1
TextLine = objReader.ReadLine()

SplitLine = Split(TextLine, ",")

                radgridview1.ColumnCount = SplitLine.Count

           'if .RowCount = 0 then we are processing the first row
           'only need this code if you have a header row
                If radgridview1.RowCount = 0 Then
                    For i = 1 To SplitLine.Count - 1
                        With radgridview1
                            .Columns(i).HeaderText = SplitLine(i).ToString
                            .Columns(i).BestFit()
                        End With
                    Next
                End If
                radgridview1.Rows.Add(SplitLine)
            Loop

            'stupid but the only way I could get the datagridview to populate correctly
            'removes the header row
            If radgridview1.RowCount > 1 Then
                radgridview1.Rows.RemoveAt(0)
            End If

        Else
            RadMessageBox.Show("File Does Not Exist")
        End If

answered on 25 Aug 2009, 08:38 PM

Much cleaner method to import Excel data (in my opinion at least) google some of the oledb stuff and you can find examples to import CSV files as well. I've used this method and it's much better than a manual reading of the CSV file as it catches columns that might have "special" characters in them much cleaner.

                                        private void Test(string filename)         
                                {         
                                    // Connection String to Excel Workbook         
                                    string excelConnectionString = @"Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" + filename + @";Extended Properties=""Excel 8.0;HDR=YES""";         
                                 
                                    // Create Connection to Excel Workbook         
                                    System.Data.OleDb.OleDbConnection connection = new System.Data.OleDb.OleDbConnection(excelConnectionString);         
                                    // replace [tbl_30_day$] with the "sheet" name of the data you want from the excel file         
                                    System.Data.OleDb.OleDbCommand command = new System.Data.OleDb.OleDbCommand("Select * FROM [tbl_30_day$]", connection);         
                                 
                                    // create table to hold excel sheet         
                                    DataTable objtb = new DataTable();         
                                    try         
                                    {         
                                        connection.Open();         
                                 
                                        System.Data.OleDb.OleDbDataAdapter da = new System.Data.OleDb.OleDbDataAdapter(command);         
                                 
                                        da.Fill(objtb);         
                                        da.Dispose();         
                                    }         
                                    catch (Exception exd)         
                                    {         
                                        // variable here to catch exception message / stacktrace         
                                    }         
                                    finally         
                                    {         
                                        if (connection != null)         
                                        {         
                                            connection.Close();         
                                        }         
                                    }         
                                 
                                    travelling_Grid.DataSource = objtb;         
                                }         