Tutorial by Examples: an

Dim lo as ListObject Set lo = Sheet1.ListObjects("Table1") lo.Unlist

This example is a quick setup of Angular and how to generate a quick example project. Prerequisites: Node.js 6.9.0 or greater. npm v3 or greater or yarn. Typings v1 or greater. Open a terminal and run the commands one by one: npm install -g typings or yarn global add typings npm install -...

The idea behind the AdhocWorkspace is to create a workspace on the fly. var workspace = new AdhocWorkspace(); string projectName = "HelloWorldProject"; ProjectId projectId = ProjectId.CreateNewId(); VersionStamp versionStamp = VersionStamp.Create(); ProjectInfo helloWorldProject = P...

The MSBuildWorspace is built around the concept of handling MSBuild solutions (.sln files) and their respective projects (.csproj, .vbproj). Adding new projects and documents to this workspace is not supported. string solutionPath = @"C:\Path\To\Solution\Sample.sln"; MSBuildWorkspace ...

Swift: centralManager.scanForPeripherals(withServices: nil, options: nil) Objective C: [centralManager scanForPeripheralsWithServices:nil options:nil];

Swift: let services = [CBUUID(string: SERVICE1_UUID), CBUUID(string: SERVICE2_UUID)] centralManager.scanForPeripherals(withServices: services, options: nil) Objective C: NSArray *services = @[[CBUUID UUIDWithString:SERVICE1_UUID], [CBUUID UUIDWithString:SERVICE2_UUID]]; [centralManager scanFo...

Swift: var centralManager:CBCentralManager! centralManager = CBCentralManager(delegate: self, queue: nil) Objective C: @property (nonatomic, strong) CBCentralManager *centralManager; centralManager = [[CBCentralManager alloc] initWithDelegate:self queue:nil];

Swift: var centralManager:CBCentralManager! centralManager = CBCentralManager(delegate: self, queue: nil, options: [CBCentralManagerOptionRestoreIdentifierKey : "com.companyname.appname.central"]) Objective C: @property (nonatomic, strong) CBCentralManager *centralManager; self....

Inline expansion (also known as inlining) is compiler optimisation that replaces a call to a function with the body of that function. This saves the function call overhead, but at the cost of space, since the function may be duplicated several times. // source: int process(int value) { ret...

Replace operator: The -replace operator replaces a pattern in an input value using a regular expression. This operator uses two arguments (separated by a comma): a regular expression pattern and its replacement value (which is optional and an empty string by default). "The rain in Seattle&quo...

I would like to point out that we rotate left when the shifting value is negative and we rotate right when the value is positive. public static void Main() { int[] array = { 1, 2, 3, 4, 5, 6, 7, 8, 9, 10 }; int shiftCount = 1; Rotate(ref array, shiftCount); ...

There qutie a fiew ways to get the sematic model. From a Document class Document document = ...; SemanticModel semanticModel = await document.GetSemanticModelAsync(); From a Compilationclass CSharpCompilation compilation = ...; var semanticModel = await compilation.GetSemanticModel...

As this documentation explains, Sometimes a resource file will need to contain a value that can only be supplied at build time. To accomplish this in Maven, put a reference to the property that will contain the value into your resource file using the syntax ${<property name>}. The property ...

Design Patterns provide solutions to the commonly occurring problems in software design. The design patterns were first introduced by GoF(Gang of Four) where they described the common patterns as problems which occur over and over again and solutions to those problems. Design patterns have four ess...

it caused by your batch size too small, which lead to a lot of ROS Containers created and reach the limitation(1024 default). you should do defragment using TupleMover task(mergeout) before the error raised. To do troubleshooting: ROS Containers viewed from the projections. select * from STOR...

it often happened some rows with format issue, data type issue rejected by copy command while try load it by copy command. the query return succeed but some of data rejected. To do troubleshooting save Rejected Data and Exceptions COPY large_tbl FROM :file1 ON site01, :file2 O...

Before deploying the angular project in server we need to build angular project for production. We also need to change the routing path in index.html file from <base href=”/”> to <base href=”./”> if it is not done then your project wouldn’t get loaded properly there will be some routing ...

ng build –prod Above given command with extra option like –prod would generate the production build project bundle. Once the above command gets executed in the root directory of your project would appear a directory called dist. In which all the production build bundle of your project appears in ...

Once the dist directory is ready with your production built bundles. Just open the dist directory and open the command prompt type the following command to create the war file to deploy your project on apache tomcat server. jar cvf dist.war . Once the above jar commands gets executed. It wou...

Cut/Copy the dist.war file from dist directory and place it in apache tomcat webapp directory. Go to apache tomcat bin folder and double click on startup.bat file. Now tomcat server will execute dist.war file and startup the tomcat catalina server. Once the tomcat catalina server gets started o...