GreetingsI have a variable
A={'H$1';'H$2';'H$3'} %a 4x1 cell
% I need to generate an xlsx file with
=(YesH$1No) in cell A1=(YesH$2No) in cell A2=(YesH$2No) in cell A3
% I can xlswrite AA elements to excel wo problem
for ii=1:3AA(1,ii)=A(ii)BB{1,ii}=strcat('=(Yes',AA{ii},'No)')endxlswrite('fileA.xls', AA)xlswrite('fileB.xls', BB)
% for BB because of the equal and parenthesis it outputs an error
Error using xlswrite (line 219)Error: Object returned error code: 0x800A03EC
Best Answer