Download Latest Version google-spreadsheet v5.3.0 source code.zip (191.3 kB)
Email in envelope

Get an email when there's a new version of node-google-spreadsheet

Home / v5.1.0
Name Modified Size InfoDownloads / Week
Parent folder
README.md 2026-02-13 2.3 kB
0
v5.1.0 source code.tar.gz 2026-02-13 232.0 kB
0
v5.1.0 source code.zip 2026-02-13 255.0 kB
1 1 weekly downloads
Totals: 3 Items   489.3 kB 1

Minor Changes

  • 3edb1ba: Add deleteDimension, deleteRows, and deleteColumns methods to GoogleSpreadsheetWorksheet

  • a2f00b2: Add comprehensive data manipulation and convenience methods to GoogleSpreadsheetWorksheet:

    Data Manipulation Methods:

    • pasteData: Insert delimited data at a coordinate
    • appendDimension: Append rows or columns to sheet
    • textToColumns: Split delimited text into columns
    • deleteRange: Delete cells and shift remaining
    • deleteDimension: Delete rows or columns
    • moveDimension: Move rows or columns
    • sortRange: Sort data by columns
    • trimWhitespace: Remove leading/trailing spaces
    • deleteDuplicates: Remove duplicate rows
    • copyPaste: Copy and paste ranges
    • cutPaste: Cut and paste ranges
    • autoFill: Fill cells with patterns
    • repeatCell: Repeat cell data across range
    • appendCells: Append cell data to sheet
    • findReplace: Find and replace text
    • randomizeRange: Randomize row order

    Convenience Wrapper Methods (auto-fill sheetId):

    • addNamedRange: Create named ranges in worksheet
    • updateNamedRange: Update existing named ranges
    • deleteNamedRange: Delete named ranges
    • setBasicFilter: Set basic filter on sheet
    • clearBasicFilter: Clear basic filter from sheet
    • updateBorders: Update cell borders in range

    Filter View Methods:

    • addFilterView: Add filter views to sheets
    • updateFilterView: Update existing filter views
    • deleteFilterView: Delete filter views
    • duplicateFilterView: Duplicate filter views

    Conditional Formatting Methods:

    • addConditionalFormatRule: Add conditional format rules
    • updateConditionalFormatRule: Update or move conditional format rules
    • deleteConditionalFormatRule: Delete conditional format rules

    Banding Methods:

    • addBanding: Add alternating row/column colors
    • updateBanding: Update banding properties
    • deleteBanding: Delete banded ranges

    Developer Metadata Methods:

    • createDeveloperMetadata: Create custom metadata
    • updateDeveloperMetadata: Update existing metadata
    • deleteDeveloperMetadata: Delete metadata
Source: README.md, updated 2026-02-13