Variable names are detected from the file but are replaced by the value of VariableNames. Verify that the values of Read

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

Variable names are detected from the file but are replaced by the value of VariableNames. Verify that the values of Read

Post by matlab1 »

Variable names are detected from the file but are replaced by the value of VariableNames. Verify that the values of ReadVariableNames and/or NumHeaderLines are correct
matlab1
Site Admin
Posts: 4797
Joined: Thu Dec 15, 2016 9:30 am
Contact:

Re: Variable names are detected from the file but are replaced by the value of VariableNames. Verify that the values of

Post by matlab1 »

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.



ReadVariableNames — Indicator for reading variable names
true (default) | false | 1 | 0
Indicator for reading the first row of the first file in the datastore as variable names, specified as either true (1) or false (0).

If true, then the first nonheader row of the first file determines the variable names for the data.

If false, then the first nonheader row of the first file contains the first row of data. Default variable names are assigned as Var1, Var2, and so on.

Data Types: logical | double








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 14 guests