Page 1 of 1

Generating Stream from XLS files

Posted: Thu Jun 29, 2017 10:05 pm
by camorani
Hi, I am beginner with Odysseus.
I have read the excel file using the following code :

Code: Select all

#PARSER CQL
#RUNQUERY
CREATE STREAM xls:person (id Double, age Double)
WRAPPER 'GenericPull'
PROTOCOL 'XLS'
TRANSPORT 'File'
DATAHANDLER 'Tuple'
OPTIONS ('filename' '//transnas.engr.utk.edu/asad/Ramin/CAV/oddysseus/test.xls')
and the file is being shown in the source as System.xls:person.
But when i use this code as a query:

Code: Select all

#PARSER PQL
#RUNQUERY
out = xls:person
I get this error

'Parsing and Executing Query' has encountered a problem.

Script Execution Error: null
java.lang.NullPointerException

Even I am not sure if this is the correct way of generating streams from Excel files.

Thanks!

Re: Generating Stream from XLS files

Posted: Fri Jun 30, 2017 9:36 am
by Marco Grawunder
Hi Camorani,

welcome to Odysseus.

You did nearly everything right. You need to install the xls feature to read from this kind of sources.

I added a note to the documentation of the xls wrapper.

Greetings,

Marco