Unable to write the following arrays in Excel sheet from a mat file. >> TRDetails_Convert2ExcelSheet('TR_selectedData_200_2000_25_1_1') The error displayed is i command prompt>>??? Error using ==> xlswrite at 213

Question

Beneyaz Begum 2015-9-14

0
链接

此问题的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/242806-unable-to-write-the-following-arrays-in-excel-sheet-from-a-mat-file-trdetails_convert2excelsheet

回答： Walter Roberson 2015-9-14

             TR_new: [1506x2 double]
    data_gen_matrix: [1506x2 double]
         DTR_pair_1: [472x2 double]
           PI_var_1: [472x1 double]
         Group_AT_1: [472x472 double]
         DTR_pair_2: [342x2 double]
           PI_var_2: [342x1 double]
         Group_AT_2: [342x342 double]
         DTR_pair_3: [237x2 double]
           PI_var_3: [237x1 double]
         Group_AT_3: [237x237 double]
         DTR_pair_4: [166x2 double]
           PI_var_4: [166x1 double]
         Group_AT_4: [166x166 double]
         DTR_pair_5: [109x2 double]
           PI_var_5: [109x1 double]
         Group_AT_5: [109x109 double]
         DTR_pair_6: [63x2 double]
           PI_var_6: [63x1 double]
         Group_AT_6: [63x63 double]
         DTR_pair_7: [41x2 double]
           PI_var_7: [41x1 double]
         Group_AT_7: [41x41 double]
         DTR_pair_8: [29x2 double]
           PI_var_8: [29x1 double]
         Group_AT_8: [29x29 double]
         DTR_pair_9: [18x2 double]
           PI_var_9: [18x1 double]
         Group_AT_9: [18x18 double]
        DTR_pair_10: [11x2 double]
          PI_var_10: [11x1 double]
        Group_AT_10: [11x11 double]
        DTR_pair_11: [5x2 double]
          PI_var_11: [5x1 double]
        Group_AT_11: [5x5 double]
        DTR_pair_12: [5x2 double]
          PI_var_12: [5x1 double]
        Group_AT_12: [5x5 double]
        DTR_pair_13: [3x2 double]
          PI_var_13: [3x1 double]
        Group_AT_13: [3x3 double]
        DTR_pair_14: [2x2 double]
          PI_var_14: [2x1 double]
        Group_AT_14: [2x2 double]
        DTR_pair_15: [1599 136]
          PI_var_15: 0
        Group_AT_15: 1599
        DTR_pair_16: [1612 136]
          PI_var_16: 0
        Group_AT_16: 1612
        DTR_pair_17: [1879 136]
          PI_var_17: 0
        Group_AT_17: 1879
TRDetails_Convert2ExcelSheet( 'TR_selectedData_200_2000_25_1_1') 
??? Error using ==> xlswrite at 213
Excel returned: Error: Object returned error code: 0x800A03EC.
Error in ==> TRDetails_Convert2ExcelSheet at 13

Kindly, help me how to write the matrix. I need to analyze the different gourps with their non-zero values for comparison.

MY code:

function []= TRDetails_Convert2ExcelSheet(arg1)
st= load(sprintf('%s.mat', arg1));
names=fieldnames(st);
for i=1:1:length(names')
n=names(i);
xlswrite(sprintf('%s.xls', arg1), n,['PAGE' num2str(i)], 'A1')% different pages of an excel sheet
end
for i=1:1:length(names')
x=st.(names{i});
xlswrite(sprintf('%s.xls',arg1), x, ['PAGE' num2str(i)], ['A' num2str(i)])
end
end
xlswrite(sprintf('%s.xls',arg1), x, ['PAGE' num2str(i)], ['A' num2str(i)]

I will remain obliged for help.

0 个评论
显示 -2更早的评论隐藏 -2更早的评论

请先登录，再进行评论。

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

Answer 1

Walter Roberson 2015-9-14

0
链接

此回答的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/242806-unable-to-write-the-following-arrays-in-excel-sheet-from-a-mat-file-trdetails_convert2excelsheet#answer_192247

http://www.mathworks.com/matlabcentral/answers/101631-why-do-i-receive-an-error-error-code-0x800a03ec-when-using-xlswrite-in-matlab

But probably more relevant is http://www.mathworks.com/matlabcentral/answers/14515-xlwrite-object-returned-error-code-0x800a03ec which suggests that your may be limited to 96 columns when you use the .xls file extension. Try switching to .xlsx file extension.

You should also investigate xlswrite1() from the File Exchange