Multidimensional Array Excel Output
2 views (last 30 days)
Show older comments
I have a multidimentional array that is 45X151X43 that I need in Excel. This may sound strange but I absolutely need the data in Excel. They represent a sereis of 45 excitation-emission matrices of fluorescence measurements. So a single EEM has a dimension of 151X43 where 45 represents each individual EEM. The large 45X151X43 multidimentional array is called XcRU100. I have tried using xlswrite('results.xls',XcRU100(1,:,:)) but MATLAB spits back an error saying the array cannot be higher than two. The command xlswrite('results.xls',XcRU100(:,:,1)) will not work since that gives me data for all EEMs only at certain wavelengths. The command xlswrite('results.xls',XcRU100(1:,:,3)) works but, like the previous command, it doesn't give me the data I need. I actually just need the data in the 3rd column of the 151X43 (assuming 43 represents columns).
Is there a way to output a single 151X43 excel file for for each of the 45 EEMs and/or output a single excel file containing 45 sheets and each one is a 151X43 data set for the corresponding EEMs. I know the ordering of the big XcRU100 array. The command of xlswriate('results.xls',XcRU100(1,:,3)) works and outputs the appropriate data. Is there a better way to automate that to output 45 individual Excel files or, like I said, one Excel file with 45 different sheets?
Thank you
0 Comments
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!