<?php
header('Cache-Control: No-cache');
error_reporting(E_ALL);
ini_set('display_errors', TRUE);
ini_set('display_startup_errors', TRUE);
date_default_timezone_set('Europe/London');
set_time_limit(0);
require "E:\www\Classes\PHPExcel.php";//引入PHPExcel$objPHPExcel=new PHPExcel();//实例化PHPExcel类, 等同于在桌面上新建一个excel
$link = mysql_connect('127.0.0.1','root','root');
mysql_select_db('wsyy',$link);
mysql_query("set name gbk");
$sql = "select hospital.id,hospital.name as hosname from wsyy_hospital inner join wsyy_hospitalspecialtyill on wsyy_hospital.id=wsyy_hospitalspecialtyill.hosid limit 100;";
$result = mysql_query($sql);$objPHPExcel->getActiveSheet()->setTitle('Simple');
// Set active sheet index to the first sheet, so Excel opens this as the first sheet
$objPHPExcel->setActiveSheetIndex(0);
$objPHPExcel->getProperties()->setCreator("Maarten Balliauw")
->setLastModifiedBy("Maarten Balliauw")
->setTitle("PHPExcel Test Document")
->setSubject("PHPExcel Test Document")
->setDescription("Test document for PHPExcel, generated using PHP classes.")
->setKeywords("office PHPExcel php")
->setCategory("Test result file");
$objPHPExcel->setActiveSheetIndex(0)
->setCellValue("A1","编号")
->setCellValue("B1","医院名称")
->setCellValue("C1","省")
->setCellValue("D1","市")
->setCellValue("E1","区")
->setCellValue("F1","简介");//填充数据$res=array();
while(($row=mysql_fetch_assoc($result))!=false){
$res[]=$row;
}$j=2;
foreach($res as $key=>$vo){
$objPHPExcel->setActiveSheetIndex(0)
->setCellValue("A".$j,$vo['id'])
->setCellValue("B".$j,$vo['hosname'])
->setCellValue("C".$j,$vo['province'])
->setCellValue("C".$j,$vo['city'])
->setCellValue("C".$j,$vo['area'])
->setCellValue("D".$j,$vo['name']);
$j++;
}$objWriter = PHPExcel_IOFactory::createWriter($objPHPExcel, 'Excel2007');var_dump($objWriter);die;
$objWriter->save(str_replace('.php', '.xlsx', __FILE__));
header('Cache-Control: No-cache');
error_reporting(E_ALL);
ini_set('display_errors', TRUE);
ini_set('display_startup_errors', TRUE);
date_default_timezone_set('Europe/London');
set_time_limit(0);
require "E:\www\Classes\PHPExcel.php";//引入PHPExcel$objPHPExcel=new PHPExcel();//实例化PHPExcel类, 等同于在桌面上新建一个excel
$link = mysql_connect('127.0.0.1','root','root');
mysql_select_db('wsyy',$link);
mysql_query("set name gbk");
$sql = "select hospital.id,hospital.name as hosname from wsyy_hospital inner join wsyy_hospitalspecialtyill on wsyy_hospital.id=wsyy_hospitalspecialtyill.hosid limit 100;";
$result = mysql_query($sql);$objPHPExcel->getActiveSheet()->setTitle('Simple');
// Set active sheet index to the first sheet, so Excel opens this as the first sheet
$objPHPExcel->setActiveSheetIndex(0);
$objPHPExcel->getProperties()->setCreator("Maarten Balliauw")
->setLastModifiedBy("Maarten Balliauw")
->setTitle("PHPExcel Test Document")
->setSubject("PHPExcel Test Document")
->setDescription("Test document for PHPExcel, generated using PHP classes.")
->setKeywords("office PHPExcel php")
->setCategory("Test result file");
$objPHPExcel->setActiveSheetIndex(0)
->setCellValue("A1","编号")
->setCellValue("B1","医院名称")
->setCellValue("C1","省")
->setCellValue("D1","市")
->setCellValue("E1","区")
->setCellValue("F1","简介");//填充数据$res=array();
while(($row=mysql_fetch_assoc($result))!=false){
$res[]=$row;
}$j=2;
foreach($res as $key=>$vo){
$objPHPExcel->setActiveSheetIndex(0)
->setCellValue("A".$j,$vo['id'])
->setCellValue("B".$j,$vo['hosname'])
->setCellValue("C".$j,$vo['province'])
->setCellValue("C".$j,$vo['city'])
->setCellValue("C".$j,$vo['area'])
->setCellValue("D".$j,$vo['name']);
$j++;
}$objWriter = PHPExcel_IOFactory::createWriter($objPHPExcel, 'Excel2007');var_dump($objWriter);die;
$objWriter->save(str_replace('.php', '.xlsx', __FILE__));
解决方案 »
- 怎样隐藏下载文件链接?
- PHP+mysql 在windows2000下如何搭建环境
- php 拼写检查
- 急...php如何获取falsh文件中链接的地址
- 请问在这里如何再添加一个发送目标(小白问题)
- PHP中MYSQL的存储过程应该如何写?
- 从SQL Server取回的日期格式是2004 一月 1 12:44,怎样转换成yyyy-mm-dd?
- 您好,请问PHP 哪个版本对XML的支持好些 ?
- 奇怪的问题,请大家来评评
- 在函式的名称上,PHP 对于大小写的管制很松散。可以在定义函式时写成大写的名字,而在使用时使用小写的名字。总之,对函式而言,不用管大
- php,将数据库信息导入word中
- 我用phpstudy安装的iis+php5.3n。为什么PHP Notice: Undefined variable。脚本就会中断执行?
自然是要乱码的mysql_query("set name gbk");
应改为
mysql_query("set name utf8");形如
->setCellValue("A1","编号")
的要改为形如这样的
->setCellValue("A1", iconv('gbk', 'utf-8', "编号"))