Unable to use xlsread to open a file

1 visualización (últimos 30 días)
Meghana Balasubramanian
Meghana Balasubramanian el 28 de Ag. de 2019
Respondida: Bruno Luong el 28 de Ag. de 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?
  1 comentario
Meghana Balasubramanian
Meghana Balasubramanian el 28 de Ag. de 2019
My apologies, I realized i made an error with using the brackets. It should be:
for i=1:10
fil_length= xlsread(['\\some_pathway_here\Filament_Length_Data\Filament_Length_',num2str(i),'.xls'])
end

Iniciar sesión para comentar.

Respuesta aceptada

Bruno Luong
Bruno Luong el 28 de Ag. de 2019
for i=1:10
fil_length= xlsread(['\\some_pathway_here\Filament_Length_Dat\Filament_Length_' num2str(i) '.xls'])
end

Más respuestas (1)

darova
darova el 28 de Ag. de 2019
2Untitled.png
  1 comentario
Walter Roberson
Walter Roberson el 28 de Ag. de 2019
No, initial \\ in Windows indicates a path for network access, and is proper.

Iniciar sesión para comentar.

Etiquetas

Community Treasure Hunt

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

Start Hunting!

Translated by