This can be done, with a certain amount of bad language, using VBScript
and importing the result into a TEMP table. I can write something and post it
to the list in the next day or two if anyone is interested.
Thanks,
Jason
Jason Kramer
University Archives and Records Management
002 Pearson Hall
(302) 831 - 3127 (voice)
(302) 831 - 6903 (fax)
-----Original Message-----
From: [email protected] [mailto:[email protected]] On Behalf Of Dennis McGrath
Sent: Wednesday, July 03, 2013 4:16 PM
To: RBASE-L Mailing List
Subject: [RBASE-L] - Re: GATEWAY IMPORT
True, but sometimes sheets are reorganized without changing the name.
Wouldn't it be nice to have a function to retrieve a list of the sheet names in
a workbook, in their sheet number order?
Dennis McGrath
Software Developer
QMI Security Solutions
1661 Glenlake Ave
Itasca IL 60143
630-980-8461
[email protected]
-----Original Message-----
From: [email protected] [mailto:[email protected]] On Behalf Of A. Razzak Memon
Sent: Wednesday, July 03, 2013 2:55 PM
To: RBASE-L Mailing List
Subject: [RBASE-L] - Re: GATEWAY IMPORT
At 03:42 PM 7/3/2013, Dennis McGrath wrote:
>using the GATEWAY IMPORT XLS syntax one can specify the sheet index.
>
>Is there a way to specify the sheet name rather than the index?
FWIW ...
SHEET_INDEX value parameter is the bullet-proof identifier to specify a
specific sheet of the spreadsheet file, starting with 0.
In addition, very consistent without having to worry about the name that could
be misspelled, duplicated, and/or any name that makes no sense in the R:BASE
world.
Enjoy these cool and gadgets in R:BASE eXtreme!
Very Best R:egards,
Razzak.
www.rbase.com
www.facebook.com/rbase
--
30+ years of continuous innovation!
15 Years of R:BASE Technologies, Inc. making R:BASE what it is today!
--
