How to combine string and numbers before using xlswrite to export data into an Excel file?

2 次查看（过去 30 天）
Leon
Leon 2019-3-17
评论： Leon 2019-3-18
I have like to write the below information into one Excel spreadsheet:
Cruise # Longitude Latitude Year Month Day
SE_01 -126 35 2017 9 17
SE_01 -123 31 2017 9 18
SE_01 -121 27 2017 9 20
How do I form the matrix? For Column 1, if it is numerical, I would do: A*size(3,1); but how about strings? Once I get the string column for Column 1, how do I combine it with the other numerical matrix values?
Many thanks!

请先登录，再回答此问题。

采纳的回答

KSSV
KSSV 2019-3-18
cruise = {'SE_01', 'SE_01','SE_01'}' ;
Longitude = [-126 -123 -121]' ;
Latitude = [35 31 27]' ;
Year = [2017 2017 2017]' ;
Month = [9 9 9 ]';
Day = [17 18 20]' ;
thedates = datetime(Year,Month,Day) ;
T = table(cruise,thedates,Longitude,Latitude);
writetable(T,'test.xlsx')
  3 个评论
显示 1更早的评论

请先登录，再进行评论。

更多回答（0 个）

类别

在 Help Center 和 File Exchange 中查找有关 Spreadsheets 的更多信息

标签

产品

Community Treasure Hunt

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

Start Hunting!

Translated by