MATLAB: How to transfer a 3D variable into a row in an excel file

3d structure fileimporting excel dataMATLAB

Hello all,

As shown in the attached document, I have "data"(EEG data) in the form of "numberOf_Electorrdes * numberOf_Points * rial" single variable.

How Can I write it in an excel file in one row (each row is one subject) and with as many columns as the number of electordes? I tired writetable(struct2table(EEG.data), 'data.xlsx' but I got this error "Input structure must be a scalar structure.

I have also the "lable of each electrode" and I need each number to go under the right channel.

EEGData= EEG.data;

ch_lables=EEG.chanlocs.labels; % I uesed this and only the first lable is shown?

I appreciate your help in advance.

Zahra

Best Answer

In general, you can make a row vector out of your 3-D variable like this:

rowVector = array3d(:)';
% Now write to Excel
xlswrite(filename, rowVector, sheetName, 'A1');

array3d(:) turns it into a column vector, and then the apostrophe transposes it into a row vector.

Related Solutions

MATLAB: How to read only specific columns in from an Excel file, not consecutive columns

I enclose a first version of a function I just wrote. This will read a number of columns from a large Excel file. Since it opens the Excel file only once, it is significantly faster than repeated calls to xlsread, reading one column at a time.

No error checks so far. A crash may leave an Excel process running. End it using the Windows tast manager

 function data = read_excel_columns(filename,sheet,columns,firstrow,lastrow)
% Read selected columns from large Excel sheet using ActiveXServer
%  filename:  Seems that you have to use the full path to the Excel file
%  sheet   :  e.g. 'Sheet1'
%  columns :  array of column mumbers, e.g [17,341,784]
%  firstrow, lastrow:  The first and last rows to be read 
%  data:   : array of numerical values
%
% Are Mjaavatten, 2016-03-14
    nrows = lastrow-firstrow+1;
    ncols = length(columns);
    data = zeros(nrows,ncols);
    first = num2str(firstrow);
    last = num2str(lastrow);
    hExcel = actxserver('Excel.Application');
    hWorkbook = hExcel.Workbooks.Open(filename);
    hWorksheet = hWorkbook.Sheets.Item(sheet);
    for i = 1:ncols
        col = col2str(columns(i));
        Range = [col,first,':',col,last];
        RangeObj = hWorksheet.Range(Range);
        data(:,i) = cell2mat(RangeObj.value);
    end
    release(hWorksheet)
    release(hWorkbook)
    release(hExcel)
end
 function colname = col2str(n)
% Translate Excel column number to Column characters 
    s = '';
    while n > 0
        s = [s,char(mod(n-1,26)+65)];
        n = floor((n-1)/26);
    end
    colname = deblank(fliplr(s));
end

MATLAB: Coupling of coorresponding sheets of excel files

There are two ways of doing this. You can either use xlsread and load each set of data into matlab one sheet at a time, or you can use actX and do much the same thing. Personally, because you have so many sheets and files, I would suggest using actX because it doesn't require you to open an close excel 500 times.

Examples of both methods:

files = dir('*.xlsx'); % Get list of files; this does assume you are working directly in the directory which contains them
%% xlsread method
for i = 3:length(files)
    for j = 1:50
        data(:,:,j,i) = xlsread(files(i).name,j);
    end
end
%% actx method
xl = actxserver('Excel.Application');                                   % Start Excel
% set(xl,'Visible',1);                                                  % Make excel visible
xlsdir = pwd;                                                           % Work in current directory
for i = 3:length(files)
    xls = xl.Workbooks.Open(files(i).name);                             % Open specific document; may need to use full file path
    xlss = xls.Worksheets;
    for j = 1:50
        xlssl = xlss.get('Item',j);
        colEnd = xlssl.Range('A1').End('xlToRight').Column;
        rowEnd = xlssl.Range('A1').End('xlDown').Row;
        range = ['A1:',char('A'-1+rem),char('A'-1+rem2),num2str(rowEnd)];
        Range = get(eSheet1,'Range',range);
        data(:,:,j,i) = Range.Value;
    end
end
%% Reorganizing things for one sheet
for j = 1:50
    out = [data(:,:,j,:)];
    % Preferred print to file method, xlswrite, or actx
    xlswrite('myoutfile.xlsx',out,j);
    % or
    xls = xl.WorkBooks.Open('myoutfile.xlsx'); % Should move this outside the loop, no need to repeat
    xlssl = xls.Worksheets.get('Item',j);
    range = 'A1:XX100'; % You will need to find your own range
    Range = get(xlssl,'Range',range);
    Range.Value = out;
end

That should give you a sterting point from whichever method you prefer. Note that I assumed all of your data was the same size. If not, you will need to adjust your matlab data storage variable (I called it data) to be able to accomodate the different sizes.

Best Answer

Related Solutions

MATLAB: How to read only specific columns in from an Excel file, not consecutive columns

MATLAB: Coupling of coorresponding sheets of excel files

Related Question