void testit()
	{
		SimpleDateFormat sdf = new SimpleDateFormat( "yyyy-MM-dd hh:mm:ss" );
		book = new WorkBookHandle( file );
		try
		{
			sheet = book.getWorkSheet( sheetname );
		}
		catch( WorkSheetNotFoundException e )
		{
			log.error( "",e );
		}

		// get a date-time
		CellHandle a1 = null, a2 = null, a3 = null;
		int GMT_FORMAT = -1;
		try
		{
			a1 = sheet.getCell( "a1" );
			GMT_FORMAT = a1.getFormatId();
			a2 = sheet.getCell( "a2" );
			a3 = sheet.getCell( "a3" );
		}
		catch( CellNotFoundException e )
		{
			log.error( "",e );
		}

		log.info( sdf.format( DateConverter.getDateFromCell( a1 ) ) );
		log.info( sdf.format( DateConverter.getDateFromCell( a2 ) ) );
		log.info( sdf.format( DateConverter.getDateFromCell( a3 ) ) );

		// add new date to cells
		CellHandle a6 = sheet.add( new Date( System.currentTimeMillis() ), "a6" );
		log.info( a6.getFormattedStringVal() );

		CellHandle a7 = sheet.add( new Date( System.currentTimeMillis() + 5555555 ), "a7", "m/d/yy h:mm" );
		log.info( a7.getFormattedStringVal() );

		// Excel Divides the day into 100 units, so .25 is 9am, .5 is 12 noon, .75 is 9pm, and 00 is midnight
		try
		{
			sheet.add( new Float( 2000.75 ), "a5" ); // add a new cell, set date format
			CellHandle a5 = sheet.getCell( "a5" );
			a5.setFormatId( GMT_FORMAT );
			log.info( sdf.format( DateConverter.getDateFromCell( a5 ) ) );
		}
		catch( Exception e )
		{
			log.error( "setting date failed.", e );
		}

		try
		{
			// set today's date in cell A10
			Date dt = new Date( System.currentTimeMillis() );
			Calendar gc = new java.util.GregorianCalendar();
			gc.setTime( dt );
			double dd = DateConverter.getXLSDateVal( gc );
			CellHandle a10 = sheet.add( new Double( dd ), "A10" ); // add a new cell, set date format
			a10.setFormatId( GMT_FORMAT ); // set date format on cell
			log.info( sdf.format( DateConverter.getDateFromCell( a10 ) ) );
		}
		catch( Exception e )
		{
			log.error( "setting date failed.", e );
		}
		testWrite( book );
	}