Files
-
- 10 KB
- Download
Introduction
Let’s begin working with Microsoft Excel data by first viewing the data through Visual Preview in FME Workbench. Visual Preview is used to preview data, both before, during, and after a translation, and is particularly useful for identifying where additional data formatting may be necessary. It is important to note that Visual Preview is not an editing environment, and changes cannot be made to the source data through this window. Optionally, you can also view data with FME Data Inspector.
Video
This video was recorded using FME 2016. Please note that the interface and dataset differ, but the underlying concepts remain the same.
Step-by-Step Instructions
1. Add an Excel Reader
Open a blank workspace in FME Workbench. From the top menu, select Reader to add a new reader to the canvas.
In the Add Reader dialog, for the Format, type "Microsoft Excel". For the Dataset, click on the ellipsis, then browse to the Precipitation.xlsx file, which can be downloaded from the Files section of this article (located in the top-right corner).
Click OK to add the reader to the canvas.
2. Open the Pop-up Menu
This Excel spreadsheet has four workbooks, by default FME will read them all in. Each of the worksheets will appear on the canvas; these are referred to as data types. Let’s inspect one of the worksheets (feature types). Click on the "2020 Reader Data Type" to open the pop-up menu. From the pop-up menu, click on Inspect Source Data, which will open the dataset in Visual Preview. If FME Data Inspector opens, you may be using an older version of FME, but the functionality is the same.
3. Review Data in Visual Preview
In the Visual Preview window, there are three different views, a table view, graphics view, and feature information view. Since this data doesn’t have x and y coordinates, only the table view will be displayed.
The Table View displays the data contained in the Excel spreadsheet, with attribute (column) names displayed in bold. Right-clicking on the attribute name allows you to sort using several criteria: alphabetical/numeric, ascending/descending. Text values are presented left-aligned, and numeric values are right-aligned.
For more information on Visual Preview, see the Getting Started with FME Form tutorial or the documentation. For more information on FME Data Inspector, see the tutorial or documentation.
Data Attribution
The data used here originates from open data made available by the City of Vancouver, British Columbia. It contains information licensed under the Open Government License - Vancouver.