Tutorial by Examples: en

//Add a TextLength Validation to column G var val5 = worksheet.DataValidations.AddTextLengthValidation("G:G"); //For TextLenght Validation, you have to set error message to true val5.ShowErrorMessage = true; //Minimum allowed text lenght val5.Formula.Value = 3; //Maximum allowed te...

Typically, some files from the Web Application should not be overwritten when performing the deployment (e.g. web.config). This can be accomplished by: 1) Excluding from output - which means setting Build action to None. This is the easiest way, but it might not work for some particular files or fo...

Web deployment offers the option to automatically backup target Web site (not target Web application!) on deployment. This is recommended to allow web application rollback. In order to configure automatic backups, the following steps must be followed: 1) Enable backups Open %programfiles%\IIS\Mic...

type ProjectIdType = ProjectId String getProject : ProjectIdType -> Cmd Msg getProject (ProjectId id) = Http.get <| "/projects/" ++ id

Occasionally we see StackOverflow Java questions (and C or C++ questions) that ask what something like this: i += a[i++] + b[i--]; evaluates to ... for some known initial states of i, a and b. Generally speaking: for Java the answer is always specified1, but non-obvious, and often difficult ...

Let A and B be two matrices of same dimension. The operators +,-,/,*,^ when used with matrices of same dimension perform the required operations on the corresponding elements of the matrices and return a new matrix of the same dimension. These operations are usually referred to as element-wise opera...

Sometimes one would like to pass names of columns from a data frame to a function. They may be provided as strings and used in a function using [[. Let's take a look at the following example, which prints to R console basic stats of selected variables: basic.stats <- function(dset, vars){ f...

from nltk.tokenize import sent_tokenize, word_tokenize example_text = input("Enter the text: ") print("Sentence Tokens:") print(sent_tokenize(example_text)) print("Word Tokens:") print(word_tokenize(example_text))

An example of a parametric parameter of a type function: data List a = Nil | Cons a (List a) type family DoNotInspect x type instance DoNotInspect x = List x Here x is parametric because to determine the outcome of applying DoNotInspect to a type argument, the type function do not need to in...

StrictMode.setThreadPolicy(new StrictMode.ThreadPolicy.Builder() .detectDiskWrites() .penaltyLog() //Logs a message to LogCat .build())

StrictMode.setVmPolicy(new StrictMode.VmPolicy.Builder() .detectActivityLeaks() .detectLeakedClosableObjects() .penaltyLog() .build());

The EntityDamage event is thrown when an Entity is damaged. EntityDamageEvent @EventHandler public void onEntityDamage(EntityDamageEvent e) { DamageCause cause = e.getCause(); //Get the event DamageCause double rawDamage = e.getDamage(); //Returns the damage before any calculation...

The member function fill() can be used on std::array for changing the values at once post initialization int main() { std::array<int, 3> arr = { 1, 2, 3 }; // change all elements of the array to 100 arr.fill(100); }

import React, { Component } from 'react'; import { WebView } from 'react-native'; class MyWeb extends Component { render() { return ( <WebView source={{uri: 'https://github.com/facebook/react-native'}} style={{marginTop: 20}} /> ); } } ...

SWIFT: Step 1: In your Info.plist add the following attribute: View controller-based status bar appearance and set its value to NO as described in the image below: Step 2: In your AppDelegate.swift file, in didFinishLaunchingWithOptions method, add this code: UIApplication.shared.st...

-- Create a sample JSON with ARRAY create table car_sample(dim_id integer, info varchar(2000)); insert into car_sample values (200, '{"cars": [ { "Manufacturer": "Nissan", "Models": [{"Name":"Sentra", "doors":4}, {"Name&quo...

Note: This only works for the built-in keyboard provided by iOS SWIFT: In order for the view of a UIViewController to increase the origin of the frame when it is presented and decrease it when it is hidden, add the following functions to your class: func keyboardWillShow(notification: NSNotificat...

The break instruction: Using break we can leave a loop even if the condition for its end is not fulfilled. It can be used to end an infinite loop, or to force it to end before its natural end The syntax is break; Example: we often use break in switch cases,ie once a case i switch is satisfied...

Let's say that inside a resources file, you had a file called /icons/ok.png The full url of this file within code is qrc:/icons/ok.png. In most cases, this can be shortened to :/icons/ok.png For example, if you wanted to create a QIcon and set it as the icon of a button from that file, you could u...

This example is about changing the form depending on decisions the user did with the form previously. In my special case, I needed to disable a selectbox, if a certain checkbox wasn't set. So we have the FormBuilder, where we'll set the EventListener on the FormEvents::PRE_SUBMIT event. We're usin...