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

3 次查看（过去 30 天）
Damith
Damith 2014-10-23
评论： Damith 2014-10-23
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.

请先登录，再回答此问题。

采纳的回答

per isakson
per isakson 2014-10-23
编辑：per isakson 2014-10-23
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?

更多回答（0 个）

类别

在 Help Center 和 File Exchange 中查找有关 Adding custom doc 的更多信息

标签

Community Treasure Hunt

Find the treasures in MATLAB Central and discover how the community can help you!

Start Hunting!

Translated by