Excel on Web Page

Looking for simplest, most effective way to expose an Excel spreadsheet (.xlsm) on a web page, preferably without using third party software, but if that is the best option, please share your opinion.  Ideally, would like to have a control that could be placed on a web page, where the control would contain the Excel spreadsheet, and the spreadsheet would be completely interactive to the user as if they were actually just using it in Excel. Would need Excel VBA code in the document to work as normal as well. Thank you.
SEMCITAsked:
Who is Participating?
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

radcaesarCommented:
The most powerful one like one for web was not exists now. They may give some features. You can try below products.

If you want it as only readonly, then you can do that using HTML and Javascript itself.

http://www.sigmawidgets.com/products/sigma_grid2/

http://www.essentialobjects.com/Products/EOWeb/Grid.aspx

http://blogs.msdn.com/b/mattdotson/archive/2005/11/09/real-world-gridview-bulk-editing.aspx
0

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
SEMCITAuthor Commented:
Thank you for your quick reply radcaesar.  I appreciate what you shared.  I also appreicate that you made me realize that perhaps I was not clear enough with regards to third party software.  I would be open to third party software if it provides a control to contain an actual Excel spreadsheet in it.  I'm not looking for alternative grids to use instead of Excel.  However, I do really appreciate you sharing those, because they are very nice and I'm sure they will be useful for something else in the future. Thank you so much for your time.
0
Eddie ShipmanAll-around developerCommented:
Unless your ISP's host server is Windows, there is no chance. You will have to convert it on the fly to some other presentation format.
0
Cloud Class® Course: Microsoft Office 2010

This course will introduce you to the interfaces and features of Microsoft Office 2010 Word, Excel, PowerPoint, Outlook, and Access. You will learn about the features that are shared between all products in the Office suite, as well as the new features that are product specific.

SEMCITAuthor Commented:
Thank you for trying to help me.  I truly appreciate it, but I refuse to take no for an answer, so I found a couple of answers for myself, which I would like to share in case anyone else clicks on this question in the future seeking the same thing I was.  Here are two options I found:

Excel Viewer OCX 2.0 (I believe this would be about $99)
http://www.skysof.com/
scroll down until you see "Excel Viewer OCX 2.0 - ActiveX to view Excel files"

Excel Viewer OCX 3.1 (this is very expensive, but very nice)
http://www.officeocx.com/
scroll down until you see "Edraw Viewer OCX For Excel v7.4"

This should give someone an idea of what I was looking for.  Since I answered this myself, I will leave it open for a little while in case someone would like to look at what I found, get an idea of what I want, and possibly offer an even better solution, in case someone would like to get awarded the points.  Thank you all for your time.
0
rspahitzCommented:
I've heard that Office 2010 lets you do Excel Web Apps, which might be what you want:

http://office.microsoft.com/en-us/web-apps

They have a video to demonstrate it (see if this works or check out the page above):

http://office.microsoft.com/en-us/redir/va102446424.aspx
0
Eddie ShipmanAll-around developerCommented:
I think you don't quite understand what we are trying to get across, here. You cannot use Excel Viewers in a web page. They are OCXs and would require the user to download and install to be able to view the file.

You still haven't noted what OS your host is using. It will make a very big difference.

Can you also explain why it is that you cannot use a server based language to convert the Excel file, parse and display it? Are you wanting to keep formatting? Are you wanting the users to interact with it, through formula's, etc?
0
Eddie ShipmanAll-around developerCommented:
http://www.exceleverywhere.com/

http://www.microsoft.com/downloads/en/details.aspx?familyid=7287252c-402e-4f72-97a5-e0fd290d4b76&displaylang=en

You also have to remember that when using MS Office Web Components, only IE users will be able to interact with the spreadsheet.
0
Eddie ShipmanAll-around developerCommented:
0
SEMCITAuthor Commented:
Thank you all for your help.   You all gave good possible solutions.  However, we do need the user to be able to interact with the Excel document as if they were opening it on their machine (including .xlsm documents).  I believe at this point we are either going to look at using one of the OCX solutions, which I understand the user's would need on their machine, but it may be our best solution, or we are also going to look into whether adding a Web Part in Sharepoint might be a solution.
0
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Microsoft Applications

From novice to tech pro — start learning today.