Tutorial by Examples: le

//create a list to hold all the values List<string> excelData = new List<string>(); //read the Excel file as byte array byte[] bin = File.ReadAllBytes("C:\\ExcelDemo.xlsx"); //or if you use asp.net, get the relative path byte[] bin = File.ReadAllBytes(Server.MapPath(&q...

Let's say that you have the following class: public class PersonInfo { public int ID { get; set; } [Display(Name = "First Name")] [Required(ErrorMessage = "Please enter your first name!")] public string FirstName{ get; set; } [Display(Name = "L...

//set the formatting options ExcelTextFormat format = new ExcelTextFormat(); format.Delimiter = ';'; format.Culture = new CultureInfo(Thread.CurrentThread.CurrentCulture.ToString()); format.Culture.DateTimeFormat.ShortDatePattern = "dd-mm-yyyy"; format.Encoding = new UTF8Encoding(); ...

In the file myConfig.groovy is the following content. message = 'Hello World!' aNumber=42 aBoolean=false aList=["apples", "grapes", "oranges"] Then in your main script you create a ConfigSlurper for your myConfig.groovy file which is really just another groovy sc...

public String getCitiesByCountry(String countryName) throws MalformedURLException, IOException { //Code to make a webservice HTTP request String responseString = ""; String outputString = ""; String wsURL = "http://www.webservicex.com/globalweather.asm...

When it comes to dealing with timing issue, it is tempting and easy to put a "quick" browser.sleep(<timeout_in_milliseconds>) and move on. The problem is, it would some day fail. There is no golden/generic rule on what sleep timeout to set and, hence, at some point due to network or...

Using a CASE statement, conditionally display an expression in the column based on values found in another column, a.k.a. “my kingdom for an OR”. In the example, the result is obtained when the status of the transaction is Pending Fulfillment or Partially Fulfilled: CASE DECODE( {status}, 'Pending ...

The example builds a string from the name of the parent record, the name of this record, and the memo of this record. {createdfrom} || ' ' || {name} || ' ' || {memo}

'<div style="font-size:11pt">' || expression || '</div>'

The following example combines several of the techniques covered here. It puts a hyperlink in a custom formatted column which, when clicked, opens the sales order record associated with a row. The hyperlink is designed to open the record in a new window or tab when clicked, and to display a tooltip ...

If you haven't already lets simply start this file of with: class HelloWorldLeftAndMain extends LeftAndMain { } Configure The first thing you should do, is define the $url_segment that will be used to access the interface, and the title ($menu_title) that will appear in the side navigation m...

The expected structure of this template can be a bit convoluted but it all boils down to this: There are 3 sections worth noting for this guide: .north .center .south It must be wrapped entirely within an element that has the data-pjax-fragment="Content" attribute. This is...

Variable declaration @buttonColor: #FF0000; /* Now you can use @buttonColor variable with css Functions. */ .product.into.detailed { additional-attributes{ .lib-table-button( background-color: @buttonColor; ); } } Here function lib-tabgle-button used v...

winsound Windows environment import winsound winsound.PlaySound("path_to_wav_file.wav", winsound.SND_FILENAME) wave Support mono/stereo Doesn't support compression/decompression import wave with wave.open("path_to_wav_file.wav", "rb") as wav_file: #...

let frame = CGRect(x: 0, y: 100, width: 320, height: 10) let slider = UISlider(frame: frame) slider.addTarget(self, action: #selector(sliderAction), for: .valueChanged) slider.backgroundColor = .clear slider.minimumValue = 0.0 slider.maximumValue = 50.0 //sending a NO/False would updat...

navigationController?.navigationBar.titleTextAttributes = [NSForegroundColorAttributeName: UIColor.white, NSFontAttributeName:UIFont(name: "HelveticaNeue-CondensedBold", size: 17)!,] navigationController?.navigationBar.tintColor = .white navigationController?.navigationBar.barTintColor =...

If we have a c++ project that uses a config.h configuration file with some custom paths or variables, we can generate it using CMake and a generic file config.h.in. The config.h.in can be part of a git repository, while the generated file config.h will never be added, as it is generated from the cu...

If you have a cmake module . You can create a folder called in to store all config files. For example,you have a project called FOO, you can create a FOO_config.h.in file like: //=================================================================================== // CMake configuration file, base...

my @letters = ( 'a' .. 'z' ); # English ascii-bet print $letters[ rand @letters ] for 1 .. 5; # prints 5 letters at random How it works rand EXPR expects a scalar value, so @letters is evaluated in scalar context An array in scalar context returns the number of elements it ...

A std::tuple<T...> can be used to pass multiple values around. For example, it could be used to store a sequence of parameters into some form of a queue. When processing such a tuple its elements need to be turned into function call arguments: #include <array> #include <iostream>...