Comments (8)
@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.
Related Issues (20)
- Update conda forge package HOT 2
- A way to add DataValidation HOT 6
- Missing py.typed marker HOT 1
- AttributeError: 'HTTPClient' object has no attribute 'import_csv' HOT 3
- Unable to read public readonly spreadsheet HOT 4
- Add missing types HOT 2
- Disambiguating and filling in headers similar to Pandas HOT 8
- worksheet.add_protected_range() - impossible to create the `warning_only=True` range HOT 2
- ADC Authentication HOT 2
- HTTPSConnectionPool(host='oauth2.googleapis.com', port=443): Max retries exceeded with url: /token (Caused by SSLError(SSLCertVerificationError(1, '[SSL: CERTIFICATE_VERIFY_FAILED] certificate verify failed: self signed certificate (_ssl.c:1000)'))) HOT 2
- Questions about Copilot + Open Source Software Hierarchy HOT 1
- gspread depends on google-auth>2.4.0 but only specifies google-auth>=1.12.0 HOT 7
- Client.copy(..., copy_permissions=True) breaks when permission type is domain HOT 1
- Remove StrEnum dependency HOT 6
- Add support for append columns HOT 5
- Feature request. Batch Merge in worksheet class HOT 4
- lint failure HOT 1
- get_notes from a range HOT 3
- check Spinx will work with RTD
- Exception requests.exceptions.JSONDecodeError is raised in APIError constructor HOT 2
Recommend Projects
-
React
A declarative, efficient, and flexible JavaScript library for building user interfaces.
-
Vue.js
🖖 Vue.js is a progressive, incrementally-adoptable JavaScript framework for building UI on the web.
-
Typescript
TypeScript is a superset of JavaScript that compiles to clean JavaScript output.
-
TensorFlow
An Open Source Machine Learning Framework for Everyone
-
Django
The Web framework for perfectionists with deadlines.
-
Laravel
A PHP framework for web artisans
-
D3
Bring data to life with SVG, Canvas and HTML. 📊📈🎉
-
Recommend Topics
-
javascript
JavaScript (JS) is a lightweight interpreted programming language with first-class functions.
-
web
Some thing interesting about web. New door for the world.
-
server
A server is a program made to process requests and deliver data to clients.
-
Machine learning
Machine learning is a way of modeling and interpreting data that allows a piece of software to respond intelligently.
-
Visualization
Some thing interesting about visualization, use data art
-
Game
Some thing interesting about game, make everyone happy.
Recommend Org
-
Facebook
We are working to build community through open source technology. NB: members must have two-factor auth.
-
Microsoft
Open source projects and samples from Microsoft.
-
Google
Google ❤️ Open Source for everyone.
-
Alibaba
Alibaba Open Source for everyone
-
D3
Data-Driven Documents codes.
-
Tencent
China tencent open source team.
from gspread.