How to check existence of worksheet in excel file
42 visualizaciones (últimos 30 días)
Mostrar comentarios más antiguos
YoungKwang
el 11 de En. de 2012
Comentada: Ilya Gurin
el 13 de Ag. de 2021
I'm working on some script and i need to check if there's any particular name of worksheet. Is there anyway to check the workshee existing in excel file? Additionally, I wanna know if there is the way deleting particular worksheet. And I don't wanna use activeX for this. Can anybody help me?
0 comentarios
Respuesta aceptada
C.J. Harris
el 11 de En. de 2012
[A,B] = xlsfinfo('foofoo.xlsx');
sheetValid = any(strcmp(B, 'foo2'));
Más respuestas (1)
Doug Hull
el 11 de En. de 2012
>> [a,b] = xlsread('foofoo.xlsx','foo2')
Error using xlsread>activate_sheet (line 435)
Specified worksheet was not found.
Error in xlsread (line 259)
activate_sheet(Excel,sheet);
Throw a Try Catch around it.
3 comentarios
Doug Hull
el 11 de En. de 2012
I like Chris' answer better about xlsinfo. Mine will error for the wrong sheet and then you can TRY CATCH the error.
Ver también
Categorías
Más información sobre Data Import from MATLAB en Help Center y File Exchange.
Community Treasure Hunt
Find the treasures in MATLAB Central and discover how the community can help you!
Start Hunting!