Tell me more ×
Stack Overflow is a question and answer site for professional and enthusiast programmers. It's 100% free, no registration required.
up vote 6 down vote favorite
6

I need to export the Users List from excel to my asp.net mvc(C#) application.

The Excel should have an header like First Name Last Name Email,...
and its values like                                  John          Smith           [email protected],                                                               David         Beckam       [email protected],

Need to validate the values before storing it to my database and show it in the grid of next page.

Is there any easy way to do it, like a plugin?

share|improve this question

1 Answer

up vote 5 down vote accepted

I think that it would be best, in this case, to use ADO.NET.

A few articles on how to do this in order to read values from an Excel Worksheet:

(1) Reading and Writing Excel Spreadsheets Using ADO.NET C# DbProviderFactory (David Hayden)

(2) Import Excel File to DataSet (CodeProject)

(3) Tips for reading Excel spreadsheets using ADO.NET (Lab49)

(4) Reading Excel files from C# (Stack Overflow)

I think that this should get you to where you need to go.

-- Mike

share|improve this answer
Thanks Mike, good reference. – Prasad Oct 13 '09 at 3:58

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.