Generate Excel file (Template)

One Star

Generate Excel file (Template)

Hi,
We get data in excel files. I want to generate an excel template and define columns and its schema.
How can i do that.
e.g
i want excel with coloumn names and datatypes as follows,
1.Col1(String)
2.Col2(Date)
3.Col3(Integer)
4.Col4(String) ... etc.
Thanks,
Pankaj
One Star

Re: Generate Excel file (Template)

Pankaj,
an Excel schema can be defined in two ways:
* In the meta data repository: "Metadata" -> right-click on "File Excel" to create new schema
You may drag & drop the created schema into a job to create Excel job steps based on that created schema
or
* When creating and Excel job step directly, e.g. "tFileInputExcel" you may specifiy the schema with pushing the small "save" diskette symbol, right of the "property type" field. "Property type" set to "built in" means, that the data schema is created for this component instance only. Set to "repository" means, that a repository schema, created as described above, is used

For more sophisticated Excel handling I recommend using the Excel components, that Jan Lolling offers for free on the Talend Exchange. 
They allow to e.g. conveniently
- Reading Excel templates, filling them with data and writing them to a new file
- Mapping data by column title rather than position of the column
Markus
One Star

Re: Generate Excel file (Template)

Hi Markus,
Thank you for your response .
I will give your suggestions a try.
Best regards,
Pankaj