How do I selectively write from struct to excel
显示 更早的评论
I have a 35x1 struct with character arrays, double arrays (just a number), datetime array, and an Nx2 double array (N being variable). I uploaded a table of that data sans the Nx2 double array.
I want to send that to excel transposed and with empty columns between data columns, for easier viewing and to accomodate the Nx2 double array that should not be transposed. I can move the Nx2 to its own container instead of putting it in the struct.
Any strategies for doing this? I think converting to a table gets me part of the way there. Transposing and adding columns and row skips is the challenge (for me).
采纳的回答
whos -file mystruct
load mystruct
whos mystruct
head(mystruct)
A=table2array(rows2vars(mystruct));
whos A
A(1:10,:)
B=cell(size(A,1),3*(size(A,2)-1));
B(:,[1 2:3:size(B,2)])=A;
B(1:10,1:7)
mystruct isn't a struct at all, it's a table...so, not knowing what the deal is with that, the above takes it and creates the requested format to write to the Excel file for that data.
The array data are nowhere in sight, but simply do something similar with them and then write to the sheet in the desired location separately or append to B in the correct locations desired.
Then writecell
更多回答（0 个）
类别
在 帮助中心 和 File Exchange 中查找有关 Spreadsheets 的更多信息
Translated by 
