cant read all items.

[mattehalen]

We have an excel file with around 1000 rows and I just say that all rows are NOT read.
It now gives me ... 400 more items.

So my question is can I read all items in the excel file?

function getData(){

    return spauth.getAuth(url, {          
        username:username,  
        password:password  
    })  
    .then(function(options){  
        // Headers  
        var headers = options.headers;  
        headers['Accept'] = 'application/json;odata=verbose';  
        // Pull the SharePoint list items  
        return requestprom.get({  
        url: url,  
            headers: headers,  
            json: true  
        }).then(function(listresponse){
            var items = listresponse.d.results; 
            console.log(items);

                }
            })
        });  
    });
}

After some more research I found that I can only read the first 500 rows.
Don't know if the limitation is here or Office API and no idea how to get around it.