Greetings,
Unfortunately, there's not a property that does this since the DataStation
accesses the file "line by line".
An "after the fact count" can be obtained using:
F("RC")=d.record
d.record tells you the current record it is reading. If this is put in a
strategic place in your script, it will keep "incrementing" as the script
progresses, and when it reaches the end of the file, F("RC") would be equal
to the last record in the file, which would also be the total number of
records.
Since you're using Excel ,there <may> be an "backdoor" here. I've cc'd a
resident expert here that may know this.
Regards,
Thom
Thom C. Blackwell
Product Manager
Boston Software Systems
(866) 653-5105 ex 807
www.bossoft.com <http://www.bossoft.com/>
Visit us in Booth 2471 at HIMSS08 - February 25-28 in Orlando, FL
Sign <http://www.bostonworkstation.com/customer_center/special_events.aspx>
up for my weekly webinar!
LEGAL NOTICE Unless expressly stated otherwise, this message is confidential
and may be privileged. It is intended for the addressee(s) only. Access to
this E-mail by anyone else is unauthorized. If you are not an addressee, any
disclosure or copying of the contents of this E-mail or any action taken (or
not taken) in reliance on it is unauthorized and may be unlawful. If you are
not an addressee, please inform the sender immediately, then delete this
message and empty from your trash.
From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED] On Behalf Of Heather Castillo
Sent: Friday, February 15, 2008 10:50 AM
To: [email protected]
Subject: [Talk] Row Count
Anyone happen to know a simple object/function to count the number of rows
in an excel spreadsheet from the datastation and return that as a variable?
I think I am making this way more difficult than it needs to be....
Thanks!
---------------------------------------
Heather Castillo
Module Coordinator/HPMIN Support
Information Systems
785.623.5084
HaysMedicalCenter
<mailto:[EMAIL PROTECTED]> [EMAIL PROTECTED]
