MATLAB Answers

0

When using the import tool to import data from an excel file, how do I convert the spreadsheet dates to datenumbers?

  댓글 수: 0

로그인 to comment.

답변 수: 3

Umakant 님의 답변 29 Sep 2014
 채택된 답변

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

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?

로그인 to comment.


Joseph Cheng 님의 답변 29 Sep 2014
Joseph Cheng 님이 편집함. 29 Sep 2014

you'll have to have the rules for the "unimportable Cells" portion to have:
  • Convert Spreadsheet dates to datenum
  • exclude rows with unimportable cells

  댓글 수: 0

로그인 to comment.


Sean de Wolski 님의 답변 29 Sep 2014

You could also click the drop down arrow next to the column and select date as the option:

  댓글 수: 1

로그인 to comment.



Translated by