Tutorial by Examples: a

//set the total value of all cells in Sheet 2 into G27 worksheet.Cells["G27"].Formula = "=SUM('" + worksheet2.Name + "'!" + worksheet2.Dimension.Start.Address + ":" + worksheet2.Dimension.End.Address + ")"; //set the number of cells with conten...

If you use formulas, Excel will ask you to save the file every time, even if there were no changes made. To prevent this behaviour you can set the calculation mode to manual. excelPackage.Workbook.CalcMode = ExcelCalcMode.Manual; //fill the sheet with data and set the formulas excelPackage....

//create a new ExcelPackage using (ExcelPackage excelPackage = new ExcelPackage()) { //create 2 WorkSheets ExcelWorksheet worksheet = excelPackage.Workbook.Worksheets.Add("Sheet 1"); ExcelWorksheet worksheet2 = excelPackage.Workbook.Worksheets.Add("Sheet 2"); ...

Using private repos working with yarn caveat: This works using npm: "common-js": "[email protected]:<user-name>/<repo-name>.git#<identifier>" but will not work using yarn. This change is required: "common-js": "git+ssh://[email protected]:&...

Add this lane to your Fastfile and run fastlane installAll type:{BUILD_TYPE} in command line. Replace BUILD_TYPE with the build type you want to build. For example: fastlane installAll type:Debug This command will build all flavors of given type and install it to your device. Currently, it doesn't...

Code below will show you bootstrap model without writing hole long code by generating bootstrap model at run time. It will also make creating multiple bootstrap model i.e. one on other easy. Follow below simple code to make simple bootstrap model. Include below CSS to your code <link rel=&quot...

Include below CSS to your code <link rel="stylesheet" href="https://maxcdn.bootstrapcdn.com/bootstrap/3.3.7/css/bootstrap.min.css"> <link rel="stylesheet" href="https://cdnjs.cloudflare.com/ajax/libs/bootstrap3-dialog/1.34.7/css/bootstrap-dialog.min.css&...

Include below CSS to your code <link rel="stylesheet" href="https://maxcdn.bootstrapcdn.com/bootstrap/3.3.7/css/bootstrap.min.css"> <link rel="stylesheet" href="https://cdnjs.cloudflare.com/ajax/libs/bootstrap3-dialog/1.34.7/css/bootstrap-dialog.min.css&...

package com { package utility { package serialization { class Serializer ... } } }

Dim oDic Set oDic = CreateObject("Scripting.Dictionary") oDic.Add "US", "United States of America" oDic.Add "UK", "United Kingdom"

If oDic.Exists("US") Then msgbox "The Key US Exist. The value is " + oDic("US") Else msgbox "Key Does not exist." End If

If oDic.Exists("UK") Then oDic.remove("UK") End If

If you do not want to use ASPNETCORE_ENVIRONMENT from environment variables and use it from web.config of your application then modify web.config like this- <aspNetCore processPath=".\WebApplication.exe" arguments="" stdoutLogEnabled="false" stdoutLogFile=".\lo...

The <div> in this template grows to 50px and then 100px and then shrinks back to 20px when you click the button. Each state has an associated style described in the @Component metadata. The logic for whichever state is active can be managed in the component logic. In this case, the component...

Main layout : activity_main.xml <?xml version="1.0" encoding="utf-8"?> <LinearLayout xmlns:android="http://schemas.android.com/apk/res/android" android:id="@+id/activity_main" android:layout_width="match_parent" android:layo...

We can create a service to set and get the data between the controllers and then inject that service in the controller function where we want to use it. Service : app.service('setGetData', function() { var data = ''; getData: function() { return data; }, setData: function(requestData)...

This example shows the basic type inferences the compiler can perform. auto a = 1; // a = int auto b = 2u; // b = unsigned int auto c = &a; // c = int* const auto d = c; // d = const int* const auto& e = b; // e = const unsigned int& auto x = a...

The data type auto keyword is a convenient way for programmers to declare lambda functions. It helps by shortening the amount of text programmers need to type to declare a function pointer. auto DoThis = [](int a, int b) { return a + b; }; // Do this is of type (int)(*DoThis)(int, int) // e...

This example shows how auto can be used to shorten type declaration for for loops std::map<int, std::string> Map; for (auto pair : Map) // pair = std::pair<int, std::string> for (const auto pair : Map) // pair = const std::pair<int, std::string> for (c...

Declare two receivers in a manifest file: <receiver android:name=".UVMateWidget" android:label="UVMate Widget 1x1"> <intent-filter> <action android:name="android.appwidget.action.APPWIDGET_UPDATE" /> </intent-filter...