How to I get the info from a designated cell from Excel when it is a string?
조회 수: 1 (최근 30일)
이전 댓글 표시
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일
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');
채택된 답변
VBBV
2023년 6월 6일
편집: VBBV
2023년 6월 6일
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
Cris LaPierre
2023년 6월 7일
편집: Cris LaPierre
2023년 6월 7일
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)
추가 답변 (0개)
참고 항목
카테고리
Help Center 및 File Exchange에서 Matrix Indexing에 대해 자세히 알아보기
Community Treasure Hunt
Find the treasures in MATLAB Central and discover how the community can help you!
Start Hunting!