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.

You can create an Excel DataSource by right-clicking an Excel file on the repository and selecting Define as an Excel DataSource.