How to check existence of worksheet in excel file
42 Ansichten (letzte 30 Tage)
Ältere Kommentare anzeigen
YoungKwang
am 11 Jan. 2012
Kommentiert: Ilya Gurin
am 13 Aug. 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 Kommentare
Akzeptierte Antwort
C.J. Harris
am 11 Jan. 2012
[A,B] = xlsfinfo('foofoo.xlsx');
sheetValid = any(strcmp(B, 'foo2'));
Weitere Antworten (1)
Doug Hull
am 11 Jan. 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 Kommentare
Doug Hull
am 11 Jan. 2012
I like Chris' answer better about xlsinfo. Mine will error for the wrong sheet and then you can TRY CATCH the error.
Siehe auch
Kategorien
Mehr zu Data Import from MATLAB finden Sie in Help Center und File Exchange
Community Treasure Hunt
Find the treasures in MATLAB Central and discover how the community can help you!
Start Hunting!