import from excel to gridview

Question

0.00/5 (No votes)

See more:

Hi All,

Let me know how to import data from excel to grid view.I want to click on button where a file dialog box opens,then i use to select excel sheet which is then imported to gridview.

How can i do it.

Thanks in advance...

Posted 3-May-11 20:14pm

mylogics

Updated 3-May-11 20:21pm

Ramalinga Koushik

v3

Add a Solution

4 solutions

Solution 1

Some links that might help you -
http://dotnetguts.blogspot.com/2006/10/import-excel-to-datagrid-aspnet.html[^]
Import and Export Data from GridView[^]

Posted 3-May-11 20:17pm

Abhinav S

Comments

mylogics 4-May-11 2:26am

yaa its fine thank u bt i in this connection string is hardcoded.i want to get excel sheet anywhere from my computer.user select the excel sheet than it is imported.for ex as it happens in fileuploader.user select the file and then upload it.

Abhinav S 4-May-11 3:45am

it should be easy to open the excel file via the file open control.
Once the file is loaded, try to load sheets in that file into a dropdown and then let the user choose the sheet they want to import into the datagrid.

Hope this helps!

Solution 2

see this link

http://davidhayden.com/blog/dave/archive/2006/05/26/2973.aspx[^]

Posted 3-May-11 20:27pm

Ashishmau

Solution 3

Try
Link1[^]
Link2[^]

Posted 3-May-11 20:29pm

RaviRanjanKr

Add a Solution

Add your solution here

Treat my content as plain text, not as HTML

Preview 0

…

Existing Members

Sign in to your account

...or Join us

Download, Vote, Comment, Publish.

Your Email
Password
Forgot your password?

Your Email
This email is in use. Do you need your password?
Optional Password

I have read and agree to the Terms of Service and Privacy Policy
Please subscribe me to the CodeProject newsletters

When answering a question please:

Read the question carefully.
Understand that English isn't everyone's first language so be lenient of bad spelling and grammar.
If a question is poorly phrased then either ask for clarification, ignore it, or edit the question and fix the problem. Insults are not welcome.
Don't tell someone to read the manual. Chances are they have and don't get it. Provide an answer or move on to the next question.

Let's work to help developers, not make them feel stupid.

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

Hemant__Sharma · Accepted Answer · 2011-05-03T20:55:00

There are 2 parts of your question

1- Uploading the excel file to the server
2- exporting the data to Gridview

For:
1- use simple file uploader control and receives the file stream at server end. Remember your file is in memory it is not saved anywhere else.

2- Exporting operation requires source data and target control. In your case source data is in memory stream and target control is gridview. So you need to either save the uploaded file to a temp location on server and then use the path with the above examples to export it to Gridview, or you can use Excel interop assembly but you need to find a way to convert memory stream to Excel's WorkBook object.

Note: I'm not able to recall but excel oledb driver has some limitation in reading data because the driver analyze the data size to read based on first N number of rows. I think it has something like below:
http://social.msdn.microsoft.com/forums/en-US/adodotnetdataproviders/thread/8ac74201-0371-47d9-b6a9-2993942777aa[^]

So i'll vote for Excel interop. I found a link which talks about exporting data to xml you can code similar for GridView.
http://www.dreamincode.net/forums/topic/192828-reading-excel-data-from-specific-cells/[^]

Thanks,
Hemant