Office App Store: JavaScript API Tutorial for Office using Excel
Channel: LearnAccessByCrystal
Date: 31/01/2014

What are the new apps for Office?
Learn what they are and how you can get started using and building them.

1. download an app from the Microsoft Store 
2. Create a new workbook using Excel 2013
3. Insert an app from the store on an Excel spreadsheet
4. set Excel Options so you have permission to run the app
5. review Code to read from and write data to Excel.

Learn what to do for the steps that are missing in the instructions.

What is the difference between Markup and Code?

In an Office app, HTML is used to layout what will be displayed. JavaScript is the programming language.

Also show how to change the Office Theme so the ribbons are darker.

*** Original Music  *** Jubal Lee Young

http://juballeeyoung.com
YouTube: http://www.youtube.com/jly151
MySpace: http://www.myspace.com/juballee
'Greed Is The Creed' on YouTube: 
http://www.youtube.com/watch?v=Zu32nlN6aYw

and I am going to include a link to Jubal's lyrics, which are amazing and insightful:
http://juballeeyoung.com/lyrics.php

*** Links ***

excellent video tutorial by Bruce Johnson of Microsoft Developer Canada that goes into depth on building an app: https://www.youtube.com/watch?v=j7Xha_Vs2f4
 
API tutorial for Office" by Microsoft in the app store 
http://office.microsoft.com/en-us/store/api-tutorial-for-office-WA104077907.aspx

JavaScript API for Office
http://msdn.microsoft.com/en-us/library/office/fp142185.aspx

Office Dev Center
http://msdn.microsoft.com/en-us/office/aa905340

Context object
http://msdn.microsoft.com/en-us/library/office/fp161104.aspx

Context.document property
http://msdn.microsoft.com/en-us/library/office/fp161177.aspx

Document object 
http://msdn.microsoft.com/en-us/library/office/fp142295.aspx

Document.setSelectedDataAsync method
http://msdn.microsoft.com/en-us/library/office/fp142295.aspx

AsyncResultStatus enumeration (apps for Office)
http://msdn.microsoft.com/en-us/library/office/fp142269.aspx

AsyncResult.value property
http://msdn.microsoft.com/en-us/library/office/fp161049.aspx

AsyncResult.status property
http://msdn.microsoft.com/en-us/library/office/fp142283.aspx

Document.getSelectedDataAsync method
http://msdn.microsoft.com/en-us/library/office/fp142294.aspx

CoercionType enumeration
http://msdn.microsoft.com/en-us/library/office/fp161141.aspx

Asynchronous programming in apps for Office
http://msdn.microsoft.com/en-us/library/office/jj220067.aspx

Office Store FAQ
http://office.microsoft.com/en-us/support/office-store-faq-HA102900784.aspx

Microsoft Store Provider Page
https://office.microsoft.com/en-us/store/dashboard.aspx?AssetId=PN102957641

Apps in the Office Store 
http://office.microsoft.com/en-us/store/apps-for-excel-FX102804981.aspx

Overview of apps for Office
http://msdn.microsoft.com/en-us/library/office/jj220082.aspx

Fundamentals for developing task pane and content apps
http://msdn.microsoft.com/en-us/library/office/fp123523.aspx

How to: Publish an app for Office that is packaged as an autohosted app for SharePoint
http://msdn.microsoft.com/en-us/library/office/jj692556.aspx

for more information on HTML 
- what it is and where it came from, watch:
2a Windows Phone - XAML Controls, Markup Languages 
http://www.youtube.com/watch?v=wD4t0Zhaz9M

"Developing Apps for Office 2013" forum
http://social.msdn.microsoft.com/Forums/office/en-US/home?forum=appsforoffice

happy learning!

______________________
Intro and End: Microsoft Office PowerPoint.
Screen-shots: Techsmith SnagIt.
Screen capture and production: Techsmith Camtasia
Audio edited with GoldWave
~~~~~~~~
Capture and Production Settings:
Video: H.264, 24-bit color, 30 fps, 1280x720
Audio: PCM, 44,100 kHz, 16-bit, 172 kb/sec
~~~~~~~~
Render Format: QuickTime MOV
~~~~~~~~

* let's connect *
Do you need help? You know your business. I know how to teach, write programs, and develop applications. If you have a budget and want control of your project, let's connect and build it together!

visit MsAccessGurus and contact me today!
http://msaccessgurus.com 

I look forward to hearing from you ~

warm regards,
crystal

Remote Programming & Training -- connect to me, let's built it together

~ have an awesome day ~