i have a html form. And i want my output to be in excel sheet. Please suggest want i have to do. PHP.

Question

i have a html form. And i want my output to be in excel sheet. Please suggest want i have to do. PHP.

Answer 1

You can output the values as plain text with fields separated with a character like ; and import that in Excel as CSV.

Answer 2

<?php
// We'll be outputting a Excel
header('Content-type: application/xls');

// It will be called Test.xls
header('Content-Disposition: attachment; filename="Test.xls"');

echo "some Excel data";
?>