Multidimensional Array Excel Output

2 views (last 30 days)
Paul
Paul on 12 Jul 2012
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

Answers (0)

Community Treasure Hunt

Find the treasures in MATLAB Central and discover how the community can help you!

Start Hunting!