phpExcel导出excel加超级链接的实例代码

//写excel

//Include class

/**

//Set properties 设置文件属性

//Add some data 添加数据

//Add comment 添加注释

//Add rich-text string 添加文字 可设置样式

//Merge cells 合并分离单元格

//Protect cells 保护单元格

//Set cell number formats 数字格式化

//Set column widths 设置列宽度

//Set fonts 设置字体

//Set alignments 设置对齐

//Set column borders 设置列边框

//Set border colors 设置边框颜色

//Set fills 设置填充

//Add a hyperlink to the sheet 添加链接

//Add a drawing to the worksheet 添加图片

//Play around with inserting and removing rows and columns

//Add conditional formatting

//Set autofilter 自动过滤

//Hide “Phone” and “fax” column 隐藏列

//Set document security 设置文档安全

//Set sheet security 设置工作表安全

//Calculated data 计算

//Set outline levels

//Freeze panes

//Rows to repeat at top

//Set data validation 验证输入值

//Create a new worksheet, after the default sheet 创建新的工作标签

//Set header and footer. When no different headers for odd/even are used, odd header is assumed. 页眉页脚

//Set page orientation and size 方向大小

//Rename sheet 重命名工作表标签

//Set active sheet index to the first sheet, so Excel opens this as the first sheet

//Save Excel 2007 file 保存

//Save Excel 5 file 保存

//1.6.2新版保存

//读excel

$objPHPExcel = $objReader->load(“05featuredemo.xlsx”);

//读写csv

//Write to CSV format 写

//Read from CSV format 读

//Write to Excel2007 format

//写html

//Write to HTML format

//写pdf

//Write to PDF format