Simple MATLAB to Excel Question

[swartzism]

I've discovered that MATLAB is not my forte. I have a 51x3 matrix that I want to print to an Excel sheet, but with column headers. I can get the matrix into an Excel file and I can get the headers into an Excel file, but I cannot figure out how to get the two together. I've looked up how to do this and it is not working for me.

What I have is

sunAngleMtx(:,1) = results.Timestamp;
sunAngleMtx(:,2) = results.SubTargetID;
sunAngleMtx(:,3) = results.SunAngle;

data = {'Timestamp','SubTargetID','SunAngle'; sunAngleMtx};
xlswrite('sunAngleData.xls', data);

and I'm getting the error

Error using vertcat
CAT arguments dimensions are not consistent.

Error in sunAngleCheck (line 12)
data = {'Timestamp','SubTargetID','SunAngle'; sunAngleMtx};

Any idea what I'm doing wrong. I imagine this is just me being a MATLAB noob.

Thanks in advance.

 

[swartzism]

Solved.

 

[jtbell]

How? Other people might find it useful.

 

[swartzism]

data = 'Timestamp,SubTargetID,SunAngle\n';
fout = fopen('sunAngleData.csv','wt');
fprintf(fout,data);
fprintf(fout,'%d,%f,%f,%f,%f,%f\n',sunAngleMtx');
fclose(fout);

 

[alphy]

Hello,

It seems like the issue may be with the dimensions of your matrix and the data you are trying to concatenate. The error message is indicating that the dimensions are not consistent, meaning they do not match up.

One thing you can try is to transpose your matrix, as shown below, before concatenating it with the headers. This will ensure that the dimensions are consistent.

sunAngleMtx(:,1) = results.Timestamp;
sunAngleMtx(:,2) = results.SubTargetID;
sunAngleMtx(:,3) = results.SunAngle;

% Transpose the matrix
sunAngleMtx = sunAngleMtx';

% Concatenate the headers and matrix
data = {'Timestamp','SubTargetID','SunAngle'; sunAngleMtx};
xlswrite('sunAngleData.xls', data);

I hope this helps and good luck with your MATLAB and Excel integration!