MATLAB: How to join/merge all sub tables into 1 table

MATLABPreprocessing Data

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)

Best Answer

[~,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{:});

Related Solutions

MATLAB: Excel Range in specifies Sheet.

Hi, Just activating the particular sheet before adding range will solve it.

ex = actxserver('excel.application');

ex.Workbooks.Open(fullfile(pwd,'XXXXXXX.xlsx'));

Sheets = Excel.ActiveWorkBook.Sheets;

Sheet3 = get(Sheets, 'Item', 'Sheet3');

Sheet3.Activate

ex.Range('A3').Name = 'RangeName';

ex.ActiveWorkbook.Save

ex.Quit

ex.release

MATLAB: Create loop for multiple excel sheets/documents

One approach would be to use a nested structure with the first level down having a fieldname for each of the files, and then each file will have a level down for the individual sheets, so that might go something like this:

fils=dir('C:\...\GaitAnalysisReportP*.xls');
foldername=fils(1).folder;
for c=1:length(fils)
   fullfname=fullfile(foldername,fils(c).name);
    [~,sheet_name] = xlsfinfo(fullfname);    %get the sheetnames of the current file
    for k = 1:numel(sheet_name)
        [data, vnames{k}] = xlsread('examplefile.xlsx',sheet_name{k}); % load
        s.(fils(c).name).(sheet_name{k}) = array2table(data,'VariableNames',vnames{k}); %format into a table
    end
end

I haven't tested this, let me know how it goes.

Best Answer

Related Solutions

MATLAB: Excel Range in specifies Sheet.

MATLAB: Create loop for multiple excel sheets/documents

Related Question