I am exporting data from a mysql db into xls format using the following code headers:
header("Content-Type: application/vnd.ms-excel;name='excel'");
header("Content-Disposition: attachment; filename=hbscAccListing.xls");
There are 46 records in the file but only 24 are appearing when I open the file in excel97. My select statement must be Ok as the exact same file works fine using a database via a local Apache Server during testing.
Is there a known bug causing this to happen??😕
