How to xlswrite cell array with both strings and number?
1 visualizzazione (ultimi 30 giorni)
Mostra commenti meno recenti
Supreet Hegde
il 30 Lug 2015
Commentato: Supreet Hegde
il 31 Lug 2015
I have a cell array of the type A={'01:02:03'};
when I use the function: xlswrite('Output',A)
The excel sheet that I get has eliminated the first zero, it is reading the cell as a number and giving me output as '1:02:03'. How do I get the entire string without eliminating 0?
0 Commenti
Risposta accettata
Azzi Abdelmalek
il 30 Lug 2015
Modificato: Azzi Abdelmalek
il 30 Lug 2015
A={'''01:02:03'};
5 Commenti
Azzi Abdelmalek
il 31 Lug 2015
s={'01:02:03';11; 20; '01:02:03';'01:02:03' ;11 ;10 }
idx=cellfun(@isstr,s)
s(idx)=strcat('''',s(idx))
xlswrite('fic.xlsx',s)
Più risposte (1)
Vedere anche
Categorie
Scopri di più su Spreadsheets in Help Center e File Exchange
Community Treasure Hunt
Find the treasures in MATLAB Central and discover how the community can help you!
Start Hunting!