Community Tip - New to the community? Learn how to post a question and get help from PTC and industry experts! X
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
Solved! Go to 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
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 !??
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
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?
@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.
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
Thank you Stuart