帮助中心

# getFileFormat-获取文件格式

调用getActiveSheet函数获取工作簿格式。

最小支持版本:5.0.0

# 接口说明

已打开Excel文件获取到ExcelWorkbook对象,详情请参见open (opens new window)

# 语法

<ExcelWorkbook object>.getFileFormat()
1
<ExcelWorkbook object>.获取文件格式()
1

# 函数类型

实例函数

# 请求参数

# 返回参数

参数名称 类型 示例值 描述
Result Cube.Lang.Number 51.0 文件的格式。取值:
●18:Microsoft Excel 97-2003 Add-In, *.xla
●18:Microsoft Excel 97-2003 Add-In, *.xla
●6:CSV文件, *.csv
●22:Macintosh系统的CSV文件, *.csv
●24:MSDOS系统的CSV文件, *.csv
●62:utf-8编码的CSV文件, *.csv
●23:windows系统的CSV文件, *.csv
●-4158:当前平台的文本, *.txt
●7:Dbase 2 格式, *.dbf
●8:Dbase 3 格式, *.dbf
●11:Dbase 4 格式, *.dbf
●9:数据交换格式, *.dif
●50:二进制Excel工作簿, *.xlsb
●16:Excel version 2.0 (1987), *.xls
●27:Excel version 2.0 far east (1987), *.xls
●29:Excel version 3.0 (1990), *.xls
●33:Excel version 4.0 (1992), *.xls
●35:Excel version 4.0. Workbook format (1992), *.xlw
●39:Excel version 5.0 (1994), *.xls
●39:Excel 95 (version 7.0), *.xls
●56:Excel 97-2003 Workbook, *.xls
●43:Excel version 95 and 97, *.xls
●44:HTML格式, *.htm; *.html
●26:International Add-In
●25:International Macro
●60:OpenDocument电子表格, *.ods
●55:Open XML Add-In, *.xlam
●61:严格的Open XML文件, *.xlsx
●54:Open XML模板, *.xltx
●53:可使用宏的Open XML模板, *.xltm
●51:Open XML 工作簿, *.xlsx
●52:可使用宏的Open XML工作簿, *.xlsm
●2:符号链接格式, *.slk
●17:Excel模板格式, *.xlt
●17:Template 8, *.xlt
●19:Macintosh系统Text, *.txt
●21:MSDOS系统Text, *.txt
●36:打印机Text, *.prn
●20:Windows系统Text, *.txt
●42:Unicode编码Text, No file extension; *.txt
●45:Web Archive, *.mht; *.mhtml
●14:Japanese 1-2-3, *.wj2
●40:Japanese 1-2-3, *.wj2
●41:Japanese 1-2-3 format, *.wj3
●5:Lotus 1-2-3 format, *.wk1
●31:Lotus 1-2-3 format, *.wk1
●30:Lotus 1-2-3 format, *.wk1
●15:Lotus 1-2-3 format, *.wk3
●32:Lotus 1-2-3 format, *.wk3
●38:Lotus 1-2-3 format, *.wk4
●4:Lotus 1-2-3 format, *.wks
●51:默认工作簿, *.xlsx
●-4143:普通工作簿(XLS格式工作簿), *.xls
●28:Microsoft Works 2.0 far east format, *.wks
●34:Quattro Pro format, *.wq1
●val:des

# 请求示例

ExcelWorkbook对象.getFileFormat()
1
最近更新时间: { "value": "2023-09-12", "effect": true }