Value of a range consisting of several cells

enebo / jruby-win32ole

JRuby implementation of win32ole

Other

29 stars 2 forks source link

Value of a range consisting of several cells #22

Open Thomas008 opened 5 years ago

Thomas008 commented 5 years ago

The Value method of a range containing multiple cells causes an ArrayIndexOutOfBoundsException.

For example:

excel = WIN32OLE.new("Excel.Application")
workbook = excel.Workbooks.Open(File.expand_path("workbook.xls") worksheet = workbook.Worksheets.Item(1) range = worksheet.Range(worksheet.Cells(1,1), worksheet.Cells(3,4)) range.Value => ArrayIndexOutOfBoundsException

Thomas008 commented 5 years ago

I have published this issue in the jruby github already, since I did not know where the best place might be (issue 5755).