How to Write a Multi-Line Character Array to Excel?
10 vues (au cours des 30 derniers jours)
Afficher commentaires plus anciens
MathWorks Support Team
le 2 Oct 2017
Réponse apportée : MathWorks Support Team
le 2 Jan 2018
How to write a multi-line character array (user comments) into an Excel file using 'xlswrite'?
Réponse acceptée
MathWorks Support Team
le 2 Oct 2017
Below is an example to write multi-line comments to an excel spreadsheet:
prompt = {'Pipe Dream','Supplier','Comments'};
dlg_title = 'User Comments';
num_lines = [1 20;1 35;5 50];
user_comments = inputdlg(prompt,dlg_title,num_lines);
filename = 'testfile.xlsx';
sheet = 1;
xlswrite(filename,user_comments(1),sheet,'D40'); % save as cells
xlswrite(filename,user_comments(2),sheet,'D41');
% Add new line characters to the string ends
user_comments(3) = cellfun(@(x) {strcat(x,{newline})},user_comments(3));
% Concatenate the inner cells and remove the trailing newlines
user_comments(3) = cellfun(@(x) {deblank([x{:}])},user_comments(3));
% write the data to cells
xlswrite(filename,user_comments(3),sheet,'D42');
0 commentaires
Plus de réponses (0)
Voir également
Catégories
En savoir plus sur Spreadsheets dans Help Center et File Exchange
Community Treasure Hunt
Find the treasures in MATLAB Central and discover how the community can help you!
Start Hunting!