Eclipse Community Forums: Epsilon » Using EGL to instantiate an excel file

Home » Modeling » Epsilon » Using EGL to instantiate an excel file

Using EGL to instantiate an excel file [message #1865112]

Fri, 26 April 2024 09:48

Eclipse User

Hello,

I've got an EGL script that generates an XML file based on an ECore model that I've defined. However, when I run the EGL file it outputs the correct information to the console but doesn't write it to the designated target file.

For now I copy and paste it into the XML file, but then I'm not sure how to apply the XML file to my target Excel file so that it populates the header columns in the excel file to match the XML specification. Any ideas for how to remove the manual work so it can all be done through EGL or another language would be appreciated.

Re: Using EGL to instantiate an excel file [message #1865142 is a reply to message #1865112]

Fri, 26 April 2024 16:53

Eclipse User

Hi Thomas,

If you're running your EGL transformation from Eclipse, could you please check that in your run configuration you've selected the correct option in the "Template" tab ("Text generated should be printed to" -> "The following file")?

Thanks,
Dimitris

Re: Using EGL to instantiate an excel file [message #1865277 is a reply to message #1865142]

Mon, 29 April 2024 16:08

Eclipse User

Thanks Dimitris, didn't know that console was just the default.

I have a follow question though. This has allowed me to create an XML file however I still haven't been able to apply that file to my excel file. Specifically, I haven't been able to create the worksheets and populate the cells.

I am currently looking into EOL to see if there is someway of going about it. I've been diving into the org.eclipse.epsilon.emc.spreadsheets driver along with other emc packages. Any help would be appreciated.

Re: Using EGL to instantiate an excel file [message #1865301 is a reply to message #1865277]

Tue, 30 April 2024 09:47

Eclipse User

Hi Thomas,

I'm afraid that the Excel driver doesn't support initialising the worksheets and column headers of a spreadsheet from an XML configuration file.

Thanks,
Dimitris

Re: Using EGL to instantiate an excel file [message #1865355 is a reply to message #1865301]

Tue, 30 April 2024 16:57

Eclipse User

How would I do it just from EOL then? When I call some functions based on the documentation and they seem to match types they still don't actually do anything.

For example:

var col = w.addColumn(1, "newColumn");
w.header.addColumn(col);

Would assume that it should allow me to initialize a header but I just get back an empty cell.

Is there anyway to address the cells individually? Say as an array index?

Re: Using EGL to instantiate an excel file [message #1865358 is a reply to message #1865355]

Wed, 01 May 2024 01:18

Eclipse User

Hi Thomas,

Please see this thread.

Thanks,
Dimitris

Previous Topic:	Loading Excel file in Ant
Next Topic:	load xtext dsl during ant build

Goto Forum:

-=] Back to Top [=-

Current Time: Sat Oct 25 18:17:16 EDT 2025

.:: Contact :: Home ::.

Breadcrumbs

Sign up to our Newsletter