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! --
