RE: Excel ranges

2002-10-19 Thread Paul Casteels
s@;ua.ac.be] > Sent: Thursday, October 17, 2002 11:49 PM > To: [EMAIL PROTECTED] > Subject: Excel ranges > > > > I want to copy an array (size 2*8192) to an Excel range. > This works fine : > > xlApp = Dispatch("Excel.Application") > xlApp.

RE: Excel ranges

2002-10-18 Thread Stefan Kuzminski
From: Paul Casteels [mailto:Paul.Casteels@;ua.ac.be] Sent: Thursday, October 17, 2002 11:49 PM To: [EMAIL PROTECTED] Subject: Excel ranges I want to copy an array (size 2*8192) to an Excel range. This works fine : xlApp = Dispatch("Excel.Application") xlApp.Workbooks.Add() xSheet = xl

Excel ranges

2002-10-18 Thread Paul Casteels
I want to copy an array (size 2*8192) to an Excel range. This works fine : xlApp = Dispatch("Excel.Application") xlApp.Workbooks.Add() xSheet = xlApp.ActiveWorkbook.ActiveSheet xSheet.Range(xSheet.Cells(row,col), \ xSheet.Cells(row+aLen-1,col+1)).Value = array but is extremely slow.