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: 1879TRDetails_Convert2ExcelSheet( 'TR_selectedData_200_2000_25_1_1') ??? Error using ==> xlswrite at 213Excel 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
endfor i=1:1:length(names')x=st.(names{i});xlswrite(sprintf('%s.xls',arg1), x, ['PAGE' num2str(i)], ['A' num2str(i)])endendxlswrite(sprintf('%s.xls',arg1), x, ['PAGE' num2str(i)], ['A' num2str(i)]
I will remain obliged for help.
Best Answer