ctsstc

treeView.treeModel.currentSession_rootNode.subnodes.forEach(node => node.setCollapsing(true))

stefanmaric

Copy-to-clipboard Bookmarklet

Create Bookmarklet (browser bookmark that executes Javsacript) to copy a given text to Clipboard.

This is the base javascript:

(function (text) {
  var node = document.createElement('textarea')
  var selection = document.getSelection()

LiamKarlMitchell

function onOpen() {
  var sheet = SpreadsheetApp.getActiveSpreadsheet();
  var entries = [{
    name: "Toggle Rows",
    functionName: "toggleRows"
  },{
    name: "Hide Rows",
    functionName: "hideRows"
  },{
    name: "Show Rows",

ellisgeek

function Import-Excel {
<#
    .SYNOPSIS
        Creates table-like custom objects from the items in a Excel file.
        Requires Excel be installed!
    .DESCRIPTION
        The Import-Excel cmdlet creates table-like custom objects from the items in Excel
        Worksheets.
        Each column in the Excel Worksheet becomes a property of the custom object and the items in
        rows become the property values. Import-Excel works on any file supported by Excel.

spiralx

@script:jscript

/**
 * Return an array of the results of running func on each item in coll e.g.
 *   map(DOpus.vars, function(v, i) {
 *     return v + '=' + v.value;
 *   }
 */
function map(coll, func) {
  var res = [];

liunian

<?php
# http://jeffreysambells.com/2012/10/25/human-readable-filesize-php
function human_filesize($bytes, $decimals = 2) {
    $size = array('B','kB','MB','GB','TB','PB','EB','ZB','YB');
    $factor = floor((strlen($bytes) - 1) / 3);
    return sprintf("%.{$decimals}f", $bytes / pow(1024, $factor)) . @$size[$factor];
}

echo human_filesize(filesize('example.zip'));

steve-jansen

' Excel macro to export all VBA source code in this project to text files for proper source control versioning
' Requires enabling the Excel setting in Options/Trust Center/Trust Center Settings/Macro Settings/Trust access to the VBA project object model
Public Sub ExportVisualBasicCode()
    Const Module = 1
    Const ClassModule = 2
    Const Form = 3
    Const Document = 100
    Const Padding = 24
    
    Dim VBComponent As Object