How to read and plot multiple Excel file

5 views (last 30 days)
Khairul Afifi
Khairul Afifi on 19 Dec 2014
Commented: Khairul Afifi on 29 Jan 2015
Greetings,
I would like to know how can I read and plot the excel file from 1 Dec 2013 to 30 Dec 2013. The data for the excel file I wish to plot is N,E and Z as shown below.
<<
>>
I would like to also ask the function for a folder ?
For example. function for a single file can be written as
function [ndata,header] = ReadExcelv6(filename);
But how about function for a folder base on date ?
Thank you in advance.
  2 Comments
Sara
Sara on 19 Dec 2014
look into
dir or ls
to get the names of the files in a folder. Then you can select only those within a certain range and use
xlsread
to read in only the columns you're interested in. makes sense?
Khairul Afifi
Khairul Afifi on 29 Jan 2015
Thank you, Sara.
I actually managed to plot the graph. Thank you for the feedback.

Sign in to comment.

Answers (0)

Community Treasure Hunt

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

Start Hunting!