I've
written scripts that read from a spreadsheet with a single worksheet, and it
works well. However, I don't know if you can use multiple
worksheets.
Can
you create a summary worksheet? If so, you can us that specific worksheet
as your input. You just have to give the name of the worksheet (i.e.
"Sheet1") when opening the file in datastation.
Bradley M. Bates
Systems Consultant
Information Management &
Technology
David Thompson Health Region
Phone: (403) 343-4644
Web: www.dthr.ab.ca
-----Original Message-----
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]
Sent: Thursday, April 21, 2005 15:25
To: [email protected]
Subject: [Talk] Reading from an Excel File
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]
Sent: Thursday, April 21, 2005 15:25
To: [email protected]
Subject: [Talk] Reading from an Excel File
Has anyone written a script that reads data from and
Excel file with multiple worksheets?
I am
able to read a .txt file easily but I'm not sure what the trick is for reading
from an excel file. I could convert it to .txt if I have to but I'd rather
not.
Thanks.
Linda Ralston,
ISP
Applications
Analyst
Information
Management
Peace Country
Health
Grande Prairie, AB
Canada
780-538-7135
