How to make a form in php language-PHP Problem-php.cn

How to make a form in php language

(*-*)浩

Release： 2023-02-26 18:26:02

Original

4795 people have browsed it

To create or edit Excel spreadsheets using pure PHP, we will use the PHPExcel library, which can read and write many spreadsheet formats, including xls, xlsx, ods, and csv. Before we continue, double check that you have PHP 5.2 or higher on your server and that the following PHP extensions are installed: php_zip, php_xml, and php_gd2.

How to make a form in php language

Creating spreadsheets

Creating spreadsheets is one of the most common use cases in PHP applications for Export data to Excel spreadsheet. Check out the following code to learn how to create a sample Excel spreadsheet using PHPExcel: (Recommended learning: PHP Video Tutorial)

// Include PHPExcel library and create its object
require(&#39;PHPExcel.php&#39;);
 
$phpExcel = new PHPExcel;
 
// Set default font to Arial
$phpExcel->getDefaultStyle()->getFont()->setName(&#39;Arial&#39;);
 
// Set default font size to 12
$phpExcel->getDefaultStyle()->getFont()->setSize(12);
 
// Set spreadsheet properties – title, creator and description
$phpExcel ->getProperties()->setTitle("Product list");
$phpExcel ->getProperties()->setCreator("Voja Janjic");
$phpExcel ->getProperties()->setDescription("PHP Excel spreadsheet testing.");
 
// Create the PHPExcel spreadsheet writer object
// We will create xlsx file (Excel 2007 and above)
$writer = PHPExcel_IOFactory::createWriter($phpExcel, "Excel2007");
 
// When creating the writer object, the first sheet is also created
// We will get the already created sheet
$sheet = $phpExcel ->getActiveSheet();
 
// Set sheet title
$sheet->setTitle(&#39;My product list&#39;);
 
// Create spreadsheet header
$sheet ->getCell(&#39;A1&#39;)->setValue(&#39;Product&#39;);
$sheet ->getCell(&#39;B1&#39;)->setValue(&#39;Quanity&#39;);
$sheet ->getCell(&#39;C1&#39;)->setValue(&#39;Price&#39;);
 
// Make the header text bold and larger
$sheet->getStyle(&#39;A1:D1&#39;)->getFont()->setBold(true)->setSize(14);
 
// Insert product data
 
 
// Autosize the columns
$sheet->getColumnDimension(&#39;A&#39;)->setAutoSize(true);
$sheet->getColumnDimension(&#39;B&#39;)->setAutoSize(true);
$sheet->getColumnDimension(&#39;C&#39;)->setAutoSize(true);
 
// Save the spreadsheet
$writer->save(&#39;products.xlsx&#39;);

Copy after login

If you want to download the spreadsheet instead of saving it to the server , please do the following:

header(&#39;Content-Type: application/vnd.ms-excel&#39;);
header(&#39;Content-Disposition: attachment;filename="file.xlsx"&#39;);
header(&#39;Cache-Control: max-age=0&#39;);
$writer->save(&#39;php://output&#39;);

Copy after login

The above is the detailed content of How to make a form in php language. For more information, please follow other related articles on the PHP Chinese website!