Skip to content

Latest commit

 

History

History
35 lines (22 loc) · 1.22 KB

README.md

File metadata and controls

35 lines (22 loc) · 1.22 KB

allHeaders Google Apps Script

Overview

The allHeaders function retrieves all table and column headers from all sheets within a Google Sheets document, except the currently active sheet. Each header is represented as a pair [table name, column name].

image

Orignal Blog Post: https://www.googlecloudcommunity.com/gc/Tips-Tricks/Auto-Fill-a-Sheet-with-All-Table-Column-Names-from-Your-App/m-p/262203

Usage

To use the function:

  1. Copy the Script: Copy the allHeaders function into the script editor of your Google Sheets document.

  2. Cell Formula: Enter the cell formula =allHeaders() in any cell of your Google Sheets document.

  3. Result: The function will return a 2D array containing all table and column headers, excluding the headers from the currently active sheet.

Return Value Format

The function returns a 2D array where each row represents a table and column header pair. The format of each row is [table name, column name].

Example

TABLE COLUMN
Table1 Column1
Table1 Column2
Table1 Column3
Table2 Column1
Table2 Column2
Table2 Column3