READEXCEL function returns wrong cell value

[MikeMcDermott]

I get a cell 1 down from what I specify. This is constant in MC11.2, MC15 and Prime 2.

I'll attach samples of all 3 versions.

[MikeArmstrong]

I haven't got Mathcad at the moment but I've heard of a similiar issue before.

I you using Origin = 0?

Mike

[MikeMcDermott]

I have origin set to 0 and setting it to 1 makes no difference.

[MikeArmstrong]

Your correct Origin has no bearing on the component, but I'm sure Excel components have Origin = 1 built in.

Mike

[VladimirN]

Mike Armstrong wrote:

I haven't got Mathcad at the moment...

Mike,

Please see the attachment.

[MikeArmstrong]

Cheers Valdimir,

I have definately come across this issue before with Raiko, I'm sure of it. When I have time I'll try and dig the thread out.

Mike

[AndyWesterman]

One note - If you add an entry in the B1 cell the readexcel gives the correct result.

It works the same for mathcad 15 & prime2 so the same bug probably exists in both.

Andy

[mzeftel]

Andy and Mike,

I see the same thing you do for XLS files (Excel 2003). READEXCEL works correctly for XLSX files (Excel 2007 and Excel 2010.(

If I add an entry to B1 in the XLS file, Mathcad grabs the correct cell, if B1 is empty, then it grabs the value one cell down.

I'll log this if it is not logged already.

Thanks,

Mona

[MikeArmstrong]

Mona,

I'm not sure if the issue has been logged. The thread I previously came across this issue was one of Raiko's threads using scripted components.

Mike

[mzeftel]

I'm still investigating. I can repeat Mike's issue in his worksheet, but if I make a new XLS file, it works correctly.

Mona

[MikeArmstrong]

Very strange. I'll look for the thread I was referring to as I'm sure that way the case last time.

Mike

[mzeftel]

Mike McDermott

I have been chasing why your spreadsheet doesn't work for READEXCEL. I deleted your top empty row in the Excel sheet, then replaced it with a new blank row, and everything is now working correctly.

So something was in your original Excel sheet that caused the problem. Let me know if you still have the issue.

Mona

[MikeArmstrong]

So something was in your original Excel sheet that caused the problem. Let me know if you still have the issue.

I remember the Excel sheet I was dealing with had alot of data in multiple cells and a little untidy. But should this have an issue?

Mike