How to access large arrays
8 次查看(过去 30 天)
显示 更早的评论
I am working with an array that is 76800x7 character elements. How can I view all the entries in this array and extract them into an excel spreadsheet? I can only view about 5000 or so of the last entries by printing the value in the command window.
0 个评论
采纳的回答
Adam Danz
2019-6-17
编辑:Adam Danz
2019-6-24
"How can I view all the entries in this array"
One way is to put the char array into an edit box where you can scroll through all 76800 rows of your data. Here's an example that also adds the row number.
% Create 10000 x 7 char array (rand chars)
ca = char(randi(40,10000,7)+40);
% Optionally append the row number to the left
ca = [num2str((1:10000)'), repmat(' ',10000,1), ca];
% Assign to edit box with vertical scroll
f = figure();
uih = uicontrol(f,'Style','Edit','Units','Normalize','Position',[0 0 1 1],...
'max',2,'String',ca,'FontName','consolas');
"and extract them into an excel spreadsheet?"
更多回答(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!