How to transfer 3D data in Matlab into Excel
1 view (last 30 days)
Show older comments
Hi everyone,
I have a problem with my 3D values which is in a matrix form as shown if figure below:
![](https://www.mathworks.com/matlabcentral/answers/uploaded_files/200708/image.png)
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:
![](https://www.mathworks.com/matlabcentral/answers/uploaded_files/200709/image.png)
For your information, I am using MATLAB 2015b version. Hope to get the solution from you. Thank you.
Regards
Huda
1 Comment
Guillaume
on 14 Jan 2019
"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?
Answers (0)
See Also
Categories
Find more on Spreadsheets in Help Center and File Exchange
Community Treasure Hunt
Find the treasures in MATLAB Central and discover how the community can help you!
Start Hunting!