Get the Last Filled Row or Column in Any Excel Spreadsheet
Sometimes you need to know which is the last row or column in an Excel sheet that contains actual data. To do that, use the following code: ‘ Find last
Sometimes you need to know which is the last row or column in an Excel sheet that contains actual data. To do that, use the following code: ‘ Find last
This code snippet creates a Validator that you can use to validate an XML document represented as a DOMSource. //create a DocumentBuilderFactory objectDBF=DocumentBuilderFactory.newInstance(); //activating namespaces supportDBF.setNamespaceAware(true); //create a DocumentBuilder objectDB=DBF.newDocumentBuilder();
When a WPF control gains the focus, it displays a dashed box around itself to indicate that it has the focus. In some cases, the focus rectangle can detract from
This example assumes the main page from which users will pop up the calendar is named Calender.aspx. The following procedure shows how to create the popup calendar: In Calendar.aspx, add
The .NET Framework includes a SoundPlayer class (in System.Media) that can play sound files. However, this class suffers from two crippling limitations: it can play only PCM-encoded WAV files, and
Even though this is a reserved word in JavaScript, the following code fails… with(parent){…this.window.event…} …because it can’t back out of parent. The workaround is to assign the window object to
You can create a list of a specific type at run time by passing the type to the MakeGenericType method, for example: Type t = Type.GetType(“System.Int32”);IList tList= (IList)Activator.CreateInstance( (typeof(List<>).MakeGenericType(t))); tList.GetType().FullName
The following code gets all the properties of an Employee class using Reflection. Here’s the Employee class code: class Employee{ private int m_age; private string m_name; public int Age {
The following code snippet is J2SE 6.0 code that uses the setRequestProperty method to send cookies to the server. You can find more information about cookies and the complete application