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

File crashes Excel!!

Save my workbook!
The best tool for salvaging problematic workbooks.

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 > Dynamic demo
Deze pagina in het Nederlands

Creating webpages with Excel Web App mashups

Demo of a dynamic chart

This page contains event code that will automatically increase the Phase box with steps of 10 degrees and updates the chart accordingly.

You can still edit both boxes however. Remember to use the decimal separator that belongs to your windows country setting. If the chart stays blank, try using the dot instead of the comma or vice versa.

Phase difference (degrees) Frequency ratio 

Please Wait...


 


Comments

All comments about this page:


Comment by: dev (1/23/2013 8:30:22 PM)

I want to source file for I want to make this application make my side.

 


Comment by: Jan Karel Pieterse (1/24/2013 10:17:40 AM)

Hi Dev,

You can go to this page:

http://www.jkp-ads.com/Articles/embeddedexcel00.asp

It displays the same excel file. At the bottom of the excel window, on the far right there is an icon you can click to view the excel file in your browser. From there you can download the file (Edit in Excel).

 


Comment by: Andrew (8/26/2013 6:18:09 AM)

Hi,

Great article,

My question is how did you remove the "full-size work book" button in the bottom right hand corner?
= Andrew

 


Comment by: Jan Karel Pieterse (8/26/2013 9:21:34 AM)

Hi Andrew,

In the Javascript code behind this page you can find this part:

var props = {item: "Chart 2",
uiOptions:
{
showDownloadButton: false,
showGridlines: false,
showRowColumnHeaders: false,
showParametersTaskPane: false
},


Look for the "showDownloadButton" setting.

 


Comment by: Hans Billiet (10/24/2013 9:05:21 PM)

I'm new in this, and looking for an excel file that can interact with a form on a website. I read your article, and it seems very useable. But what concerns me is the security. I don't want to allow people to have access to the excel file itself, because it contains confidential information. Is there a way to protect the content? I read that protected sheets are not supported, but if using JavaScript shields the excel file from the user, then protection might not be needed. Please comment. Thanks!

 


Comment by: Jan Karel Pieterse (10/25/2013 9:05:13 AM)

Hi Hans,

Indeed the protection is the part that is worrying. I don't think you can actually prevent people from downloading your file. But you can make it hard to do.

In fact, the embedded Excel file on this page has no buttons for download. But you can still access the JAVASCRIPT code of this page and some editors allow you to step through the code and hence influence its behavior.
Any knowledgable developer will be able to get at your file utlimately.
But 99% of the audience using your embedded document will not be able to do so because they lack the expertise.

 


Comment by: mike (3/19/2015 9:39:11 PM)

hi i want to ask one thing... i have embeded sheet on my website please have a look http://www.g-laptops.com/librarymain/
my question is if i can zoom in or out.. or if there is a way i can add something like zoom control using java script.. or even better embed the worksheet with already 50 % zoomed out. So it will show not 20 % of the sheet but for example half of it bit zoomed out. Right now i can only use ctrl - and ctrl + to zoom in and out. Please let me know, it will be a great help. Thank you

 


Comment by: Jan Karel Pieterse (3/20/2015 1:40:40 PM)

Hi Mike,

What happens if you change the zoom level on the original file and replace it on your OneDrive?

 


Comment by: Renaud (5/26/2016 11:19:43 AM)

Hello,

I understand how to send value in the ExcelWebApp, but how to get value from the Excel to use it in the webpage ?

 


Comment by: Jan Karel Pieterse (5/30/2016 6:08:14 PM)

Hi Renaud,

Apologies for the belated reply.

Perhaps you can find more information on Tushar Metha's website:
http://www.tushar-mehta.com/publish_train/data_visualization/15a%20Excel%20Mashup.shtml

 


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].