Tutorial by Examples: w

What you see is NOT what you get: char vs cellstring in the command window

This a basic example aimed at new users. It does not focus on explaining the difference between char and cellstring. It might happen that you want to get rid of the ' in your strings, although you never added them. In fact, those are artifacts that the command window uses to distinguish between ...

MATLAB Language • Common mistakes and errors

Retrieve all Worksheets Names in Active Workbook

Option Explicit Sub LoopAllSheets() Dim sht As Excel.Worksheet ' declare an array of type String without committing to maximum number of members Dim sht_Name() As String Dim i As Integer ' get the number of worksheets in Active Workbook , and put it as the maximum number of members in t...

excel-vba • Loop through all Sheets in Active Workbook

Adding -WhatIf and -Confirm support to your cmdlet

function Invoke-MyCmdlet { [CmdletBinding(SupportsShouldProcess = $true)] param() # ... }

PowerShell • Using ShouldProcess

Using ShouldProcess() with one argument

if ($PSCmdlet.ShouldProcess("Target of action")) { # Do the thing } When using -WhatIf: What if: Performing the action "Invoke-MyCmdlet" on target "Target of action" When using -Confirm: Are you sure you want to perform this action? Performing operation &qu...

PowerShell • Using ShouldProcess

Writing the module

--- trim: a string-trimming module for Lua -- Author, date, perhaps a nice license too -- -- The code here is taken or adapted from material in -- Programming in Lua, 3rd ed., Roberto Ierusalimschy -- trim_all(string) => return string with white space trimmed on both sides local trim_al...

Lua • Writing and using modules

Hello World

Microsoft Windows applications are usually written as either a console application or a windowed application (there are other types such as services and plug-ins). The difference for the programmer is the difference in the interface for the main entry point for the application source provided by the...

Win32 API • Getting started with Win32 API

Reading a file with a Scanner

Reading a file line by line public class Main { public static void main(String[] args) { try { Scanner scanner = new Scanner(new File("example.txt")); while(scanner.hasNextLine()) { String line = scanner.nextLine(); ...

Java Language • File I/O

Why are there two build.gradle files in an Android Studio project?

<PROJECT_ROOT>\app\build.gradle is specific for app module. <PROJECT_ROOT>\build.gradle is a "Top-level build file" where you can add configuration options common to all sub-projects/modules. If you use another module in your project, as a local library you would have another...

Android • Gradle for Android

Creating a new program using .NET Core

First install the .NET Core SDK by going through the installation instructions for the platform of your choice: Windows OSX Linux Docker After the installation has completed, open a command prompt, or terminal window. Create a new directory with mkdir hello_world and change into the ne...

C# Language • Getting started with C# Language

Using the where statement in a switch

The where statement may be used within a switch case match to add additional criteria required for a positive match. The following example checks not only for the range, but also if the number is odd or even: switch (temperature) { case 0...49 where temperature % 2 == 0: print(&quot...

Swift Language • Switch

Joining Strings with a delimiter

Java SE 8 An array of strings can be joined using the static method String.join(): String[] elements = { "foo", "bar", "foobar" }; String singleString = String.join(" + ", elements); System.out.println(singleString); // Prints "foo + bar + foobar&qu...

Java Language • Strings

Getting Started: Hello world!

Creating an HTML document and enabling knockout.js Create an HTML file and include knockout.js via a <script> tag. <!DOCTYPE html> <html> <head> <title>Hello world! (knockout.js)</title> </head> <body> <script src="https://cdnjs...

knockout.js • Getting started with knockout.js

First Module and Hello World

To start coding in the first place, you have to right click your VBA Project in the left list and add a new Module. Your first Hello-World Code could look like this: Sub HelloWorld() MsgBox "Hello, World!" End Sub To test it, hit the Play-Button in your Toolbar or simply hit the...

VBA • Getting started with VBA

Add shadows to text

Swift label1.layer.shadowOffset = CGSize(width: 3, height: 3) label1.layer.shadowOpacity = 0.7 label1.layer.shadowRadius = 2 Swift 3 label1.layer.shadowOffset = CGSize(width: 3, height: 3) label1.layer.shadowOpacity = 0.7 label1.layer.shadowRadius = 2 Objective-C label1.layer.shadowOffs...

iOS • UILabel

INSERT multiple rows of data

To insert multiple rows of data in SQL Server 2008 or later: INSERT INTO USERS VALUES (2, 'Michael', 'Blythe'), (3, 'Linda', 'Mitchell'), (4, 'Jillian', 'Carson'), (5, 'Garrett', 'Vargas'); To insert multiple rows of data in earlier versions of SQL Server, use "UNION ALL" like so: ...

Microsoft SQL Server • INSERT INTO

INSERT a single row of data

A single row of data can be inserted in two ways: INSERT INTO USERS(Id, FirstName, LastName) VALUES (1, 'Mike', 'Jones'); Or INSERT INTO USERS VALUES (1, 'Mike', 'Jones'); Note that the second insert statement only allows the values in exactly the same order as the table columns whereas in...

Microsoft SQL Server • INSERT INTO

Converting NSArray to NSMutableArray to allow modification

NSArray *myColors = [NSArray arrayWithObjects: @"Red", @"Green", @"Blue", @"Yellow", nil]; // Convert myColors to mutable NSMutableArray *myColorsMutable = [myColors mutableCopy];

Objective-C Language • NSArray

What is SFINAE

SFINAE stands for Substitution Failure Is Not An Error. Ill-formed code that results from substituting types (or values) to instantiate a function template or a class template is not a hard compile error, it is only treated as a deduction failure. Deduction failures on instantiating function templa...

C++ • SFINAE (Substitution Failure Is Not An Error)

Hello World

An example document class that prints “Hello, World” to the debug console when instantiated. import flash.display.Sprite; public class Main extends Sprite { public function Main() { super(); trace("Hello, World"); } }

ActionScript 3 • Getting started with ActionScript 3

Hello World Component

A React component can be defined as an ES6 class that extends the base React.Component class. In its minimal form, a component must define a render method that specifies how the component renders to the DOM. The render method returns React nodes, which can be defined using JSX syntax as HTML-like ta...

React • Getting started with React