Unable to use xlsread to open a file
1 view (last 30 days)
Show older comments
Meghana Balasubramanian
on 28 Aug 2019
Answered: Bruno Luong
on 28 Aug 2019
Hey everyone,
I'm trying to run the follwing code:
for i=1:10
fil_length= xlsread('\\some_pathway_here\Filament_Length_Data\Filament_Length_',num2str(i),'.xls')
end
However, I get an error: Error using xlsread (line 132)
XLSREAD unable to open file '\\some_pathway_here\Filament_Length_Data\Filament_Length_'.
File '\\some_pathway_here\Filament_Length_Data\Filament_Length_' not found.
When I run this code:
fil_length= xlsread('\\some_pathway_here\Filament_Length_Data\Filament_Length_1.xls')
without the num2str(i) part, I'm able to read the file. Is it not possible to run a function such as this? If not, are there any other ways that i could access my excel files inside a loop?
Accepted Answer
Bruno Luong
on 28 Aug 2019
for i=1:10
fil_length= xlsread(['\\some_pathway_here\Filament_Length_Dat\Filament_Length_' num2str(i) '.xls'])
end
0 Comments
More Answers (1)
darova
on 28 Aug 2019
1 Comment
Walter Roberson
on 28 Aug 2019
No, initial \\ in Windows indicates a path for network access, and is proper.
See Also
Categories
Find more on Spreadsheets in Help Center and File Exchange
Community Treasure Hunt
Find the treasures in MATLAB Central and discover how the community can help you!
Start Hunting!