G
gordon smith
I'm having trouble accessing named ranges in Excel. I can create and
use named ranges during a run of a ruby script, but I cannot use named
ranges from a preexisting workbook.
WIN32OLE::VERSION = Win32OLE: 0.5.9
RUBY_VERSION = 1.8.2
RUBY_RELEASE_DATE = 2004-12-25
Microsoft Excel 2002 in Windows 2000 Pro
I can add and access a named range if both are done from Ruby in the
same script:
# Add a named range.
worksheet.names.Add( { 'Name' => 'myRange', 'RefersTo' =>
worksheet.Range( 'A2' ) } )
# Assign to a named range.
worksheet.range( worksheet.names( 'myRange' ).Value ).value = 2
However, I cannot access named ranges that already exist in a
worksheet.
puts "names.count=#{worksheet.names.Count}"
worksheet.range( worksheet.names( 'foo' ).Value ).value = "bar"
results in:
names.count=0
bluesheet-gui.rb:181:in `method_missing': names (WIN32OLERuntimeError)
OLE error code:800A03EC in <Unknown>
<No Description>
HRESULT error code:0x80020009
Exception occurred. from bluesheet-gui.rb:181:in
`createBluesheet'
from bluesheet-gui.rb:456
from bluesheet-gui.rb:454:in `call'
from bluesheet-gui.rb:61:in `runDuring'
from bluesheet-gui.rb:454
This is a worksheet with ~100 named ranges
Has anyone accessed named ranges in an existing worksheet?
use named ranges during a run of a ruby script, but I cannot use named
ranges from a preexisting workbook.
WIN32OLE::VERSION = Win32OLE: 0.5.9
RUBY_VERSION = 1.8.2
RUBY_RELEASE_DATE = 2004-12-25
Microsoft Excel 2002 in Windows 2000 Pro
I can add and access a named range if both are done from Ruby in the
same script:
# Add a named range.
worksheet.names.Add( { 'Name' => 'myRange', 'RefersTo' =>
worksheet.Range( 'A2' ) } )
# Assign to a named range.
worksheet.range( worksheet.names( 'myRange' ).Value ).value = 2
However, I cannot access named ranges that already exist in a
worksheet.
puts "names.count=#{worksheet.names.Count}"
worksheet.range( worksheet.names( 'foo' ).Value ).value = "bar"
results in:
names.count=0
bluesheet-gui.rb:181:in `method_missing': names (WIN32OLERuntimeError)
OLE error code:800A03EC in <Unknown>
<No Description>
HRESULT error code:0x80020009
Exception occurred. from bluesheet-gui.rb:181:in
`createBluesheet'
from bluesheet-gui.rb:456
from bluesheet-gui.rb:454:in `call'
from bluesheet-gui.rb:61:in `runDuring'
from bluesheet-gui.rb:454
This is a worksheet with ~100 named ranges
Has anyone accessed named ranges in an existing worksheet?