Configuring the Excel stage as a target

You can configure the Excel stage to modify an existing Microsoft Excel file.

1. On the canvas, double-click the Excel stage.
2. On the Input tab, select the input link from the Input name field.
3. In the Columns section, ensure that columns are properly defined.
4. On the Stage tab, from the Write mode list, select Modify existing file.
5. Specify the target file details to write the data to.
   1. In the Output file section, select Create data asset to have the job run create an asset and add it to the Assets tab automatically.
   2. In the File name field, specify the name of the file to write data to.
   3. If more than 32 columns will be updated in the Microsoft Excel sheet, specify the number of the column in the Number of columns to load field.
   4. In the Properties section, select None or First row from the Column header list.
   5. Enter a value in the field Start writing from this row.
      If you specify the first row, enter a value that is greater than or equal to 2 or enter a value that is greater than or equal to 1.
   6. Click Edit in the Map section, then click Import columns.
6. Specify the Microsoft Excel details to import in the Import page.
   1. From the Sheet list, select the Microsoft Excel sheet to update.
   2. From the list of columns, select the Microsoft Excel columns to update.
   3. Click Import.
7. Map the imported Microsoft Excel columns to the DataStage® columns that are defined in the input link. Select a column to write the data.
8. Repeat the steps for the Properties section and mapping for all the input links.
9. Click Save.