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