How to transfer 3D data in Matlab into Excel

Hi everyone,

I have a problem with my 3D values which is in a matrix form as shown if figure below:

I would like to transfer those data into excel; the data in the first column of val(:,:,1) should be inserted in the first column in Excel. However, the whole

data is in text form. I cannot even seperate the data in the first column with the data in the second column.

The data that have been transfered in Excel is in the figure below:

For your information, I am using MATLAB 2015b version. Hope to get the solution from you. Thank you.

Regards

Huda

[Guillaume]

"However, the whole data is in text form"

That is solely due to the way you write the data into excel. You haven't told us how you do that.

Since Excel spreadsheet are 2D only, how do you want to write a 3D matrix in a spreadsheet. You've told us that " the data in the first column of val(:,:,1) should be inserted in the first column in Excel", so val(:, 1, 1) goes into column 1. What goes into column 2? val(:, 2, 1)? Where does val(:, 1, 2) goes? and so on?