Tutorial by Examples: p

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...

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...

To create an kivy application sub class the app class Implement the build method, which will return the widget. Instantiate the class an invoke the run. from kivy.app import App from kivy.uix.label import Label class Test(App): def build(self): return Label(text='Hello worl...

We have simple module available in npm for goggle authetication name passport-google-oauth20 Consider the following example In this example have created a folder namely config having the passport.js and google.js file in the root directory. In your app.js include the following var express = requ...

Code example : Now Start with Creating the Pagination Controller public with sharing class Pagination { } i am going to show all the contacts in the form of pagination and there should be one checkbox for each contact to selected or deselect contact to perform delete operation on contacts. ...

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...

Keypoint :- SortedMap interface extends Map. entries are maintained in an ascending key order. Methods of sorted Map : Comparator comparator( ). Object firstKey( ). SortedMap headMap(Object end). Object lastKey( ). SortedMap subMap(Object start, Object end). SortedMap tailMap(Object s...

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...

Key Points:- Is Hash table and Linked list implementation of the Map interface, with predictable iteration order. inherits HashMap class and implements the Map interface. contains values based on the key. only unique elements. may have one null key and multiple null values. ...

if object_id('tempdb.dbo.#temp') is not null drop table #temp create table #temp ( dateValue datetime, category varchar(3), amount decimal(36,2) ) insert into #temp values ('1/1/2012', 'ABC', 1000.00) insert into #temp values ('2/1/2012', 'DEF', 500.00) insert into #temp value...

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...

On the shoulders of the low level drivers, there is pomm. It proposes a modular approach, data converters, listen/notify support, database inspector and much more. Assuming, Pomm has been installed using composer, here is a complete example: <?php use PommProject\Foundation\Pomm; $loader = re...

//try same approach for currency types with format like "$#,###.00"and date "m/d/yy h:mm" XSSFFont defaultFont = (XSSFFont)workbook.CreateFont(); defaultFont.FontHeightInPoints = (short)10; defaultFont.FontName = "Arial"; XSSFCellStyle phoneCellStyle = (XSSFCellStyl...

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")

<div class="content"> Lorem ipsum dolor sit amet, consectetuer adipiscing elit, sed diam nonummy nibh euismod tincidunt ut laoreet dolore magna aliquam erat volutpat. Ut wisi enim ad minim veniam, quis nostrud exerci tation ullamcorper suscipit lobortis nisl ut aliquip ex ea c...

Set SECKET_KEY, then flashing message in view function: from flask import Flask, flash, render_template app = Flask(__name__) app.secret_key = 'some_secret' @app.route('/') def index(): flash('Hello, I'm a message.') return render_template('index.html') Then render the messages...

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 ...

import sys import json # load input arguments from the text file filename = sys.argv[ 1 ] with open( filename ) as data_file: input_args = json.loads( data_file.read() ) # cast strings to floats x, y = [ float(input_args.get( key )) for key in [ 'x', 'y' ] ] print json.dumps( { ...