Eclipse Community Forums: Epsilon » Create spreadsheet as a model using ETL

Help

Home

Home » Modeling » Epsilon » Create spreadsheet as a model using ETL

Show: Today's Messages :: Show Polls :: Message Navigator

Create spreadsheet as a model using ETL [message #1794646]

Tue, 04 September 2018 13:13

Bas Har

Messages: 18
Registered: May 2017

Junior Member

Is it possible to create an excel spreadsheet as a model and populate it with data using ETL?
I was successful to create an excel sheet and populate it using EGL, but I need the ETL model handling of the generated sheet.

And as a convince, an xslx file rather than an xml.

Thank you.

Report message to a moderator

Re: Create spreadsheet as a model using ETL [message #1794649 is a reply to message #1794646]

Tue, 04 September 2018 13:24

Dimitris Kolovos

Messages: 2163
Registered: July 2009
Location: York, UK

Senior Member

Hi Bas,

If an empty spreadsheet with the appropriate column headers is already in place you can use the Excel driver to populate it through an ETL transformation.

Cheers,
Dimitris

Report message to a moderator

Re: Create spreadsheet as a model using ETL [message #1794665 is a reply to message #1794649]

Tue, 04 September 2018 16:51

Bas Har

Messages: 18
Registered: May 2017

Junior Member

Hi Dimitris,

I appreciate the prompt replay.
Based on this, can the style of the cells be manipulated like merge down while filling it? if so, is their exist an example for such?
Also, is their a reference for the Sheet types that I can transform to? Like Sheet!Cell?

Thank you.

Regards,
Bas

[Updated on: Wed, 05 September 2018 04:18]

Report message to a moderator