With the command xlsread you can easily import excel data into matlab and assign each column to a vector.

Can you explain more about your question, please? I didn't understand what you mean!

in order to assign data to the vector, u can do this

vector = xlsread('myFile.xls')

for the first question its not clear. Do you mean, you want to fit the linear equation onto the data read into vector? Also what is the range of your time?

Thanks Iman and Farouk for your response

Attached is an example of a single equation inside the loop where the Pgrid is calculated and Pload should be imported from excel every time step (index count)

Thanks