Skip to main content


Eclipse Community Forums
Forum Search:

Search      Help    Register    Login    Home
Home » Modeling » Epsilon » Create spreadsheet as a model using ETL
Create spreadsheet as a model using ETL [message #1794646] Tue, 04 September 2018 13:13 Go to next message
Bas Har is currently offline Bas HarFriend
Messages: 12
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.
Re: Create spreadsheet as a model using ETL [message #1794649 is a reply to message #1794646] Tue, 04 September 2018 13:24 Go to previous messageGo to next message
Dimitris Kolovos is currently offline Dimitris KolovosFriend
Messages: 1612
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
Re: Create spreadsheet as a model using ETL [message #1794665 is a reply to message #1794649] Tue, 04 September 2018 16:51 Go to previous messageGo to next message
Bas Har is currently offline Bas HarFriend
Messages: 12
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

Re: Create spreadsheet as a model using ETL [message #1794698 is a reply to message #1794665] Wed, 05 September 2018 05:18 Go to previous messageGo to next message
Dimitris Kolovos is currently offline Dimitris KolovosFriend
Messages: 1612
Registered: July 2009
Location: York, UK
Senior Member

Hi Bas,

Please see [1] for a discussion on the abstractions provided by the Excel driver.

Cheers,
Dimitris

[1] https://www-users.cs.york.ac.uk/~dkolovos/research/publications/pdf/models13-spreadsheets.pdf
Re: Create spreadsheet as a model using ETL [message #1794738 is a reply to message #1794698] Wed, 05 September 2018 19:01 Go to previous message
Bas Har is currently offline Bas HarFriend
Messages: 12
Registered: May 2017
Junior Member
Hi Dimitris,

I will go through it and let you know if I have questions.

Thank you.

Regards,
Previous Topic:Cannot find Java class from standalone EOL plugin
Next Topic:ETL Performance with Simulink
Goto Forum:
  


Current Time: Sat Nov 17 03:26:22 GMT 2018

Powered by FUDForum. Page generated in 0.02731 seconds
.:: Contact :: Home ::.

Powered by: FUDforum 3.0.2.
Copyright ©2001-2010 FUDforum Bulletin Board Software

Back to the top