Skip to main content
S
SFares14-Alexandrite
14-Alexandrite
August 29, 2025
Solved

Reading from an Excel File, MP10

  • August 29, 2025
  • 1 reply
  • 757 views

Hello,

 

I am reading values from an Excel sheet. I was building on the answer that Werner had for one of the questions. I have attached both P10 sheet and the excel sheet i am reading from. I was able to read the values for some but not others. The problem is there are dashes at TPP3,TPP5,... 

SFares_0-1756498602597.png

SFares_1-1756498843852.png

 

Thanks,

Sam

 

 

Best answer by StuartBruff

For example, you could do something like the following, Sam.

 

2025 08 29 A.png

 

Stuart

1 reply

S
StuartBruff23-Emerald V
23-Emerald V
August 29, 2025

The reason you are getting the error is that you are multiplying the dashes by a unit (in.lbf), and Mathcad raises an error when multiplying a scalar by a string..

 

How do you want to handle the dashes within the rest of your worksheet?  Eg, convert them to zero or NaN.

 

Stuart

S
SFares14-AlexandriteAuthor
14-Alexandrite
August 29, 2025

Hi Stuart,

 

Is it possible to read the excel sheet by skipping the row with dashes

by specifying certain cells like F13:F14, F16:17,.. that corresponds to:

SFares_0-1756501442146.png

 

Regards,

Sam

S
StuartBruff23-Emerald V
23-Emerald V
August 29, 2025

Hi Sam,

 

Yes, it's possible to skip rows, but what values do you want to put in the TCn variables in their place?

 

Stuart

Terms & ConditionsCookie settingsAccessibility statement