Read excel function give zeros instead of real values

[YA_10963798]

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

[Werner_E]

Missing your Prime file. Hopefully stripped down just showing the reading of the data and the display of the unexpected zeros

Not sure how the pdf you posted should be of any help here.

P.S.: Your Excel sheet only contains three columns of data (A,B,C). Hope you did not try to read columns D and E !??

[YA_10963798]

Sorry I attached the wrong sheet 

[Werner_E]

There is no sheet2 in the Excel file you posted!

As already written before it contains just one sheet with three columns of data (X,Y,Z values) - nothing more.

So trying to read from the second sheet obviously must fail

[YA_10963798]

I changed that , however it wasn't saved ... range 4 is in the first excel sheet , but I'm getting zeros in mathcad 

also in the one below ... it is writen bad sheet what does that mean? 

[Werner_E]

---

@YA_10963798 wrote:

I changed that , however it wasn't saved ... range 4 is in the first excel sheet , but I'm getting zeros in mathcad 

---

Haven't you read what I wrote more than 3 hours ago in my first reply and what I repeated in my last one?

Your Excel sheet contains only three columns of X,Y,Z data - nothing more!. There is no CPT data stored in the file. There is neither a second sheet nor a column D, E or F!!!!

Or better said, of course there actually are column E and F, but they are empty and contain no data. So Mathcad reads zero values there.

[StuartBruff · Accepted solution]

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

[YA_10963798]

Thank you Stuart