How to access large arrays
3 views (last 30 days)
Show older comments
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 Comments
Accepted Answer
Adam Danz
on 17 Jun 2019
Edited: Adam Danz
on 24 Jun 2019
"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?"
2 Comments
More 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!