MATLAB: How to also read the first row correctly with ‘readtable’

MATLABtablexlsread

Hello,

I am trying to import an Excel table to Matlab. I used the following command:

T = readtable('Stoomtabellen Excel.xlsx','ReadRownames',true);

In which 'Stoomtabellen Excel.xlsx' is the Excel file. The first row of the table is the variable 'p' (for pressure). You can see this in the attached image. But when it's converted (see other image), the first row shows up correctly, only the variable 'p' is missing. I used 'Readrownames', true, so why doesn't it read the first row correctly 'p'. My question is: how can I make the row 'p' separate from the first row (the 1,2,3, etc. row). I also tried using 'xlsread' and put the 'p' row in a separate row but it didn't include the row names. Thanks in advance.

Best Answer

You seem to be confusing rows and columns. 'ReadRowNames', true means use the values in the 1st column to name the rows. In your case, it should be:

T = readtable('Stoomtabellen Excel.xlsx','ReadVariableNames',true);

or simply

T = readtable('Stoomtabellen Excel.xlsx');

since 'ReadVariableNames' is true by default.

Related Solutions

MATLAB: Can I import this CSV file into Matlab

Looks like Excel. Try xlsread

MATLAB: How to locate some specific files

Hi,

you can use the compose function to create a string array with the file names in different folders like your example:

folder_pattern = 'C:\DATA_DIR\TEST_1\2018_11_26.0001\Excel.xlsx';
A= 1:100;
newText = compose("%04d",A);
folder_new = string(zeros(100,1));
for k = 1:numel(A)
folder_new(k) = replaceBetween(folder_pattern,'C:\DATA_DIR\TEST_1\2018_11_26.','\Excel.xlsx',newText(k))
end

As result you get a string array like this:

folder_new = 
  100×1 string array
    "C:\DATA_DIR\TEST_1\2018_11_26.0001\Excel.xlsx"
    "C:\DATA_DIR\TEST_1\2018_11_26.0002\Excel.xlsx"
    "C:\DATA_DIR\TEST_1\2018_11_26.0003\Excel.xlsx"
    "C:\DATA_DIR\TEST_1\2018_11_26.0004\Excel.xlsx"
    "C:\DATA_DIR\TEST_1\2018_11_26.0005\Excel.xlsx"
    "C:\DATA_DIR\TEST_1\2018_11_26.0006\Excel.xlsx"
    "C:\DATA_DIR\TEST_1\2018_11_26.0007\Excel.xlsx"
    "C:\DATA_DIR\TEST_1\2018_11_26.0008\Excel.xlsx"
    "C:\DATA_DIR\TEST_1\2018_11_26.0009\Excel.xlsx"
    .
    .
    .
    "C:\DATA_DIR\TEST_1\2018_11_26.0096\Excel.xlsx"
    "C:\DATA_DIR\TEST_1\2018_11_26.0097\Excel.xlsx"
    "C:\DATA_DIR\TEST_1\2018_11_26.0098\Excel.xlsx"
    "C:\DATA_DIR\TEST_1\2018_11_26.0099\Excel.xlsx"
    "C:\DATA_DIR\TEST_1\2018_11_26.0100\Excel.xlsx"

If you include your operations on the single files into the for loop, you can process all operations in one step.

Best rregards

Stephan

Best Answer

Related Solutions

MATLAB: Can I import this CSV file into Matlab

MATLAB: How to locate some specific files

Related Question