Writing data to existing Microsoft Excel files

You can use the Unstructured Data stage in jobs that write data to an existing Microsoft Excel file. You can also copy a Microsoft Excel file and write data to the copy.

When the Unstructured Data stage writes data to an existing Microsoft Excel file, the stage writes only the cell data. If a Microsoft Excel cell that the stage writes to has any format, then the stage keeps the existing format. If the Microsoft Excel file has a formula or a graph that refers to cells that are written to by the Unstructured Data stage, then the formula or the graph is recalculated when it is opened by Microsoft Excel.

You can write to Microsoft Excel columns from any InfoSphere DataStage columns. The names and order of InfoSphere DataStage columns and Microsoft Excel columns do not have to match. If the Microsoft Excel sheet has a header in the first row, you can configure the Unstructured Data stage so that values in the first row are used to determine the column that records are written to. You can write up to 1,048,576 rows of a Microsoft Excel sheet. The source InfoSphere DataStage columns must be defined in the design time.