Solved
Read excel function give zeros instead of real values
Hi there
I using (READEXCEL) but it read all the values as zeros
they should be these values
It works with the previous values
thanks in advance
Is the Excel worksheet up to date? You call Sheet 2 in your Mathcad worksheet, but in addition to the lack of Column D, there is no Sheet 2 in "Total Original Location.xlsx".
I modified your Mathcad worksheet to construct the range from the sheet number, column letter and number of lines; I also modified Sheet 1 to include a Column D (scaled copy of Column C). I didn't see any errors when using Sheet 1 for all valid ranges. I then changed rang_6 to point to the empty Column E and got a vector of zeros (as expected from an empty column).
Stuart