Create tab and add N rows with pygsheets

Question

I want to create an empty tab via pyghseets and add N rows, like I would do with the following button:

Is there an easy way to do this in pygsheets?

Thanks!

Edit:

My base code is the following:


import pygsheets

client = ### # Please use your client.

spreadsheet_id = "###" # Please set your Spreadsheet ID.
sheet_name = "Sheet to create" # Please set your sheet name.
N = 10000
sh = client.open_by_key(spreadsheet_id)

# Create sheet_name and add N rows below

Hi, do you have a code you're working on? – Iamblichus Jul 13 '22 at 09:57 — Iamblichus, Jul 13 '22 at 09:57

score 1 · Answer 1 · answered Jul 13 '22 at 10:32

This does the job:



import pygsheets

client = ### # Please use your client.

spreadsheet_id = "###" # Please set your Spreadsheet ID.
sheet_name = "Sheet to create" # Please set your sheet name.
N = 10000
sh = client.open_by_key(spreadsheet_id)
sh.add_worksheet(sheet_name, rows=N)

Create tab and add N rows with pygsheets

1 Answers1