PHP通过get方法获得form表单数据方法总结

// Include PHPExcel library and create its objectrequire('PHPExcel.php');$phpExcel = new PHPExcel;// Set default font to Arial$phpExcel->getDefaultStyle()->getFont()->setName('Arial');// 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('My product list');// Create spreadsheet header$sheet ->getCell('A1')->setValue('Product');$sheet ->getCell('B1')->setValue('Quanity');$sheet ->getCell('C1')->setValue('Price');// Make the header text bold and larger$sheet->getStyle('A1:D1')->getFont()->setBold(true)->setSize(14);// Insert product data// Autosize the columns$sheet->getColumnDimension('A')->setAutoSize(true);$sheet->getColumnDimension('B')->setAutoSize(true);$sheet->getColumnDimension('C')->setAutoSize(true);// Save the spreadsheet$writer->save('products.xlsx');

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

// Include PHPExcel library and create its objectrequire('PHPExcel.php');// Load an existing spreadsheet$phpExcel = PHPExcel_IOFactory::load('products.xlsx');// Get the first sheet$sheet = $phpExcel ->getActiveSheet();// Remove 2 rows starting from the row 2$sheet ->removeRow(2,2);// Insert one new row before row 2$sheet->insertNewRowBefore(2, 1);// Create the PHPExcel spreadsheet writer object// We will create xlsx file (Excel 2007 and above)$writer = PHPExcel_IOFactory::createWriter($phpExcel, "Excel2007");// Save the spreadsheet$writer->save('products.xlsx');

$sheet->getPageSetup()->setOrientation(PHPExcel_Worksheet_PageSetup::ORIENTATION_LANDSCAPE);$sheet -> getPageSetup()->setPaperSize(PHPExcel_Worksheet_PageSetup::PAPERSIZE_A4); $sheet->getPageMargins()->setTop(1);$sheet ->getPageMargins()->setRight(0.75);$sheet ->getPageMargins()->setLeft(0.75);$sheet ->getPageMargins()->setBottom(1);

Excel::create('Products', function($excel) {        // Set the title        $excel->setTitle('Product list');          // Set the creator        $excel->setCreator('Voja Janjic');          // Set description        $excel->setDescription('PHP Excel spreadsheet testing');          $excel->sheet('Products', function($sheet) {                   // Get data from the database                $products = Product::all();                   // Generate header row                $sheet->row(1, array(                        'ID',                        'Product',                        'Price',                        'Quantity',                     ));                  // Generate data rows                 $i = 2;                 foreach($products as $product) {                            $sheet->row($i, array(                                   $product->product_id,                                   $product->product_name,                                   $product->price,                                   $variety->quantity,                            ));                           $i++;                }        });})->export('xlsx');