Show Excel data in a Project Siena app
In Project Siena, you can create a Windows Store app that shows data that you import from one or more tables in an Excel workbook. For example, you can follow this tutorial to create an app in which users can display and filter data about laptops, tablets, and all-in-one devices from several original equipment manufacturers (OEMs). As an alternative, you can watch a video on Channel 9 that shows the same steps as this topic.
For a general overview of Project Siena and links to resources such as sample apps, video tutorials, and forums, see Project Siena.
Note
The data in this tutorial is provided for demonstration purposes only. Microsoft makes no guarantees as to the accuracy of the data at the time of this writing or at any point in the future.
Prerequisites
Project Siena, which you can get for free from the Windows Store
You can find system requirements and other information in the release notes.
Excel 2010 or Excel 2013
Familiarity with basic operations in Project Siena, as Create your first app with Project Siena describes.
Import data
Download and decompress the Excel workbook and image folders for this tutorial from the TechNet Gallery.
In Excel, format all the data in the OEMs worksheet as a table named OEMs, and format all the data in the Devices worksheet as a table named Devices.
For more information, see Add data from Excel.
Copy the folders that contain device images and OEM logos, and then paste them into C:\Users\Public\Public Pictures.
If you're running Windows 8.1, right-click the Public Pictures folder, point to Include in library, and then click Pictures.
In Project Siena, import the tables that you just formatted.
For more information, see Add data from Excel.
Add galleries
Add a vertical Image Gallery, name it OEM gallery, and bind it to the OEMs table.
In the gallery template, click the top logo to select the image control, click Design if it appears near the bottom of the screen, and then set the Image Position property of the image control to Fit.
Make the gallery narrower so that more logos appear.
.jpeg "A narrower gallery shows more logos at once")
Add a horizontal Image Gallery with Text, name it Device gallery, and bind it to the Devices table.
Move the Device gallery to the center of the screen, and adjust the width of the gallery so that it shows information about two devices.
In the first item of the Device gallery, click the label that shows the OEM name, click Data if it appears in the lower-left corner, and then set the Text property of the label to ThisItem!'Device Name'.
Repeat the previous step, except set the Text property of the other label in the Device gallery to 'ThisItem!OEM name'.
.jpeg "Left: OEM gallery, Right: Device gallery")
Filter a gallery
Click the Device gallery, click Data if it appears in the lower-left corner, and then set the Items property of that gallery to this function:
Filter(Devices, Type = "Laptop")
The Device gallery shows laptops but no other types of devices. For more information about the Filter function and other functions in Project Siena, see Filter.
Set the Items property of the Device gallery to this function:
Filter(Devices, 'OEM name' = 'OEM gallery'!Selected!'OEM name')
Press F5, click an item in the OEM gallery, and then click another.
The Device gallery shows only those devices that were manufactured by the OEM that you clicked most recently.