>> writetable(tMismatch)
>> type tMismatch.txt
Fund,Acct,B_Student,SID,B_Paid,R_Student,R_Paid,R_Award,MatchStatus,R_Formula,Recipient
"ALEXANDER, HELEN WILLIAMS",A63032,Total,,482,Total,0,NaN,NOT MATCH,=0.00,GED graduate -
,,,,0,=$0.00,0,NaN,NOT BILLED,,
>>
succeeds and writes what is expected...but
>> writetable(tMismatch,'tmismatch.xlsx')
Error using writetable (line 124)
Unable to write to sheet 'Sheet1' in file 'tmismatch.xlsx'. Disable sheet protection,
disable workbook's Mark as Final option, and ensure input does not exceed cell capacity.
>> whos tMismatch
Name Size Bytes Class Attributes
tMismatch 2x11 5259 table
>> tMismatch
tMismatch =
2×11 table
Fund Acct B_Student SID B_Paid R_Student R_Paid R_Award MatchStatus R_Formula Recipient
___________________________ ________ _________ ___ ______ _________ ______ _______ ____________ _________ ________________
'ALEXANDER, HELEN WILLIAMS' 'A63032' 'Total' '' 482 'Total' 0 NaN 'NOT MATCH' '=0.00' 'GED graduate -'
[] [] [] [] 0 '=$0.00' 0 NaN 'NOT BILLED' [] []
>>
fails spectacularly with a string of messages I've no idea what causes...
Stepping through writetable to the bottom level call, everything looks as expected preparing to write the data but the write() itself errors out. I can't see why it shouldn't be able to do so...
R2017b, Win7/Pro
ADDENDUM
BTW,
xlswrite('tMismatch.xlsx',table2cell(tMismatch))
also fails but with just an "object failed" error number.