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

Asked By 0 points N/A Posted on -
qa-featured

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?

  • Answer Accepted: No
  • Question Category:
SHARE
Answered By 0 points N/A #194343

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

qa-featured

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 1st 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
  • Posted on -
  • Question Category:

MS Project is not allocating resources as per my calendar

Previous

Help required creating a matrix of 3x4 in Matlab

Next

Related Questions