How to read and plot multiple Excel file

1 次查看（过去 30 天）

Khairul Afifi 2014-12-19

0
链接

此问题的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/167157-how-to-read-and-plot-multiple-excel-file

评论： Khairul Afifi 2015-1-29

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 个评论
显示无隐藏无

Sara 2014-12-19

在 MATLAB Online 中打开

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 2015-1-29

Thank you, Sara.

I actually managed to plot the graph. Thank you for the feedback.

请先登录，再进行评论。

请先登录，再回答此问题。

回答（0 个）

请先登录，再回答此问题。

类别

MATLAB Data Import and Analysis Data Import and Export Standard File Formats Spreadsheets

在 Help Center 和 File Exchange 中查找有关 Spreadsheets 的更多信息

Community Treasure Hunt

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

Start Hunting!

Translated by