User guide

© GeoWise Ltd. 2011
Page 94
visualise | communicate | ENGAGE The InstantAtlas Excel Data Manager
g the InstantAtlas Area Profile Template User Guide
© GeoWise Ltd. 2013
E.1. About this Section
The Excel Data Manager is an Excel add-in (i.e. a supplemental program
that adds custom commands to Excel). It enables data in an Excel
workbook to be exported as InstantAtlas XML or JSON data files.
For InstantAtlas Flash dynamic reports, the data files need to be in XML
format. XML stands for Extensible Markup Language and is a flexible
format for storing, structuring and publishing information.
E.2. The Excel Add-in
With InstantAtlas version 5 or later, the Excel Data Manager add-in is
automatically installed. However, you will still need to enable it in order for
the InstantAtlas menu and toolbar to appear. If you have followed the
instructions in the InstantAtlas Getting Started guide, you will already have
enabled the add-in.
To enable the add-in follow the instructions below for either Excel 2007 /
2010 / 2013 or for earlier versions.
Excel 2007 / 2010 / 2013
Open Excel. In Excel 2007 click the Office button and click on the ‘Excel
Options’ button (Figure 113). For Excel 2010 and 2013 click the green
‘File’ tab and select ‘Options’ in the left hand menu (Figure 114 for Excel
2010; Figure 115 for Excel 2013).
Figure 113
Figure 114
For InstantAtlas HTML dynamic reports the data files need to be in
JSON format. JSON stands for JavaScript Object Notation which is
a text-based format for representing data structures.