Add support for creating cells/rows/columns about gspread HOT 8 CLOSED

@burnash I really appreciate your work, I was looking for a method Worksheet.insert_col but unfortunately it's not there, Please let me know how can I insert columns at any particular location.

from gspread.

Good suggestion, Arthur. Thank you!

from gspread.

I've added 3 methods for resizing a worksheet:

# General
worksheet.resize(rows_number, columns_number)  

# Shortcuts
worksheet.add_rows(100)
worksheet.add_cols(100)

Note: resize will truncate the worksheet without any warning.

The code is in master now, and will show up in the next release (0.0.13) on PyPI.

from gspread.

That was fast! Thank you very much!

from gspread.

You're welcome :)

from gspread.

Is it possible to add new rows at the very top of the spreadsheet?

Suppose I already have data in Row 1, and create a new empty row above it. So that I can add new data to the 'new' and empty Row 1 without overwriting existing data.

from gspread.

Maybe Worksheet.insert_row will work for you? Beware that it can be quite slow depending on the size of your spreadsheet.

from gspread.

Bro @burnash! Any chances you will be adding a append_col method? Having a real difficulty trying to insert column data :(

from gspread.