Creating timeseries objects from .xlsx files

Dear all,

Would anyone be able to share some information on creating timeseries objects from external .xlsx files at the command line? I don't want to have to go through the tstools GUI because I would like to create these objects as part of a larger program.

The webpage at http://www.mathworks.co.uk/help/matlab/data_analysis/time-series-objects.html#brenqws-3 provides an example of creating timeseries objects from an array in the base workspace, but not from external files.

Regards

Answer 1

[Shashank Prasanna]

Use xlsread to import the data into an array then use the method shown in that link.

You can also graphically import it this way:

http://www.mathworks.com/help/matlab/import_export/import-data-interactively.html

[Eleni Karagkiozidou]

You have helped me, too, now. Thank you!