MATLAB Answers

Why writetable() adds ' 'true ' table element as ''table?

Chen David Gongwei 님이 질문을 제출함. 2 Aug 2019
최근 활동 Jeremy Hughes 님이 답변함. 2 Aug 2019
Here is how my MATLAB table transitionsTable looks like:
I added a single quote before true and false so that Excel won't interpret them as special words.
But when I do:
writetable(transitionsTable,excel_file,'Sheet',1,'Range','C1')
'true and 'false show up in Excel cells like this:
It looks fine, but those single quotes aren't suppose to show. When I double-click on one of them, it becomes:

  댓글 수: 1

Excel has strange display rules for text. These days I just assume that excel might be lying about the actual content of text cells.

로그인 to comment.

제품

답변 수: 1

Jeremy Hughes 님의 답변 2 Aug 2019

I think this is a case where using strings would make things more clear.
In MATLAB, if I create a char vector and put a single-quote in it, that looks like
c = '...''...'
If I do this with a string, I can avoid the escaping.
s = "...'..."
It may be the case that the char vectors in your data have two single-quotes, which display as one in MATLAB.
try
string(transitionsTable.transition) to see if that's what's happening

  댓글 수: 0

로그인 to comment.



Translated by