Dennis You could just ask whoever is importing the worksheet the sheet number. I've done that in the past where I asked the sheet number and row number.
Buddy -----Original Message----- From: [email protected] [mailto:[email protected]] On Behalf Of Dennis McGrath Sent: Wednesday, July 03, 2013 5:09 PM To: RBASE-L Mailing List Subject: [RBASE-L] - Re: GATEWAY IMPORT Thanks Jason, I could do the same if I wanted to. I prefer all-rbase solutions since they are easier to maintain and run under differing environments. 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 Kramer, Jason J Sent: Wednesday, July 03, 2013 3:40 PM To: RBASE-L Mailing List Subject: [RBASE-L] - Re: GATEWAY IMPORT 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! --
