Chapter 5. Excel DataSource

Table of Contents

Overview
Excel DataSource Wizard
Working with Excel DataSource
Adding Data in a Single Worksheet
Adding Data in Multiple Worksheets
Passing Dynamic Parameters

Overview

Excel is a spreadsheet application developed by Microsoft. By adding an Excel DataSource you can access the data directly from the Excel file. From Repertoire 7.4 onwards, XSLX format (Excel 2007 format) will be supported.

A range of data can be loaded, including support for both single and multiple sheet (3D) ranges.

An Excel DataSource can be created simply by right-clicking on an Excel file on the repository and select “Define as an Excel DataSource”.