LogoLogo
About
Tables: v2
  • Home
  • Guides
  • BDK
  • REST API
  • Release Notes
Tables: v2
  • Getting Started
    • Tables Overview
  • Table Creation
    • Create a Table
    • Create a Sample Table
    • Create a Pivot Table
    • Create an Integer Table
    • Create a Table from JSON
    • Create a Combined Table
    • Get a Table from a File
  • Rows
    • Get Rows
    • Get Row Count
    • Get Row Number
    • Get Value from Row
    • Insert a Row
    • Insert an Empty Row
    • Remove Duplicate Rows
    • Set a Row to JSON
  • Columns
    • Get a Column
    • Get a Column's Values
    • Get a Column Number
    • Get Column Count
    • Get Column Stats
    • Get Column Names
    • Change a Column's Data Type
    • Delete Columns
    • Insert a Column
    • Move a Column
    • Rename a Column
    • Rename Columns
    • Round a Column's Values
    • Update a Column
  • Cells
    • Set a Cell in a Table
  • Conversions
    • Convert CSV to a Table
    • Convert a Table to CSV
    • Convert a Table to Excel
  • Manipulations
    • Clear a Table
    • Combine Tables
    • Copy a Table
    • Extract a Subtable
    • Query a Table
    • Sort a Table
    • Replace a Value
    • Replace a Value in a Column
    • Transpose a Table
Powered by GitBook
On this page
  • Overview
  • Input Concepts
  • Output Concepts
  • Examples

Was this helpful?

Export as PDF
  1. Cells

Set a Cell in a Table

Sets the value of a cell in a table.

Overview

Sets the value of a cell in the table.

Input Concepts

Concept
Type
Description
Default
Required

row number

number

The row number to insert to. (1-indexed)

No default

Yes

column name

string

The name of the column.

No default

Yes

value

any

The value to set.

No default

Yes

Note: Table rows are numbered starting with the number 1.

Output Concepts

Concept
Description

table

The updated table.

Examples

1. Example 1

For this example, consider the following table, which can be generated using the create a sample table procedure:

Name
Number
Address
City

john

+ 1 (415) 691 9426

123 east street

San Francisco

joe

+ 1 (415) 691 1234

321 west street

San Jose

jack

+ 1 (415) 691 4595

213 north street

San Francisco

set the cell in the table where
    the column name is "City"
    the row number is 2
    the value is "Mountain View"
Name
Number
Address
City

john

+ 1 (415) 691 9426

123 east street

San Francisco

joe

+ 1 (415) 691 1234

321 west street

Mountain View

jack

+ 1 (415) 691 4595

213 north street

San Francisco

Last updated 29 days ago

Was this helpful?