Excel 相關應用

session_cache_limiter('private');

session_cache_limiter('public');
header("Content-type: application/vnd.ms-excel; charset=BIG5;");
header("Content-Disposition: inline; filename=UniformCashNewReport.xls;");

or

session_cache_limiter('public');
header("Content-type: application/vnd.ms-excel; charset=UTF8;");
header("Content-Disposition: inline; filename=MachAuditReport.xls;");

日期格式
Style='mso-number-format:\"yyyy\\-mm\\-dd\"'
Style='mso-number-format:\"yyyy\\-mm\\-dd hh\\:mm\"'

字串格式
Style='mso-number-format:\"\@\";'