php在线编辑电子表格源码,PHP中创建和编辑Excel表格的方法

// Include PHPExcel library and create its object

require('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