MATLAB Answers

Error using getappdata when Import excel with multiple sheets

2 views (last 30 days)
Dinouk Goonewardena
Dinouk Goonewardena on 6 Jul 2020
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');

  0 Comments

Sign in to comment.

Answers (1)

Jyotsna Talluri
Jyotsna Talluri on 9 Jul 2020
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 Comment

Dinouk Goonewardena
Dinouk Goonewardena on 10 Jul 2020
for some reason it does not reconogize the handles from PB_sheet....any idea to fix it?

Sign in to comment.

Products


Release

R2016b

Community Treasure Hunt

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

Start Hunting!