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

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?

[Walter Roberson]

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

[Jannis Holtkoetter]

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

Answer 1

[Gouri Chennuru]

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!

[Jannis Holtkoetter]

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.