How to export a cell matrix into a MS Excel file

Question

Paul Barrette 2023-12-8

0
链接

此问题的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/2058054-how-to-export-a-cell-matrix-into-a-ms-excel-file

评论： Voss 2023-12-8

THRESH_DATA.mat

Attached is a cell array which I would like to export into a MS Excel spreasheet where each row correspond to one (of 12) years and would represent a tab inside that Excel file. Each of the 8 columns (or variables) would represent a column inside each tab.

I know this can be done with the 'xlswrite' command (see here for an example). But that command has now been superseded by the 'writecell' command, which I have problems with. Thanks!

3 个评论
显示 1更早的评论隐藏 1更早的评论

Dyuman Joshi 2023-12-8

编辑：Dyuman Joshi 2023-12-8

在 MATLAB Online 中打开

THRESH_DATA.mat

What problems did you encounter with writecell?

And which array from the following list are you trying to save? ans?

z = load("THRESH_DATA.mat")
z = struct with fields:
                  DATA_ISI: {12×1 cell}
                      DATE: [23060×1 datetime]
                DATES_ECCC: [12×4 double]
                  DATE_ISI: [2868×1 datetime]
           DATE_RANGE_ECCC: [23×4 double]
            DATE_RANGE_ISI: [12×4 double]
                       DAY: [23060×1 double]
                D_YEAR_ISI: {12×1 cell}
                 ECCC_File: [23060×36 table]
                  FDD_Fall: [12×1 double]
                FIRST_1_CB: [12×2 double]
                  ISI_File: [2868×24 table]
                ISI_NUMBER: [2868×1 double]
      ISIdata_CBeauharnois: 1
    ISIdata_LakeStLawrence: 0
                    MAX_TP: [23060×1 double]
                   MEAN_TP: [23060×1 double]
                    MIN_TP: [23060×1 double]
                     MONTH: [23060×1 double]
                 STARTYEAR: [2000 2001 2002 2003 2004 2005 2006 2007 2008 2009 2010 2011]
               THRESH_DATA: {12×8 cell}
                      YEAR: [23060×1 double]
                         a: [1×1 TiledChartLayout]
                       ans: {[110×1 datetime]  [110×1 double]  [110×1 double]  [110×1 double]  [110×1 double]  [110×1 double]  [110×1 double]  [110×1 double]}
              aver_CB_0to1: 51.5056
              aver_CB_1to2: 96.9560
               aver_CB_to0: 27.3914
             aver_LSL_0to1: 80.5893
             aver_LSL_1to2: 104.3250
              aver_LSL_to0: 32.7929
                        ax: [1×1 Axes]
                   bstfit2: [3.8500 -7.2983e+04]
                  coeff_CB: [1.6133 -3.0864e+03]
                 coeff_LSL: [3.1997 -6.1568e+03]
                    dumISI: [12×1 double]
                   end_day: 20-Mar-2012
               end_day_ini: 20
               end_day_isi: 20-Mar-2012
                 end_month: 3
                  firstISI: [12×1 double]
                  idx_year: 12
                      init: 0
                         k: 10
                         m: 62
                         n: 12
           no_days_AirTemp: 10
                     p_ISI: [1×1 struct]
               p_ISI_model: [1×12 Line]
                 p_ISI_obs: [1×12 Line]
                    sl_bst: 5
                     slope: 1.6133
             slope_CB_0to1: -0.7768
             slope_CB_1to2: -0.6994
              slope_CB_to0: 0.9104
            slope_LSL_0to1: -1.2459
            slope_LSL_1to2: 1.1121
             slope_LSL_to0: 0.4805
                 start_day: 01-Dec-2011
             start_day_ISI: 1
             start_day_isi: 01-Dec-2011
           start_month_ISI: 12
                start_year: 2000
            temperature_DD: 0
              temporary_DD: 18
                   thresh1: 10
                   thresh2: 20
               y_intercept: -3.0864e+03
                 yearcount: 12

Paul Barrette 2023-12-8

Thanks, @Dyuman Joshi. I had NO idea THRESH_DATA.mat contained so many variables! (I thought it was only 'THRESH_DATA', which is what I'm interested in). As for the problems in using 'writecell', it was mostly about sorting out the differences between [ vs { vs ( in the script. The Documentation is written for programming-savvy folks.

请先登录，再进行评论。

请先登录，再回答此问题。

Answer 1

Voss 2023-12-8

1
链接

此回答的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/2058054-how-to-export-a-cell-matrix-into-a-ms-excel-file#answer_1368034

在 MATLAB Online 中打开

filename = 'test_THRESH_DATA.xlsx';
N = size(THRESH_DATA,1);
for ii = 1:N
    T = table(THRESH_DATA{ii,:});
    writetable(T,filename,'Sheet',ii,'WriteVariableNames',false);
end

3 个评论
显示 1更早的评论隐藏 1更早的评论

Voss 2023-12-8

在 MATLAB Online 中打开

THRESH_DATA.mat

I assumed the variable you want to write is THRESH_DATA.

S = load('THRESH_DATA.mat','THRESH_DATA');
THRESH_DATA = S.THRESH_DATA
THRESH_DATA = 12×8 cell array
    {110×1 datetime}    {110×1 double}    {110×1 double}    {110×1 double}    {110×1 double}    {110×1 double}    {110×1 double}    {110×1 double}
    {110×1 datetime}    {110×1 double}    {110×1 double}    {110×1 double}    {110×1 double}    {110×1 double}    {110×1 double}    {110×1 double}
    {110×1 datetime}    {110×1 double}    {110×1 double}    {110×1 double}    {110×1 double}    {110×1 double}    {110×1 double}    {110×1 double}
    {111×1 datetime}    {111×1 double}    {111×1 double}    {111×1 double}    {111×1 double}    {111×1 double}    {111×1 double}    {111×1 double}
    {110×1 datetime}    {110×1 double}    {110×1 double}    {110×1 double}    {110×1 double}    {110×1 double}    {110×1 double}    {110×1 double}
    {110×1 datetime}    {110×1 double}    {110×1 double}    {110×1 double}    {110×1 double}    {110×1 double}    {110×1 double}    {110×1 double}
    {110×1 datetime}    {110×1 double}    {110×1 double}    {110×1 double}    {110×1 double}    {110×1 double}    {110×1 double}    {110×1 double}
    {110×1 datetime}    {110×1 double}    {110×1 double}    {110×1 double}    {110×1 double}    {110×1 double}    {110×1 double}    {110×1 double}
    {110×1 datetime}    {110×1 double}    {110×1 double}    {110×1 double}    {110×1 double}    {110×1 double}    {110×1 double}    {110×1 double}
    {110×1 datetime}    {110×1 double}    {110×1 double}    {110×1 double}    {110×1 double}    {110×1 double}    {110×1 double}    {110×1 double}
    { 92×1 datetime}    { 92×1 double}    { 92×1 double}    { 92×1 double}    { 92×1 double}    { 92×1 double}    { 92×1 double}    { 92×1 double}
    {106×1 datetime}    {106×1 double}    {106×1 double}    {106×1 double}    {106×1 double}    {106×1 double}    {106×1 double}    {106×1 double}
% write the file:
filename = 'test_THRESH_DATA.xlsx';
N = size(THRESH_DATA,1);
for ii = 1:N
    T = table(THRESH_DATA{ii,:});
    writetable(T,filename,'Sheet',ii,'WriteVariableNames',false);
end
Warning: Added specified worksheet.
Warning: Added specified worksheet.
Warning: Added specified worksheet.
Warning: Added specified worksheet.
Warning: Added specified worksheet.
Warning: Added specified worksheet.
Warning: Added specified worksheet.
Warning: Added specified worksheet.
Warning: Added specified worksheet.
Warning: Added specified worksheet.
Warning: Added specified worksheet.
% to verify, read the first couple of sheets from the file:
T = {readtable(filename,'Sheet',1),readtable(filename,'Sheet',2)}
T = 1×2 cell array
    {110×8 table}    {110×8 table}
T{:}
ans = 110×8 table
       Var1        Var2     Var3     Var4     Var5    Var6    Var7     Var8
    ___________    _____    _____    _____    ____    ____    _____    ____

    01-Dec-2000     -2.3    -1.24     25.5    23.2    10.8     0.39     0  
    02-Dec-2000     -6.8    -1.44     32.3    25.2    10.8    -1.21     0  
    03-Dec-2000     -5.5    -1.59     37.8    26.7    10.8    -2.67     0  
    04-Dec-2000      0.3    -1.29     37.8    23.7    10.8    -2.64     0  
    05-Dec-2000      0.5    -0.48     37.8    15.9    11.1    -0.46     0  
    06-Dec-2000     -9.5    -0.33     47.3    14.9    11.6     1.27     0  
    07-Dec-2000      -10    -1.25     57.3    24.1    11.6     0.06     0  
    08-Dec-2000    -17.5     -2.5     74.8    34.1     9.1    -1.88     0  
    09-Dec-2000      -13     -4.6     87.8    51.6     5.6    -4.61     0  
    10-Dec-2000     -6.3    -6.28     94.1    64.6     1.8     -3.5     0  
    11-Dec-2000     -1.3    -7.01     95.4    70.9     0.8     0.34     0  
    12-Dec-2000     -7.8    -6.91    103.2    69.9     0.8     2.86     0  
    13-Dec-2000    -14.5    -7.01    117.7    70.9     0.8     3.11     0  
    14-Dec-2000      -10    -7.91    127.7    79.9     0.8    -0.45     0  
    15-Dec-2000       -7    -8.94    134.7    89.9     0.5    -2.06     0  
    16-Dec-2000        0    -9.69    134.7    96.9       0    -1.36     0  
ans = 110×8 table
       Var1        Var2    Var3    Var4    Var5    Var6    Var7     Var8
    ___________    ____    ____    ____    ____    ____    _____    ____

    01-Dec-2001       7    5.76       1      1     58.6    -1.35     0  
    02-Dec-2001     7.3    6.11       1      1     62.1     1.35     0  
    03-Dec-2001     5.5    6.14       1      1     62.4     2.16     0  
    04-Dec-2001       7    6.16       1      1     62.6     1.53     0  
    05-Dec-2001    12.5    5.93       1      1     60.3     0.25     0  
    06-Dec-2001      12    5.63       1      1     57.3     1.07     0  
    07-Dec-2001     4.5    5.83       1      1     59.3     1.64     0  
    08-Dec-2001    -2.5    6.03     3.5      1     61.3      0.3     0  
    09-Dec-2001       0    5.73     3.5    3.5     60.8     -2.7     0  
    10-Dec-2001     2.8    5.83     3.5    2.5     60.8    -3.95     0  
    11-Dec-2001       4    5.61     3.5    2.5     58.6    -2.29     0  
    12-Dec-2001     1.3    5.31     3.5    2.5     55.6     0.43     0  
    13-Dec-2001     6.5    4.71     3.5    2.5     49.6     1.16     0  
    14-Dec-2001       3    4.81     3.5    2.5     50.6     1.15     0  
    15-Dec-2001    -3.3    4.41     6.8    2.5     46.6     0.29     0  
    16-Dec-2001    -6.3    2.83    13.1    5.8     34.1    -1.29     0  