Tutorial by Examples: d

Required JARs on classpath: javax.money:money-api:1.0 (JSR354 money and currency api) org.javamoney:moneta:1.0 (Reference implementation) javax:annotation-api:1.2. (Common annotations used by reference implementation) // Let's create non-ISO currency, such as bitcoin // At first, t...

Using named ranges allows you to describe the meaning of a cell(s) contents and use this defined name in place of an actual cell address. For example, formula =A5*B5 can be replaced with =Width*Height to make the formula much easier to read and understand. To define a new named range, select cell ...

Create new named range called ‘MyRange’ assigned to cell A1 ThisWorkbook.Names.Add Name:="MyRange", _ RefersTo:=Worksheets("Sheet1").Range("A1") Delete defined named range by name ThisWorkbook.Names("MyRange").Delete Access Named Range by name...

Formulas tab > Defined Names group > Name Manager button Named Manager allows you to: Create or change name Create or change cell reference Create or change scope Delete existing named range Named Manager provides a useful quick look for broken links.

Example sheet Code Sub Example() Dim wks As Worksheet Set wks = ThisWorkbook.Worksheets("Sheet1") Dim units As Range Set units = ThisWorkbook.Names("Units").RefersToRange Worksheets("Sheet1").Range("Year_Max").Value =...

BatchBashDescriptioncommand /?man commandShows the help for commandbitsadminwget or curlDownloads a remote filecertutil -hashfile file_name MD5md5sum file_nameGets the MD5 checksum of file_namecdpwdDisplays the current directorycd directorycd directoryChanges the current directory to the specified o...

BatchBashDescription%variable%$variableA regular variable!variable!$variableA variable inside of a code block when setlocal enabledelayedexpansion is on%errorlevel% or ERRORLEVEL$?Returns the status of the previous command: 0 if successful, 1 (or something else) if not%1, %2, %3, etc.$1, $2, $3, etc...

Windows provides an explicit interface through which the winsound module allows you to play raw beeps at a given frequency and duration. import winsound freq = 2500 # Set frequency To 2500 Hertz dur = 1000 # Set duration To 1000 ms == 1 second winsound.Beep(freq, dur)

Using immutable locals: Uses less horizontal space but more vertical space than the "anonymous temporaries" template. Preferable over the "anonymous temporaries" template if the when expression is in a loop--in that case, regex definitions should be placed outside the loop. im...

The static factory method is a variation of the factory method pattern. It is used to create objects without having to call the constructor yourself. When to use the Static Factory Method if you want to give a meaningfull name to the method that generates your object. if you want to avoid over...

When a method is defined to be a macro, the compiler takes the code that is passed as its argument and turns it into an AST. It then invokes the macro implementation with that AST, and it returns a new AST that is then spliced back to its call site. import reflect.macros.blackbox.Context object ...

Declare @userList Table(UserKey VARCHAR(60)) Insert into @userList values ('bill'),('jcom'),('others') --Declared a table variable and insert 3 records Declare @text XML Select @text = ( select UserKey from @userList for XML Path('user'), root('group') ) --Set the XML value from ...

using System; using System.Speech.Synthesis; using System.Windows; namespace Stackoverflow.SpeechSynthesisExample { public partial class SpeechSynthesisSample : Window { public SpeechSynthesisSample() { InitializeComp...

This example demonstrates how a cross origin http request can be handled using a middleware. CORS Background CORS is an access control method adopted by all major browsers to avert Cross Scripting Vulnerabilities inherent by them. In general browser security, scripts should maintain that all XHR r...

Let's say you need to add a field to every document in a collection. import pymongo client = pymongo.MongoClient('localhost', 27017) db = client.mydb.mycollection for doc in db.find(): db.update( {'_id': doc['_id']}, {'$set': {'newField': 10} }, upsert=False, multi=False...

Previously, datatables were initialized as follows: var oTable = $("#selector").dataTable(); This used to return a jQuery object which would stored in the variable oTable. And then to access the api to modify table properties, we had to initialize the api differently, as shown below: ...

The following 3 features (that were deprecated in 1.9) are no longer available in 1.10, they are : fnRender: According to the deverloper: The old fnRender option provided a method of manipulating a cell when it was created. however, it was provided with a confusing list of options as its a...

Conditional predicate will be cleaner and safer by using the NSCompoundPredicate class which provides basic boolean operators for the given predicates. Objective-c AND - Condition NSPredicate *predicate = [NSPredicate predicateWithFormat:@"samplePredicate"]; NSPredicate *anotherPre...

This code create a producer which send two messages to a queue, and a consumer which receives all the messages from that queue. Code for producer.py (using the pika 0.10.0 Python client): import pika connection = pika.BlockingConnection(pika.ConnectionParameters( host='localhost')) ch...

This approach was introduced in JSR 286. In JSR 168,render parameters set in processAction of a portlet were available only in that portlet.With the Public Render Parameters feature, the render parameters set in the processAction of one portlet will be available in render of other portlets also.In ...