How to join/merge all sub tables into 1 table?

Hi;

i have a table (S1) and it contains 4041 tables into. Sub tables are all text. I want to merge them to a single table or cell. I don't know how to merge them..

(all tables have text data)

[Guillaume]

Do all the subtables have the same variable name S_r_mNo_1_0FarabiA__klama?

[Ergün AKGÜN]

Hi Guillauma,

No; Actually, it's not a variable name. I import these tables from excel spreedsheets and i guess i made a mistake. Matlab gets the first lines as variable name. Now we have a new problem :)

[Guillaume]

That new problem is easily fixed. But at the same time, we can fix the import so that it's the right format directly. The simplest thing would be for you to show your import code.

[Ergün AKGÜN]

Here is my code;

[~,SheetNames]  = xlsfinfo('a.xlsx')
nSheets = length(SheetNames)
for iSheet = 1:nSheets
Name = SheetNames{iSheet};
Data = readtable('a.xlsx','Sheet',Name) ;
S(iSheet).Name = Name;
S(iSheet).Data = Data;
end

Answer 1

[Guillaume]

[~,SheetNames]  = xlsfinfo('a.xlsx');
nSheets = numel(SheetNames);
SheetContents = cell(size(SheetNames));
for iSheet = 1:nSheets
    Name = SheetNames{iSheet};
    SheetContents{iSheet} = readtable('a.xlsx','Sheet',Name, 'ReadVariableNames', false);
end
SheetContents = vertcat(SheetContents{:});

[Ergün AKGÜN]

The code lists the table numbers, but not their contents.And here is the warning.

[Guillaume]

The code lists the table numbers

That bit is your own code and is the output of xlsfinfo that is displayed because you didn't end the line with a semicolon.

As for the error, that's a simple typo. I wrote sheetNames instead of SheetNames.

I've fixed both issues.