Skip to content

Instantly share code, notes, and snippets.

View laxman954's full-sized avatar

L∈κshmαηα ρεγυmαl M laxman954

View GitHub Profile
@laxman954
laxman954 / no_of_Sheets_Excel
Created September 12, 2014 07:07
Find number of sheets in Excel
1. Click 'Ctrl+F3', then 'Name Manager' Box Appears
2. Click 'New' (use shortcut key Alt+N)
3. Then, 'New name' box appears
4. Enter 'Name' as "CountSheets"(Your choice)
5. Enter 'Refer To' as =GET.WORKBOOK(1)&T(NOW())
6. Click OK
7. It takes you to the 'Name Manager' box again (you can find the Defined Name in the list)
8. Click 'Close'
9. Come to the Cell, where you want to enter the Formula
@laxman954
laxman954 / RandomIDGeneration.java
Created September 11, 2014 14:39
Randomly Generate Unique Id using UUID -Java
import java.util.UUID;
/**
* @author lekshmana.murugan
* @since 2014-09-11 This RandomIDGeneration class Generate Unique id using UUID class is in
* util pacakage in Java Since version 1.5
* @see http://docs.oracle.com/javase/7/docs/api/java/util/UUID.html
*/
public class RandomIDGeneration {
/**
@laxman954
laxman954 / formatDay.jsp
Created September 11, 2014 14:22
Format day like 1st,2nd,3rd.. in JSP
<%@ tag body-content="empty" trimDirectiveWhitespaces="true"%>
<%@ attribute name="day" required="true" type="String"%>
<%@ taglib prefix="c" uri="http://java.sun.com/jsp/jstl/core"%>
<%@ taglib prefix="fn" uri="http://java.sun.com/jsp/jstl/functions"%>
<%@ taglib prefix="fmt" uri="http://java.sun.com/jsp/jstl/fmt"%>
<fmt:parseNumber var="n" type="number" value="${day}" />
${day}
<sup>
<c:choose>
<c:when test="${n >= 11 && n <= 13}">th </c:when>
@laxman954
laxman954 / 0_reuse_code.js
Created August 1, 2014 18:58
Here are some things you can do with Gists in GistBox.
// Use Gists to store code you would like to remember later on
console.log(window); // log the "window" object to the console