Write data on to Excel
显示 更早的评论
I want to write the following data onto excel, in a way which the first answer (M(: , : , 1)) will be at the range E to G and the next answer (M(: , : , 2)) will be at the range I to K, so 4 column space between each.The sample data is below, is there a easier to do this as sometimes there might be more than 6 data sets.
X = ones(6).*(1:6);
Y = 2*ones(6).*(1:6);
Z = 3*ones(6).*(1:6);
M = permute(cat(3,X,Y,Z), [1 3 2]);
M= reshape(M, 6, []);
5 个评论
darova
2020-4-3
Is this correct?
Avishka G
2020-4-3
darova
2020-4-3
Your ccode then look ok. Why don't you want it?
Image Analyst
2020-4-3
What code? Easier way to do what? I see no code calling xlswrite() or writematrix(). Do you have any code that actually tries to write to Excel?
Avishka G
2020-4-6
采纳的回答
Guillaume
2020-4-6
If I understood correctly:
xlswrite(somefile, reshape([M, nan(size(M, 1), 1, size(M, 3))], 6, []), '', 'E1')
basically pad your 3D matrix with a column of NaNs. NaNs result in empty cells in the output spreadsheet.
9 个评论
Avishka G
2020-4-6
Avishka G
2020-4-6
Guillaume
2020-4-6
The second input to NaN is the number of pad columns, so:
xlswrite(somefile, reshape([M, nan(size(M, 1), 4, size(M, 3))], 6, []), '', 'E1')
Avishka G
2020-4-6
Guillaume
2020-4-7
So, yes you get four columns of NaN which will end up as blank columns in excel. What's the problem?
Avishka G
2020-4-7
Guillaume
2020-4-7
"do you know the code for it?"
Depends on what's L. If L is a column vector, the above will work as desired.
Avishka G
2020-4-7
Guillaume
2020-4-7
That's a different arrangement than in your initial question where each row of the input ended up on a different row of excel whereas you want it all in one row.
L = [0, 70, 100, 150, 200];
N = reshape([L; nan(4, size(L, 2))], 1, [])
This time, we're putting the nans below L and reshaping into a vector.
更多回答（0 个）
类别
在 帮助中心 和 File Exchange 中查找有关 Spreadsheets 的更多信息
Translated by 
