Most Valuable Professional


View Jan Karel Pieterse's profile on LinkedIn subscribe to rss feed
Subscribe in a reader

Subscribe to our mailing list

* indicates required

Audit !!!

Check out our RefTreeAnalyser
the ultimate Excel formula auditing tool.

Trainings

Excel VBA Masterclass (English)
Excel VBA for Financials (Dutch)

Third party tools

Speed up your file

FastExcel
The best tool to optimise your Excel model!

Repair your file

Stellar Phoenix Excel Repair
Best tool to repair corrupt Excel sheets and objects
Home > English site > Articles > Excel Web App Mashups > Conclusion
Deze pagina in het Nederlands

Creating webpages with Excel Web App mashups

Conclusion

Excel Web Applications and their ability to interact with your web page using JavaScript open up a whole new world of possibilities. Now you can build Excel models your users can interact with using your web site. Also, this enables you to create mashups in which you combine data from multiple sources; you can grab data from other websites and put that into your Excel model and have it show the results on your website.

Further reading

To get this all working I used information from the following sources:

Excel Mashup

MSDN: Using the Excel Services JavaScript API to Work with Embedded Excel Workbooks

MSDN: Ewa Namespace


 


Comments

All comments about this page:


Comment by: Chandoo (12/15/2011 9:12:37 PM)

Wow... very exhaustive and clear tutorial. Thank you so much for writing this. I am eager to play with this feature. Will let you know once I build something using this.

 


Comment by: Jan Karel Pieterse (12/16/2011 3:47:33 AM)

Hi Chandoo,

Thanks!

 


Comment by: Mike Webster (4/23/2014 4:42:58 AM)

Hi Jan,

This has been incredibly helpful. Thank you. One thing I can't seem to find a way to do is hide a row using javascript. Is this possible?

Thanks,
Mike

 


Comment by: Jan Karel Pieterse (4/28/2014 10:15:27 AM)

Hi Mike,

That cannot be done using JavaScript (yet).

 


Comment by: Gan Kok Wee (11/7/2017 4:57:01 AM)

Hi,

On OneDrive, I've an Excel file linked to a form. The form contains a set of multiple-choice questions. When a user submits a respond, I would like to compute a score based on the user's input and inform the user via email about the score. I would appreciate any advice on how to achieve this.

FYI, with Google Drive, this is simple as I can use add-ons such as copyDown and formMule on a Google sheet. But for Microsoft 365 on OneDrive, I've been stuck.

Any helps will be much appreciated

 


Comment by: Jan Karel Pieterse (11/7/2017 5:43:57 PM)

Hi Gan Kok,

I'm afraid Excel on-line does not offer such options.

 


Have a question, comment or suggestion? Then please use this form.

If your question is not directly related to this web page, but rather a more general "How do I do this" Excel question, then I advise you to ask your question here: www.eileenslounge.com.

Please enter your name (required):

Your e-mail address (optional but if you want me to respond it helps!; will not be shown, nor be used to send you unsolicited information):

Your request or comment:

To post VBA code in your comment, use [VB] tags, like this: [VB]Code goes here[/VB].