How to I get the info from a designated cell from Excel when it is a string?
2 visualizaciones (últimos 30 días)
Mostrar comentarios más antiguos
Jesse Finnell
el 6 de Jun. de 2023
Editada: Cris LaPierre
el 7 de Jun. de 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 comentarios
Cris LaPierre
el 6 de Jun. de 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');
Jesse Finnell
el 6 de Jun. de 2023
Editada: Jesse Finnell
el 6 de Jun. de 2023
Respuesta aceptada
VBBV
el 6 de Jun. de 2023
Editada: VBBV
el 6 de Jun. de 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 comentarios
Cris LaPierre
el 7 de Jun. de 2023
Editada: Cris LaPierre
el 7 de Jun. de 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)
Más respuestas (0)
Ver también
Categorías
Más información sobre Matrix Indexing en Help Center y File Exchange.
Community Treasure Hunt
Find the treasures in MATLAB Central and discover how the community can help you!
Start Hunting!