def xl_range_formula(sheetname, first_row, first_col, last_row, last_col):
 cell_range = xl_range_abs(first_row, first_col, last_row, last_col)
 sheetname = quote_sheetname(sheetname)
 return ((sheetname + '!') + cell_range)

def xl_range_formula ( sheetname , first_row , first_col , last_row , last_col ) : cell_range = xl_range_abs ( first_row , first_col , last_row , last_col ) sheetname = quote_sheetname ( sheetname ) return ( ( sheetname + '!' ) + cell_range )
convert worksheet name and zero indexed row and col cell references to a sheet1!a1:b1 range formula string .