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. XSLX format (Excel 2007 format) is 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”.