Articles   Members Online:
-Article/Tip Search
-News Group Search over 21 Million news group articles.
-Delphi/Pascal
-CBuilder/C++
-C#Builder/C#
-JBuilder/Java
-Kylix
Member Area
-Home
-Account Center
-Top 10 NEW!!
-Submit Article/Tip
-Forums Upgraded!!
-My Articles
-Edit Information
-Login/Logout
-Become a Member
-Why sign up!
-Newsletter
-Chat Online!
-Indexes NEW!!
Employment
-Build your resume
-Find a job
-Post a job
-Resume Search
Contacts
-Contacts
-Feedbacks
-Link to us
-Privacy/Disclaimer
Embarcadero
Visit Embarcadero
Embarcadero Community
JEDI
Links
How to copy an Excel range into a two-dimensional array Turn on/off line numbers in source code. Switch to Orginial background IDE or DSP color Comment or reply to this aritlce/tip for discussion. Bookmark this article to my favorite article(s). Print this article
14-Apr-04
Category
OLE
Language
Delphi 5.x
Views
181
User Rating
No Votes
# Votes
0
Replies
0
Publisher:
DSP, Administrator
Reference URL:
DKB
			Author: Deborah Pate

How to copy an Excel range into a two-dimensional array 

Answer:

Copy it to a variant, then read the resulting variant array. This will be much 
faster than reading from each Excel cell individually, and it will avoid an Excel 
resource leak that can be critical on Win9x systems.

1   { ... }
2   var
3     ArrV: OleVariant;
4     { ... }
5   
6     ArrV := WS.UsedRange[LCID].Value2;
7     for Row := 1 to VarArrayHighBound(ArrV, 1) - 1 do
8       for Col := 1 to VarArrayHighBound(ArrV, 2) - 1 do
9         Memo1.Lines.Add(Format('Row: %d Col: %d %s', [Row, Col, VarToStr(ArrV[Row,
10          Col])]));
11  end;
12  { ... }


			
Vote: How useful do you find this Article/Tip?
Bad Excellent
1 2 3 4 5 6 7 8 9 10

 

Advertisement
Share this page
Advertisement
Download from Google

Copyright © Mendozi Enterprises LLC