How to I get the info from a designated cell from Excel when it is a string?
1 Ansicht (letzte 30 Tage)
Ältere Kommentare anzeigen
Jesse Finnell
am 6 Jun. 2023
Bearbeitet: Cris LaPierre
am 7 Jun. 2023
I have the following code:
Std = get(DB.Activesheet,'Range','C8');
if Std.Value == "DWA"
standard = 1-2.29*10^(-4)*(Depth.Value/3.2808)^2+9.19*10^(-3)*(Depth.Value/3.2808)
else
standard = 1
end
This returns the error "Dot indexing is not supported for variables of this type."
If I run the following code in the command window I receive the output needed.
>> Std.Value
ans =
'DWA'
How do I fix this to be able to test if the cell in the Excel spreadsheet contains that three letter string "DWA"?
2 Kommentare
Cris LaPierre
am 6 Jun. 2023
What line of code is throwing the error? Please share the entire error message (all the red text).
What if you try the following format instead?
Std = DB.ActiveSheet.get('Range','C8');
Akzeptierte Antwort
VBBV
am 6 Jun. 2023
Bearbeitet: VBBV
am 6 Jun. 2023
May be the error refers to the variable Depth for which there is no Value field..
Can you check whether its a simple variable or a struct variablle ? If its NOT struct then its likely to throw such error
if Std.Value == 'DWA'
standard = 1-2.29*10^(-4)*(Depth/3.2808)^2+9.19*10^(-3)*(Depth/3.2808)
% >> >>
else
standard = 1
end
3 Kommentare
Cris LaPierre
am 7 Jun. 2023
Bearbeitet: Cris LaPierre
am 7 Jun. 2023
What is the output if you run the following code? I'd run each line separately so you know which line of code any error messages belong to.
Std.Value
Depth.Value
standard = 1-2.29*10^(-4)*(Depth.Value/3.2808)^2+9.19*10^(-3)*(Depth.Value/3.2808)
Weitere Antworten (0)
Siehe auch
Kategorien
Mehr zu Matrix Indexing finden Sie in Help Center und File Exchange
Community Treasure Hunt
Find the treasures in MATLAB Central and discover how the community can help you!
Start Hunting!