NumHeaderLines must be a nonnegative integer

Post Reply
matlab1
Site Admin
Posts: 4797
Joined: Thu Dec 15, 2016 9:30 am
Contact:

NumHeaderLines must be a nonnegative integer

Post by matlab1 »

NumHeaderLines must be a nonnegative integer
matlab1
Site Admin
Posts: 4797
Joined: Thu Dec 15, 2016 9:30 am
Contact:

Re: NumHeaderLines must be a nonnegative integer

Post 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
Post Reply

Who is online

Users browsing this forum: No registered users and 11 guests