How to I get the info from a designated cell from Excel when it is a string?

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"?

[Cris LaPierre]

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');

[Jesse Finnell]

Here is the output from the command window

>> 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
Dot indexing is not supported for variables
of this type.

If I change my code to what is suggested, I receive the same error.

Answer 1

[VBBV]

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

[Jesse Finnell]

So, each of the previous variables that are taken from the Excel spreadhseet are numerical values stored as a 1x1 Interface variable which is followed by a series of numbers and letters.

Hopefully the picture above better explains the variable type. With the numerical values that are grabbed I can use

name.Value

to convert the above variable type to a standard 1x1 double. This is the case for the Depth variable as well as a few others that I did not originally include.

[Cris LaPierre]

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)

[Jesse Finnell]

My failure to read closely was my problem. I had already converted the Depth variable to a double and the if loop fails because I was trying to index the value a second time. Thanks for the help.