Eclipse Community Forums: RCP Testing Tool » Excel import and export example

Home » Eclipse Projects » RCP Testing Tool » Excel import and export example

Excel import and export example [message #1760298]

Tue, 25 April 2017 11:20

Eclipse User

Hello,
I try to use Excel import and export example with ECL command, described here:
https://www.eclipse.org/rcptt/documentation/userguide/ecl/excel-import-export/
but I have error message when I run test script:
"Scriptlet ListAsTableData not found"

I have similar error (missing scriplet) for write-excel-file and read-excel-file ECL commands.

Do you know what is wrong?
How to fix it?

Regrads,
Arek

Re: Excel import and export example [message #1760336 is a reply to message #1760298]

Wed, 26 April 2017 00:48

Eclipse User

Hi Arek,

Excel support was added in RCPTT 2.2.0. It is available as nightly build here: https://www.eclipse.org/rcptt/download/
Maybe you are using RCPTT 2.1.0 version or older? Try to download the latest nightly build, then re-add an AUT and execute the test.

Re: Excel import and export example [message #1760346 is a reply to message #1760336]

Wed, 26 April 2017 04:14

Eclipse User

Hi,
thank you for answer.

I downloaded and installed RCPTT 2.2.0 version. Problem with scriplet ListAsTableData disappears.

But, I still have problem with write-excel-file command:
"Scriptlet WriteExcelFile not found".

Do you know how to resolve it?

Regards,
Arek

Re: Excel import and export example [message #1761165 is a reply to message #1760346]

Mon, 08 May 2017 08:48

Eclipse User

Hi ,

I have also followed the same documentation for importing and exporting an excel file using ecl commands

https://www.eclipse.org/rcptt/documentation/userguide/ecl/excel-import-export/

I am currently importing the excel file and it is giving me the same error

Scriptlet ReadExcelFile not found
at read-excel-file (/GUIEditorTesting/ExportFile.test:8)

Can anyone know how to resolve it . Is it the problem of the path of the work-space or a tool limitation

Re: Excel import and export example [message #1763743 is a reply to message #1761165]

Fri, 19 May 2017 05:21

Eclipse User

Hi Arek and Radman,

Could you attach a full log from AUT workspace?

Thanks.

Re: Excel import and export example [message #1796249 is a reply to message #1763743]

Tue, 09 October 2018 03:53

Eclipse User

Hi Viktoria,

did you find out what the issue was there? I am using rcptt 2.3.0 and I get the same error regarding the "Scriptlet WriteExcelFile not found at write-excel-file". And I am using the example from https://www.eclipse.org/rcptt/documentation/userguide/ecl/excel-import-export/ to write the device.xslx

The write-csv-file command works without problems.

I attached the console and .log files of the two AUTs I tested this on.

Thanks,
Thomas

Attachment: console_2.log
(Size: 7.49MB, Downloaded 138 times)
Attachment: console.log
(Size: 432.72KB, Downloaded 156 times)
Attachment: .2.log
(Size: 73.55KB, Downloaded 145 times)
Attachment: .log
(Size: 20.78KB, Downloaded 126 times)

Re: Excel import and export example [message #1796264 is a reply to message #1760298]

Tue, 09 October 2018 07:56

Eclipse User

Please ignore my previous question regarding the write excel. I found out what the issue was, my AUT had no apache.poi bundle imported. So the functionality for reading/writing to Excel files could not be loaded:

Here the log from the aut console:

!MESSAGE Bundle org.eclipse.rcptt.ecl.data.apache.poi.impl_2.3.0.201706220835 [21] was not resolved.
!SUBENTRY 2 org.eclipse.rcptt.ecl.data.apache.poi.impl 2 0 2018-10-09 13:17:37.605
!MESSAGE Missing required bundle org.eclipse.rcptt.ecl.data.apache.poi.impl_0.0.0.
!SUBENTRY 2 org.eclipse.rcptt.ecl.data.apache.poi.impl 2 0 2018-10-09 13:17:37.606
!MESSAGE Missing required bundle org.apache.poi_3.9.0.
!SUBENTRY 2 org.eclipse.rcptt.ecl.data.apache.poi.impl 2 0 2018-10-09 13:17:37.606
!MESSAGE Missing required bundle org.apache.poi.ooxml_3.9.0.

Previous Topic:	Memory leak ?
Next Topic:	RCPTT with e4Application

Goto Forum:

-=] Back to Top [=-

Current Time: Fri Mar 21 07:50:57 EDT 2025

.:: Contact :: Home ::.

Breadcrumbs

Sign up to our Newsletter