存档

‘Office’ 分类的存档

Business Solution – Finance reprt & BI

2013年11月22日 评论已被关闭

时间: 2013年11月21日 晚20:00 – 21:30
地点: YY频道 40215226
内容: Business Solution – Finance reprt & BI

视频:

课程讲义:

B&S P&L Cash flow, Sales Analysis

B&S 资产负债表
资产=负债+所有者权益

资产 (现金和银行存款(Bank Posting Group), 应收账款(Customer Posting Group),预付款项, 存货 (Inventory Posting Group))
….

期末余额/年初额(FY[1] + 期初金额)

P&L 损益表
销售收入 (过账设置 Sales Revalue)
销售成本 (过账设置 COGS)
税金 (VAT过账设置)
资产减值损失 (过账设置的存货调整科目)
资产处置损失 (固定资产过账设置的清理损益科目)

本期/上期 (-1P)

Cash flow, 现金流量表
关系体, 与现金的流入与流出有关.

在Navision中的解决方案:
1. 找到现金流量表涉及的科目 (Bank Posting Group)
2. 建立Dimension – Cashflow
3. 将现金涉及的科目强制Cashflow Dimension
4. 建立Cashflow的Dimension Value
5. 建立Analysis Value
6. 建立分析报表

Sales Analysis 销售分析
销售收入 / 销售成本
销售收入-销售成本 Sales Margin 销售毛利
(销售收入-销售成本)/销售收入 毛利率

Item 对物料分析
Customer 对客户分析

Accoun Schedules

Analysis by Dimensions

Analysis Reports – Inventory / Sales / Purchase

BI

Qlikview

Halo BI – ETL for Navision

Jet Reports –

抽取数据–>整理数据–>创建分析数据库–>分析展现数据

Navision Consultant – Office – Project

2013年9月27日 评论已被关闭

时间: 2013年09月26日 晚20:00 – 21:30
地点: YY频道 40215226
内容: How to use project 2010 step by step

视频:

1小时时间带你玩转Office Project 2010. 以Navision ERP实施计划为案例进行逐一介绍,为你详解甘特图和项目编排.

课程讲义:

如何使用Project编排计划?

1. 项目的整体安排
项目的执行期间 (开始日期/结束日期, 日历)
项目的范围 (项目的阶段\详细时间计划. 资源)
项目的目标 (指定目标结束日期, 则越晚开始越好
指定目标开始日期, 则越早开始越好)

项目的任务编排
任务有摘要和任务的区分.
里程碑主要用于表示不同的阶段

任务的先后顺序, 以及任务的执行时期区间。

Alt+Shift+左光标 上一级
Alt+Shift+右光标 下一级

分类: Office 标签:

Navision Consultant – Office – Excel – 03 Analysis

2013年7月26日 评论已被关闭

时间: 2013年07月25日 晚20:00 – 21:30
地点: YY频道 40215226
内容: Navision Consultant – Office – Excel – 03 Analysis

视频:

课程内容:
玩转Excel数据分析, 用Excel收集,清洗,整理数据. 数据稍多一些可以建立Access数据集市, 大数据就用Cube了. 都用Excel来分析. 最后更加料, 独家介绍一款商用BI软件 Halobi的ETL与Analysis Web进行综合数据分析. 每期10分钟VBA, 介绍如何定制功能, 并设置到Excel菜单中激活此功能. (HFM/Jetreports都是此相似架构)

分类: Office, Training 标签:

Navision Consultant – Office – Excel – 02

2013年7月19日 评论已被关闭

时间: 2013年07月18日 晚20:00 – 21:30
地点: YY频道 40215226
内容: Navision Consultant – Office – Excel – 02 Functions

视频:

课程内容:
1. 固定资产模块答疑
2. Excel函数应用.(函数的由来,单元格参数的变换,名称与表的作用. 及如何自我学习Excel函数与自定义函数. 全新演绎如何玩转Excel函数)

笔记与附件下载: 函数笔记

分类: Office, Training 标签:

通过VBA编写NAV函数创建Dataport格式数据源

2010年12月2日 没有评论

通过VBA 写的NAV函数创建Dataport的导入数据源。

Function NAV(Optional R1 As Range, Optional R2 As Range, Optional r3 As Range, Optional R4 As Range, Optional R5 As Range, Optional R6 As Range, Optional R7 As Range, Optional R8 As Range, Optional R9 As Range, Optional R10 As Range, Optional R11 As Range, Optional R12 As Range, Optional R13 As Range, Optional R14 As Range, Optional R15 As Range, Optional R16 As Range, Optional R17 As Range, Optional R18 As Range, Optional R19 As Range, Optional R20 As Range) As String
If AddRange(R1) <> “” Then NAV = AddRange(R1)
If AddRange(R2) <> “” Then NAV = NAV + “,” + AddRange(R2)
If AddRange(r3) <> “” Then NAV = NAV + “,” + AddRange(r3)
If AddRange(R4) <> “” Then NAV = NAV + “,” + AddRange(R4)
If AddRange(R5) <> “” Then NAV = NAV + “,” + AddRange(R5)
If AddRange(R6) <> “” Then NAV = NAV + “,” + AddRange(R6)
If AddRange(R7) <> “” Then NAV = NAV + “,” + AddRange(R7)
If AddRange(R8) <> “” Then NAV = NAV + “,” + AddRange(R8)
If AddRange(R9) <> “” Then NAV = NAV + “,” + AddRange(R9)
If AddRange(R10) <> “” Then NAV = NAV + “,” + AddRange(R10)
If AddRange(R11) <> “” Then NAV = NAV + “,” + AddRange(R11)
If AddRange(R12) <> “” Then NAV = NAV + “,” + AddRange(R12)
If AddRange(R13) <> “” Then NAV = NAV + “,” + AddRange(R13)
If AddRange(R14) <> “” Then NAV = NAV + “,” + AddRange(R14)
If AddRange(R15) <> “” Then NAV = NAV + “,” + AddRange(R15)
If AddRange(R16) <> “” Then NAV = NAV + “,” + AddRange(R16)
If AddRange(R17) <> “” Then NAV = NAV + “,” + AddRange(R17)
If AddRange(R18) <> “” Then NAV = NAV + “,” + AddRange(R18)
If AddRange(R19) <> “” Then NAV = NAV + “,” + AddRange(R19)
If AddRange(R20) <> “” Then NAV = NAV + “,” + AddRange(R20)

End Function

Function AddRange(R1 As Range) As String

Dim tempStr As String
If R1 Is Nothing Then
AddRange = “”
Else
Dim rN As Range
For Each rN In R1
tempStr = CStr(rN.Text)
If tempStr = “0” Then tempStr = “”
tempStr = Replace(tempStr, Chr(13), ” “)
tempStr = Replace(tempStr, ChrB(13), ” “)
tempStr = Replace(tempStr, “”””, “‘”)
tempStr = Trim(tempStr)

If AddRange = “” Then
AddRange = “””” + tempStr + “”””
Else
AddRange = AddRange + “,” + “””” + tempStr + “”””
End If
Next
End If
End Function

函数用法是:
在Excel中,直接执行 =NAV(选择单元格) 就可以得到以””,””进行分隔的Dataport格式,然后直接复制到新建的txt中,就可以执行Dataport导入操作了。

分类: Office 标签: ,

如何从Excel直接生成Dataport需要的文件

2010年6月24日 没有评论

如果要从Excel将基础数据使用Dataport导入到系统中,建议采用下面的公式来做。不要做什么CSV

比如现在基础数据表有5列,A/B/C/D/E列,在F1 输入 " 定义名称为y, 在G1输入"," 定义名称为s

那么在F2输入公式 =y&a2&s&b2&s&c2&s&d2&s&e2&y 就可以得到可以用Dataport导入的数据。

将F2到F100里面的复制出来,新建一个文本文件,粘贴保存,就可以在dataport里面导入了

这时就可以自动生成 "1001","test","KG","","" 的格式了

如果需要调整基础数据,只需要在Excel里面修改,然后F列的公式会自动变的。

在Excel中用的时候,可以用Text函数来定义数据类型。

比如 日期,可以用 Text(C2,"yyyy-mm-dd") 就可以得到 2010-07-12的格式

建议使用这种方法,一步一步做就OK。 
这样做,不管基础数据格式怎么样,怎么改,都可以直接复制得到结果。

分类: Office 标签: ,

使用Ado访问Navision Item表

2009年7月24日 没有评论

Navision在SQL Server中存储时,会进行语义转换。

/ 在 SQL Server中转换为_

. 在SQL Server中转换为_

 

采用Adodb连接SQL 2008的语句.

"Driver={SQL Server Native Client 10.0};uid=sa;password=xxxx;server=.;DATABASE=CRONUS;AutoTranslate=No"

AutoTranslate=No 表示不强制转换字符。

 

如果使用 本地Windows帐号认证,则使用:

使用 Trusted_Connection=Yes, 表示 信任连接

"Driver={SQL Server Native Client 10.0};Trusted_Connection=Yes;server=.;DATABASE=CRONUS;AutoTranslate=No"

 

接着使用rs.open “select * from [Company Name$ITEM] 就可以得到物料表。

$分隔后就表示 其中一个公司下的某个表。

分类: Office 标签:

Microsoft Excel file format

2007年4月9日 没有评论

Microsoft Excel is a popular spreadsheet. It uses a file format called BIFF (Binary

File Format). There are many types of BIFF records. Each has a 4 byte header. The

first two bytes are an opcode that specifies the record type. The second two bytes

specify record length. Header values are stored in byte-reversed form (less significant

byte first). The rest of the record is the data itself (Figure 2-1).

Figure 2-1. BIFF record header.

                 | Record Header    | Record Body

Byte Number      | 0    1    2    3 | 0    1   …

                ———————————–

Record Contents    | XX | XX | XX | XX | XX | XX | …

                ———————————–

                | opcode   | length | data

Each X represents a hexadecimal digit

Two X’s form a byte. The least significant (low) byte of the opcode is byte 0 and the

most significant (high) byte is byte 1. Similarly, the low byte of the record length

field is byte 2 and the high byte is byte 3.

BOF (Beginning of File)

The first record in every spreadsheet is always of the BOF type (Figure 2-2).

Figure 2-2. BOF record.

           | Record Header  |   Record Body   |

Byte       | 0   1   2   3 | 0   1   2   3 |

           —————————————–

Contents   | 09 | 00 | 04 | 00 | 02 | 00 | 10 | 00 |

           —————————————–

           | opcode | length | version | file   |

           |        |        | number | type |

The first two bytes, arranged with the low byte first, show that the opcode for BOF is

09h. The second two bytes indicate that the record body is 4 bytes long. The first two

bytes of the body are the version number (2 for the initial version of Excel). The last

two bytes are the file type. Type 10h is a worksheet file.

Relating Spreadsheet Cells to Record Data Bytes

A spreadsheet appears on a screen or printout as a matrix of rectangular cells. Each

column is identified by a letter at its top, and each row is identified by a number.

Thus cell A1 is in the first column and the first row. Cell C240 is in the third column

and the 240th row. This scheme identifies cells in a way easily understood by people.

However, it is not particularly convenient for computers, as they do not handle letters

efficiently. They are best at dealing with binary numbers. Thus, Excel stores cell

identifiers as binary numbers, that people can read as hexadecimal. The first number in

the system is 0 rather than 1.

Figure 2-3, which shows the form of an INTEGER record, illustrates the storage of column

and row information.

Figure 2-3. INTEGER record.

      | Record Header    | Record Body

Byte | 0    1    2    3 | 0    1    2    3    4    5    6    7    8 |

      ——————————————————————

Value | 02 | 00 | 09 | 00 | 00 | 00 | 02 | 00 | 00 | 00 | 00 | 39 | 00 |

      ——————————————————————

      | opcode | length |   row   | column |   rgbAttr    |    w    |

Opcode 2 indicates an integer record. The length bytes show that the record body is 9

bytes long. Row 0 in the body corresponds to spreadsheet row 1. Row 1 corresponds to

spreadsheet row 2, and so on. Column 2 corresponds to spreadsheet column C. Thus,

Figure 2-3 deals with cell C1. The next three bytes, labeled "rgbAttr," specify cell

attributes (Table 2-3). The final pair of bytes, (labeled "w") holds the integer’s

value. Here it is 39H or 57 decimal. Thus the record specifies that cell C1 of the

spreadsheet contains an integer with the value 57.

Standard File Record Order

Excel worksheet files have each record type in a predetermined position. A file need

not have all types, but the ones that are present are always be in the same order.

Table 2-1 lists the record types for Excel document (spreadsheet) files, in the order

they would appear in a BIFF file. Table 2-2 lists the types in opcode order.

Several record types in a BIFF file, namely, ROW, BLANK, INTEGER, NUMBER, LABEL,

BOOLERR, FORMULA, and COLUMN DEFAULT, describe the contents of a cell. These records

contain a 3 byte attribute field labeled "rgbAttr". The following table describes how

the bits in the field correspond to cell attributes.

Table 2-1. Cell Attributes

Byte Offset     Bit   Description                     Contents

     0          7     Cell is not hidden              0b

                      Cell is hidden                  1b

                6     Cell is not locked              0b

                      Cell is locked                  1b

                5-0   Reserved, must be 0             000000b

                7-6   Font number (4 possible)

                5-0   Cell format code

     2          7     Cell is not shaded              0b

                      Cell is shaded                  1b

                6     Cell has no bottom border       0b

                      Cell has a bottom border        1b

                5     Cell has no top border          0b

                      Cell has a top border           1b

                4     Cell has no right border        0b

                      Cell has a right border         1b

                3     Cell has no left border         0b

                      Cell has a left border          1b

                2-0   Cell alignment code

                           general                    000b

                           left                       001b

                           center                     010b

                           right                      011b

                           fill                       100b

                           Multiplan default align.   111b

The font number field is a zero-based index into the document’s table of fonts. the

cell format code is a zero-based index into the document’s table of picture formats.

There are 21 different standard formats. Additional custom formats may be defined by

the user. See the FONT and FORMAT record descriptions form additonal details.

Table 2-2. Excel Record Type in Order of Appearance

Record Type                Opcode (Hexadecimal)

BOF                           09

FILEPASS                      2F

INDEX                         0B

CALCCOUNT                     0C

CALCMODE                      0D

PRECISION                     0E

REFMODE                       0F

DELTA                         10

ITERATION                     11

1904                          22

BACKUP                        40

PRINT ROW HEADERS             2A

PRINT GRIDLINES               2B

HORIZONTAL PAGE BREAKS        1B

VERTICAL PAGE BREAKS          1A

DEFAULT ROW HEIGHT            25

FONT                          31

FONT2                         32

HEADER                        14

FOOTER                        15

LEFT MARGIN                   26

RIGHT MARGIN                  27

TOP MARGIN                    28

BOTTOM MARGIN                 29

COLWIDTH                      24

EXTERNCOUNT                   16

EXTERNSHEET                   17

EXTERNNAME                    23

FORMATCOUNT                   1F

FORMAT                        1E

NAME                          18

DIMENSIONS                    00

COLUMN DEFAULT                20

ROW                           08

BLANK                         01

INTEGER                       02

NUMBER                        03

LABEL                         04

BOOLERR                       05

FORMULA                       06

ARRAY                         21

CONTINUE                      3C

STRING                        07

TABLE                         36

TABLE2                        37

PROTECT                       12

WINDOW PROTECT                19

PASSWORD                      13

NOTE                          1C

WINDOW1                       3D

WINDOW2                       3E

PANE                          41

SELECTION                     1D

EOF                           0A

Table 2-3. Excel Record Types in Opcode Order

Record Type             Opcode (hexadecimal)

DIMENSIONS                 00

BLANK                      01

INTEGER                    02

NUMBER                     03

LABEL                      04

BOOLERR                    05

FORMULA                    06

STRING                     07

ROW                        08

BOF                        09

EOF                        0A

INDEX                      0B

CALCCOUNT                  0C

CALCMODE                   0D

PRECISION                  0E

REFMODE                    0F

DELTA                      10

ITERATION                  11

PROTECT                    12

PASSWORD                   13

HEADER                     14

FOOTER                    15

EXTERNCOUNT                16

EXTERNSHEET                17

NAME                       18

WINDOW PROTECT             19

VERTICAL PAGE BREAKS       1A

HORIZONTAL PAGE BREAKS     1B

NOTE                       1C

SELECTION                  1D

FORMAT                     1E

FORMATCOUNT                1F

COLUMN DEFAULT             20

ARRAY                      21

1904                       22

EXTERNNAME                 23

COLWIDTH                   24

DEFAULT ROW HEIGHT         25

LEFT MARGIN                26

RIGHT MARGIN               27

TOP MARGIN                 28

BOTTOM MARGIN              29

PRINT ROW HEADERS          2A

PRINT GRIDLINES            2B

FILEPASS                   2F

FONT                       31

FONT2                      32

TABLE                      36

TABLE2                     37

CONTINUE                   3C

WINDOW1                    3D

WINDOW2                    3E

BACKUP                     40

PANE                       41

Worksheet Record Types in Opcode Order

The following section lists all record types in opcode order. It gives a specification

and byte-by-byte breakdown of each type. Note that Excel terminology refers to

spreadsheets or worksheets as "documents."

DIMENSIONS                  00h                         0d

Record Type: DIMENSIONS

Description: Entire dimensions or range of a spreadsheet

Record Body Length: 8 bytes

Record Body Byte Structure:

      Byte Number     Byte Description               Contents (hex)

           0-1        First row

           2-3        Last row plus 1

           4-5        First column

           6-7        Last column plus 1

Note: The last row and column in the record are both one greater than the highest

numbered occupied ones.

BLANK                       01h                         1d

Record Type: BLANK

Description: Cell with no formula or value

Record Body Length: 7 bytes

Record Body Byte Structure:

Byte Number     Byte Description               Contents (hex)

           0-1        Row

           2-3        Column

           4-6        Cell attributes (rgbAttr) (Table 2-3)

INTEGER                     02h                         2d

Record Type: INTEGER

Description: Constant unsigned integer

Record Body Length: 9 bytes

Record Body Byte Structure:

Byte Number     Byte Description               Contents (hex)

           0-1        Row

           2-3        Column

           4-6        Cell attributes (rgbAttr) (Table 2-3)

           7-8        Unsigned integer value (w)

NUMBER                      03h                         3d

Record Type: NUMBER

Description: Constant floating point number

Record Body Length: 15 bytes

Record Body Byte Structure:

Byte Number     Byte Description               Contents (hex)

           0-1        Row

           2-3        Column

           4-6        Cell attributes (rgbAttr) (Table 2-3)

           7-14       Floating point number value (IEEE format, see Appendix A)

LABEL                       04h                         4d

Record Type: LABEL

Description: Constant string

Record Body Length: 8 to 263 bytes

Record Body Byte Structure:

      Byte Number     Byte Description               Contents (hex)

           0-1        Row

           2-3        Column

           4-6        Cell attributes (rgbAttr) (Table 2-3)

           7          Length of string

           8-263      ASCII string, 0 to 255 bytes long

BOOLERR                     05h                         5d

Record Type: BOOLERR

Description: Boolean constant or error value

Record Body Length: 9 bytes

Record Body Byte Structure:

      Byte Number     Byte Description               Contents (hex)

           0-1        Row

           2-3        Column

           4-6        Cell attributes (rgbAttr) (Table 2-3)

           7          Boolean or error value

                                Boolean

                                      true                 1

                                      false                0

                                Error

                                      #NULL!               0

                                      #DIV/0!              7

                                      #VALUE!              0Fh

                                      #REF!                17h

                                      #NAME?               1Dh

                                      #NUM!                24h

                                      #N/A                 2Ah

           8          Specifies Boolean or error

                                Boolean                    0

                                Error                      1

FORMULA                     06h                         6d

Record Type: FORMULA

Description: Name, size, and contents of a formula cell

Record Body Length: 17-272 bytes

Record Body Byte Structure:

      Byte Number     Byte Description               Contents (hex)

           0-1        Row

           2-3        Column

           4-6        Cell attributes (rgbAttr) (see Table 2-3)

           7          Current value of formula (IEEE format, see Appendix A)

           15         Recalc flag

           16         Length of parsed expression

           17         Parsed expression

If a formula must be recalculated whenever it is loaded, the recalc flag (byte 15) must

be set. Any nonzero value is a set recalc flag. However, a flag value of 3 indicates

that the cell is a part of a matrix, and the entire matrix must be recalculated. Bytes 7

through 14 may contain a number, a Boolean value, an error code, or a string. The

following tables apply.

Case 1: Bytes 7 – 14 contain a Boolean value.

     Byte Number     Byte Description          Contents (hex)

           7         otBool                          1

           8         Reserved                        0

           9         Boolean value

           10-12     Reserved                        0

           13-14     fExprO                          FFFFh

Case 2: Bytes 7 – 14 contain an error code.

     Byte Number     Byte Description          Contents (hex)

           7         otErr                           2

           8         Reserved                        0

           9         error code

           10-12     Reserved                        0

           13-14     fExprO                          FFFFh

Case 3: Bytes 7 – 14 contain a string.

     Byte Number     Byte Description         Contents (hex)

           7         otString                        0

           8-12      Reserved                        0

           13-14     fExprO                          FFFFh

The string value itself is not stored in the field, but rather in a separate record of

the STRING type.

STRING                      07h                         7d

Record Type: STRING

Description: Value of a string in a formula

Record Body Length: variable

Record Body Byte Structure:

      Byte Number     Byte Description           Contents (hex)

           0          Length of the string

           1-256 (max) The string itself

The STRING record appears immediately after the FORMULA record that evaluates to the

string, unless the formula is in an array. In that case, the string record immediately

follows the ARRAY record.

ROW                         08h                         8d

Record Type: ROW

Description: Specifies a spreadsheet row

Record Body Length: 16 bytes

Record Body Byte Structure:

      Byte Number     Byte Description               Contents (hex)

           0-1        Row number

           2-3        First defined column in the row

           4-5        Last defined column in the row plus 1

           6-7        Row height

           8-9        RESERVED                               0

           10         Default cell attributes byte

                      Default attributes                      1

                      Not default attributes                  0

           11-12      Offset to cell records for this row

           13-15      Cell attributes (rgbAttr) (see Table 2-3)

BOF                         09h                         9d

Record Type: BOF

Description: Beginning of file

Record Body Length: 4 bytes

Record Body Byte Structure:

      Byte Number     Byte Description               Contents (hex)

           0-1        Version number

                           Excel                           2

                           Multiplan                       3

           2-3        Document type

                           worksheet                       10h

                           chart                           20h

                           macro sheet                     40h

If bit 8 of the version number byte pair is high (mask with 0100h to find out), the BIFF

file is a Multiplan document.

EOF                         0Ah                         10d

Record Type: EOF

Description: End of file

Record Body Length: 0 bytes

The EOF record is the last one in a BIFF file. It always takes the form 0A000000h.

INDEX                       0Bh                         11d

Record Type: INDEX

Description: Contains pointers to other records in the BIFF file, and defines the range

of rows used by the document. It is used to simplify searching a file for a particular

cell or name.

Record Body Length: variable

Record Body Byte Structure:

      Byte Number     Byte Description               Contents (hex)

           0-3        Absolute file position of first NAME record

           4-5        First row that exists

           6-7        Last row that exists plus 1

           8-on       Array of absolute file positions of the

                      blocks of ROW records.

The INDEX record is optional. If present, it must immediately follow the FILEPASS

record. IF there is no FILEPASS record, it must follow the BOF record.

CALCCOUNT                   0Ch                         12d

Record Type: CALCCOUNT

Description: Specifies the iteration count

Record Body Length: 2

Record Body Byte Structure:

      Byte Number     Byte Description               Contents (hex)

           0-1        Iteration Count

CALCMODE                    0Dh                         13d

Record Type: CALCMODE

Description: Specifies the calculation mode

Record Body Length: 2

Record Body Byte Structure:

      Byte Number     Byte Description               Contents (hex)

           0-1        Calculation mode

                        Manual                           0

                        Automatic                        1

                        Automatic, no tables            -1

PRECISION                   0Eh                         14d

Record Type: PRECISION

Description: Specifies precision of calculations for document

Record Body Length: 2

Record Body Byte Structure:

      Byte Number     Byte Description               Contents (hex)

           0-1        Document precision

                        precision as displayed           0

                        full precision                   1

REFMODE                     0Fh                         15d

Record Type: REFMODE

Description: Specifies location reference mode

Record Body Length: 2

Record Body Byte Structure:

      Byte Number     Byte Description            Contents (hex)

          0-1         Reference mode

                        R1C1 mode                      0

                        A1 mode                        1

DELTA                       10h                         16d

Record Type: DELTA

Description: Maximum change for an iterative model

Record Body Length: 8

Record Body Byte Structure:

      Byte Number           Byte Description      Contents (hex)

          0-7               Maximum change (IEEE format, see Appendix A)

ITERATION                   11h                         17d

Record Type: ITERATION

Description: Specifies whether iteration is on

Record Body Length: 2

Record Body Byte Structure:

      Byte Number           Byte Description         Contents (hex)

          0-1               Iteration flag

                              Iteration off               0

                              Iteration on                1

PROTECT                     12h                         18d

Record Type: PROTECT

Description: Specifies whether the document is protected with a document password

Record Body Length: 2

Record Body Byte Structure:

      Byte Number           Byte Description         Contents (hex)

          0-1               Document protection

                              Not protected               0

                              Protected                   1

PASSWORD                    13h                         19d

Record Type: PASSWORD

Description: Contains encrypted document password

Record Body Length: 2

Record Body Byte Structure:

      Byte Number           Byte Description         Contents (hex)

          0-1               Encrypted password

HEADER                      14h                         20d

Record Type: HEADER

Description: Specifies header string that appears at the top of every page when the

document is printed

Record Body Length: variable

Record Body Byte Structure:

      Byte Number           Byte Description         Contents (hex)

           0                Length of string (bytes)

         1-on               Header string (ASCII)

FOOTER                      15h                         21d

Record Type: FOOTER

Description: Specifies footer string that appears at the bottom of every page when the

document is printed

Record Body Length: variable

Record Body Byte Structure:

      Byte Number           Byte Description         Contents (hex)

          0                 Length of string (bytes)

        1-on                Footer string (ASCII)

EXTERNCOUNT                 16h                         22d

Record Type: EXTERNCOUNT

Description: Specifies the number of documents referenced externally by an Excel

document

Record Body Length: 2

Record Body Byte Structure:

      Byte Number           Byte Description         Contents (hex)

          0-1               Number of externally referenced documents

EXTERNSHEET                 17h                         23d

Record Type: EXTERNSHEET

Description: Specifies a document that is referenced externally by the Excel file.

There must

分类: Office 标签: