From: David Naseby <david.naseby@...>
Date: 2002-01-17T07:41:21+09:00
Subject: RE: Windows Automation

> > The Pragmatic Programmers guide talks about creating charts thru
> > Excel..........It says" -4100 is the value for the Excel constant
> > xl3DColumn".........How can u get the values for other Excel
> > constants..........for creating diff kinds of charts
> > Regds
> > Suresh

To get constants out of win32ole for excel, try:

require 'win32ole'
#lifted from my (one day to be published, maybe) rexcel package

module EXCEL_CONST
   	def show_constants
      	EXCEL_CONST.constants.sort.each do |c|
        		puts "#{c} = #{EXCEL_CONST.const_get(c)}"
      	end
   	end
end

if __FILE__ == $0
	app = WIN32OLE.new('Excel.Application')
	WIN32OLE.const_load(app, EXCEL_CONST)
	EXCEL_CONST.show_constants
end

This should produce a god awful long list. Try sticking a grep in
show_constants to look for, say, "3D". The following snippet shows how to
use the module constants:

def get_column()
  @rng.Select
  @rng = @application.Range(@rng.Offset(1), @rng.End
(EXCEL_CONST.const_get('XlDown')))
end

HTH,
David Naseby