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()
treeView.treeModel.currentSession_rootNode.subnodes.forEach(node => node.setCollapsing(true)) |
function onOpen() { | |
var sheet = SpreadsheetApp.getActiveSpreadsheet(); | |
var entries = [{ | |
name: "Toggle Rows", | |
functionName: "toggleRows" | |
},{ | |
name: "Hide Rows", | |
functionName: "hideRows" | |
},{ | |
name: "Show Rows", |
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. |
@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 = []; |
<?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')); |
' 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 |