"Failing to load Excel data using ExcelExampleSource"

amogha_ec

Hello all,
             Am trying to load Excel data and to create Example set objec but ending up with  exception.I am confused on how to use ExcelExampleSource.Am confused on how to configure xml file and some concepts like .aml format.Both my xml file and .xls file reside in c drive Excel folder
name of xls file is AirTickets.xls which contains some 35000 entries..I am executing the following code..
                       RapidMiner.init();
try
{
Operator operator=OperatorService.createOperator(ExcelExampleSource.class);
operator.setParameter("attributes", "C:\\Excel\\excelexamplesource.xml");
OperatorDescription operatordis = operator.getOperatorDescription();
ExcelExampleSource excelexamplesource=new ExcelExampleSource(operatordis);
System.out.println("excelexamplesource="+excelexamplesource);
ExampleSet exampleSet = excelexamplesource.createExampleSet();
Iterator<Example> iterator= exampleSet.iterator();
Example example=iterator.next();

}
catch (OperatorCreationException e)
{
e.printStackTrace();
}

and my excelexamplesource.xml file looks like:

<?xml version="1.0" encoding="UTF-8"?>
<operator name="excelexamplesource" class="com.rapidminer.operator.nio.ExcelExampleSource" >
<parameter key="attributes" value="C:\Excel\Air_Tickets.xls"/>
</operator>

The Exception is:

" java.lang.NullPointerException
     java.io.FileInputStream.<init>(FileInputStream.java:103)"

Anyone please help..Explain exactly how to load Excel data..
           

Marco_Boeck

Hi,

the easiest way is probably to create the RapidMiner process, configure all parameters in RapidMiner, load the process file (xyz.rmp) via

String xml = com.rapidminer.tools.Tools.readTextFile(is);
Process process = new Process(xml);

and then execute it, and store the result:

IOContainer ioResult = process.run();
if (ioResult.getElementAt(0) instanceof ExampleSet) {
	resultSet = (ExampleSet)ioResult.getElementAt(0);
}

now you have the example set build from your excel file.

Regards,
Marco