Create a job that uses the Excel 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.