Mahdi About RealSlimMahdi

Hiding and Deleting Rows and Columns on Google Spreadsheet using Google Apps Script

These are the sample scripts for hiding and deleting rows and columns on Google Spreadsheet using Google Apps Script. I sometimes see the questions for hiding and deleting rows and columns on Spreadsheet at Stackoverflow. So here, I would like to introduce the sample scripts for this.

In this case, when the process costs of the scripts created by using Spreadsheet service and Sheets API are compared, the cost of script created by Sheets API is much lower than that of script created by Spreadsheet service. So when the rows and columns of your Spreadsheet is large and you can use Sheets API, I recommend to use Sheets API.

Sample situation

As the sample situation, the following sample Spreadsheet is used.

VSCode Shortcuts

List of helpful shortcuts for faster coding

If you have any other helpful shortcuts, feel free to add in the comments of this gist :)

Official List of all commands

Windows
Mac

	{
	"name": "workshop-setup",
	"version": "1.0.0",
	"description": "This is the common setup script for most of my workshops",
	"bin": "./setup.js"
	}

	import React from "react"
	import { render, Static, Box, Color, Text } from "ink"
	import BigText from "ink-big-text"
	import BBox from "ink-box"
	import TextInput from "ink-text-input"
	import { Tabs, Tab } from "ink-tab"
	import _ from "lodash"

	const purple = [102, 51, 153]
	const hexPurple = `#663399`