How do I export four variables of different sizes to an excel, txt or csv file?

Question

Jannis Holtkoetter 2020-10-30

0
链接

此问题的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/631909-how-do-i-export-four-variables-of-different-sizes-to-an-excel-txt-or-csv-file

评论： Jannis Holtkoetter 2020-11-8

Hello, I have four variables, which I want to save to either excel, txt or csv. Which file format doesn't matter, it only needs to be able to save this file in a database and load the data later on again. Of the four variables, three have a size of 1x1 double and one has a size of 10x2 double.

Is there a way to export this data to one file, maybe even with the variable name?

2 个评论
显示无隐藏无

Walter Roberson 2020-10-31

store [A;B;C;D(:)] perhaps ?

Jannis Holtkoetter 2020-10-31

When I try that it only gives me the error: Undefined function 'store' for input arguments of type 'double'.

请先登录，再进行评论。

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

Answer 1

Gouri Chennuru 2020-11-6

0
链接

此回答的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/631909-how-do-i-export-four-variables-of-different-sizes-to-an-excel-txt-or-csv-file#answer_536310

在 MATLAB Online 中打开

Hi Jannis,

As a workaround you can use the following code snippet as an example,

a = 1 % 1*1 
b = 2 % 1*1
c = 3 % 1*1
d = randn(10,2) % 10 *2
e = {a b c d} % storing all the variables in a single cell
writecell(e,'filename.xls') % eexporting the data into excel 

Hope this Helps!

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

Jannis Holtkoetter 2020-11-8

Hey, yeah it is a good workaround. It exports all data into one row of excel.

However, I already created another workaround which works aswell: I simply add a few NaNs to the 1x1 array, so that they have the same length as the 10X2 matrix. Then I save everything in a table and export to excel. The NaNs are not being displayed in excel.

请先登录，再进行评论。