Hello!
I am collecting data from a range of cells from an .xlsx file using the readmatrix function as so:
Datafiles(j).data = readmatrix(Data,’Sheet’,’Report’,’Range’,’M18:N18′,’FileType’,’spreadsheet’);

Then I populate that data into a new excel file like so:

CurrentData = {Datafiles.data}’;
TABLE_Pass = table(CurrentData);
TABLE = vertcat(TABLE_Pass);

Now, my problem is, it spits out the data in 2 columns labeled "CurrentData_1" "CurrentData_2" and I want to specify the name of the second column.
When I create a second variable name, it gives me 4 columns with the information doubled.
Any tips on how to give the data 2 separate variable names?Hello!
I am collecting data from a range of cells from an .xlsx file using the readmatrix function as so:
Datafiles(j).data = readmatrix(Data,’Sheet’,’Report’,’Range’,’M18:N18′,’FileType’,’spreadsheet’);

Then I populate that data into a new excel file like so:

CurrentData = {Datafiles.data}’;
TABLE_Pass = table(CurrentData);
TABLE = vertcat(TABLE_Pass);

Now, my problem is, it spits out the data in 2 columns labeled "CurrentData_1" "CurrentData_2" and I want to specify the name of the second column.
When I create a second variable name, it gives me 4 columns with the information doubled.
Any tips on how to give the data 2 separate variable names? Hello!
I am collecting data from a range of cells from an .xlsx file using the readmatrix function as so:
Datafiles(j).data = readmatrix(Data,’Sheet’,’Report’,’Range’,’M18:N18′,’FileType’,’spreadsheet’);

Then I populate that data into a new excel file like so:

CurrentData = {Datafiles.data}’;
TABLE_Pass = table(CurrentData);
TABLE = vertcat(TABLE_Pass);

Now, my problem is, it spits out the data in 2 columns labeled "CurrentData_1" "CurrentData_2" and I want to specify the name of the second column.
When I create a second variable name, it gives me 4 columns with the information doubled.
Any tips on how to give the data 2 separate variable names? importing excel data MATLAB Answers — New Questions

​