Why 'PreserveFormat' in writetable returns error?

Question

Joanna Przeworska 2021-4-9

0
链接

此问题的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/797062-why-preserveformat-in-writetable-returns-error

编辑： Walter Roberson 2021-4-9

采纳的回答： Stephen23

在 MATLAB Online 中打开

Hi,

I have a code:

writetable(SECTORS.NFC.Total,'Wyniki_2020_12.xlsx','Sheet','NFC','Range','B9:L77','PreserveFormat',true,'WriteVariableNames',0)

and my goal is to save table in Excel spreadsheet without changing the format of rows and columns. I found, within writetable command, I may use 'PerserveFormat' however it returns an error:

Error using writetable (line 152)
Invalid parameter name: PreserveFormat.

How can I correct my code?

0 个评论
显示 -2更早的评论隐藏 -2更早的评论

请先登录，再进行评论。

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

Answer 1

Stephen23 2021-4-9

0
链接

此回答的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/797062-why-preserveformat-in-writetable-returns-error#answer_671117

编辑：Stephen23 2021-4-9

The 'PreserveFormat' option was added in R2020b:

https://www.mathworks.com/help/matlab/release-notes.html?rntext=PreserveFormat&startrelease=R2016a&endrelease=R2021a&groupby=release&sortby=descending&searchHighlight=

You are probably using an earlier version which does not support that option. If you add the version number (see the field on the right of this page) when you ask a question then we do not have to guess what version you are using.

Note that although the online documentation is very interesting to read, to know what your installed MATLAB version is capable of you should refer to the help of your installed MATLAB.

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

Stephen23 2021-4-9

"Is there any other simple way to achieve this goal?"

I do not know of any simple alternative.

Walter Roberson 2021-4-9

编辑：Walter Roberson 2021-4-9

For those older versions, you have to use MS Windows with Excel installed and use ActiveX to talk to Excel.

Or you have to get down into the insides of the xlsx file, find the XML sheet that holds the format information, and insert it into the newly written xlsx file (or something along those lines.)

请先登录，再进行评论。