When using the import tool to import data from an excel file, how do I convert the spreadsheet dates to datenumbers?
显示 更早的评论
采纳的回答
Umakant
2014-9-29
0 个投票
To convert dates from spreadsheets to Date Number add a new rule for converting dates to Date Number. To add this rule:
1) Select “Convert” from drop down list in middle of the import window then Spreadsheets dates to->datenum from next dropdown lists.
2) Click “Import Selection” button this will import the selected data to the workspace in Date Numbers.
Please refer to following link for information on importing spreadsheet data:
1 个评论
Rasmus
2014-10-2
Thank you for the quick answer, however I am not able to add a new rule for converting data in the drop down menu. How do I do that?
更多回答（2 个）
Joseph Cheng
2014-9-29
编辑：Joseph Cheng
2014-9-29
0 个投票
you'll have to have the rules for the "unimportable Cells" portion to have:
- Convert Spreadsheet dates to datenum
- exclude rows with unimportable cells
Sean de Wolski
2014-9-29
0 个投票
You could also click the drop down arrow next to the column and select date as the option:
类别
在 帮助中心 和 File Exchange 中查找有关 Spreadsheets 的更多信息
Community Treasure Hunt
Find the treasures in MATLAB Central and discover how the community can help you!
Start Hunting!
Translated by 
