4.3. Load table data from Google Sheets

Following example shows how to extract TableData from Google Sheets by using GoogleSheetsTableLoader class.

Load table data from Google Sheets

import io

import pytablereader as ptr
import pytablewriter as ptw


loader = ptr.TableUrlLoader(
    "https://en.wikipedia.org/wiki/List_of_unit_testing_frameworks",
    "html")

writer = ptw.TableWriterFactory.create_from_format_name("rst")
writer.stream = io.open("load_url_result.rst", "w", encoding=loader.encoding)
for table_data in loader.load():
    writer.from_tabledata(table_data)
    writer.write_table()