Skip to main content


Eclipse Community Forums
Forum Search:

Search      Help    Register    Login    Home
Home » Eclipse Projects » RCP Testing Tool » Excel import and export example
Excel import and export example [message #1760298] Tue, 25 April 2017 15:20 Go to next message
Arek J. is currently offline Arek J.Friend
Messages: 2
Registered: April 2017
Junior Member
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 04:48 Go to previous messageGo to next message
Viktoria Dlugopolskaya is currently offline Viktoria DlugopolskayaFriend
Messages: 124
Registered: March 2017
Senior Member
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 08:14 Go to previous messageGo to next message
Arek J. is currently offline Arek J.Friend
Messages: 2
Registered: April 2017
Junior Member
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 12:48 Go to previous messageGo to next message
Radman sheikh is currently offline Radman sheikhFriend
Messages: 2
Registered: May 2017
Junior Member
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 09:21 Go to previous messageGo to next message
Viktoria Dlugopolskaya is currently offline Viktoria DlugopolskayaFriend
Messages: 124
Registered: March 2017
Senior Member
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 07:53 Go to previous messageGo to next message
Thomas Sandu is currently offline Thomas SanduFriend
Messages: 2
Registered: October 2018
Junior Member
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 0 times)
  • Attachment: console.log
    (Size: 432.72KB, Downloaded 0 times)
  • Attachment: .2.log
    (Size: 73.55KB, Downloaded 0 times)
  • Attachment: .log
    (Size: 20.78KB, Downloaded 0 times)
Re: Excel import and export example [message #1796264 is a reply to message #1760298] Tue, 09 October 2018 11:56 Go to previous message
Thomas Sandu is currently offline Thomas SanduFriend
Messages: 2
Registered: October 2018
Junior Member
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:
  


Current Time: Fri Oct 19 05:07:42 GMT 2018

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

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

Back to the top