User Guide

10.5.0
- 10.5.3
- 10.4.0
- 10.2.3
- 10.2.2 HotFix 1
- 10.2.2
- 10.2.1
- 10.2

Back Next

Example 1: Read Excel Task

Follow the steps below to read an Excel document and format a date column.

From within the Project Designer page, expand the Data Translation folder in the Component Library, and then drag the Read Excel task to the Project Outline.

On the Basic tab of the Read Excel task, specify values for the following attributes:

Input File: The file path and file name of an Excel document from which to read data.
Output RowSet Variable: The name of a variable to contain the data read from the Excel document.

On the Advanced tab of the Read Excel task, specify values for the following attributes:

Data Start Row Number: The row number where the data starts in the document. In the example above, the Data starts on row four (4).
Headings Row Number: The row number where the column headings are found in the document.

Click the

Add

button and click the

Specify Data Options

option.

Click the

Add

button and click the

Add Column

option.

On the Basic tab of the Column element, specify the Index value:

Index: The index of the column in the document.

On the Type Conversion tab of the Column element, specify values for the following attributes:

Type: The data type of this column. In the example above the data type is DATE.
Pattern: The pattern to use to format numeric or date/time fields. The pattern is automatically determined based on ISO formatting. Only specify the pattern if ISO date format is not desired.

Click the

Save

button when finished.

When the project executes, a RowSet variable named myData will contain the following data:

${myData} RowSet Variable
${myData[1]}	${myData[2]}	${myData[3]}	${myData[4]}	${myData[5]}	${myData[6]}
ID	First Name	Last Name	Hire Date	Dept Code	Wages
34594	Heather	Banks	1998-01-19	BB001	72000
34593	Tina	Young	2010-04-01	BB001	65000
34590	Kathy	Harris	2007-09-30	KH001	105000
34592	Mark	Walker	2012-11-15	KH001	87500
34591	John	Davis	2001-06-15	KH001	85000

The Read Excel Task will ignore any formatting such as alignment options, size, and font family. Also, formulas are processed before they are read, so if a cell contains the formula of =SUM(A1:A10), then the value will be read as the sum of the cells A1 through A10.

Rename Saved Search

Table of Contents

User Guide

User Guide

Example 1: Read Excel Task

Example 1: Read Excel Task