Tutorial by Examples: c

Remove all conditional format in range: Range("A1:A10").FormatConditions.Delete Remove all conditional format in worksheet: Cells.FormatConditions.Delete

Highlighting Duplicate Values With Range("E1:E100").FormatConditions.AddUniqueValues .DupeUnique = xlDuplicate With .Font .Bold = True .ColorIndex = 3 End With End With Highlighting Unique Values With Range("E1:E100").FormatConditions.AddUniqueVa...

Highlighting Top 5 Values With Range("E1:E100").FormatConditions.AddTop10 .TopBottom = xlTop10Top .Rank = 5 .Percent = False With .Font .Bold = True .ColorIndex = 3 End With End With

With Range("E1:E100").FormatConditions.AddAboveAverage .AboveBelow = xlAboveAverage With .Font .Bold = True .ColorIndex = 3 End With End With Operators: NameDescriptionXlAboveAverageAbove averageXlAboveStdDevAbove standard deviationXlBelowAverageBelow ...

You need to include the Pagination.php in your page/s. require_once 'Paginator.php'; $Paginator = new Paginator('mysql:host=localhost;dbname=ng_app', 'root', '000000'); $Paginator->setItemLimitPerPage(4); $Paginator->setTable('comments'); $Paginator->createPages(); // this will creat...

Range("a1:a10").FormatConditions.AddIconSetCondition With Selection.FormatConditions(1) .ReverseOrder = False .ShowIconOnly = False .IconSet = ActiveWorkbook.IconSets(xl3Arrows) End With With Selection.FormatConditions(1).IconCriteria(2) .Type = xlConditionValueP...

This example shows how you might handle users interacting with modals on a 1-1 basis. //client side function modals(socket) { this.sendModalOpen = (modalIdentifier) => { socket.emit('openedModal', { modal: modalIdentifier }); }; this.closeModa...

Normally when rails environment is run by typing. This just runs the default environment which is usually development rails s The specific environment can be selected by using the flag -e for example: rails s -e test Which will run the test environment. The default environment can be change...

InputBox, userinput This will store what the user types into the input box in the variable named userinput

String hostName = args[0]; int portNumber = Integer.parseInt(args[1]); try ( Socket echoSocket = new Socket(hostName, portNumber); PrintWriter out = new PrintWriter(echoSocket.getOutputStream(), true); BufferedReader in = new BufferedReader( new Inpu...

WarehosueEntity findWarehouseById(@Param("id") Long id); List<WarehouseEntity> findWarehouseByIdIn(@Param("idList") List<Long> warehouseIdList);

Sending The Request Header $uri = 'http://localhost/http.php'; $ch = curl_init($uri); curl_setopt_array($ch, array( CURLOPT_HTTPHEADER => array('X-User: admin', 'X-Authorization: 123456'), CURLOPT_RETURNTRANSFER =>true, CURLOPT_VERBOSE => 1 )); $out = curl_exec($ch...

CREATE TABLE Table1 ( id INT UNSIGNED NOT NULL, created_on DATE NOT NULL, PRIMARY KEY (id) ) CREATE TABLE Table2 ( id INT UNSIGNED NOT NULL, personName VARCHAR(255) NOT NULL, PRIMARY KEY (id) ) CREATE TABLE Table3 ( id INT UNSIGNED NOT NULL, accountName VA...

Basically to apply a theme for SearchView extracted as app:actionViewClass from the menu.xml, we need understand that it depends completely on the style applied to the underlying Toolbar. To achieve themeing the Toolbar apply the following steps. Create a style in the styles.xml <style name=&qu...

Our TCP echo back server will be a separate thread. It's simple as its a start. It will just echo back whatever you send it but in capitalised form. public class CAPECHOServer extends Thread{ // This class implements server sockets. A server socket waits for requests to come // in ove...

public class JSEngine { /* * Note Nashorn is only available for Java-8 onwards * You can use rhino from ScriptEngineManager.getEngineByName("js"); */ ScriptEngine engine; ScriptContext context; public Bindings scope; // Initialize t...

class Person { constructor(firstname, lastname) { this._firstname = firstname; this._lastname = lastname; } get firstname() { return this._firstname; } set firstname(name) { this._firstname = name; } get lastname() { return this._lastname; } ...

import Json.Decode as JD import Json.Decode.Pipeline as JP type PostType = Image | Video type alias Post = { id: Int , postType: PostType } -- assuming server will send int value of 0 for Image or 1 for Video decodePostType: JD.Decoder PostType decodePostType = JD.int |&...

Processlist This will show all active & sleeping queries in that order then by how long. SELECT * FROM information_schema.PROCESSLIST ORDER BY INFO DESC, TIME DESC; This is a bit more detail on time-frames as it is in seconds by default SELECT ID, USER, HOST, DB, COMMAND, TIME as time_second...

If you want to notify other clients/users throughout the application ,you not need to worry about the connection because signalr new connection is created every time you visit other pages in the web app. we can leverage the users feature of signalr to achieve the same. see the example below: Here...