PHP export to Excel: Define Excel Sheetname
Posted on 2006-06-16
I am currently exporting data from php to excel using the following method:
header("Content-Disposition: attachment; filename=ExcelFile.xls;");
This works fine, but the generated excel file has a sheetname of: ".xls]ExcelFile(1)" , and when you try to rename the sheet it causes an error in excel.
How can I define the sheetname in my php file?