How to view the excel file using ASP.NET C#?

Question

1.00/5 (1 vote)

See more:

i upload the excel file in file upload button.and click the show button to view the excel means pop up view of excel (if attached excel file in gmail and view the excel file in popup window )how to do it.

What I have tried:

I have search online for reference but the excel viewing application only available.

Posted 23-Nov-16 0:18am

Raja Ganapathy

Updated 23-Nov-16 1:52am

Afzaal Ahmad Zeeshan

v2

Add a Solution

Comments

[no name] 28-Aug-17 7:21am

As Afzaal has already mentioned, the reason why you can "preview" the file in Gmail is because they render the file themselves. What this actually means is that they have a "canvas" element on their page and they use JavaScript to draw the file's content on that "canvas".
As you can imagine, this is quite a complicated task so you should probably use an existing solution for this. For example you may want to try out this Excel library for C# and VB.NET. Here you can find an Excel example for ASP.NET and also here you can find a C# and VB.NET conversion example for Excel to HTML.

2 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)

preety sunita · Answer 1 · 2016-11-23T00:33:00

Solution 1

May below links will be useful to you..have a look !

how to open excel file on browser ...in asp.net c#[^]

and this one

Fetch and read email messages with attachments from GMAIL POP3 mail server in ASP.Net[^]

Posted 23-Nov-16 0:33am

preety sunita

v2

Afzaal Ahmad Zeeshan · Answer 2 · 2016-11-23T01:51:00

They render the uploaded files themselves using the content of files, rendered in native HTML. Browsers are unable to render special file types, such as PDF, MS Word and MS Excel etc. You need either a plugin to be installed on the browser, or you need to render it using HTML, and for that you need to read everything from file and then render it using tables, gridviews etc. Otherwise browser will simply download the file to disk.

Your best bid is to use an Excel to HTML converter, that converts your Excel sheet data to an HTML table element. You can find hundreds of them online. Google[^] will help. There are special libraries created too, .NET Office[^] etc that can be utilized here. But choice is yours.