Can any one know how to customise a date field??
Code: Select all
$today_display = date("m/d/Y H:i");MADHU
Moderator: General Moderators
Code: Select all
$today_display = date("m/d/Y H:i");Code: Select all
require_once "class.writeexcel_workbook.inc.php";
require_once "class.writeexcel_worksheet.inc.php";
$dir = getcwd();
$today = date("ymdHi");
$today_display = date("m/d/Y H:i");
$source_file = $today.'.xls';
$remote_file = $today.'.xls';
$fname = tempnam($dir, $source_file);
$workbook = &new writeexcel_workbook($fname);
$worksheet =& $workbook->addworksheet();
$worksheet->write(0, 0, 'USERID');
$worksheet->write(0, 1, 'PASSWORD');
$worksheet->write(0, 2, 'ADDRESS');
$worksheet->write(0, 3, 'CITY');
$worksheet->write(0, 4, 'COUNTRY');
$worksheet->write(0, 5, 'PIN');
$worksheet->write(0, 6, 'PHONE');
$worksheet->write(0, 7, 'FIRSTNAME');
$worksheet->write(0, 8, 'LASTNAME');
$worksheet->write(0, 9, 'COL_TIME');
$worksheet->write(1, 0, "madhu@bsepaper.com");
$worksheet->write(1, 1, "12345678");
$worksheet->write(1, 2, '' );
$worksheet->write(1, 3, "Akranes");
$worksheet->write(1, 4, "Iceland");
$worksheet->write(1, 5, '');
$worksheet->write(1, 6, '');
$worksheet->write(1, 7, "Madhu");
$worksheet->write(1, 8, "Hari");
$worksheet->write(1, 9, '1234');
$workbook->close();
$fh=fopen($fname, "rb");
chmod($fname,0777);
copy($fname, $dir.'/'.$source_file); //copy from temp to source file