1 update in 1 topic. Kyaw On Oct 28, 2014 10:51 PM, <[email protected]> wrote:
> [email protected] > <https://groups.google.com/forum/?utm_source=digest&utm_medium=email/#!forum/google-spreadsheets-api/topics> > Google > Groups > <https://groups.google.com/forum/?utm_source=digest&utm_medium=email/#!overview> > <https://groups.google.com/forum/?utm_source=digest&utm_medium=email/#!overview> > Topic digest > View all topics > <https://groups.google.com/forum/?utm_source=digest&utm_medium=email/#!forum/google-spreadsheets-api/topics> > > - Import Range problems <#149578f7b25ddcbc_group_thread_0> - 1 Update > > Import Range problems > <http://groups.google.com/group/google-spreadsheets-api/t/9f1772965e90edce?utm_source=digest&utm_medium=email> > Bob Puffer <[email protected]>: Oct 27 09:21AM -0700 > > This has been disabled in the new sheets which you may likely have been > converted to. I use the script below to accomplish the same thing: > > // to be used in the spreadsheet like ImportRange, > // i.e. like this: =myImportRange( "key" ; "sheet!range" ; GoogleClock() ) > // the third parameter - GoogleClock() - triggers an automatic update > every > minute. > // updated 2011-07-17 (ahab): better regex to strip sheetname of *outer* > single quotes > function myImportRange(key ,sheetrange) { > var shra = sheetrange.split("!") ; > if (shra.length==1) shra[1]=shra[0], shra[0]=""; > > var sheetstring = shra[0].replace( /^'(.*)'$/g , "$1") // was: replace( > /'/g , "") ; updated 2011-07-17 (ahab) > var rangestring = shra[1] > > var source = SpreadsheetApp.openById( key ) > if ( sheetstring.length==0 ) sheet = source.getSheets()[0] ; > else sheet = source.getSheetByName( sheetstring ) ; > > return sheet.getRange( rangestring ).getValues(); > } > > On Saturday, October 25, 2014 5:17:09 PM UTC-5, Tyler Hueter wrote: > Back to top <#149578f7b25ddcbc_digest_top> > You received this digest because you're subscribed to updates for this > group. You can change your settings on the group membership page > <https://groups.google.com/forum/?utm_source=digest&utm_medium=email/#!forum/google-spreadsheets-api/join> > . > To unsubscribe from this group and stop receiving emails from it send an > email to [email protected]. > -- You received this message because you are subscribed to the Google Groups "Google Spreadsheets API" group. To unsubscribe from this group and stop receiving emails from it, send an email to [email protected]. For more options, visit https://groups.google.com/d/optout.
