how to check whether a sheet exists or not, while using readtable function

23 次查看（过去 30 天）
kishore babu kavuru
回答： Jeremy Hughes 2020-3-3
rawData = readtable('filepath.xls','Sheet','Data Export')
in the above command, if sheet is not available then its throwing an error.
Error using readtable (line 216)
Sheet name 'Data Export' does not exist or is not supported. To check if the sheet is supported, specify the sheet by its worksheet index.
So i would like to skip this error and proceed further without using 'xlsfinfo'. if possible help me out please.

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

回答（1 个）

Jeremy Hughes
Jeremy Hughes 2020-3-3
I don't know if it's any better, but there is https://www.mathworks.com/help/matlab/ref/sheetnames.html
Otherwise, try/catch might work.

类别

在 Help Center 和 File Exchange 中查找有关 Data Import from MATLAB 的更多信息

标签

产品


版本

R2018b

Community Treasure Hunt

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

Start Hunting!

Translated by