Ki`xSrSSKrSSKrSSKJr SSKJr SSKJr SSK J r SSK J r J r JrJrJrJrJrJrJrJrJrJr SSKJr SS KJr SS KJr SS KJr S S K!J"r"J#r#J$r$ \ (aS S K%J&r& S r'\RP"S5r)\RP"S5r*\RP"S5r+\RP"S5r,\RP"S5r-"SS\.\R^5r0"SS\05r1"SS\05r2"SS\05r3"SS\05r4"SS\05r5"SS \05r6"S!S"\05r7"S#S$\05r8"S%S&\05r9"S'S(\05r:"S)S*\05r;"S+S,\05r<"S-S.\05r=S/\S0\4S1jr>S/\ S0\4S2jr?S/\ S0\4S3jr@\"S45rAS5\\A/\B4S6\\AS0\A4S7jrCS|S:\\S;\BS<\ S=\BS0\\\D\E\44 S>jjrFS8S9S8/4S?\\S;\BS<\ S=\BS@\\DS0\\\\D\E\44 SAjjrGSB\DSC\DS0\.4SDjrHSE\.S0\\D\D44SFjrI\\D\E4rJSE\.S0\\J\J44SGjrKS}SH\.SI\\DS0\\.\D44SJjjrLSK\.S0\D4SLjrMSM\SN\A4S0\SN\A44SOjrNSP\.S0\.4SQjrOSR\.S0\.4SSjrPS~SB\\ ST\DSU\ S0\\ 4SVjjrQSSW\\\ SX\\DSY\\DSU\ S0\\\ 4 SZjjrRS[\S\S0\\\\.4S]jrSSS:\.S^\.S_\.S0\.4S`jjrS}Sa\.Sb\\.S0\.4ScjjrTSd\ S0\B4SejrUSf\\.\ 4S?\\\ Sg\DSh\DS0\\\ 4 SijrVSj\.S0\\.\E44SkjrWSSl\ESm\ESn\ES0\.4SojjrXSb\.S0\B4SpjrYSb\.S0\.4SqjrZ///4Sr\\ S?\\\ S0\\\.\\.\D\E444Ssjjr[S?\\\.St\DSu\DSB\DS0\D4 Svjr\S?\\\.St\DSu\DSC\DS0\D4 Swjr]\=R4S?\\\.Sx\.Sy\=S0\\\.4Szjjr_\`S{:XaSSKara\aR"5 gg)zG gspread.utils ~~~~~~~~~~~~~ This module contains utility functions. N) defaultdict)Sequence)wraps)chain) TYPE_CHECKINGAnyAnyStrCallableDictIterableListMappingOptionalTupleTypeVarUnion)quote) Credentials)IncorrectCellLabelInvalidInputValueNoValidUrlKeyFound)Cell@z([A-Za-z]+)([1-9]\d*)z([A-Za-z]+)?([1-9]\d*)?$z[A-Za-z]+\d+:[A-Za-z]+\d+z key=([^&#]+)z /spreadsheets/d/([a-zA-Z0-9-_]+)c4^\rSrSrU4SjrSrSrSrU=r$)StrEnum2c>[U[[R45(d[ SU<S[ U535e[ TU]"X/UQ70UD6$)Nz$Values of StrEnums must be strings: z is a ) isinstancestrenumauto TypeErrortypesuper__new__)clsvalueargskwargs __class__s `C:\Users\julio\OneDrive\Documentos\Trabajo\Ideas Frescas\venv\Lib\site-packages\gspread/utils.pyr&StrEnum.__new__3sU%#tyy!1226uivd5k]S ws;D;F;;c,[UR5$N)r r()selfs r,__str__StrEnum.__str__:s4::r.cU$r0)name_s r,_generate_next_value_StrEnum._generate_next_value_=s r.r5) __name__ __module__ __qualname____firstlineno__r&r2r8__static_attributes__ __classcell__)r+s@r,rr2s<r.rc\rSrSrSrSrSrg) DimensionAROWSCOLUMNSr5N)r:r;r<r=rowscolsr>r5r.r,rArAAs D Dr.rAc \rSrSrSrSrSrSrg) MergeTypeF MERGE_ALL MERGE_COLUMNS MERGE_ROWSr5N)r:r;r<r= merge_all merge_columns merge_rowsr>r5r.r,rHrHFsI#MJr.rHc \rSrSrSrSrSrSrg)ValueRenderOptionLFORMATTED_VALUEUNFORMATTED_VALUEFORMULAr5N)r:r;r<r= formatted unformattedformular>r5r.r,rQrQLs!I%KGr.rQc\rSrSrSrSrSrg)ValueInputOptionRRAW USER_ENTEREDr5N)r:r;r<r=raw user_enteredr>r5r.r,rZrZRs C!Lr.rZc\rSrSrSrSrSrg)InsertDataOptionW OVERWRITE INSERT_ROWSr5N)r:r;r<r= overwrite insert_rowsr>r5r.r,raraWs IKr.rac\rSrSrSrSrSrg)DateTimeOption\ SERIAL_NUMBERFORMATTED_STRINGr5N)r:r;r<r= serial_numberformatted_stringr>r5r.r,rhrh\s #M)r.rhc0\rSrSrSrSrSrSrSrSr Sr S r g ) MimeTypeaz'application/vnd.google-apps.spreadsheetzapplication/pdfzAapplication/vnd.openxmlformats-officedocument.spreadsheetml.sheetztext/csvz.application/vnd.oasis.opendocument.spreadsheetztext/tab-separated-valueszapplication/zipr5N) r:r;r<r= google_sheetspdfexcelcsvopen_office_sheettsvzipr>r5r.r,roroas&=M C OE CH %C Cr.roc\rSrSr\R r\Rr\Rr \Rr \Rr\RrSrg) ExportFormatkr5N)r:r;r<r=rorrPDFrsEXCELrtCSVruOPEN_OFFICE_SHEETrvTSVrw ZIPPED_HTMLr>r5r.r,ryryks; ,,C NNE ,,C 22 ,,C,,Kr.ryc0\rSrSrSrSrSrSrSrSr Sr Sr g ) PasteTypet PASTE_NORMAL PASTE_VALUES PASTE_FORMATPASTE_NO_BORDERSPASTE_DATA_VALIDATIONPASTE_CONDITIONAL_FORMATTINGr5N) r:r;r<r=normalvaluesformat no_bordersrXdata_validationconditional_formatingr>r5r.r,rrts& F F F#J G-O:r.rc\rSrSrSrSrSrg)PasteOrientation~NORMAL TRANSPOSEr5N)r:r;r<r=r transposer>r5r.r,rr~s FIr.rc\rSrSrSrSrSrg) GridRangeType ValueRange ListOfListsr5N)r:r;r<r=rrr>r5r.r,rrs JKr.rc\rSrSrSrSrSrSrSrSr Sr S r S r S r S rS rSrSrSrSrSrSrSrSrSrSrSrSrSrSrSrSrSr Sr!S r"S!r#S"r$g#)$ValidationConditionTypeNUMBER_GREATERNUMBER_GREATER_THAN_EQ NUMBER_LESSNUMBER_LESS_THAN_EQ NUMBER_EQ NUMBER_NOT_EQNUMBER_BETWEENNUMBER_NOT_BETWEEN TEXT_CONTAINSTEXT_NOT_CONTAINSTEXT_STARTS_WITHTEXT_ENDS_WITHTEXT_EQ TEXT_IS_EMAIL TEXT_IS_URLDATE_EQ DATE_BEFORE DATE_AFTERDATE_ON_OR_BEFOREDATE_ON_OR_AFTER DATE_BETWEENDATE_NOT_BETWEEN DATE_IS_VALID ONE_OF_RANGE ONE_OF_LISTBLANK NOT_BLANKCUSTOM_FORMULABOOLEAN TEXT_NOT_EQ DATE_NOT_EQFILTER_EXPRESSIONr5N)%r:r;r<r=number_greaternumber_greater_than_eq number_lessnumber_less_than_eq number_eq number_not_eqnumber_betweennumber_not_between text_containstext_not_containstext_starts_withtext_ends_withtext_eq text_is_email text_is_urldate_eq date_before date_afterdate_on_or_beforedate_on_or_after date_betweendate_not_between date_is_valid one_of_range one_of_listblank not_blankcustom_formulaboolean text_not_eq date_not_eqfilter_expressionr>r5r.r,rrs%N5K/I#M%N-#M+)%NG#MKGKJ+)!L)#M!LK EI%NGKK+r.rc \rSrSrSrSrSrSrg)TableDirectionTABLEDOWNRIGHTr5N)r:r;r<r=tabledownrightr>r5r.r,rrs E D Er.r credentialsreturncURnURRnSU;aUS:Xa [U5$SU;aUS;a [ U5$[ U[ 5(aU$[S5e)N oauth2clientServiceAccountCredentials)OAuth2CredentialsAccessTokenCredentialsGoogleCredentialszDCredentials need to be from either oauth2client or from google-auth.)r;r+r:_convert_service_account_convert_oauthrrr#)rmoduler's r,convert_credentialsrs}  # #F    ( (CC+F$F' 44 6 !c.' k** K - - N r.c [URURURURUR UR UR5$r0)UserCredentials access_token refresh_tokenid_token token_uri client_id client_secretscopes)rs r,rrsN   !!!! r.cURnURUS'URR5=(d SS/n[R "XS9$)Nrz%https://www.googleapis.com/auth/drivez%https://spreadsheets.google.com/feeds)r)serialization_datar_scopessplitrfrom_service_account_info)rdatars r,rrsT  ) )D#--D  & & (//-F % > >t SSr.Tfuncseqc.^[U4SjU55$)zFFinds and returns first item in iterable for which func(item) is True.c3F># UHnT"U5(dMUv M g7fr0r5).0itemrs r, finditem..s3T s! !)next)rrs` r,finditemr s 33 33r.Fr( empty2zero default_blank%allow_underscores_in_numeric_literalsc@Un[U[5(aASU;aU(dU$URSS5nURSS5n[U5nU$U$![a8 [ U5nU$![a US:Xa U(aSnO UnU$f=fU$f=f)aReturns a value that depends on the input: - Float if input is a string that can be converted to Float - Integer if input is a string that can be converted to integer - Zero if the input is a string that is empty and empty2zero flag is set - The unmodified input value, otherwise. Examples:: >>> numericise("faa") 'faa' >>> numericise("3") 3 >>> numericise("3_2", allow_underscores_in_numeric_literals=False) '3_2' >>> numericise("3_2", allow_underscores_in_numeric_literals=True) 32 >>> numericise("3.1") 3.1 >>> numericise("2,000.1") 2000.1 >>> numericise("", empty2zero=True) 0 >>> numericise("", empty2zero=False) '' >>> numericise("", default_blank=None) >>> >>> numericise("", default_blank="foo") 'foo' >>> numericise("") '' >>> numericise(None) >>> r7r ,r)rr replaceint ValueErrorfloat)r(rrr numericised cleaned_values r, numericisersf8=K% %<8 MM#r*E c2.  4m,K ; 4 4#M2   4B;!&' &3  4$  4s< A B& A44B BBBBBBrignorec U=(d /n[[U55Vs/sHnUS-U;aXO [XUUUS9PM nnU$s snf)aReturns a list of numericised values from strings except those from the row specified as ignore. :param list values: Input row :param bool empty2zero: (optional) Whether or not to return empty cells as 0 (zero). Defaults to ``False``. :param Any default_blank: Which value to use for blank cells, defaults to empty string. :param bool allow_underscores_in_numeric_literals: Whether or not to allow visual underscores in numeric literals :param list ignore: List of ints of indices of the row (index 1) to ignore numericising. r)rrr)rangelenr)rrrrrindexnumericised_lists r,numericise_allr .st*\rF3v;' (EqyF" M %+6[  (   s%A rowcolcUS:dUS:a[SRX55eUnSnU(a9[US5up$US:XaSnUS-n[U[-5U-nU(aM9SRX05nU$)amTranslates a row and column cell address to A1 notation. :param row: The row of the cell to be converted. Rows start at index 1. :type row: int, str :param col: The column of the cell to be converted. Columns start at index 1. :type row: int, str :returns: a string containing the cell's coordinates in A1 notation. Example: >>> rowcol_to_a1(1, 1) A1 rz({}, {})r rz{}{})rrdivmodchr MAGIC_NUMBER)r!r"div column_labelmodlabels r, rowcol_to_a1r,Vs& Qw#' !2!23!<== CL C_  !8C 1HC3-.= # MM, ,E Lr.r+c<[RU5nU(avURS5R5n[ URS55nSn[ [ U55H upVU[U5[- SU--- nM" X44$[U5e)a0Translates a cell's address in A1 notation to a tuple of integers. :param str label: A cell label in A1 notation, e.g. 'B1'. Letter case is ignored. :returns: a tuple containing `row` and `column` numbers. Both indexed from 1 (one). :rtype: tuple Example: >>> a1_to_rowcol('A1') (1, 1) rrr$) CELL_ADDR_REmatchgroupupperr enumeratereversedordr'rr+mr)r!r"ics r, a1_to_rowcolr:{s 5!Awwqz'') !''!*oh|45DA CF\)b!e4 4C6 :!''r.cr[RU5nU(aUR5up#U(aISn[[ UR 555H upVU[ U5[- SU--- nM" O [S5nU(a[U5nX44$[S5nX44$[U5e)aTranslates a cell's address in A1 notation to a tuple of integers. Same as `a1_to_rowcol()` but allows for missing row or column part (e.g. "A" for the first column) :returns: a tuple containing `row` and `column` numbers. Both indexed from 1 (one). :rtype: tuple Example: >>> _a1_to_rowcol_unbounded('A1') (1, 1) >>> _a1_to_rowcol_unbounded('A') (inf, 1) >>> _a1_to_rowcol_unbounded('1') (1, inf) >>> _a1_to_rowcol_unbounded('ABC123') (123, 731) >>> _a1_to_rowcol_unbounded('ABC') (inf, 731) >>> _a1_to_rowcol_unbounded('123') (123, inf) >>> _a1_to_rowcol_unbounded('1A') Traceback (most recent call last): ... gspread.exceptions.IncorrectCellLabel: 1A >>> _a1_to_rowcol_unbounded('') (inf, inf) rr$inf) A1_ADDR_ROW_COL_REr0groupsr3r4r2r5r'rrrr6s r,_a1_to_rowcol_unboundedr?sN   'AHHJ  C!(<+=+=+?"@AA-"a%88B,C c(C : ,C :!''r.r6sheet_idc:URS5up#n[U5upV[U=(d U5upxXW:aXupuXh:aXpUS- UUS- US.n U R5V V s0sHup[U [5(dMX_M n n n UbXS'U $s sn n f)aConverts a range defined in A1 notation to a dict representing a `GridRange`_. All indexes are zero-based. Indexes are half open, e.g the start index is inclusive and the end index is exclusive: [startIndex, endIndex). Missing indexes indicate the range is unbounded on that side. .. _GridRange: https://developers.google.com/sheets/api/reference/rest/v4/spreadsheets/other#GridRange Examples:: >>> a1_range_to_grid_range('A1:A1') {'startRowIndex': 0, 'endRowIndex': 1, 'startColumnIndex': 0, 'endColumnIndex': 1} >>> a1_range_to_grid_range('A3:B4') {'startRowIndex': 2, 'endRowIndex': 4, 'startColumnIndex': 0, 'endColumnIndex': 2} >>> a1_range_to_grid_range('A:B') {'startColumnIndex': 0, 'endColumnIndex': 2} >>> a1_range_to_grid_range('A5:B') {'startRowIndex': 4, 'startColumnIndex': 0, 'endColumnIndex': 2} >>> a1_range_to_grid_range('A1') {'startRowIndex': 0, 'endRowIndex': 1, 'startColumnIndex': 0, 'endColumnIndex': 1} >>> a1_range_to_grid_range('A') {'startColumnIndex': 0, 'endColumnIndex': 1} >>> a1_range_to_grid_range('1') {'startRowIndex': 0, 'endRowIndex': 1} >>> a1_range_to_grid_range('A1', sheet_id=0) {'sheetId': 0, 'startRowIndex': 0, 'endRowIndex': 1, 'startColumnIndex': 0, 'endColumnIndex': 1} :r) startRowIndex endRowIndexstartColumnIndexendColumnIndexsheetId) partitionr?itemsrr) r6r@ start_labelr7 end_labelstart_row_indexstart_column_index end_row_indexend_column_index grid_rangekeyr(filtered_grid_ranges r,a1_range_to_grid_rangerSsJ!%s 3KI*A+*N'O&=i>V;&W#M&)6,/?,)1,$.2* J(2'7'7'9+'9|Zs=S  '9+)1I& +s &BBcolumnc[U5up[ U[ 5(d[SRU55eU$![a [SRU55ef=f)aConverts a column letter to its numerical index. This is useful when using the method :meth:`gspread.worksheet.Worksheet.col_values`. Which requires a column index. This function is case-insensitive. Raises :exc:`gspread.exceptions.InvalidInputValue` in case of invalid input. Examples:: >>> column_letter_to_index("a") 1 >>> column_letter_to_index("A") 1 >>> column_letter_to_index("AZ") 52 >>> column_letter_to_index("!@#$%^&") ... gspread.exceptions.InvalidInputValue: invalid value: !@#$%^&, must be a column letter z*invalid value: {}, must be a column letter)r?rrrrr)rTr7rs r,column_letter_to_indexrVsr2 ,V4  eS ! ! 8 ? ? G   L   8 ? ? G   s A%A%method.c ^^S[[S4S[4Sjm[T5S[S[S[S[4UU4Sjj5nU$)zQDecorator function casts wrapped arguments to A1 notation in range method calls. r).rc[US[5=(aG [US[5=(a- [US[5=(a [US[5$)Nrrr.)rr)r)s r,contains_row_cols.cast_to_a1_notation..contains_row_colsIsP tAw $ )47C( )47C( )47C(  r.r1r*c>[U5S:a>T"U5(a1[USS6n[USS6nSRX445nU4USS-nT"U/UQ70UD6$![a Nf=f)Nr.rB)rr,joinr)r1r)r* range_start range_end range_namer[rWs r,wrapper$cast_to_a1_notation..wrapperQs 4yA~"3D"9"9+D!H5 ($q)4  XX{&>? "}tABx/d,T,V,,   sA A A)(A))rrboolr)rWrcr[s` @r,cast_to_a1_notationrfDsY  c3h D  6]-c-#---- Nr.urlc[RU5nU(aURS5$[RU5nU(aURS5$[e)Nr) URL_KEY_V2_REsearchr1 URL_KEY_V1_REr)rgm2m1s r,extract_id_from_urlrnesJ   c "B xx{   c "B xx{ r.widc[U5S:aUSSOUn[U5S:aSOSn[[US5U- 5$)z*Calculate gid of a worksheet from its wid.rZrNiiZ{$)rr r)rowidvalxorvals r, wid_to_gidrtqs@C1 SW#FHqLSeF s62' ((r.max_len padding_valuec>U[U5- nUS:waX/U--$U$)Nrr)r!rurvpad_lens r,rightpadrzxs+C G071 3/G+ ,E#Er.LrErFc Uc[SU55OUnUc [U5OUnU[U5- nU(a U//U--nUVs/sH n[XtUS9PM sn$s snf![a //s$f=f)aFill gaps in a list of lists. e.g.,:: >>> L = [ ... [1, 2, 3], ... ] >>> fill_gaps(L, 2, 4) [ [1, 2, 3, ""], ["", "", "", ""] ] :param L: List of lists to fill gaps in. :param rows: Number of rows to fill. :param cols: Number of columns to fill. :param padding_value: Default value to fill gaps with. :type L: list[list[T]] :type rows: int :type cols: int :type padding_value: T :return: List of lists with gaps filled. :rtype: list[list[T]]: c38# UHn[U5v M g7fr0rxrr!s r,r fill_gaps..s-1Cs3xx1)rv)maxrrzr)r{rErFrvmax_colsmax_rowspad_rowsr!s r, fill_gapsr}s> 153-1--4!\3q6tc!f$ bTH_%APQRPQmDPQRRR t s$A A' A"A'"A'' A76A7 cell_listrc tU(d/$[[5n[SU55n[SU55nUHFnUR[ UR 5U- 05nUR XTRU- 'MH U(d/$[R"SUR555n[[U5S-5n[[UR55S-5nUV V s/sH&oV s/sHoU RU 5PM sn PM( sn n $s sn fs sn n f)Nc38# UHoRv M g7fr0)r!rr9s r,r $cell_list_to_rect...IqUUIrc38# UHoRv M g7fr0)r"rs r,r rrrc3@# UHoR5v M g7fr0)keysr~s r,r rs&K]cxxzz]sr)rdictmin setdefaultrr!r(r"r from_iterablerrrrget) rrE row_offset col_offsetcellr! all_row_keys rect_cols rect_rowsr8js r,cell_list_to_rectrs  0;D0AD.I..J.I..Jooc$((mj8"=%)ZZHHz !"  &&&KT[[]&KKLc,'!+,Ic$))+&*+I :C CAY /Y!W[[^Y / CC / Cs> D4D/ $D4/D4safeencodingc8[URU5U5$r0)uquoteencode)r(rrs r,rrs %,,x($ //r. sheet_namerbcxSRURSS55nU(aSRX5$U$)ayReturn an absolutized path of a range. >>> absolute_range_name("Sheet1", "A1:B1") "'Sheet1'!A1:B1" >>> absolute_range_name("Sheet1", "A1") "'Sheet1'!A1" >>> absolute_range_name("Sheet1") "'Sheet1'" >>> absolute_range_name("Sheet'1") "'Sheet''1'" >>> absolute_range_name("Sheet''1") "'Sheet''''1'" >>> absolute_range_name("''sheet12''", "A1:B2") "'''''sheet12'''''!A1:B2" z'{}''z''z{}!{})rr)rrbs r,absolute_range_namers7*z11#t<=J~~j55r.xcZ[U[5=(d [U[5(+$)zReturn True if the value is scalar. A scalar is not a sequence but can be a string. >>> is_scalar([]) False >>> is_scalar([1, 2]) False >>> is_scalar(42) True >>> is_scalar('nice string') True >>> is_scalar({}) True >>> is_scalar(set()) True )rr r)rs r, is_scalarrs . a  >> convert_hex_to_colors_dict("#3300CC") {'red': 0.2, 'green': 0.0, 'blue': 0.8} >>> convert_hex_to_colors_dict("#30C") {'red': 0.2, 'green': 0.0, 'blue': 0.8} #NrZr r.z/Hex color code must be in the format '#RRGGBB'.rr^)redgreenbluez(Invalid character in hex color string: #)lstriprr_rr)rchar rgb_colorexs r,convert_hex_to_colors_dictrFs&  %I  9~crN  9~GG)<)$AX)<=  9~JKK Yy1~r*S01Q,s2 !A+c1 = YCI;OPVXXYsB,47B11 C;C  CrrrcS[S[4Sjn[SXU455(a [S5eSU"U5U"U5U"U53$)aConvert RGB color values to a hex color code. :param float red: Red color value (0-1). :param float green: Green color value (0-1). :param float blue: Blue color value (0-1). :returns: Hex color code in the format "#RRGGBB". :rtype: str :raises: ValueError: If any color value is out of the accepted range (0-1). Example: >>> convert_colors_to_hex_value(0.2, 0, 0.8) '#3300CC' >>> convert_colors_to_hex_value(green=0.5) '#008000' r(rct[[US-55SSnUR5RS5$)z7 Convert an integer to a 2-digit uppercase hex string. rr.N)hexroundr2zfill)r( hex_values r,to_hex+convert_colors_to_hex_value..to_hexs6eck*+AB/  &&q))r.c3B# UHoS:=(d US:v M g7f)rrNr5)rr(s r,r .convert_colors_to_hex_value..s B/Ae19 ! !/Asz&Color value out of accepted range 0-1.r)rr anyr)rrrrs r,convert_colors_to_hex_valuertsZ0*e** BD/A BBBABB vc{mF5M?6$<. 99r.c0[RU5SL$)adCheck if the range name is a full A1 notation. "A1:B2", "Sheet1!A1:B2" are full A1 notations "A1:B", "A1" are not Args: range_name (str): The range name to check. Returns: bool: True if the range name is a full A1 notation, False otherwise. Examples: >>> is_full_a1_notation("A1:B2") True >>> is_full_a1_notation("A1:B") False N)A1_ADDR_FULL_RErjrbs r,is_full_a1_notationrs&  ! !* -T 99r.c:SU;aURS5S$U$)zGet the A1 notation from an absolute range name. "Sheet1!A1:B2" -> "A1:B2" "A1:B2" -> "A1:B2" Args: range_name (str): The range name to check. Returns: str: The A1 notation of the range name stripped of the sheet. !r)rrs r,get_a1_from_absolute_rangers( j$Q'' r.headersc VUVs/sHn[[X55PM sn$s snf)azBuilds the list of dictionaries, all of them have the headers sequence as keys set, each key is associated to the corresponding value for the same index in each list from the matrix ``values``. There are as many dictionaries as they are entry in the list of given values. :param list: headers the key set for all dictionaries :param list: values a matrix of values Examples:: >>> to_records(["name", "City"], [["Spiderman", "NY"], ["Batman", "Gotham"]]) [ { "Name": "Spiderman", "City": "NY", }, { "Name": "Batman", "City": "Gotham", }, ] )rrw)rrr!s r, to_recordsrs&406 6vDW" #v 66 6s&startendcVXRSX5S- $![a Us$f=f)zThis is a private function, returning the column index of the last non empty cell on the given row. Search starts from ``start`` index column. Search ends on ``end`` index column. Searches only in the row pointed by ``row``. r r)rr)rrrr!s r, _expand_rightrs5{  U0144  s  ((c[X5HEnU[U5:a[U5S- s $U[X5:d XUS:XdM@US- s $ US- $)zThis is a private function, returning the row index of the last non empty cell on the given column. Search starts from ``start`` index row. Search ends on ``end`` index row. Searches only in the column pointed by ``col``. rr )rr)rrrr"rEs r,_expand_bottomrs`e! 3v; v;? " #fl# #v|C'8B'>!8O" 7Nr. start_range directionc [U5up4US-nUS-nU[U5:a$[SRU[U555eU[X5:a&[SRU[X555eU[R :XaUn[ X[U5U5nU[R:XaUn[X[X5U5nU[R:Xa.[X[X5U5n[ X[U5U5n/nXWS-HnURXWS-5 M U$)aExpands a list of values based on non-null adjacent cells. Expand can be done in 3 directions defined in :class:`~gspread.utils.TableDirection` * ``TableDirection.right``: expands right until the first empty cell * ``TableDirection.down``: expands down until the first empty cell * ``TableDirection.table``: expands right until the first empty cell and down until first empty cell In case of empty result an empty list is restuned. When the given ``start_range`` is outside the given matrix of values the exception :class:`~gspread.exceptions.InvalidInputValue` is raised. Example:: values = [ ['', '', '', '', '' ], ['', 'B2', 'C2', '', 'E2'], ['', 'B3', 'C3', '', 'E3'], ['', '' , '' , '', 'E4'], ] >>> utils.find_table(TableDirection.table, 'B2') [ ['B2', 'C2'], ['B3', 'C3'], ] .. note:: the ``TableDirection.table`` will look right from starting cell then look down from starting cell. It will not check cells located inside the table. This could lead to potential empty values located in the middle of the table. .. warning:: Given values must be padded with `''` empty values. :param list[list] values: values where to find the table. :param gspread.utils.TableDirection direction: the expand direction. :param str start_range: the starting cell range. :rtype list(list): the resulting matrix rz\given row for start_range is outside given values: start range row ({}) >= rows in values {}zegiven column for start_range is outside given values: start range column ({}) >= columns in values {}) r:rrrrrrrrrappend) rrrr!r" rightMost bottomMostresultrEs r, find_tablersG`K(HC1HC1HC c&k j q qS[    c&+ s z zS%   N''' #FVcB N((( !&s6;/?E N(((!&s6;/?E #FVcB FZ!^, dQ/0- Mr.__main__)Fr Fr0)r )NNr )r zutf-8)rr)c__doc__r!re collectionsrcollections.abcr functoolsr itertoolsrtypingrrr r r r r rrrrr urllib.parserrgoogle.auth.credentialsrgoogle.oauth2.credentialsrgoogle.oauth2.service_accountr exceptionsrrrrrr'compiler/r=rrkrir EnumrrArHrQrZrarhroryrrrrrrrrrrer rrrr r,r:IntOrInfr?rSrVrfrnrtrzrrrrrrrrrrrrrrr:doctesttestmodr5r.r,rsD #$    )>DRQQ zz23 ZZ ;<**9: ?+  >?  c499    "w"  w *W* w7;;w  G ,g ,FW [[&   T#T+T CL48QCI&4Xa[4Q427 H F HHH,0 H eC&'( HZ27 % L%%%,0 % I %  (5eV+, -. %P"c"""Jc3h: e :3:581C+D:z?? ?cSVh?D'3'3'Ta 0Xc1f5EB S S )C)C)F$s)FcF#FtCyF * DI* 3-* 3-* *  $s)_ *ZDfD$tHSM7J2KD600C00#0CXc]c:===4CS)C cOCC C  $s)_ CL+Y#+Y'#u*2E+Y^9<": ":"":05":":J:C:D:, 3 3 " B47 c]7)1(3-)@7 $sE#sE/** +,7: $tCy/ # C c c 4S ?3Sss.!/ 4 4V cOVVV $s)_ Vl z OOr.