× Heads up!

Aqua Data Studio / nhilam

Follow
IDE for Relational Databases
×
NielsGron reported 2011-12-05T23:34:28Z  · last modified 2011-12-06T02:02:56Z

AQExcelReader.setFirstLineContainsColumnNames(true) causes null pointer exception


Priority Low
Complexity Unknown
Component Open API - IO
Version 10.0

=============


var yd = getExcelReader("test-ndg.xlsx");
var row;
aqua.console.println(yd.columnStructure.columnNames);
while((row = yd.readNextRow()) != null) {
    aqua.console.println(row.get(0));
}
yd.close();


function getExcelReader(path) {
    var yd = aqua.io.newExcelReader();
    yd.setFirstLineContainsColumnNames(true);
    yd.setFile(path);
    var row = yd.readNextRow();
    var icol = [];
    var i = 0;
    for(i = 0; i<row.size;i++) {
        icol[i] = row.getString(i);
    }
    yd.close();
    yd = aqua.io.newExcelReader();
    yd.setFirstLineContainsColumnNames(false);
    yd.setColumnNames(icol);
    yd.setFile(path);
    yd.readNextRow();
    return yd;
}

============

Error on line 15: Wrapped java.lang.NullPointerException (#15)

2 attachments

Issue #6198

Closed
Fixed
Resolved 2011-12-06T00:00:26Z
 
 
Completion
No due date
Fixed Build 10.0.3_07
No time estimate

About AquaClusters Privacy Policy Support Version - 19.0.2-4 AquaFold, Inc Copyright © 2007-2017