Inaccurate results when writing xls through writetable

Question

Yazan 2022-5-21

0
链接

此问题的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/1724335-inaccurate-results-when-writing-xls-through-writetable

评论： Yazan 2022-5-21

Hello everyone.

I am using Matlab R2021b. I write then save .xls files from a table using writetable. After saving, I write again on the same file but without deleting the older version first. If I do so, I get strange results in some cases, e.g., the last cell gets duplicated, some characters are added to some cells. If I delete the older version before saving the new one, I have no issues. Is this a known issue?

2 个评论
显示无隐藏无

Image Analyst 2022-5-21

I've never noticed that. You're writing the very same array both times, right? Not a smaller one the second time, which would leave the existing cells that don't get written over? You're specifying the upper left cell the same both times, right, like 'A1'? Can you attach your data in a .mat file and attach the code that demonstrates what you think is the problem? Can you download the latest version (R2022a) and try it there also?

Yazan 2022-5-21

You guessed it. I was not setting "WriteMode" to "overwritesheet". Thank you.

请先登录，再进行评论。

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

Answer 1

Voss 2022-5-21

0
链接

此回答的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/1724335-inaccurate-results-when-writing-xls-through-writetable#answer_968830

From the documentation for writetable:

If filename is the name of an existing spreadsheet file, then the writing function writes the data to the specified location, but does not overwrite any values outside the range of the input data.

Does that explain the behavior you are seeing?

1 个评论
显示 -1更早的评论隐藏 -1更早的评论

Yazan 2022-5-21

It does indeed. Rechecked the documentation: the default value of "WriteMode" is "inplace" for xls, and not "overwritesheet", as I was assuming. Apparently, I was overwriting an existing table with one of one less row, which caused the impression that the last cell was getting duplicated. Appreciate the help.

请先登录，再进行评论。