Tutorial by Examples: w

Download and install Code::Blocks here. If you're on Windows, be careful to select a file for which the name contains mingw, the other files don't install any compiler. Open Code::Blocks and click on "Create a new project": Select "Console application" and click &...

The first function, using an array, is much faster If called without the optional parameter, will default to .ThisWorkbook.ActiveSheet If the range is empty will returns Cell( 1, 1 ) as default, instead of Nothing Speed: GetMaxCell (Array): Duration: 0.0000790063 seconds GetMaxCell (Find ...

Deleting rows is slow, specially when looping through cells and deleting rows, one by one A different approach is using an AutoFilter to hide the rows to be deleted Copy the visible range and Paste it into a new WorkSheet Remove the initial sheet entirely With this method, th...

Require is a statement that Node interprets as, in some sense, a getter function. For example, say you have a file named analysis.js, and the inside of your file looks like this, function analyzeWeather(weather_data) { console.log('Weather information for ' + weather_data.time + ': '); consol...

Node's require is also very helpful when used in tandem with an NPM package. Say, for example, you would like to use the NPM package require in a file named getWeather.js. After NPM installing your package through your command line (git install request), you are ready to use it. Your getWeather.js f...

fun startNewActivity(){ val intent: Intent = Intent(context, Activity::class.java) startActivity(intent) } You can add extras to the intent just like in Java. fun startNewActivityWithIntents(){ val intent: Intent = Intent(context, Activity::class.java) intent.putExtra(KEY_NA...

.* in regex basically means "catch everything until the end of input". So, for simple strings, like hello world, .* works perfectly. But if you have a string representing, for example, lines in a file, these lines would be separated by a line separator, such as \n (newline) on Unix-like s...

Consider this example: He went into the cafe "Dostoevski" and said: "Good evening." Here we have two sets of quotes. Let's assume we want to match both, so that our regex matches at "Dostoevski" and "Good evening." At first, you could be tempted to keep...

Key Points:- Implementation of Map. stores only weak references to its keys. Weak References : The objects that are referenced only by weak references are garbage collected eagerly; the GC won’t wait until it needs memory in that case. Diffrence between Hashmap and WeakHashMap:- If the Jav...

Prerequisites: Setting up the Development Environment Before we get started, we have to setup our environment. Install Node.js and npm if they are not already on your machine. Verify that you are running at least node 6.9.x and npm 3.x.x by running node -v and npm -v in a terminal/console wi...

You can read all items either from any config file or type it inline. Considering if its saved in Config File // Read all list items from config file string[] countryDV = ConfigurationManager.AppSettings["countryDV"].Split(',').Select(s => s.Trim().ToUpper()).ToArray(); int DVRowLim...

Approach in this case will be different than previous example because Excel file supports the Data validation for list of items with total character count less than 256 if all items are binded directly as in previous example. But in many situation list items can be longer than 256 characters and in ...

Example shows 5 items per row: <div *ngFor="let item of items; let i = index"> <div *ngIf="i % 5 == 0" class="row"> {{ item }} <div *ngIf="i + 1 < items.length">{{ items[i + 1] }}</div> <div *ngIf="i + 2 &l...

While you are not allowed to use *ngIf and *ngFor in the same div (it will gives an error in the runtime) you can nest the *ngIf in the *ngFor to get the desired behavior. Example 1: General syntax <div *ngFor="let item of items; let i = index"> <div *ngIf="<your cond...

int DVRowLimit = (Int16.MaxValue); CellRangeAddressList cellRangeFieldsType1 = new CellRangeAddressList(1, DVRowLimit, targetFirstCol, targetLastCol); XSSFDataValidationConstraint dvConstraint = (XSSFDataValidationConstraint)validationHelper.CreateDateConstraint(OperatorType.BET...

dvConstraint = (XSSFDataValidationConstraint)validationHelper.CreateTimeConstraint(OperatorType.BETWEEN, "=TIME(0,0,0)", "=TIME(23,59,59)");

To get a value use the .getPropertyValue() method element.style.getPropertyValue("--var") To set a value use the .setProperty() method. element.style.setProperty("--var", "NEW_VALUE")

Set second argument when use flash() in view function: flash('Something was wrong!', 'error') In the template, set with_categories=true in get_flashed_messages(), then you get a list of tuples in the form of (message, category), so you can use category as a HTML class. {% with messages = get_fl...

This example will show you back navigation which is expected generally in most of the flows. You will have to add following code to every screen depending on expected behavior. There are 2 cases: If there are more than 1 screen on stack, device back button will show previous screen. If there is ...

Depending on whether you have installed composer globally or locally. Locally: php composer.phar create-project slim/slim-skeleton {my-app-name} Globally: composer create-project slim/slim-skeleton {my-app-name} If you are running a webserver (ex. Apache or nginx) point your virtualho...