Error using getappdata when Import excel with multiple sheets

1 回表示 (過去 30 日間)
Dinouk Goonewardena
Dinouk Goonewardena 2020 年 7 月 6 日
I keep getting an error which I cant seem to solve, all the code is the files, Import_PB imports the excel file.
The error=>
Error using getappdata
Value must be a handle.
Error in Import_PB (line 44)
handles.SheetsData =getappdata(h,'SheetsData');

回答 (1 件)

Jyotsna Talluri
Jyotsna Talluri 2020 年 7 月 9 日
The error occurs when the handle 'h' you are refering to is not a valid handle of a handle graphics object .
handles.SheetsData = getappdata(h,'SheetsData');
Check if you have specified 'Tag' property correctly as findobj is not returning a valid handle
h = findobj('Tag','GUI_PB');
  1 件のコメント
Dinouk Goonewardena
Dinouk Goonewardena 2020 年 7 月 10 日
for some reason it does not reconogize the handles from PB_sheet....any idea to fix it?

サインインしてコメントする。

カテゴリ

Help Center および File ExchangeData Import from MATLAB についてさらに検索

製品


リリース

R2016b

Community Treasure Hunt

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

Start Hunting!

Translated by