How can i display "Excel File" in Asp.net

Question

0.00/5 (No votes)

See more:

How can i display "Excel File" in Asp.net

I have an Excel sheet so i have to display data in asp.net in simple table formate so kindly please help me how can i do that.

Posted 28-Nov-13 19:45pm

DGKumar

Updated 28-Nov-13 19:46pm

v2

Add a Solution

4 solutions

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)

Maciej Los · Answer 1 · 2013-11-28T19:54:00

Solution 3

Start here: How To Use ADO.NET to Retrieve and Modify Records in an Excel Workbook With Visual Basic .NET[^]
How to query and display excel data by using ASP.NET, ADO.NET, and Visual C# .NET[^]

Posted 28-Nov-13 19:54pm

Maciej Los

TrushnaK · Answer 2 · 2013-11-28T19:56:00

Solution 4

Refer below:-
you can do that using several ways like:-

using gridview:-
http://www.dotnetgallery.com/kb/resource16-Upload-and-display-excel-file-content-in-gridview-using-aspnet.aspx[^]

using Iframe:-
<iframe src="file:\\yourpath\yourfile.xls" width="100%" height="500"></iframe>

Using Excel Services:-
http://blah.winsmarts.com/2007-3-SharePoint_2007__Excel_Services_-_A_Quick_Introduction.aspx[^]

Posted 28-Nov-13 19:56pm

TrushnaK

Comments

Janardhan.GRD 14-Sep-15 7:36am

i am using iframe code and all it does is show cannot use local resources in mvc4

Janardhan.GRD 14-Sep-15 7:37am

Not allowed to load local resource: file:///C:/Users/TECH-1/Desktop/report.xls

Anis Mohd Said 9-Oct-18 21:57pm

what will be displayed when using iframe? can i have the image?

Aydin Homay · Answer 3 · 2013-11-28T19:52:00

Hi

You can show excel files from asp.net with different ways for example some useful solutions you can find follow of links:
http://dotnetmentors.com/aspnet/display-excel-data-in-web-page.aspx[^]
www.codeproject.com/Articles/16302/Display-MS-Excel-Sheets-and-Charts-in-ASPX-Pages-u[^]
www.freevbcode.com/ShowCode.asp?ID=4242[^]
http://forums.asp.net/t/1717501.aspx[^]

Best Regards

kumar9avinash · Answer 4 · 2013-11-28T19:52:00

Solution 1

hi,
you can use Microsoft report viewer(reporting tool)to view in excel and pdf of any table, but your requirement is different but you can try that tool to generate report in excel.

Posted 28-Nov-13 19:52pm

kumar9avinash

Updated 28-Nov-13 19:53pm

v2