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

Question

Jesse Finnell 2023-6-6

0
链接

此问题的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/1979359-how-to-i-get-the-info-from-a-designated-cell-from-excel-when-it-is-a-string

编辑： Cris LaPierre 2023-6-7

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 个评论
显示无隐藏无

Cris LaPierre 2023-6-6

在 MATLAB Online 中打开

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 2023-6-6

编辑：Jesse Finnell 2023-6-6

在 MATLAB Online 中打开

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 2023-6-6

0
链接

此回答的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/1979359-how-to-i-get-the-info-from-a-designated-cell-from-excel-when-it-is-a-string#answer_1251609

编辑：VBBV 2023-6-6

在 MATLAB Online 中打开

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 个评论
显示 1更早的评论隐藏 1更早的评论

Cris LaPierre 2023-6-7

编辑：Cris LaPierre 2023-6-7

在 MATLAB Online 中打开

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 2023-6-7

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.

请先登录，再进行评论。