How to transfer 3D data in Matlab into Excel
2 次查看(过去 30 天)
显示 更早的评论
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 个评论
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?
回答(0 个)
另请参阅
类别
在 Help Center 和 File Exchange 中查找有关 Spreadsheets 的更多信息
Community Treasure Hunt
Find the treasures in MATLAB Central and discover how the community can help you!
Start Hunting!