phpexcel-Set table font color background style, data format, alignment, add picture, annotation, text block, merge split cell, cell password protection ____php

First go to the phpexcel official website to download the latest phpexcel class. Next week, decompress a classes folder, which contains the folders of PHPExcel.php and PHPExcel. This class file and folder are what we need. Decompress the classes to your project. In a directory, the name is phpexcel, start myself, (the code is taken from its own example)
 
Program part
 
require_once './phpexcel/PHPExcel.php';
 
// First create a new object PHPExcel object
$ objPHPExcel = new PHPExcel ();
 
// Set some properties of the file, you can see these values in the xls file-> properties-> detailed information, these values are not in the xml table
$ objPHPExcel
      -> getProperties () // Get the file properties object and provide setting resources for the following
      -> setCreator ("Maarten Balliauw") // Set the creator of the file
      -> setLastModifiedBy ("Maarten Balliauw") // Set the last modified
      -> setTitle ("Office 2007 XLSX Test Document") // Set title
      -> setSubject ("Office 2007 XLSX Test Document") // Set subject
      -> setDescription ("Test document for Office 2007 XLSX, generated using PHP classes.") // Set note
      -> setKeywords ("office 2007 openxml php") // Set tags
      -> setCategory ("Test result file"); // Set category
// Location aaa * Provide anchor for the following code location
// Add data to the table
$ objPHPExcel-> setActiveSheetIndex (0) // Set the first built-in table (there can be multiple tables in an xls file) as active
            -> setCellValue ('A1', 'Hello') // Set data for the cell of the table
            -> setCellValue ('B2', 'world!') // Data format can be string
            -> setCellValue ('C1', 12) // Digital
            -> setCellValue ('D2', 12) //
            -> setCellValue ('D3', true) // Boolean
            -> setCellValue ('D4', '= SUM (C1: D2)'); // formula
 
// Get the currently active table, note that $ objActSheet will often be used in the following tutorials
$ objActSheet = $ objPHPExcel-> getActiveSheet ();
// position bbb * provide anchor for code position below
// Set a name for the currently active table
$ objActSheet-> setTitle ('Simple2222');
The code is not over yet, you can copy the code below to decide what we are going to do
 
What we will do is
1, Generate a file directly
$ objWriter = PHPExcel_IOFactory :: createWriter ($ objPHPExcel, 'Excel2007');
$ objWriter-> save ('myexchel.xlsx');
 
2. Prompt to download files
excel 2003 .xls
// Generate xls file in 2003excel format
header ('Content-Type: application / vnd.ms-excel');
header ('Content-Disposition: attachment; filename = "01simple.xls"');
header ('Cache-Control: max-age = 0');
 
$ objWriter = PHPExcel_IOFactory :: createWriter ($ objPHPExcel, 'Excel5');
$ objWriter-> save ('php: // output');
exit;
 
excel 2007 .xlsx
// Generate xlsx file in 2007excel format
header ('Content-Type: application / vnd.openxmlformats-officedocument.spreadsheetml.sheet');
header ('Content-Disposition: attachment; filename = "01simple.xlsx"');
header ('Cache-Control: max-age = 0');
 
$ objWriter = PHPExcel_IOFactory :: createWriter ($ objPHPExcel, 'Excel2007');
$ objWriter-> save ('php: // output');
exit;
 
pdf file
// download a pdf file
header ('Content-Type: application / pdf');
header ('Content-Disposition: attachment; filename = "01simple.pdf"');
header ('Cache-Control: max-age = 0');
 
$ objWriter = PHPExcel_IOFactory :: createWriter ($ objPHPExcel, 'PDF');
$ objWriter-> save ('php: // output');
exit;
// Generate a pdf file
$ objWriter = PHPExcel_IOFactory :: createWriter ($ objPHPExcel, 'PDF');
$ objWriter-> save ('a.pdf');
 
 
CSV file
$ objWriter = PHPExcel_IOFactory :: createWriter ($ objPHPExcel, 'CSV')-> setDelimiter (',') // Set separator
                                                                  -> setEnclosure ('"') // Set the enclosing character
                                                                  -> setLineEnding ("\ r \ n") // Set line separator
                                                                  -> setSheetIndex (0) // Set active sheet
                                                                  -> save (str_replace ('. php', '.csv', __FILE__));
 
HTML file
$ objWriter = PHPExcel_IOFactory :: createWriter ($ objPHPExcel, 'HTML'); // Convert $ objPHPEcel object to HTML format
$ objWriter-> setSheetIndex (0); // Set the active sheet
//$objWriter->setImagesRoot('http://www.example.com ');
$ objWriter-> save (str_replace ('. php', '.htm', __FILE__)); // Save the file
 
 
 
 
Format table and data
Set the default font and text size Anchor: aaa
$ objPHPExcel-> getDefaultStyle ()-> getFont ()-> setName ('Arial');
$ objPHPExcel-> getDefaultStyle ()-> getFont ()-> setSize (20);
 
Date format Anchor: bbb
// Get second value variable
$ dateTimeNow = time ();
// The three tables are set to the current actual date format, time format, date and time format
// First set the cell value to the Excel format value converted by the PHPExcel_Shared_Date :: PHPToExcel method, and then use it to get the number style in the cell style and then set the display format
$ objActSheet-> setCellValue ('C9', PHPExcel_Shared_Date :: PHPToExcel ($ dateTimeNow));
$ objActSheet-> getStyle ('C9')-> getNumberFormat ()-> setFormatCode (PHPExcel_Style_NumberFormat :: FORMAT_DATE_YYYYMMDD2);
$ objActSheet-> setCellValue ('C10', PHPExcel_Shared_Date :: PHPToExcel ($ dateTimeNow));
$ objActSheet-> getStyle ('C10')-> getNumberFormat ()-> setFormatCode (PHPExcel_Style_NumberFormat :: FORMAT_DATE_TIME4);
$ objActSheet-> setCellValue ('C10', PHPExcel_Shared_Date :: PHPToExcel ($ dateTimeNow));
$ objActSheet-> getStyle ('C10')-> getNumberFormat ()-> setFormatCode (PHPExcel_Style_NumberFormat :: FORMAT_DATE_TIME4);
// Set the number format from E4 to E13 to EUR
$ objPHPExcel-> getActiveSheet ()-> getStyle ('E4: E13')-> getNumberFormat ()-> setFormatCode (PHPExcel_Style_NumberFormat :: FORMAT_CURRENCY_EUR_SIMPLE);
 
Set column width Anchor: bbb
$ objActSheet-> getColumnDimension ('B')-> setAutoSize (true); // Content adaptation
$ objActSheet-> getColumnDimension ('A')-> setWidth (30); // 30 width
 
Set header and footer for file printing Anchor: bbb
// Set the header and footer when printing (after setting, you can see the effect through print preview) & * in the string seems to be some variables
$ objActSheet-> getHeaderFooter ()-> setOddHeader ('& L & G & C & H Please treat this document as confidential!');
$ objActSheet-> getHeaderFooter ()-> setOddFooter ('& L & B'. $ objPHPExcel-> getPropert
ies ()-> getTitle (). '& RPage & P of & N');

Set page text orientation and page size Anchor: bbb
$ objPHPExcel-> getActiveSheet ()-> getPageSetup ()-> setOrientation (PHPExcel_Worksheet_PageSetup :: ORIENTATION_LANDSCAPE);
$ objPHPExcel-> getActiveSheet ()-> getPageSetup ()-> setPaperSize (PHPExcel_Worksheet_PageSetup :: PAPERSIZE_A4); // A4 paper size
 
Add a picture for the header. Valid in office. Invalid in wps. Anchor: bbb
$ objDrawing = new PHPExcel_Worksheet_HeaderFooterDrawing ();
$ objDrawing-> setName ('PHPExcel logo');
$ objDrawing-> setPath ('./ images / phpexcel_logo.gif');
$ objDrawing-> setHeight (36);
$ objPHPExcel-> getActiveSheet ()-> getHeaderFooter ()-> addImage ($ objDrawing, PHPExcel_Worksheet_HeaderFooter :: IMAGE_HEADER_LEFT);
 
Set cell comment Anchor: bbb
// Add comments to cells
$ objPHPExcel-> getActiveSheet ()-> getComment ('E13')-> setAuthor ('PHPExcel'); // Set author
$ objCommentRichText = $ objPHPExcel-> getActiveSheet ()-> getComment ('E13')-> getText ()-> createTextRun ('PHPExcel:'); // Add annotation
$ objCommentRichText-> getFont ()-> setBold (true); // Bold the existing annotation
$ objPHPExcel-> getActiveSheet ()-> getComment ('E13')-> getText ()-> createTextRun ("\ r \ n"); // Add more comments
$ objPHPExcel-> getActiveSheet ()-> getComment ('E13')-> getText ()-> createTextRun ('Total amount on the current invoice, including VAT.');
$ objPHPExcel-> getActiveSheet ()-> getComment ('E13')-> setWidth ('100pt'); // Set the width and height of the annotation display, valid in office and invalid in wps
$ objPHPExcel-> getActiveSheet ()-> getComment ('E13')-> setHeight ('100pt');
$ objPHPExcel-> getActiveSheet ()-> getComment ('E13')-> setMarginLeft ('150pt');
$ objPHPExcel-> getActiveSheet ()-> getComment ('E13')-> getFillColor ()-> setRGB ('EEEEEE'); // Set the background color, valid in office and invalid in wps
 
Add text block to see the renderings. Valid in office. Invalid in wps. Anchor: bbb
// Probably translate Create a rich text box Office is valid wps is invalid
$ objRichText = new PHPExcel_RichText ();
$ objRichText-> createText ('This invoice is'); // Write text
// Add text and set this text bold italic and text color
$ objPayable = $ objRichText-> createTextRun ('payable within thirty days after the end of the month');
$ objPayable-> getFont ()-> setBold (true);
$ objPayable-> getFont ()-> setItalic (true);
$ objPayable-> getFont ()-> setColor (new PHPExcel_Style_Color (PHPExcel_Style_Color :: COLOR_DARKGREEN));
$ objRichText-> createText (', unless specified otherwise on the invoice.');
// Write the text in cell A18
$ objPHPExcel-> getActiveSheet ()-> getCell ('A18')-> setValue ($ objRichText);
 
Merge and split cells Anchor: bbb
$ objPHPExcel-> getActiveSheet ()-> mergeCells ('A28: B28'); // A28: B28 merge
$ objPHPExcel-> getActiveSheet ()-> unmergeCells ('A28: B28'); // A28: B28 and then split
 
Cell password protection Anchor: bbb
// Cell password protected from modification
$ objPHPExcel-> getActiveSheet ()-> getProtection ()-> setSheet (true); // In order to protect any table, it must be set to true
$ objPHPExcel-> getActiveSheet ()-> protectCells ('A3: E13', 'PHPExcel'); // Protect A3 to E13 The encryption password is PHPExcel
$ objPHPExcel-> getActiveSheet ()-> getStyle ('B1')-> getProtection ()-> setLocked (PHPExcel_Style_Protection :: PROTECTION_UNPROTECTED); // Remove protection
 
Set the cell font Anchor: bbb
// Set B1's text font to Candara. The bold underline of the 20th has a background color.
$ objPHPExcel-> getActiveSheet ()-> getStyle ('B1')-> getFont ()-> setName ('Candara');
$ objPHPExcel-> getActiveSheet ()-> getStyle ('B1')-> getFont ()-> setSize (20);
$ objPHPExcel-> getActiveSheet ()-> getStyle ('B1')-> getFont ()-> setBold (true);
$ objPHPExcel-> getActiveSheet ()-> getStyle ('B1')-> getFont ()-> setUnderline (PHPExcel_Style_Font :: UNDERLINE_SINGLE);
$ objPHPExcel-> getActiveSheet ()-> getStyle ('B1')-> getFont ()-> getColor ()-> setARGB (PHPExcel_Style_Color :: COLOR_WHITE);
 
Text alignment anchor: bbb
$ objPHPExcel-> getActiveSheet ()-> getStyle ('D11')-> getAlignment ()-> setHorizontal (PHPExcel_Style_Alignment :: HORIZONTAL_RIGHT); // Align in the horizontal direction
$ objPHPExcel-> getActiveSheet ()-> getStyle ('A18')-> getAlignment ()-> setHorizontal (PHPExcel_Style_Alignment :: HORIZONTAL_JUSTIFY); // Align both ends horizontally
$ objPHPExcel-> getActiveSheet ()-> getStyle ('A18')-> getAlignment ()-> setVertical (PHPExcel_Style_Alignment :: VERTICAL_CENTER); // Center in the vertical direction
 
Set cell border Anchor: bbb
$ styleThinBlackBorderOutline = array (
       'borders' => array (
             'outline' => array (
                   'style' => PHPExcel_Style_Border :: BORDER_THIN, // Set border style
                   // 'style' => PHPExcel_Style_Border :: BORDER_THICK, another style
                   'color' => array ('argb' => 'FF000000'), // Set the border color
            ),
      ),
);
$ objPHPExcel-> getActiveSheet ()-> getStyle ('A4: E10')-> applyFromArray ($ styleThinBlackBorderOutline);
 
Background fill color anchor: bbb
// Set the fill style and background color
$ objPHPExcel-> getActiveSheet ()-> getStyle ('A1: E1')-> getFill ()-> setFillType (PHPExcel_Style_Fill :: FILL_SOLID);
$ objPHPExcel-> getActiveSheet ()-> getStyle ('A1: E1')-> getFill ()-> getStartColor ()-> setARGB ('FF808080');
 
Sample comprehensive settings
$ objPHPExcel-> getActiveSheet ()-> getStyle ('A3: E3')-> applyFromArray (
             array (
                   'font' => array (
                         'bold' => true
                   ),
                   'alignment' => array (
                         'horizontal' => PHPExcel_Style_Alignment :: HORIZONTAL_RIGHT,
                  ),
                   'borders' => array (
                         'top' => array (
                               'style' => PHPExcel_Style_Border :: BORDER_THIN
                        )
                  ),
                   'fill' => array (
'type' => PHPExcel_Style_Fill :: FILL_GRADIENT_LINEAR,
                         'rotation' => 90,
                         'startcolor' => array (
                               'argb' => 'FFA0A0A0'
                         ),
                         'endcolor' => array (
                               'argb' => 'FFFFFFFF'
                         )
                  )
            )
);
 
 
Set url hyperlink to cell content Anchor: bbb
$ objActSheet-> getCell ('E26')-> getHyperlink ()-> setUrl ('http://www.phpexcel.net'); // Hyperlink URL address
$ objActSheet-> getCell ('E26')-> getHyperlink ()-> setTooltip ('Navigate to website'); // mouse up to connect to the prompt information
 
Add a picture to the table Anchor: bbb
$ objDrawing = new PHPExcel_Worksheet_Drawing ();
$ objDrawing-> setName ('Paid');
$ objDrawing-> setDescription ('Paid');
$ objDrawing-> setPath ('./ images / paid.png'); // Picture introduction position
$ objDrawing-> setCoordinates ('B15'); // Image add position
$ objDrawing-> setOffsetX (210);
$ objDrawing-> setRotation (25);
$ objDrawing-> setHeight (36);
$ objDrawing-> getShadow ()-> setVisible (true);
$ objDrawing-> getShadow ()-> setDirection (45);
$ objDrawing-> setWorksheet ($ objPHPExcel-> getActiveSheet ());
// You can also add pictures produced by the gd library, see the example 25 for details
 
Create a new worksheet and set the worksheet label color Anchor: bbb
$ objExcel-> createSheet ();
$ objPHPExcel-> setActiveSheetIndex (1); // Set the second table as the active table, providing operation handle
$ objExcel-> getSheet (1)-> setTitle ('Test 2'); // Get the second table directly for setting, rename the worksheet to test 2
$ objPHPExcel-> getActiveSheet ()-> getTabColor ()-> setARGB ('FF0094FF'); // Set the label color
 
Add or delete rows and columns Anchor: bbb
$ objPHPExcel-> getActiveSheet ()-> insertNewRowBefore (6, 10); // Add 10 lines before line 6
$ objPHPExcel-> getActiveSheet ()-> removeRow (6, 10); // delete 10 lines from line 6
$ objPHPExcel-> getActiveSheet ()-> insertNewColumnBefore ('E', 5); // Add 5 categories from before column E
$ objPHPExcel-> getActiveSheet ()-> removeColumn ('E', 5); // Remove 5 columns from the beginning of column E
 
Hide and show a column Anchor: bbb
$ objPHPExcel-> getActiveSheet ()-> getColumnDimension ('C')-> setVisible (false); // Hide
$ objPHPExcel-> getActiveSheet ()-> getColumnDimension ('D')-> setVisible (true); // Display
 
Rename the label name of the active table Anchor: bbb
$ objPHPExcel-> getActiveSheet ()-> setTitle ('Invoice');
 
Set up worksheet security
$ objPHPExcel-> getActiveSheet ()-> getProtection ()-> setPassword ('PHPExcel');
$ objPHPExcel-> getActiveSheet ()-> getProtection ()-> setSheet (true); // This should be enabled in order to enable any of the following!
$ objPHPExcel-> getActiveSheet ()-> getProtection ()-> setSort (true);
$ objPHPExcel-> getActiveSheet ()-> getProtection ()-> setInsertRows (true);
$ objPHPExcel-> getActiveSheet ()-> getProtection ()-> setFormatCells (true);
 
Set document security Anchor: bbb
$ objPHPExcel-> getSecurity ()-> setLockWindows (true);
$ objPHPExcel-> getSecurity ()-> setLockStructure (true);
$ objPHPExcel-> getSecurity ()-> setWorkbookPassword ("PHPExcel"); // Set password
 
Style copy Anchor: bbb
// Copy the style of B2 to B3 to B7
$ objPHPExcel-> getActiveSheet ()-> duplicateConditionalStyle (
                        $ objPHPExcel-> getActiveSheet ()-> getStyle ('B2')-> getConditionalStyles (),
                         'B3: B7'
                   );
 
Add conditional formatting anchor: bbb
echo date ('H: i: s'), "Add conditional formatting", PHP_EOL;
$ objConditional1 = new PHPExcel_Style_Conditional ();
$ objConditional1-> setConditionType (PHPExcel_Style_Conditional :: CONDITION_CELLIS);
$ objConditional1-> setOperatorType (PHPExcel_Style_Conditional :: OPERATOR_BETWEEN);
$ objConditional1-> addCondition ('200');
$ objConditional1-> addCondition ('400');
 
Set pagination (mainly used for printing) Anchor: bbb
// Set a cell as the footer
$ objPHPExcel-> getActiveSheet ()-> setBreak ('A'. $ i, PHPExcel_Worksheet :: BREAK_ROW);
 
 
Filling a table with an array Anchor: bbb
// The contents of the array are filled from A2
$ dataArray = array (array ("2010", "Q1", "United States", 790),
                   array ("2010", "Q2", "United States", 730),
                  );
$ objPHPExcel-> getActiveSheet ()-> fromArray ($ dataArray, NULL, 'A2');
 
Set up automatic filtering Anchor: bbb
$ objPHPExcel-> getActiveSheet ()-> setAutoFilter ($ objPHPExcel-> getActiveSheet ()-> calculateWorksheetDimension ());
//$objPHPExcel->getActiveSheet()->calculateWorksheetDimension()....get all the contents of line A1
 
Print out to all formulas
$ objCalc = PHPExcel_Calculation :: getInstance ();
print_r ($ objCalc-> listFunctionNames ())
 
Set the range of cell values Anchor: bbb
$ objValidation = $ objPHPExcel-> getActiveSheet ()-> getCell ('B3')-> getDataValidation ();
$ objValidation-> setType (PHPExcel_Cell_DataValidation :: TYPE_WHOLE);
$ objValidation-> setErrorStyle (PHPExcel_Cell_DataValidation :: STYLE_STOP);
$ objValidation-> setAllowBlank (true);
$ objValidation-> setShowInputMessage (true); // Set display prompt message
$ objValidation-> setShowErrorMessage (true); // Set display error message
$ objValidation-> setErrorTitle ('Input error'); // error title
// $ objValidation-> setShowDropDown (true);
$ objValidation-> setError ('Only numbers between 10 and 20 are allowed!'); // error content
$ objValidation-> setPromptTitle ('Allowed input'); // Set the prompt title
$ objValidation-> setPrompt ('Only numbers between 10 and 20 are allowed.'); // Prompt content
$ objValidation-> setFormula1 (10); // Set the maximum value
$ objValidation-> setFormula2 (120); // Set the minimum value
// Or set it like this $ objValidation-> setFormula2 (1,5,6,7); The set value is a number from 1,5,6,7
 
other
$ objPHPExcel-> getActiveSheet ()-> getStyle ('B5')-> getAlignment ()-> setShrinkToFit (true); // Wrap automatically if the length is not enough
$ objPHPExcel-> getActiveSheet ()-> getStyle ('B5')-> getAlignment ()-> setShrinkToFit (true); // Automatically convert the display font size to make the content display
$ objPHPExcel-> getActiveSheet ()-> getCell (B14)-> getValue (); // Get the value, it is possible to get the formula
$ objPHPExcel-> getActiveSheet ()-> getCell (B14)-> getCalculatedValue (); // Get the calculated value
 
 
Import or read files
// Load a file by PHPExcel_IOFactory :: load method, load will automatically determine the file suffix name to import the corresponding processing class, read the format contains xlsx / xls / xlsm / ods / slk / csv / xml / gnumeric
require_once '../Classes/PHPExcel/IOFactory.php';
$ objPHPExcel = PHPExcel_IOFactory :: load (
// The default table of loaded files (usually the first one) returns a multi-dimensional array through the toArray method
$ dataArray = $ objPHPExcel-> getActiveSheet ()-> toArray ();
// Write directly to an xlsx file after reading
$ objWriter = PHPExcel_IOFactory :: createWriter ($ objPHPExcel, 'Excel2007'); // $ objPHPExcel is the resource read above
$ objWriter-> save (str_replace ('. php', '.xlsx', __FILE__));
 
Read xml file
$ objReader = PHPExcel_IOFactory :: createReader ('Excel2003XML');
$ objPHPExcel = $ objReader-> load ("Excel2003XMLTest.xml");
Read ods file
$ objReader = PHPExcel_IOFactory :: createReader ('OOCalc');
$ objPHPExcel = $ objReader-> load ("OOCalcTest.ods");
Read numeric file
$ objReader = PHPExcel_IOFactory :: createReader ('Gnumeric');
$ objPHPExcel = $ objReader-> load ("GnumericTest.gnumeric");
Read slk file
$ objPHPExcel = PHPExcel_IOFactory :: load ("SylkTest.slk");
 
 
Loop through the data
$ objReader = PHPExcel_IOFactory :: createReader ('Excel2007'); // Create a 2007 read object
$ objPHPExcel = $ objReader-> load ("05featuredemo.xlsx"); // Read an xlsx file
foreach ($ objPHPExcel-> getWorksheetIterator () as $ worksheet) {// traverse the worksheet
       echo 'Worksheet-', $ worksheet-> getTitle (), PHP_EOL;
       foreach ($ worksheet-> getRowIterator () as $ row) {// Traverse rows
             echo 'Row number-', $ row-> getRowIndex (), PHP_EOL;
            $ cellIterator = $ row-> getCellIterator (); // Get all columns
            $ cellIterator-> setIterateOnlyExistingCells (false); // Loop all cells, even if it is not set
             foreach ($ cellIterator as $ cell) {// traverse the column
                   if (! is_null ($ cell)) {// If the column is not empty, get its coordinates and calculated value
                         echo 'Cell-', $ cell-> getCoordinate (), '-', $ cell-> getCalculatedValue (), PHP_EOL;
                  }
            }
      }
}
 
Array inserted into table
// Insert data 3 rows of data
$ data = array (array ('title' => 'Excel for dummies',
                     'price' => 17.99,
                     'quantity' => 2
                           ),
                    array ('title' => 'PHP for dummies',
                           'price' => 15.99,
                           'quantity' => 1
                           ),
                    array ('title' => 'Inside OOP',
                           'price' => 12.95,
                           'quantity' => 1
                           )
                   );
$ baseRow = 5; // Specify to insert after line 5
foreach ($ data as $ r => $ dataRow) {
      $ row = $ baseRow + $ r; // $ row is the row number of the loop operation row
      $ objPHPExcel-> getActiveSheet ()-> insertNewRowBefore ($ row, 1); // Add an empty line before the operation line number, and the line number of this empty line becomes the current line number
       // The corresponding lines are attached with data and number
      $ objPHPExcel-> getActiveSheet ()-> setCellValue ('A'. $ row, $ r + 1);
      $ objPHPExcel-> getActiveSheet ()-> setCellValue ('B'. $ row, $ dataRow ['title']);
      $ objPHPExcel-> getActiveSheet ()-> setCellValue ('C'. $ row, $ dataRow ['price']);
      $ objPHPExcel-> getActiveSheet ()-> setCellValue ('D'. $ row, $ dataRow ['quantity']);
      $ objPHPExcel-> getActiveSheet ()-> setCellValue ('E'. $ row, '= C'. $ row. '* D'. $ row);
}
$ objPHPExcel-> getActiveSheet ()-> removeRow ($ baseRow-1,1); // Finally delete the fourth line, which is required for the example, here is a delete example for everyone

Author: Huang Cong
Source: http://www.cnblogs.com/huangcong/
The copyright of this article belongs to the author and the blog garden. Reprinting is welcome, but this paragraph statement must be retained without the author's consent, and a link to the original text should be given in the obvious position of the article page, otherwise the right to pursue legal responsibility is reserved.