SelectedVariableNames must be a unique subset of VariableNames

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

SelectedVariableNames must be a unique subset of VariableNames

Post by matlab1 »

SelectedVariableNames must be a unique subset of VariableNames
matlab1
Site Admin
Posts: 4797
Joined: Thu Dec 15, 2016 9:30 am
Contact:

Re: SelectedVariableNames must be a unique subset of VariableNames

Post by matlab1 »

Solution:

SpreadsheetDatastore properties describe the format of the files in a datastore object, and control how the data is read from the datastore. Except for the Files property, you can specify the value of SpreadsheetDatastore properties using name-value pair arguments when you create the datastore object. To view or modify a property after creating the object, use the dot notation:

ds = spreadsheetDatastore('airlinesmall_subset.xlsx');
ds.Sheets = [1 2];
ds.Range = 'A1:C6';


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