How to check existence of worksheet in excel file

47 次查看（过去 30 天）
YoungKwang
YoungKwang 2012-1-11
评论： Ilya Gurin 2021-8-13
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?

请先登录，再回答此问题。

采纳的回答

C.J. Harris
C.J. Harris 2012-1-11
[A,B] = xlsfinfo('foofoo.xlsx');
sheetValid = any(strcmp(B, 'foo2'));

更多回答（1 个）

Doug Hull
Doug Hull 2012-1-11
>> [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 个评论
显示 1更早的评论
Doug Hull
Doug Hull 2012-1-11
I like Chris' answer better about xlsinfo. Mine will error for the wrong sheet and then you can TRY CATCH the error.
YoungKwang
YoungKwang 2012-1-12
I got it solved with Chris's way. But thanks for your answer as well.

请先登录，再进行评论。

类别

在 Help Center 和 File Exchange 中查找有关 Spreadsheets 的更多信息

标签

Community Treasure Hunt

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

Start Hunting!

Translated by