Tutorial by Examples: an

#Get the active Worksheet my $Book = $Excel->Activewindow; my $Sheet = $Book->Activesheet; #List of Worksheet names my @list_Sheet = map { $_->{'Name'} } (in $Book->{Worksheets}); #Access a given Worksheet my $Sheet = $Book->Worksheets($list_Sheet[0]); #Add new Worksheet...

#Edit the value of a cell (2 methods) $Sheet->Range("A1")->{Value} = 1234; $Sheet->Cells(1,1)->{Value} = 1234; #Edit the values in a range of cells $Sheet->Range("A8:C9")->{Value} = [[ undef, 'Xyzzy', 'Plugh' ], [ 42, 'Pe...

#Insert a row before/after line 22 $Sheet->Rows("22:22")->Insert(xlUp, xlFormatFromRightOrBelow); $Sheet->Rows("23:23")->Insert(-4121,0); #xlDown is -4121 and that xlFormatFromLeftOrAbove is 0 #Delete a row $Sheet->Rows("22:22")->Delete(); ...

To customize appearance of all instances of a class, access appearance proxy of the desired class. For example: Set UIButton tint color Swift: UIButton.appearance().tintColor = UIColor.greenColor() Objective-C: [UIButton appearance].tintColor = [UIColor greenColor]; Set UIButton background...

Use appearanceWhenContainedInInstancesOfClasses: to customize the appearance for instance of a class when contained within an instance of container class. For example customization of UILabel's textColor and backgroundColor within ViewController class will look like this: Set UILabel text color Sw...

var app = {}; app.signUp = function(){ app.userName = $('#userName').val(); app.password = $('#password').val(); app.email = $('#form-email').val(); app.phoneNumber = $('#form-phone').val(); app.emailRegex = ...

Mostly you will use "normal variables": set(VAR TRUE) set(VAR "main.cpp") set(VAR1 ${VAR2}) But CMake does also know global "cached variables" (persisted in CMakeCache.txt). And if normal and cached variables of the same name exist in the current scope, normal var...

The most important use of ranges is to express a sequence Syntax: (begin..end) => this construct will include end value (begin...end) => this construct will exclude end value or Range.new(begin,end,exclude_end) => exclude_end is by default false Most important end value must be gr...

Static class properties that are defined with the public visibility are functionally the same as global variables. They can be accessed from anywhere the class is defined. class SomeClass { public static int $counter = 0; } // The static $counter variable can be read/written from anywhere...

let someValue : String = "Something the user entered" let text = NSMutableAttributedString(string: "The value is: ") text.appendAttributedString(NSAttributedString(string: someValue, attributes: [NSFontAttributeName:UIFont.boldSystemFontOfSize(UIFont.systemFontSize())])) ...

Like any other java program, every swing program starts with a main method. The main method is initiated by the main thread. However, Swing components need to be created and updated on the event dispatch thread (or short: EDT). To illustrate the dynamic between the main thread and the EDT take a loo...

defmodule Processes do def receiver do receive do {:ok, val} -> IO.puts "Received Value: #{val}" _ -> IO.puts "Received something else" end end end iex(1)> pid = spawn(Processes, ...

Recursion can be used to receive multiple messages defmodule Processes do def receiver do receive do {:ok, val} -> IO.puts "Received Value: #{val}" _ -> IO.puts "Received something else" end...

Like the built-in python interactive shell, IPython is a REPL (Read-Evaluate-Print Loop) shell, with a variety of features that make it more pleasant to use for day-to-day Python development than the built-in REPL shell. Installation To install it: pip install ipython Or, via Anaconda: # To i...

There are three MonoBehaviour methods that can be made coroutines. Start() OnBecameVisible() OnLevelWasLoaded() This can be used to create, for example, scripts that execute only when the object is visible to a camera. using UnityEngine; using System.Collections; public class RotateObje...

Avoid unnecessary operations and method calls wherever you can, especially in a method which is called many times a second, like Update. Distance/Range Checks Use sqrMagnitude instead of magnitude when comparing distances. This avoids unnecessary sqrt operations. Note that when using sqrMagnitude,...

You create new ScriptableObject instances through ScriptableObject.CreateInstance<T>() T obj = ScriptableObject.CreateInstance<T>(); Where T extends ScriptableObject. Do not create ScriptableObjects by calling their constructors, ie. new ScriptableObject(). Creating ScriptableO...

Re-Save open file under the same filename (Save): C-x C-s Write as filename (Save As): C-x C-w filename The new file name will be prompted in the minibuffer. Create new file or load existing file (New / Load): C-x C-f filename With the mnemonic here for f meaning file. You will...

Often you will get into a state where you have a partially typed command sequence in progress, but you want to abort it. You can abort it with either of the following keybindings: C-g EscEscEsc

You can obtain information about EC2 instances using: aws ec2 describe-instances You can obtain information about specific EC2 instances using: aws ec2 describe-instances --instance-ids ... where ... contains one or more instance identifiers. For example: aws ec2 describe-instances --instan...