Matlab code to automatically look up for values in a xls sheets

Asked By William D Christiansen 0 points N/A Posted on - 05/24/2015

I am looking for innovative way of adding the third number to the xls sheet in Matlab. I have multiple xls sheets with three columns filled with numbers. It represents some set and presently I want to run through all the sheets and perform the following: I want to check the third column value with the third column value of previous row, if it is less than the average of previous three. I also have to change the colors of the modified cells? Can anybody share the flow of the code? Are there any easy functions for them?

• Status: Open
• Question Views: 700
• Answer Count: 1
• Vote Up 0 Vote Down

• Answer Accepted: No
• Question Category: MatLab

Answered By Annet Fralance 0 points N/A #194343

Matlab code to automatically look up for values in a xls sheets

I am not a typical MATLAB guy even though I have used it a couple of time during my college days. I will give you some example.

xlsread will help in reading MS excel files

num = xlsread(sourcefile) reads 1^st worksheet in the sourcefile.

num = xlsread(sourcefile,sheet) reads the sheet

num = xlsread(sourcefile,xlRange)  reads within the range’A3:C5’

num = xlsread(sourcefile,sheet,xlRange) rads from sheet and range

num = xlsread(sourcefile,sheet,xlRange,'basic')

[num,txt,raw] = xlsread(_)

___ = xlsread(sourcefile,-1)

[num,txt,raw,custom] = xlsread(sourcefile,sheet,xlRange,'',processFcn)

About Annet Fralance

Questions
1

Answers
203

Best Answers
0

• Vote Up 0 Vote Down

• Posted on - 05/24/2015
• Question Category: MatLab