How to access large arrays

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.

Answer 1

[Adam Danz]

"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?"

Use writematrix().

[Sana Ahmed]

Worked perfectly, thank you!

[Adam Danz]

Glad I could help!