Tutorial by Examples: ai

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

dvConstraint = (XSSFDataValidationConstraint)validationHelper.CreateExplicitListConstraint(new string[] { "MON", "TUE" , "WED", "THU", "FRI"});

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

string emailValidationFormula = GetEmailValidationFormula(targetFirstCol); CellRangeAddressList cellRangeFieldsType5 = new CellRangeAddressList(1, DVRowLimit, targetFirstCol, targetLastCol); dvConstraint = (XSSFDataValidationConstraint)validationHelper.CreateCustomConstraint(emailValidation...

if you want to see component's individual coverage of tests follow these steps. npm install --save-dev karma-teamcity-reporter Add `require('karma-teamcity-reporter')` to list of plugins in karma.conf.js ng test --code-coverage --reporters=teamcity,coverage-istanbul note that l...

The documentation of apply says the following: calls the specified function block with this value as its receiver and returns this value. While the kdoc is not so helpful apply is indeed an useful function. In layman's terms apply establishes a scope in which this is bound to the object you ca...

Camel's DSL (Domain Specific Language) is one of the features that makes Camel standout from other Integration frameworks. While some other frameworks also feature a DSL concept, typically in the form of a XML file, the DSL was in such cases always a custom based language. Camel offers multiple DSL...

If the promise doesn't return anything, the async task can be completed using await. try{ await User.findByIdAndUpdate(user._id, { $push: { tokens: token } }).exec() }catch(e){ handleError(e) }

In Spark, a DataFrame is a distributed collection of data organized into named columns. It is conceptually equivalent to a table in a relational database or a data frame in R/Python, but with richer optimizations under the hood. DataFrames can be constructed from a wide array of sources such as stru...

Let's try to look at the differences between client and cluster mode of Spark. Client: When running Spark in the client mode, the SparkContext and Driver program run external to the cluster; for example, from your laptop. Local mode is only for the case when you do not want to use a cluster and in...

function sum(numbers) { return tail_sum(numbers, 0); } function tail_sum(numbers, acc) { if(numbers.length == 0) { return acc; } return tail_sum(numbers.slice(1), acc + numbers[0]); } in the tail recursive version, function return value does not need to wait till...

The MyFrame class the extends JFrame and also contains the main method import javax.swing.JFrame; public class MyFrame extends JFrame{ //main method called on startup public static void main(String[] args) throws InterruptedException { //creates a frame window ...

Choosing which C++ Container to use can be tricky, so here's a simple flowchart to help decide which Container is right for the job. This flowchart was based on Mikael Persson's post. This little graphic in the flowchart is from Megan Hopkins

After installing perforce and setup your workspace through p4v, you could set up your workspace in Windows cmd. The command you need is: p4 set Set your server p4 set P4PORT= xx.xxx.xx.xxx:xxxxx Set your user name p4 set P4USER=username Set your password In terms of setting your passwo...

Basically, in order to insert records to nedb, the data is stored in the form of json with the key being the column names and the value for those names will be the values for that record. var rec = { name: 'bigbounty',age:16}; db.insert(rec, function (err, newrec) { // Callback is optional ...

.container has one fixed width for each screen size in bootstrap (xs,sm,md,lg); .container-fluid expands to fill the available width. @media (min-width: 568px) { .container { width: 550px; } } @media (min-width: 992px) { .container { width: 970px; } } @media (min-width: 1...

Steps to create MYSQL database Login to amazon account and select RDS service Select Launch DB Instance from the instance tab By defaul MYSQL Community Edition will be selected, hence click the select button Select the database purpose, say production and click next step Provide the mysql ver...

To list available mix tasks use: mix help To get help on a specific task use mix help task e.g.: mix help cmd

<key>CFBundleDocumentTypes</key> <array> <dict> <key>CFBundleTypeIconFile</key> <string>Icon file for associated file</string> <key>CFBundleTypeName</key> <string>My file format</string>...

mView.afterMeasured { // inside this block the view is completely drawn // you can get view's height/width, it.height / it.width } Under the hood inline fun View.afterMeasured(crossinline f: View.() -> Unit) { viewTreeObserver.addOnGlobalLayoutListener(object : ViewTreeObserver.OnGlob...