MATLAB: Creating timeseries objects from .xlsx files

timeseriesxlsx

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

Best Answer

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

Related Solutions

MATLAB: Is there an equivalent command to the ACTXCONTROLLIST in MATLAB to list all installed ActiveX server objects

The ability to list all the ActiveX server objects is not available in MATLAB 7.2 (R2006a). To work around this issue, you can use the OLE/COM Object Viewer, available for Windows from the Microsoft Web site.

MATLAB: Converting .xls and .xlsx to .csv

Why not assume the extension is correct and process it if necessary?

[folder, baseFileName, extension] = fileparts(filename);
if strcmpi(extension, '.xlsx')
  numbers = xlsread(filename);
  csvFileName = strrep(filename, '.xlsx', '.csv');
  csvFileName = strrep(csvFileName, '.xls', '.csv');
  csvwrite(csvFileName, numbers);
end

Best Answer

Related Solutions

MATLAB: Is there an equivalent command to the ACTXCONTROLLIST in MATLAB to list all installed ActiveX server objects

MATLAB: Converting .xls and .xlsx to .csv

Related Question