#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();
...
In ui-router a state can hold multiple views, each with his own controller and a template
.state('dashboard', {
name: 'dashboard',
url: '/dashboard',
views: {
"view1": {
templateUrl: "path/to/view1.html",
controller: "...
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...
The response to a CORS request must include an Access-Control-Allow-Origin header, which dictates what origins are allowed to use the CORS resource. This header can take one of three values:
An origin. Doing this permits requests from that origin only.
The character *. This permits requests from...
Allowing user credentials or the user's session to be sent with a CORS request allows the server to persist user data across CORS requests. This is useful if the server needs to check if the user is logged in before providing data (for example, only performing an action if a user is logged in - this...
A basic CORS request is allowed to use one of only two methods:
GET
POST
and only a few select headers. POST CORS requests can additionally choose from only three content types.
To avoid this issue, requests that wish to use other methods, headers, or content types must first issue a preflig...
When a server receives a preflight request, it must check if it supports the requested method and headers, and send back a response that indicates its ability to support the request, as well as any other permitted data (such as credentials).
These are indicated in access-control Allow headers. The ...
A Regexp can be created in three different ways in Ruby.
using slashes: / /
using %r{}
using Regex.new
#The following forms are equivalent
regexp_slash = /hello/
regexp_bracket = %r{hello}
regexp_new = Regexp.new('hello')
string_to_match = "hello world!"
#All of th...
Superglobal variables are defined by PHP and can always be used from anywhere without the global keyword.
<?php
function getPostValue($key, $default = NULL) {
// $_POST is a superglobal and can be used without
// having to specify 'global $_POST;'
if (isset($_POST[$key])) {
...
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...
When we want to count the number of items in an iterable, that meet some condition, we can use comprehension to produce an idiomatic syntax:
# Count the numbers in `range(1000)` that are even and contain the digit `9`:
print (sum(
1 for x in range(1000)
if x % 2 == 0 and
'9' in str...
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...
In Java, we can convert between integer values and floating-point values. Also, since every character corresponds to a number in the Unicode encoding, char types can be converted to and from the integer and floating-point types. boolean is the only primitive datatype that cannot be converted to or f...
For a function or subroutine to be useful it has to be referenced. A subroutine is referenced in a call statement
call sub(...)
and a function within an expression. Unlike in many other languages, an expression does not form a complete statement, so a function reference is often seen in an ass...
