writing date on an excel sheet
27 visualizzazioni (ultimi 30 giorni)
Mostra commenti meno recenti
Hi folk,
Got a question about writing date on an excel sheet. I am using the following codes:
DATE=datestr(now);
xlswrite('test.xls', DATE, 'A1')
The problem is that it separates each number and letter and put them in separate cells. I want the whole date in one cell like 'A1' but it appears from 'A1' to 'T1'
I appreciate your help. Thank you.
S:-)
1 Commento
Prieni
il 18 Ago 2017
Modificato: Prieni
il 18 Ago 2017
Just came across the problem to export date/time to an Excel sheet. If you do this:
DATE = now - datenum(1899,12,30,0,0,0);
xlswrite('test.xls',DATE)
you get a number in your Excel sheet that, if you change formatting to date, shows the current date. It also includes the current time which you can see when you select that date.
Risposta accettata
Più risposte (0)
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!