" Live as if you were to die tomorrow. Learn as if you were to live forever.. "
- Mahatma Gandhi

Creating Macros in Excel

Posted on November 23rd, 2015 by Srikant Das

Macros are nothing but short cuts for creating repetative tasks in Excel. Following are the steps outlined to create a new macro. 1. Click on Start>Programs>Microsoft office>Microsoft Excel to open the application. Then, go to Start>New to open a new spreadsheet. Go to File>Save as and save the new file as Book1.xls 2. Go to […]

Reading datetime value from Excel cell using C#

Posted on November 23rd, 2015 by Amrita Dash

Excel stores the datetime value as a serial number.The date January 1, 1900 is treated as day 1 and all the date and time values are calculated accordingly. Also excel saves the time value as a fractional number from 0 to 1. So the date part is a whole number and time is the fractional […]

Creating an Excel sheet from a CSV file in VB.Net

Posted on November 23rd, 2015 by Shibani Shubhadarshini

The following code lines are useful to create an Excel sheet from a CSV file in VB.Net. We need to pass the complete folder path and csv file name as two parameters. In the code I have given “NewExcelFile.xls” as the file name for new file to be created. This code will generate an NewExcelFile.xls […]

How to read an excelsheet from Java

Posted on November 23rd, 2015 by Tanmayee Sahoo

There are a number of ways to read an excelsheet from Java. JExcel is one of them. JExcel API is an opensource Java API which enables developers to read, write and edit excelsheet dynamically in a platform independent way. One good thing about JExcel is that it has no dependencies on any third party libraries. […]