没有合适的资源？快使用搜索试试~ 我知道了~

文库首页课程资源专业指导excel file format

excel file format

excel

文件格式说明

需积分: 10 9 下载量 74 浏览量 2008-08-06 16:41:42 上传评论收藏 990KB PDF 举报

温馨提示

试读

222页

openoffice出品，涵盖excel各个版本的文件格式，操作excel二进制文件的必备

资源推荐

资源详情

资源评论

OpenOffice.org's Documentation of the

Microsoft Excel File Format

Excel Versions 2, 3, 4, 5, 95, 97, 2000, XP, 2003

Author

Daniel Rentz ✉ mailto:dr@openoffice.org  http://sc.openoffice.org

License Public Documentation License

Contributors

Andrew C. Oliver ✉ mailto:acoliver@apache.org  http://jakarta.apache.org/poi/index.html

– POIFS, additional records, fixes

Yves Hiltpold, James J. Keene, Sami Kuhmonen, John Marmion, Alexander Mavrin,

Mike Salter, Charles Wyble

– additional records, fixes

Other sources

Hyperlinks to Wikipedia ( http://www.wikipedia.org) for various extended information

Mailing list

✉ mailto:dev@sc.openoffice.org

Subscription ✉ mailto:dev-subscribe@sc.openoffice.org

Download

PDF  http://sc.openoffice.org/excelfileformat.pdf

XML  http://sc.openoffice.org/excelfileformat.sxw

Project started 2001-Jun-29

Last change 2005-Mar-24

Revision 1.39

Contents

1 Introduction ........................................................................................................ 6

1.1 License Notices 6

1.2 Abstract 7

1.3 Byte Order 9

2 Document Structure .......................................................................................... 10

2.1 File Format Versions 10

2.2 Structure of the Document File 11

3 Common Record Substructures ........................................................................ 12

3.1 Structure of a Record 12

3.2 Formatting Runs 13

3.3 Byte Strings (BIFF2-BIFF7) 13

3.4 Unicode Strings (BIFF8) 14

3.5 RGB Colours 17

3.6 RK Values 17

3.7 Error Codes 17

3.8 Constant Cached Value Lists 18

3.9 URL Encoding 20

3.10 Line Styles for Cell Borders (BIFF3-BIFF8) 22

3.11 Patterns for Cell Background Area (BIFF3-BIFF8) 22

3.12 Cell Attributes (BIFF2) 23

3.13 Cell Range Addresses and Lists 24

4 Formulas ........................................................................................................... 25

4.1 Common Formula Structure 25

4.2 Token Classes 28

4.3 Cell Addresses in Tokens 32

4.4 Token Overview 36

4.5 Unary Operator Tokens 40

4.6 Binary Operator Tokens 41

4.7 Function Operator Tokens 45

4.8 Constant Operand Tokens 47

4.9 Operand Tokens 50

4.10 Control Tokens 61

4.11 Built-In Sheet Functions 69

5 Worksheet/Workbook Structure ....................................................................... 73

5.1 Worksheet/Workbook Stream 74

5.2 Record Order in Substreams 76

5.3 Worksheet Calculation Settings Block 81

5.4 Page Settings Block 81

5.5 Worksheet View Settings Block 82

5.6 Cell Formatting 83

5.7 Cell Table 84

5.8 Array Formulas, Shared Formulas 90

5.9 Multiple Operation Tables 91

5.10 Internal and External References 92

5.11 Shared String Table (BIFF8) 104

5.12 Conditional Formatting Table (BIFF8) 106

5.13 Hyperlink Table (BIFF8) 106

5.14 Data Validity Table (BIFF8) 106

5.15 AutoFilter, Advanced Filter 107

5.16 Scenarios 107

5.17 Web Queries (BIFF8) 107

5.18 Worksheet/Workbook Protection 108

5.19 File Protection 110

6 Worksheet/Workbook Records ...................................................................... 113

6.1 Overview, Ordered by Record Identifier 113

6.2 Overview, Ordered by Record Names 117

6.3 Overview, Ordered by BIFF Versions 120

6.4 ARRAY 124

6.5 BACKUP 125

6.6 BITMAP 125

6.7 BLANK 126

6.8 BOF – Beginning of File 127

6.9 BOOKBOOL 129

6.10 BOOLERR 129

6.11 BOTTOMMARGIN 130

6.12 BOUNDSHEET 130

6.13 BUILTINFMTCOUNT 131

6.14 CALCCOUNT 131

6.15 CALCMODE 131

6.16 CF – Conditional Formatting 132

6.17 CODEPAGE 136

6.18 COLINFO 137

6.19 COLUMNDEFAULT 138

6.20 COLWIDTH 138

6.21 CONDFMT 139

6.22 CONTINUE 140

6.23 COUNTRY 141

6.24 CRN 142

6.25 DATEMODE 142

6.26 DBCELL 143

6.27 DCONREF – Data Consolidation Reference 143

6.28 DEFAULTROWHEIGHT 143

6.29 DEFCOLWIDTH 144

6.30 DELTA 144

6.31 DIMENSIONS 145

6.32 DSF – Double Stream File 145

6.33 DV – Data Validity Settings 146

6.34 DVAL – Data Validity List 147

6.35 EFONT 147

6.36 EOF – End of File 148

6.37 EXTERNCOUNT 148

6.38 EXTERNNAME 149

6.39 EXTERNSHEET 152

6.40 EXTSST – Extended SST 153

6.41 FILEPASS 154

6.42 FILESHARING 156

6.43 FONT 157

6.44 FOOTER 159

6.45 FORMAT 160

6.46 FORMULA 162

6.47 GCW – Global Column Width 164

6.48 GRIDSET 165

6.49 GUTS 165

6.50 HCENTER 165

6.51 HEADER 166

6.52 HIDEOBJ 167

6.53 HLINK – Hyperlink 168

6.54 HORIZONTALPAGEBREAKS 171

6.55 INDEX 172

6.56 INTEGER 174

6.57 ITERATION 174

6.58 IXFE – Index to XF 174

6.59 LABEL 175

6.60 LABELRANGES 175

6.61 LABELSST 176

6.62 LEFTMARGIN 176

6.63 MERGEDCELLS 176

6.64 MULBLANK – Multiple BLANK 177

6.65 MULRK – Multiple RK 177

6.66 NAME 178

6.67 NOTE 181

6.68 NUMBER 182

6.69 OBJECTPROTECT 182

6.70 PALETTE 183

6.71 PANE 184

6.72 PASSWORD 184

6.73 PHONETIC 185

6.74 PRECISION 185

6.75 PRINTGRIDLINES 186

6.76 PRINTHEADERS 186

6.77 PROTECT 187

6.78 QUICKTIP 187

6.79 RANGEPROTECTION 187

6.80 REFMODE 188

6.81 RIGHTMARGIN 188

6.82 RK 188

6.83 ROW 189

6.84 RSTRING 191

6.85 SAVERECALC 191

6.86 SCENPROTECT 192

6.87 SCL 192

6.88 SELECTION 192

6.89 SETUP 193

6.90 SHEETHDR 196

6.91 SHEETLAYOUT 196

6.92 SHEETPROTECTION 197

6.93 SHEETSOFFSET 197

6.94 SHRFMLA – Shared Formula 198

6.95 SORT 199

6.96 SST – Shared String Table 200

6.97 STANDARDWIDTH 200

6.98 STRING 201

6.99 STYLE 202

6.100 SUPBOOK – External Workbook 203

6.101 TABLEOP – Multiple Operation Table 205

6.102 TABLEOP2 – Multiple Operation Table 206

6.103 TOPMARGIN 206

6.104 UNCALCED 207

6.105 USESELFS 207

6.106 VCENTER 208

6.107 VERTICALPAGEBREAKS 208

6.108 WINDOW1 209

6.109 WINDOW2 210

6.110 WINDOWPROTECT 212

6.111 WRITEACCESS 212

6.112 WRITEPROT 212

6.113 WSBOOL 213

6.114 XCT – CRN Count 213

6.115 XF – Extended Format 214

7 Drawing Objects, Escher Layer ...................................................................... 219

8 Charts ............................................................................................................. 220

9 PivotTables ..................................................................................................... 221

10 Change Tracking ............................................................................................ 222

剩余221页未读，继续阅读

评论收藏

内容反馈

资源评论

资源反馈

评论星级较低，若资源使用遇到问题可联系上传者，3个工作日内问题未解决可申请退款~

libert

粉丝: 1
资源: 21

上传资源快速赚钱

我的内容管理展开

我的资源快来上传第一个资源

我的收益

登录查看自己的收益

我的积分登录查看自己的积分

我的C币登录后查看C币余额

我的收藏

我的下载

下载帮助

前往需求广场，查看用户热搜

excel file format

excelfileformat

Excel File Format

Microsoft Excel File Format

ExcelFormat

PyPI 官网下载 | excelmagic-0.7.0.tar.gz

MICROSOFT EXCEL FILE FORMAT

直接读取Excel文件数据

Excel Binary File Format (.xls) Structure

dw2xls_4.0.1_pb903_8836

labivew_将TDMS文件转换为EXCEL文件格式

RaptorDB_v2.0.zip_Thing Thing_read excel file

ExcelLibrary:Excel 库

DBC File Format Documentation 、DBC转换解析资料

处理Excel的插件文档

NativeExcel V3.0.26 (全部源码)

ExcelDataReader开源的读取Excel文件组件net35.7z

FileFormatConverters_Office_doc_to_docx

NativeExcel.v.3.1.0.D4-XE10.1.Src

python大作业 含爬虫、数据可视化、地图、报告、及源码（整和为一个文件）（2014-2020全国各地区原油加工量）.rar

仿真电路以及操作方法

【纯干货啊】华为IPD流程管理(完整版).pptx

可编程语言标准IEC61131-3中文版.pdf

OFDM完整仿真过程与教程.zip

信号与系统——保研复习资料.pdf

Landsat_WRS2.zip

最全的Visio形状/图形库

AxureRP9项目原型50套、案例20个、元件库1套.zip

最新资源

python大作业含爬虫、数据可视化、地图、报告、及源码（整和为一个文件）（2014-2020全国各地区原油加工量）.rar