Functions — github.com/asweigart/ezsheets

hub / github.com/asweigart/ezsheets / functions

Functions133 in github.com/asweigart/ezsheets

Retrieve the value in a cell. The arguments to `get()` can either be two integers (column and row) or a single string such as 'A1'.

src/ezsheets/__init__.py:882

↓ 34 callersMethodcreateSheet

Create a new Sheet object in this Spreadsheet.

src/ezsheets/__init__.py:432

↓ 26 callersMethoddelete

(self)

src/ezsheets/__init__.py:1475

↓ 24 callersFunction_makeRequest

(requestType, **kwargs)

src/ezsheets/__init__.py:117

↓ 24 callersMethodgetRows

(self, startRow=1, stopRow=None)

src/ezsheets/__init__.py:943

↓ 22 callersMethodgetColumns

(self, startColumn=1, stopColumn=None)

src/ezsheets/__init__.py:988

↓ 17 callersMethodrefresh

(self)

src/ezsheets/__init__.py:1004

↓ 16 callersMethodupdate

(self, *args)

src/ezsheets/__init__.py:1105

↓ 13 callersFunctioncheckIfSpreadsheetInOriginalState

()

tests/test_ezsheets.py:17

↓ 13 callersMethodresize

(self, columnCount=None, rowCount=None)

src/ezsheets/__init__.py:1493

↓ 12 callersMethodgetColumn

(self, colNum)

src/ezsheets/__init__.py:970

↓ 11 callersMethodupdateRows

(self, rows, startRow=1)

src/ezsheets/__init__.py:1259

↓ 10 callersFunctiongetColumnLetterOf

getColumnLetterOf(1) => 'A', getColumnLetterOf(27) => 'AA

src/ezsheets/__init__.py:1676

↓ 10 callersMethodgetRow

(self, rowNum)

src/ezsheets/__init__.py:928

↓ 10 callersMethodupdateColumns

(self, columns, startColumn=1)

src/ezsheets/__init__.py:1320

↓ 8 callersMethodupdateColumn

(self, column, values)

src/ezsheets/__init__.py:1210

↓ 7 callersFunction_logWriteRequest

Logs a write request to the `_WRITE_REQUESTS` deque. This function should be called whenever a Google Sheets write request is made. It will a

src/ezsheets/__init__.py:68

↓ 7 callersMethod_updateGridProperties

(self)

src/ezsheets/__init__.py:1062

↓ 7 callersMethodclear

(self)

src/ezsheets/__init__.py:1426

↓ 7 callersMethodupdateRow

(self, row, values)

src/ezsheets/__init__.py:1167

↓ 6 callersMethod_download

(self, filename=None, _fileType="spreadsheet")

src/ezsheets/__init__.py:456

↓ 6 callersFunctioninit

( credentialsFile='.', sheetsTokenFile="token-sheets.pickle", driveTokenFile="token-drive.pickle",

src/ezsheets/__init__.py:1737

↓ 5 callersMethod_enlargeIfNeeded

(self, requestedColumn=None, requestedRow=None)

src/ezsheets/__init__.py:1095

↓ 4 callersFunction_logReadRequest

Logs a read request to the `_READ_REQUESTS` deque. This function should be called whenever a Google Sheets read request is made. It will also

src/ezsheets/__init__.py:93

↓ 4 callersFunctiongetColumnNumberOf

getColumnNumberOf('A') => 1, getColumnNumberOf('AA') => 27

src/ezsheets/__init__.py:1693

↓ 3 callersFunctionconvertToColumnRowInts

(arg)

src/ezsheets/__init__.py:1635

↓ 3 callersMethoddelete

(self, permanent=False)

src/ezsheets/__init__.py:496

↓ 3 callersMethodrefresh

Updates this Spreadsheet object's Sheet objects with the current data of the spreadsheet and sheets on Google sheets.

src/ezsheets/__init__.py:251

↓ 2 callersFunction_getTabColorArg

(value)

src/ezsheets/__init__.py:1595

↓ 2 callersMethod_refreshData

(self)

src/ezsheets/__init__.py:1038

↓ 2 callersMethod_refreshPropertiesWithSheetPropertiesDict

(self, sheetPropsDict)

src/ezsheets/__init__.py:1019

↓ 2 callersMethodcopyTo

(self, destinationSpreadsheet)

src/ezsheets/__init__.py:1451

↓ 2 callersMethoddownloadAsExcel

(self, filename=None)

src/ezsheets/__init__.py:481

↓ 2 callersMethodindex

The integer index of this Sheet in it's Spreadsheet's tuple of Sheet objects.

src/ezsheets/__init__.py:634

↓ 1 callersFunction_makeFilenameSafe

(filename)

src/ezsheets/__init__.py:529

↓ 1 callersMethod_refreshProperties

(self)

src/ezsheets/__init__.py:1008

↓ 1 callersFunctioncreateSpreadsheet

(title="Untitled spreadsheet")

src/ezsheets/__init__.py:1650

↓ 1 callersMethoddownloadAsCSV

(self, filename=None)

src/ezsheets/__init__.py:478

↓ 1 callersMethoddownloadAsHTML

(self, filename=None)

src/ezsheets/__init__.py:490

↓ 1 callersMethoddownloadAsODS

(self, filename=None)

src/ezsheets/__init__.py:484

↓ 1 callersMethoddownloadAsPDF

(self, filename=None)

src/ezsheets/__init__.py:487

↓ 1 callersMethoddownloadAsTSV

(self, filename=None)

src/ezsheets/__init__.py:493

↓ 1 callersMethodfind

(self, needle)

src/ezsheets/__init__.py:967

↓ 1 callersFunctiongetIdFromUrl

(url)

src/ezsheets/__init__.py:1662

↓ 1 callersFunctionlistSpreadsheets

()

src/ezsheets/__init__.py:1834

MethodSheet

(self, title="", index=None, columnCount=DEFAULT_NEW_COLUMN_COUNT, rowCount=DEFAULT_NEW_ROW_COUNT)

src/ezsheets/__init__.py:519

Method__contains__

Returns `True` if the `str` representation of `item` is equal to or within the `str` representation of a cell in this sheet.

src/ezsheets/__init__.py:959

Method__delitem__

Delete the Sheet object at index `key`. :param key An integer index of the Sheet to delete.

src/ezsheets/__init__.py:318

Method__eq__

A Spreadsheet object is only considered equal to Spreadsheet objects with the same ID.

src/ezsheets/__init__.py:511

Method__eq__

A Sheet object is only considered equal to itself.

src/ezsheets/__init__.py:689

Method__getitem__

Retrieve the Sheet object at index `key`. :param key An integer index of the Sheet to retrieve.

src/ezsheets/__init__.py:293

Method__getitem__

(self, *key)

src/ezsheets/__init__.py:1564

Method__init__

Initializer for Spreadsheet objects. :param spreadsheetId: The ID or URL of the spreadsheet on Google Sheets. E.g. `'https://docs.go

src/ezsheets/__init__.py:182

Method__init__

TODO

src/ezsheets/__init__.py:541

Method__iter__

Return an iterable of the Sheet objects in this Spreadsheet.

src/ezsheets/__init__.py:357

Method__iter__

(self)

src/ezsheets/__init__.py:1591

Method__len__

Return the number of Sheet objects in this Spreadsheet.

src/ezsheets/__init__.py:351

Method__repr__

A string representation of code that can recreate this Spreadsheet object.

src/ezsheets/__init__.py:399

Method__repr__

TODO

src/ezsheets/__init__.py:869

Method__setitem__

(self, *args)

src/ezsheets/__init__.py:1575

Method__str__

A human-readable string representation of this Spreadsheet object.

src/ezsheets/__init__.py:393

Method__str__

TODO

src/ezsheets/__init__.py:856

FunctionaddOriginalSheet

()

tests/test_ezsheets.py:25

FunctioncheckPreAndPostCondition

()

tests/test_ezsheets.py:33

MethodcolumnCount

The number of columns in this Sheet object.

src/ezsheets/__init__.py:738

MethodcolumnGroupControlAfter

TODO

src/ezsheets/__init__.py:842

FunctionconvertAddress

(*address)

src/ezsheets/__init__.py:1716

MethodfrozenColumnCount

The integer number of frozen columns in this Sheet object. Frozen columns remain visible in the browser even as the user scrolls the

src/ezsheets/__init__.py:787

MethodfrozenRowCount

The integer number of frozen rows in this Sheet object. Frozen rows remain visible in the browser even as the user scrolls down the S

src/ezsheets/__init__.py:762

MethodhideGridlines

The Boolean setting of whether the gridlines in the Sheet are visible or not.

src/ezsheets/__init__.py:812

Methodid

The unique, read-only id for this Spreadsheet on Google Sheets.

src/ezsheets/__init__.py:372

Methodid

The unique, read-only ID string of this Sheet object in its Spreadsheet. (This is the old, deprecated name. Use id instead.)

src/ezsheets/__init__.py:705

Functioninit

()

tests/test_ezsheets.py:125

Methodopen

(self)

src/ezsheets/__init__.py:507

MethodrowCount

The number of rows in this Sheet object.

src/ezsheets/__init__.py:714

MethodrowGroupControlAfter

TODO

src/ezsheets/__init__.py:827

MethodsheetId

The unique, read-only ID string of this Sheet object in its Spreadsheet. (This is the old, deprecated name. Use id instead.)

src/ezsheets/__init__.py:698

MethodsheetTitles

A tuple of the Sheet objects' titles (as strings) in this Spreadsheet object.

src/ezsheets/__init__.py:387

Methodspreadsheet

The Spreadsheet object that contains this Sheet object.

src/ezsheets/__init__.py:558

MethodspreadsheetId

The unique, read-only id for this Spreadsheet on Google Sheets. (This is the old, deprecated name. Use id instead.)

src/ezsheets/__init__.py:364

MethodtabColor

The color of the Sheet's tab as displayed in the browser.

src/ezsheets/__init__.py:599

Functiontest_Spreadsheet_attr

(init, checkPreAndPostCondition)

tests/test_ezsheets.py:148

Functiontest_Spreadsheet_url

(init)

tests/test_ezsheets.py:144

Functiontest__getTabColorArg

()

tests/test_ezsheets.py:112

Functiontest_basic

()

tests/test_ezsheets.py:41

Functiontest_bean_count

()

tests/test_automate2nded.py:494

Functiontest_changeSheetIndex

(init, checkPreAndPostCondition)

tests/test_ezsheets.py:263

Functiontest_columnNumberLetterTranslation

()

tests/test_ezsheets.py:83

Functiontest_convertAddress

()

tests/test_ezsheets.py:810

Functiontest_convertToColumnRowInts

()

tests/test_ezsheets.py:88

Functiontest_createSheet_deleteSheet

(init, checkPreAndPostCondition)

tests/test_ezsheets.py:157

Functiontest_eq

(init, checkPreAndPostCondition)

tests/test_ezsheets.py:376

Functiontest_getColumnLetterOf

()

tests/test_ezsheets.py:54

Functiontest_getColumnNumberOf

()

tests/test_ezsheets.py:70

Functiontest_getIdFromUrl

()

tests/test_ezsheets.py:45

Functiontest_getitem

(init, checkPreAndPostCondition)

tests/test_ezsheets.py:837

Functiontest_getitem_delitem

(init, checkPreAndPostCondition)

tests/test_ezsheets.py:175

Functiontest_gridProperties_settersGetters

(init, checkPreAndPostCondition)

tests/test_ezsheets.py:667

Functiontest_iter

(init, checkPreAndPostCondition)

tests/test_ezsheets.py:314

Functiontest_len

(init, checkPreAndPostCondition)

tests/test_ezsheets.py:254

next →1–100 of 133, ranked by callers