MATLAB Answers

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

24 views (last 30 days)
kishore babu kavuru
kishore babu kavuru on 3 Mar 2020
Answered: Jeremy Hughes on 3 Mar 2020
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.


Sign in to comment.




Community Treasure Hunt

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

Start Hunting!