Reading .dbf files in a for loop by dynamically changing file names

Hi All,

I need to read multiple (175) .dbf files in a for loop. But file name to be read needs to be dynamically changed. File name changes from polyzone1_1.dbf, polyzone1_2.dbf....polyzone1_175.dbf. The sheet name also needs to be dynamically changed, accordingly.

     for i=1:175
         data{i}=xlsread('<path>\polyzone1_1.dbf','polyzone1_1','A2:A10')
     end

Can somebody suggest me a method or help me to complete the code?

Thanks in advance.

Answer 1

[per isakson]

Replace

    polyzone1_1.dbf
by

    sprintf('polyzone1_%i.dbf', i )

and

   'polyzone1_1'

by

   sprintf('polyzone1_%i', i )

&nbsp

See How can I process a sequence of files?

[Damith]

Thanks.