|
-
March 6th, 2008, 09:50 AM
#1
[RESOLVED] Fast write to excel, no more working.
In VB6, this code worked fine, and was the fastest way to write to excel:
Code:
Dim MyExcelRange As Excel.Range
'Code here filling MyExcelRange with data
'Now, fast copying into excel:
With MyExcelRange
MyExcelWorksheet.Range("A1").Resize(.Rows.Count, .Columns.Count) = MyExcelRange
End With 'MyExcelRange
But now, in VB.NET .Resize() is a read only property, so it no more works.
Is critical to write the data fast, so what is the new fast way to transfer data to excel??
.
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|