Tutorial by Examples: an

//Set the row "A" height to 15 double rowHeight = 15; worksheet.Row(1).Height = rowHeight; //Set the column 1 width to 50 double columnWidth = 50; worksheet.Column(1).Width = columnWidth; When Bestfit is set to true, the column will grow wider when a user inputs numbers in a ce...

Lets say there is roles and permissions. Each role may belongs to many permissions and each permission may belongs to many role. so there will be 3 tables. two models and one pivot table. a roles, users and permission_role table. Role Model public function permissions() { return $this->bel...

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

In the following example if someone if someone presses the home button while the task is running, then the task is cancelled. In this particular cancelling it should interrupt if running. public class MainActivity extends AppCompatActivity { private static AtomicBoolean inWork; pri...

First, you need to prepare the environment by creating the SQL Server table and the CSV file. Run the script below in SQL Server to create the SQL table either on a new database or an existing one. For this example, I used my ‘TrainingDB’ database. /* Creates table for Students.csv */ CREATE TABL...

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

Private Const HashTypeMD5 As String = "MD5" ' https://msdn.microsoft.com/en-us/library/system.security.cryptography.md5cryptoserviceprovider(v=vs.110).aspx Private Const HashTypeSHA1 As String = "SHA1" ' https://msdn.microsoft.com/en-us/library/system.security.cryptography.sha1c...

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

As of Ruby 2.4.0, you can start an interactive IRB session inside any Ruby script using these lines: require 'irb' binding.irb This will start an IBR REPL where you will have the expected value for self and you will be able to access all local variables and instance variables that are in scope....

CloudCannon offers hosting and a CMS for Jekyll applications. Here are the steps in hosting your Jekyll application on CloudCannon (http://cloudcannon.com). Without version control: Create your blog locally using some local files and jekyll serve Create a CloudCannon account and create a new si...

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

RTL (Right-to-left) support is an essential part in planning for i18n and L10n. Unlike English language which is written from left to right, many languages like Arabic, Japanese, Hebrew, etc. are written from right to left. To appeal to a more global audience, it is a good idea to plan your layouts ...

Starting SDK 17 (Android 4.2), RTL support was added in Android layouts and is an essential part of localization. Going forward, the left/right notation in layouts should be replaced by start/end notation. If, however, your project has a minSdk value less than 17, then both left/right and start/end ...

To test if the layouts that have been created are RTL compatible, do the following : Go to Settings -> Developer options -> Drawing -> Force RTL layout direction Enabling this option would force the device to use RTL locales and you can easily verify all parts of the app for RTL suppo...

The first step for coding for localization is to create default resources. This step is so implicit that many developers do not even think about it. However, creating default resources is important because if the device runs on an unsupported locale, it would load all of its resources from the defau...

By default, the escape character is ~. Just go ahead and type ~. in your opened SSH session. After hitting Enter your session will end immediately. Go ahead and try it in any session, it works regardless of the responsiveness of your session.

JMeter can also can be used for recording mobile performance testing. Mobile scripts recording is very similar to web application scripts recording. Configure JMeter Configure “JMeter Templates” as specified in chapter 1. Configure your mobile phone After the JMeter configuration is prepared...

From the gnuplot 5.0 official online documentation: The command language of gnuplot is case sensitive, i.e. commands and function names written in lowercase are not the same as those written in capitals. All command names may be abbreviated as long as the abbreviation is not ambiguous. Any number...

This shows how to create the demo database used in big parts of Progress documentation: sports2000. This assumes you have installed the Progress products with at least one type of database license. Run proenv script/bat-file that will give you a prompt with all environment variables set. Create ...

List the contents of an archive file without extracting it: tar -tf archive.tar.gz Folder-In-Archive/ Folder-In-Archive/file1 Folder-In-Archive/Another-Folder/ Folder-In-Archive/Another-Folder/file2