A Ruby/Excel issue - Cross posted from Miscellaneous
 

All, apologies for the cross posting, but I had no takers on th
Miscellaneous forum.

I don't think this is pecifcally a Ruby problem, that's just what I wa
using when I encountered the issue below.:(

I am having a troublesome problem. I am trying to pull data out of
complex Excel workbook (several worksheets in the book) and make th
contents available for a variety of reporting uses. I am working i
Ruby - for no reason other than "just because".

All is going well when I have cells that contain simple data types, bu
as soon as there is any kind of complexity in a formula, I get a weir
negative number back instead of the contents. For example:

Cell K3 has this formula.....=VLOOKUP(H3,Quadrant_Table,3)
The value when that formula is executed is "Adopt" and that is wha
shows on the screen.
When I go in from Ruby (via WIN32OLE), I get the number -214682626
back.

The Ruby snippet that does this is

colIndex = @startCol
colIndex.upto(endCol) {|aCol|
currCell = ("#{@@colnames[aCol-1]}#{aRow}")
@cells << (sheet.Range(currCell) ['Value']).to_s

}
}
end

@cells is an array of individual cells. There are likely to be man
better (faster) ways of getting the range back in one fell swoop, bu
right now I am less interested in that. First get answers that yo
like, then improve the approacch!

For simple string values, non formula arithmetic values, this deliver
just what it should. However for these complex formulae the result i
always that funky -2146826265. This is also x'800A07E7' which look
suspiciously like an hresult value.

So the question is, how to I get the displayed value out of the cel
from my Ruby program?

Thanks in advance for any help.

Chri

--
seabird2
-----------------------------------------------------------------------
seabird20's Profile: http://www.excelforum.com/member.php...fo&userid=3703
View this thread: http://www.excelforum.com/showthread.php?threadid=56825

A Ruby/Excel issue - Cross posted from Miscellaneous
 

Errors

Maybe something he

http://support.microsoft.com/kb/186063/en-us
INFO: Translating Automation Errors for VB/VBA (Long)

--
Regards,
Tom Ogilvy

"seabird20" wrote
in message ...

All, apologies for the cross posting, but I had no takers on the
Miscellaneous forum.

I don't think this is pecifcally a Ruby problem, that's just what I was
using when I encountered the issue below.:(

I am having a troublesome problem. I am trying to pull data out of a
complex Excel workbook (several worksheets in the book) and make the
contents available for a variety of reporting uses. I am working in
Ruby - for no reason other than "just because".

All is going well when I have cells that contain simple data types, but
as soon as there is any kind of complexity in a formula, I get a weird
negative number back instead of the contents. For example:

Cell K3 has this formula.....=VLOOKUP(H3,Quadrant_Table,3)
The value when that formula is executed is "Adopt" and that is what
shows on the screen.
When I go in from Ruby (via WIN32OLE), I get the number -2146826265
back.

The Ruby snippet that does this is

colIndex = @startCol
colIndex.upto(endCol) {|aCol|
currCell = ("#{@@colnames[aCol-1]}#{aRow}")
@cells << (sheet.Range(currCell) ['Value']).to_s

}
}
end

@cells is an array of individual cells. There are likely to be many
better (faster) ways of getting the range back in one fell swoop, but
right now I am less interested in that. First get answers that you
like, then improve the approacch!

For simple string values, non formula arithmetic values, this delivers
just what it should. However for these complex formulae the result is
always that funky -2146826265. This is also x'800A07E7' which looks
suspiciously like an hresult value.

So the question is, how to I get the displayed value out of the cell
from my Ruby program?

Thanks in advance for any help.

Chris


--
seabird20
------------------------------------------------------------------------
seabird20's Profile:
http://www.excelforum.com/member.php...o&userid=37033
View this thread: http://www.excelforum.com/showthread...hreadid=568252