From: jim_kerr@... (Jim Kerr)
Date: 2004-11-03T03:08:53+09:00
Subject: segfault in win32ole

I'm trying to use Ruby to read an Excel spreadsheet with 853 rows and
6 columns. Here's the code:

----------
require 'win32ole'
filename = 'G:\My Documents\CXL\bigfile.xls'

xlApp = WIN32OLE.new('Excel.Application')
xlBook = xlApp.Workbooks.Open(filename)

sheet = 1
row1 = 1; col1 = 1
row2 = 800; col2 = 6
sht = xlBook.Worksheets(sheet)
data = sht.Range(sht.Cells(row1,col1), sht.Cells(row2,col2)).Value
----------

  When I run this, ruby segfaults:

J:\scripts>ruby win32crash.rb
win32crash.rb:15: [BUG] Segmentation fault
ruby 1.8.1 (2003-12-25) [i386-mswin32]

This application has requested the Runtime to terminate it in an
unusual way.
Please contact the application's support team for more information.

  Any ideas what's going on here? I'm running under Windows XP
(without SP2).

  I tried reading the spreadsheet a row at a time as a workaround, but
after reading 50 or 60 rows, the same problem occurs.

  FWIW, I tried running the same code under Python (slightly modified,
of course), and it ran just fine.

  Any help would be much appreciated!

Jim