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 […]

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 […]

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 […]

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. […]