How to use PHP spreadsheet_excel_writer_php tutorial correctly

In the use

In fact, in many ways feel pear in the spreadsheet_excel_writer is very useful. The installation of PHP Spreadsheet_excel_writer is not described in this article.

The following is the contents of the PHP spreadsheet_excel_writer reference:

2. < ? PHP
4. Call writer.php
6. Require_once ' spreadsheet/excel/writer.php ';
8. Create Workbook
10. $ Workbook = New Spreadsheet_excel_writer ();
12. Define export Excel file name
14. $workbook- > send (' Test.xls ');
16. create Worksheet
18. $ worksheet =& $workbook- > Addworksheet (' My first worksheet ');
20. Set Font size
22. $ Format_column = & $workbook- > Addformat (Array (' Size ' =>9, ' Bold ' =>1));
24. Data Write
26. Header row (first row)
28. $worksheet- > Write (0, 0, ' Name ', $format _column);
30. $worksheet- > Write (0, 1, ' age ', $format _column);
32. First person (second row)
34. $worksheet- > Write (1, 0, ' John Smith ');
36. $worksheet- > Write (1, 1, +);
38. Second person (line three)
40. $worksheet- > Write (2, 0, ' Johann Schmidt ');
42. $worksheet- > Write (2, 1, to);
44. A third person (line fourth)
46. $worksheet- > write (3, 0, ' Juan Herrera ');
48. $worksheet- > Write (3, 1, +);
50. Close Workbook
52. $workbook- > close ();
54. ?>

The above code example is the specific way to use PHP spreadsheet_excel_writer.

http://www.bkjia.com/PHPjc/446092.html www.bkjia.com true http://www.bkjia.com/PHPjc/446092.html techarticle In the use of many methods in fact feel pear in the spreadsheet_excel_writer is very useful. The installation of PHP Spreadsheet_excel_writer is not described in this article. The following is PHP spreadsheet_e ...

