Present Excel spreadsheet in ASP.NET website

Question

0.00/5 (No votes)

See more:

Greetings,

I have a very artistic and beautiful Excel spreadsheet containing all manner of charts and what not that would surely impress you. Let's pretend there is a reason other than my own laziness that I would like to serve this to some folks via a website without having to re-create it as an actual web page myself.

Does anyone know of perhaps a third party control that would accomplish such a thing? ... server-side XLS to HTML gizmo of some sort?

Cheers,
-Jack

Posted 28-Oct-13 10:10am

Jack Vanderhorst

Add a Solution

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

Richard C Bishop · Answer 1 · 2013-10-28T10:31:00

Solution 1

Here are some articles I found that may help, even though I have never attempted this:

Click me![^]

and me![^]

don't forget me![^]

Posted 28-Oct-13 10:31am

Richard C Bishop

Comments

Sergey Alexandrovich Kryukov 28-Oct-13 23:08pm

5ed, can be useful.
—SA

Jack Vanderhorst 29-Oct-13 9:09am

Hi Sergey, thanks for your reply, what is '5ed'?

Sergey Alexandrovich Kryukov 29-Oct-13 10:08am

It means that I up-voted the maximum mark of "5" the Solution 1 post by richcb. Those votes are summarized with weights to calculate reputation score of a member, how it's often done in other online communities...
—SA

Richard C Bishop 29-Oct-13 10:36am

Jack, if this solution satisfied your needs, please accept it as the solution so it will be removed from the unanswered pool.

Jack Vanderhorst 29-Oct-13 10:45am

Hi richcb,

Appreciate your response, but the first link is for some code to generate HTML which is exactly what I'm trying to avoid, the second link involves me uploading private content to Skydrive which is a reliable way to get myself unemployed, and the third link involves again a bunch of code and probably wouldn't handle the charts and fancier content in this particularly beautiful and artistic spreadsheet.

I'd prefer to hold out a bit in case someone else has any thoughts.

Richard C Bishop 29-Oct-13 11:01am

No worries. It was merely a suggestion, as some tend to forget.

Richard C Bishop 29-Oct-13 10:36am

Thank you Sergey!

Jack Vanderhorst · Answer 2 · 2013-10-30T03:15:00

Here's what I ended up with, cheap and happy, the spreadsheet shall live on...

C#

//Start Excel and get a handle on the spreadsheet
Microsoft.Office.Interop.Excel.Application objExcel = new Microsoft.Office.Interop.Excel.Application();
Microsoft.Office.Interop.Excel.Workbook objWB = objExcel.Workbooks.Open(strPath + strSourceFile);

//Refresh it
objWB.RefreshAll();

//Save it out to html
string strHTMLFileName = strTempPrefix + Guid.NewGuid().ToString() + strHTMLExtension;
objWB.SaveAs(strPath + strHTMLFileName, Microsoft.Office.Interop.Excel.XlFileFormat.xlHtml);
objWB.Close();

//Inject the html into the response
Response.Output.Write(System.IO.File.ReadAllText(strPath + strHTMLFileName));

//Have a nice day

Marc Gabrie · Answer 3 · 2013-10-30T09:36:00

try Google Doc Viewer. It's very simple to use, free & you do not need any external tool nor dll! Add a markup code like the following in your webpage:

<iframe src="http://docs.google.com/gview?url=URL-TO-YOUR-XLS-FILE&embedded=true" style="width:600px; height:500px;" frameborder="0"></iframe>

Just set "url" query string param to your Excel file as an absolute URI and that's it!

Present Excel spreadsheet in ASP.NET website

3 solutions

Solution 1

Solution 2

Solution 3

Add your solution here

Preview 0