Prev: imaqregister - for current user only?
Next: Converting a mesh to vector
From: Ben Armstrong on 13 Jul 2010 08:27
I have a series of .xls files in a directory...
I want to import sections of each, and create a variable from the data for each file...
I can write this in a brute-force kind of way:

a= xlsread('C:\CompanyData\1632_PAC','a1:e14')
b= xlsread('C:\CompanyData\1633_PAC','a1:e14')
c= xlsread('C:\CompanyData\1634_PAC','a1:e14')
d= xlsread('C:\CompanyData\1635_PAC','a1:e14')
....
z= xlsread('C:\CompanyData\1658_PAC','a1:e14')

I cannot get my head around a way of writing this as a loop...
Any help or hints on how I could do this would be most apreciated!
From: Ashish Uthama on 13 Jul 2010 08:32
This should give you some ideas:
http://matlabwiki.mathworks.com/MATLAB_FAQ#How_can_I_process_a_sequence_of_files.3F
http://matlabwiki.mathworks.com/MATLAB_FAQ#How_can_I_create_variables_A1.2C_A2.2C....2CA10_in_a_loop.3F
 | 
Pages: 1
Prev: imaqregister - for current user only?
Next: Converting a mesh to vector