Monthly Archives: March 2014

Read Excel XLS Files in Java

This tutorial shows how to read Excel .xls files using Java and Apache POI. The Apache POI Project (http://poi.apache.org/) provides Java APIs for manipulating file formats based upon the Office Open XML standards (OOXML) and Microsoft’s OLE 2 Compound Document

Tagged with: ,
Posted in Java

Split a String in Java

Java String class has the method split() to split a string around matches of a given regular expression. java.lang.String: public String[] split(String regex) Parameters: regex – the delimiting regular expression Returns: the array of strings computed by splitting this string

Tagged with:
Posted in Java

Google Maps with Polygon and Marker

Google Maps API allows drawing polygons on maps. This demo shows how to build a map with a polygon and a marker altogether. In the HTML page, add a div holding the map. In JavaScript, first provide the marker location

Tagged with:
Posted in Web

Generate Slug URL in MySQL

A slug is a short name using human-readable keywords to identify a web page. For example, in the following URL the slug is new-york-art-school. This post shows how to automatically generate slug using SQL in MySQL. Suppose we have a

Tagged with: ,
Posted in MySQL, Web