Re: Excel OLE cell value custome pre-defined predefined function formula error

As davies pointed out, without your Excel file, others won't be able to test your script. However, I took a quick look into the OLE browser. You might want to try Value2 to see if that is returning what you want.

Based on your follow on post, it looks like cell A5 is the cell that has the special function. To try my suggestion, just change:

$values[2] = $sheet -> Range("A5")->{Value};

to be:

$values[2] = $sheet -> Range("A5")->{Value2};

Not claiming that this will "fix" the problem. Just tossing out an idea to try out.

Comment on Re: Excel OLE cell value custome pre-defined predefined function formula error Select or Download Code

Replies are listed 'Best First'.
Re^2: Excel OLE cell value custome pre-defined predefined function formula error by davies (Monsignor) on Feb 06, 2011 at 00:30 UTC
There is usually no difference between Value and Value2, and if you are getting an error value, I have never encountered a difference. The difference comes with dates, where Value will return 01/01/2001 while Value2 will return 36892. I believe there are some other esoteric situations where there is a difference, but I have never needed to know them. Regards, John Davies	[reply]