How to transfer 3D data in Matlab into Excel

2 次查看（过去 30 天）

显示更早的评论

Nurulhuda Ismail 2019-1-14

0
链接

此问题的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/439672-how-to-transfer-3d-data-in-matlab-into-excel

评论： Guillaume 2019-1-14

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

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

Guillaume 2019-1-14

"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?

请先登录，再进行评论。

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