Tutorial by Examples: et

//Add a DateTime Validation to column F var val4 = worksheet.DataValidations.AddDateTimeValidation("F:F"); //For DateTime Validation, you have to set error message to true val4.ShowErrorMessage = true; //Minimum allowed date val4.Formula.Value = new DateTime(2017,03,15, 01, 0,0); /...

For Getting updated or to do something before app goes live to user you can use below method. AppDidFinishLaunching - (BOOL)application:(UIApplication *)application didFinishLaunchingWithOptions:(NSDictionary *)launchOptions { // Write your code before app launch return YES; } While ...

Just like PowerShell functions, workflows can accept input parameter. Input parameters can optionally be bound to a specific data type, such as a string, integer, etc. Use the standard param keyword to define a block of input parameters, directly after the workflow declaration. workflow DoSomeWork ...

type ProjectIdType = ProjectId String getProject : ProjectIdType -> Cmd Msg getProject (ProjectId id) = Http.get <| "/projects/" ++ id

Example: s = "Hello" # s is a string Then we find out something about s. Lets begin: So you want to know what is the class of s at run time? irb(main):055:0* s.class => String Ohh, good. But what are the methods of s? irb(main):002:0> s.methods => [:unicode_normalize,...

StrictMode.setThreadPolicy(new StrictMode.ThreadPolicy.Builder() .detectDiskWrites() .penaltyLog() //Logs a message to LogCat .build())

StrictMode.setVmPolicy(new StrictMode.VmPolicy.Builder() .detectActivityLeaks() .detectLeakedClosableObjects() .penaltyLog() .build());

Detailed instructions on getting apache-spark-sql set up or installed.

$ cut -d, -f1,3 <<<"a,,b,c,d,e" a,b is rather obvious, but with space-delimited strings it might be less obvious to some $ cut -d ' ' -f1,3 <<<"a b c d e" a b cut cannot be used to parse arguments as the shell and other programs do.

In previous versions, setting up provisioning profiles was done manually. You generate distribution profile, download it and then distribute your app. This had to be done for every development machine which was extremely time consuming. However, in most situations nowadays, Xcode 8 will do most of t...

Once the provisioning profiles are all set, next step in the process of submitting the app is to archive your code. From the dropdown of devices and simulators select option "Generic iOS device". Then, under "Product" menu select option "Archive". In case where the s...

Environment Setup: Download android sdk of API level 17 or more Node.js (https://nodejs.org/) Appium software (http://appium.io/) Selenium jars (http://www.seleniumhq.org/download/) Appium jar (https://search.maven.org/#search%7Cga%7C1%7Cg%3Aio.appium%20a%3Ajava-client) .apk file of the appl...

SELECT E.LAST_NAME|| ' reports to ' || PRIOR E.LAST_NAME "Walk Top Down" FROM HR.EMPLOYEES E START WITH E.MANAGER_ID IS NULL CONNECT BY PRIOR E.EMPLOYEE_ID = E.MANAGER_ID;

Detailed instructions on getting quartz.net set up or installed.

' How To Seek Past VBA's 2GB File Limit ' Source: https://support.microsoft.com/en-us/kb/189981 (Archived) ' This must be in a Class Module Option Explicit Public Enum W32F_Errors W32F_UNKNOWN_ERROR = 45600 W32F_FILE_ALREADY_OPEN W32F_PROBLEM_OPENING_FILE W32F_FILE_ALREAD...

We can create Singleton class in such a way that developers are forced to used the shared instance (singleton object) instead of creating their own instances. @implementation MySingletonClass + (instancetype)sharedInstance { static MySingletonClass *_sharedInstance = nil; static dispa...

Detailed instructions on getting corona set up or installed.

SWIFT: Getting an instance of UIStoryboard programmatically can be done as follows: let storyboard = UIStoryboard(name: "Main", bundle: nil) where: name => the name of the storyboard without the extension bundle => the bundle containing the storyboard file and its relate...

In version 2.10, JMeter introduced a mechanism that saves you time when creating scripts - JMeter Templates. These templates are skeletons that can be reused as the base for your new scripts. JMeter already has several available templates with detailed descriptions, and you can also add your own. T...

JMeter also enables you to manually configure your workspace. It’s more complex, but you can make the scripts fit your exact needs. Configure your browser proxy Configure your browser, as described in chapter 1. Configure JMeter The “WorkBench” branch can be used as a temporary workspace for...