Click here to Skip to main content
14,933,981 members
Please Sign up or sign in to vote.
1.00/5 (1 vote)
See more:
I am creating a Windows Forms application and i want to open a Excel sheet using OpenFileDialog and display its contents to a gridview/ListView. Please Help Me...
Posted
Updated 12-Aug-13 21:17pm
v2

Refer this link. It is exactly the same what you need.

Import Data from Excel to DataGridView in C#[^]

Regards..:)
   
Comments
Maciej Los 12-Aug-13 9:21am
   
Looks promisingly ;)
+5!
Thanks7872 12-Aug-13 12:30pm
   
Thanks Maciej. :)
Change your Excel sheet into CSV file and try this:
C#
FileUpload1.SaveAs(Server.MapPath("~/tmpdir/") + FileUpload1.FileName);
System.IO.StreamReader myFile = new System.IO.StreamReader(Server.MapPath("~/tmpdir/")    + FileUpload1.FileName);
string myString = myFile.ReadToEnd();
myFile.Close();
string[] lines = myString.Split(new string[] { Environment.NewLine },      StringSplitOptions.None);
 
foreach (string line in lines)
 {
     if (line != "")
      {
          string[] columns = line.Split(',');
 
          //Upload to your DB with your indexes

      }
     else
      {
 
      }
}
   
   
v5
C#
using System.Data;
using System.Data.OleDb;

OleDbConnection con = new OleDbConnection(@"Provider=Microsoft.Jet.OLEDB.4.0;Data Source=C:\Book1.xls;Extended Properties=Excel 8.0");
OleDbDataAdapter da = new OleDbDataAdapter("select * from MyObject", con);
DataTable dt = new DataTable();
da.Fill(dt);
   
v2
Comments
Maciej Los 12-Aug-13 9:27am
   
Please, use text formatting. You aren't newbie.
ridoy 12-Aug-13 9:37am
   
done,often they find it difficult to format code.
fjdiewornncalwe 16-Aug-13 9:55am
   
It's difficult for him because he is simple plagiarizing answers from other sites as his own without credit. (Source) He seems to have a habit of this. I've been looking at recent answers and they are pretty much all copied without credit.
ridoy 16-Aug-13 13:23pm
   
agree with you.i have seen that things also.

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)




CodeProject, 20 Bay Street, 11th Floor Toronto, Ontario, Canada M5J 2N8 +1 (416) 849-8900