Dave Crozier wrote:
> Ricardo,
> How about using:
>
> Application.DataToClip(<<cWorkarea>>,999999,3)
>
> Then pasting the data into Excel using Automation. That way it is really
> quick.
>
> Dave Crozier
>
Hi Dave,
I'm not using DataToClip, I'm actually copying my records type XLS to an
excel file and then :
oExcel2 = CreateObject("Excel.Application")
oWkbk2 = oExcel2.Workbooks.Open(lcArchXLS)
oExcel2.ActiveSheet.Rows(1).currentregion.select
oExcel2.Selection.copy
oExcel.ActiveSheet.paste
_CLIPTEXT = ""
oExcel2.Quit()
oExcel2 = null
oWkbk2 = null
Your way will certainly be faster, but my problem with both these
methods in not speed but the fact that if the user types <Ctrl>-C while
I'm working he messes the page up.
OTOH inserting every cell using automation (which solves the <Ctrl>-C
problem) is too slow.
>
> -----Original Message-----
> From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf
> Of Ricardo Aráoz
> Sent: 16 August 2007 00:39
> To: ProFox Email List
> Subject: Excel question
>
> Ok, got 135 ProFox (224 Python, 63 Python Tutor, have to stop slacking)
> mails to be read, so I hope this is not yet a subject.
>
> My reports generate Excel files, if the report is too long (more than
> 64000 lines) I use different pages in the same file. I have two ways to
> do it, either I export up to say 15000 lines with a copy to command to a
> temporary excel file, then open it (as an excel object), copy it's
> contents to the clipboard (through excel command) and then copy the
> clipboard to a new page in my multi page excel file. The pro of this
> method is speed, the con is that if the customer uses the clipboard he
> interferes with the report.
> The other way is to insert the data cell by cell, but if the file is too
> large it gets slow.
> Does any of you know of some other way to optimize this?
> TIA
>
_______________________________________________
Post Messages to: [email protected]
Subscription Maintenance: http://leafe.com/mailman/listinfo/profox
OT-free version of this list: http://leafe.com/mailman/listinfo/profoxtech
Searchable Archive: http://leafe.com/archives/search/profox
This message: http://leafe.com/archives/byMID/profox/[EMAIL PROTECTED]
** All postings, unless explicitly stated otherwise, are the opinions of the
author, and do not constitute legal or medical advice. This statement is added
to the messages for those lawyers who are too stupid to see the obvious.
