[RESOLVED] Parse Excel in ASP.NET

[jsc0624]

Hi All,

Any idea here how to parse excel files data in ASP.NET WebForms using C# or ASP.NET MVC using C#?

Thank you

[danasegarane]

Hope this helps

[gep13]

In addition to the above suggestion, you can look into using the Office Interop DLL's to read the excel file. This isn't a particularly "pretty" way of doing it, but depending on your requirements, you might need to do this.

Here is an example:

http://www.dotnetspider.com/resource...tas-using.aspx

Gary

[jsc0624]

Thanks for the help, I will give you updates as soon as possible

[gep13]

jsc0624,

Sounds like a plan, hope you get it working!

Gary

[jsc0624]

I have successfully transferred the content of my excel files into dataset but the problem is:

  foreach (DataRow row in objDataSet1.Tables[0].Rows)
            {
                string name = row.Table.Rows[0]["FirstName"].ToString();
                string last = row.Table.Rows[0]["LastName"].ToString();
            }

Although it loops I can only extract the data of the first row.

Thanks in advance.

[gep13]

Why are you going into another table in the row? Is this necessary?

Gary

[jsc0624]

Hi Gary,

You are right, I don't need to go to another table in the row. I change the code to this:

            foreach (DataRow row in objDataSet1.Tables[0].Rows)
            {
                string name = row.Field<string>("FirstName").ToString();
                string last = row.Field<string>("LastName").ToString();
            }

Thanks for the help guys!

[gep13]

Hey,

Glad to hear that you got it working!

Gary