Page 1 of 1

NumHeaderLines must be a nonnegative integer

Posted: Thu Feb 09, 2017 2:18 pm
by matlab1
NumHeaderLines must be a nonnegative integer

Re: NumHeaderLines must be a nonnegative integer

Posted: Wed Jan 20, 2021 4:51 am
by matlab1
Solution:

spreadsheetDatastore
Datastore for spreadsheet filesexpand


Description
Use a SpreadsheetDatastore object to manage large collections of spreadsheet files where the collection does not necessarily fit in memory. You can create a SpreadsheetDatastore object using the spreadsheetDatastore function, specify its properties, and then import the data using object functions.



NumHeaderLines — Number of lines to skip
0 (default) | positive integer
Number of lines to skip at the beginning of each sheet when reading, specified as a positive integer. When you also specify the Range property, NumHeaderLines is the number of lines to skip at the beginning of the specified block of data.

Data Types: double



For more information,

https://www.mathworks.com/help/matlab/ref/matlab.io.datastore.spreadsheetdatastore.html