Trial to display Capital letters on excel

1 visualización (últimos 30 días)
Ahmed Heikal
Ahmed Heikal el 28 de Mayo de 2020
Respondida: Ameer Hamza el 28 de Mayo de 2020
I have created an array containing Some Capital letters and on displaying this array on an excel file using the xlswrite Function the letters are replaced by ASCII Numbers
I haven't find a way to disp the array as it is
Note: This array is a column in a table
function GPATable(Table3,R3)
Table3(:,3)=Table3(:,3)+Table3(:,4);
for i=1:R3-1
if Table3(i,3)>=90
Table3(i,3)='A';
elseif Table3(i,3)>=80
Table3(i,3)='B';
elseif Table3(i,3)>=70
Table3(i,3)='C';
elseif Table3(i,3)>=60
Table3(i,3)='D';
else
Table3(i,3)='F';
end
end
Table3=[Table3(:,1),Table3(:,2),Table3(:,3)];
Header={'StudentID','CourseID','Grade'};
xlswrite('Table7',Header,'Section1');
xlswrite('Table7',Table3,'Section1','A2');
end
Thanks in Advance

Respuestas (1)

Ameer Hamza
Ameer Hamza el 28 de Mayo de 2020
xlswrite is used to write numeric matrices. If you want to write text data, then use writetable() or writecell(). For example
Table = {'1', '2' '3' '4'};
writecell(Table, 'Table7.xlsx');

Productos


Versión

R2019b

Community Treasure Hunt

Find the treasures in MATLAB Central and discover how the community can help you!

Start Hunting!

Translated by