Packagecom.ms.office.excel
Classpublic class Excel
InheritanceExcel Inheritance OfficeBase Inheritance Object

Excel 实体



Public Properties
 PropertyDefined By
 InheritedfileInformation : InformationVo
[read-only] 获取 文件基本信息
OfficeBase
Protected Properties
 PropertyDefined By
 InheritedofficeData : OfficeData
office 源文件数据
OfficeBase
 Inheritedoutput : ZipOutput
OfficeBase
 InheritedrootConfigData : Object
_rels/.rels 内的路径映射
OfficeBase
 Inheritedx_appConfig : XMLObject
docProps/app.xml
OfficeBase
 Inheritedx_Content_Types : XMLObject
[Content_Types].xml
OfficeBase
 Inheritedx_coreConfig : XMLObject
docProps/core.xml
OfficeBase
 Inheritedx_officeDocument : XMLObject
office 组件内容配置文件
OfficeBase
 Inheritedx_rootConfig : XMLObject
_rels/.rels
OfficeBase
Public Methods
 MethodDefined By
  
Excel(data:ByteArray = null)
构造函数
Excel
  
addSheet(name:String = null):Sheet
Excel
  
addSheetAt(index:int, name:String = null):Sheet
Excel
  
[static] 创建空的Excel文档
Excel
  
Excel
  
deteteSheetAt(index:int):Sheet
Excel
 Inherited
exportOffice():ByteArray
导出 Office 文件
OfficeBase
  
根据 sheet索引 获取 sheet 数据
Excel
  
getSheetByName(name:String):Sheet
根据 sheet名称 获取 sheet 数据
Excel
  
返回sheet页名称列表
Excel
 Inherited
importOffice(data:ByteArray):void
导入Office 文件
OfficeBase
Protected Methods
 MethodDefined By
 Inherited
写入单个文件
OfficeBase
 Inherited
写入单个文件
OfficeBase
  
[override]
Excel
  
writeFiles():void
[override]
Excel
Constructor Detail
Excel()Constructor
public function Excel(data:ByteArray = null)

构造函数

Parameters
data:ByteArray (default = null) — Excel 文件(二进制数据)
Method Detail
addSheet()method
public function addSheet(name:String = null):Sheet

Parameters

name:String (default = null)

Returns
Sheet
addSheetAt()method 
public function addSheetAt(index:int, name:String = null):Sheet

Parameters

index:int
 
name:String (default = null)

Returns
Sheet
createExcel()method 
public static function createExcel():Excel

创建空的Excel文档

Returns
Excel
deleteSheetByName()method 
public function deleteSheetByName(name:String):Sheet

Parameters

name:String

Returns
Sheet
deteteSheetAt()method 
public function deteteSheetAt(index:int):Sheet

Parameters

index:int

Returns
Sheet
getSheetByIndex()method 
public function getSheetByIndex(index:int):Sheet

根据 sheet索引 获取 sheet 数据

Parameters

index:int

Returns
Sheet
getSheetByName()method 
public function getSheetByName(name:String):Sheet

根据 sheet名称 获取 sheet 数据

Parameters

name:String

Returns
Sheet
getSheetNameArray()method 
public function getSheetNameArray():Array

返回sheet页名称列表

Returns
Array
resolveRootConfig()method 
override protected function resolveRootConfig():void

writeFiles()method 
override protected function writeFiles():void