php excel,该如何处理

WBOY
Release: 2016-06-13 11:57:15
Original
997 people have browsed it

php excel
error_reporting(E_ALL);
date_default_timezone_set('Europe/London');
/** PHPExcel */
require_once '../Classes/PHPExcel.php';

// Create new PHPExcel object
$objPHPExcel = new PHPExcel();

// Set properties
$objPHPExcel->getProperties()->setCreator("Maarten Balliauw")
                             ->setLastModifiedBy("Maarten Balliauw")
                             ->setTitle("Office 2007 XLSX Test Document")
                             ->setSubject("Office 2007 XLSX Test Document")
                             ->setDescription("Test document for Office 2007 XLSX, generated using PHP classes.")
                             ->setKeywords("office 2007 openxml php")
                             ->setCategory("Test result file");
$objPHPExcel->getActiveSheet()->mergeCells('A1:G1');
$objPHPExcel->getActiveSheet()->mergeCells('H1:W1');
$objPHPExcel->getActiveSheet()->getStyle('A1')->getAlignment()->setHorizontal(PHPExcel_Style_Alignment::HORIZONTAL_CENTER);
$objPHPExcel->getActiveSheet()->getStyle('H1')->getAlignment()->setHorizontal(PHPExcel_Style_Alignment::HORIZONTAL_CENTER);
$objPHPExcel->getActiveSheet()->getColumnDimension('C')->setAutoSize(true);
$objPHPExcel->getActiveSheet()->getColumnDimension('A')->setWidth(20);
$objPHPExcel->getActiveSheet()->getColumnDimension('E')->setWidth(20);

// Add some data


$objPHPExcel->setActiveSheetIndex(0)
            ->setCellValue('A1', 'user-data')
            ->setCellValue('A2', 'username')
            ->setCellValue('B2', 'password')
            ->setCellValue('C2', 'sex')
            ->setCellValue('D2', 'grade')
            ->setCellValue('E2', 'age')
            ->setCellValue('F2', 'weight')
            ->setCellValue('G2', 'height')
            ->setCellValue('H1', 'Module1')
            ->setCellValue('I2', 'Q2')
            ->setCellValue('J2', 'Q3')
            ->setCellValue('K2', 'Q4')
            ->setCellValue('L2', 'Q5')
            ->setCellValue('M2', 'Q6')
            ->setCellValue('N2', 'Q7')
            ->setCellValue('O2', 'Q2')
            ->setCellValue('P2', 'Q3')
            ->setCellValue('Q2', 'Q4')
            ->setCellValue('R2', 'Q5')
            ->setCellValue('S2', 'Q6')
            ->setCellValue('T2', 'Q7')
            ->setCellValue('U2', 'Q2')
            ->setCellValue('V2', 'Q3')
            ->setCellValue('W2', 'Q4')
            ->setCellValue('X1', 'Module2')
            ->setCellValue('Y2', 'Q1')
            ->setCellValue('Z2', 'Q2');    

//数据库连接
$db = mysql_connect("localhost", "root", "");
mysql_select_db("test",$db);  //选择数据库,这里为"ywcl"。
mysql_query("SET NAMES UTF8"); //设定编码方式为UTF8

$sqlgroups="select * from user order by username";
$resultgroups=mysql_query($sqlgroups);

Related labels:
source:php.cn
Statement of this Website
The content of this article is voluntarily contributed by netizens, and the copyright belongs to the original author. This site does not assume corresponding legal responsibility. If you find any content suspected of plagiarism or infringement, please contact admin@php.cn
Popular Tutorials
More>
Latest Downloads
More>
Web Effects
Website Source Code
Website Materials
Front End Template
About us Disclaimer Sitemap
php.cn:Public welfare online PHP training,Help PHP learners grow quickly!