XLConnect
  • XLConnect Documentation
  • Using XLConnect
    • Getting Started
    • Using XLConnect
    • Manage Users
    • Manage Your Subscription (Owners)
    • XLConnect Security
    • Troubleshooting
  • Developing with XLConnect
    • Getting Started
    • The Bigger Picture
    • Import Scripts
    • Scripts
    • Cloud Systems
    • Javascript
      • Javascript Studio
      • Javascript language
      • Calling API's with HTTP Requests
      • Working with JSON data
      • The xlc object
      • Advanced Javascript
    • Modules
      • HTTP module
      • FILE module
    • Maps
    • JSON Data Format
    • Data Lake
    • Excel modelling
    • VBA
    • The XLConnect API
  • Reference
    • Change log
Powered by GitBook
On this page
  1. Developing with XLConnect
  2. Javascript

Javascript Studio

Scripts transform data from an input map to an output map

PreviousJavascriptNextJavascript language

Last updated 1 year ago

Now that we have seen the Connections and Accounts scripts in action, it's time to look a little closer at how they work.

On the right-click the Accounts script and choose Edit javascript:

This will bring up the for the Accounts script.

On the left pane you can see the javascript code, the right two panes are empty. Hit F5 to run the script, this will fill the right two panes with data.

The top right pane called Engine shows the variables the code has created in the javascript engine. The bottom pane show the result of the script, this is what will be returned to Excel.

Double click the Acounts node in the bottom pane to zoom in:

Variables you see in the Engine and Result pane can be zoomed in by double-clicking them, this can be helpful when dealing wit lots of data.

Javascript Studio
Bring up the Jascript Studio for the Accounts script
Javscript Studio for the Accounts script
Zooming in on the Accoutns table by double-clicking