Example: Writing data to existing Microsoft Excel files

Create a job that uses the Unstructured Data stage to write data to existing Microsoft Excel files.

About this task

This example uses a text file, Employee.txt as source data. The source file contains information of employees in CSV format. You write this information to Microsoft Excel file ExcelModifySample1.xlsx. ExcelModifySample1.xlsx has a sheet named Employee that contains, EMP NO, FIRST NAME, MIDINIT, LAST NAME, HIRE DATE, JOB, SEX, SALARY, BONUS, and TOTAL PAYcolumns. In this job, you write to these columns except TOTAL PAY. TOTAL PAY column has a formula to calculate salary and bonus.

You can build sample jobs that write data to an existing Microsoft Excel files.

To get the files for the examples, extract the IS_install\Clients\Samples\Connectors\UnstructuredData_Samples.zip file.

Parent topic: Writing data to existing Microsoft Excel files