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.

Categorías

Más información sobre Loops and Conditional Statements en Help Center y File Exchange.

Etiquetas

Community Treasure Hunt

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

Start Hunting!

Translated by