Excel 2003 XML file format

xiaoxiao2021-03-06  37

The hierarchy of the table software is generally relatively simple. The entire file is a Workbook node. You can include multiple worksheets in Workbook. Worksheet has multiple ROW objects, and each ROW contains multiple Cell. Workbook Worksheet Row Cell Cell ... ... Worksheet ... Excel is basically this structure, the only difference is that the ROW object is not directly included in the worksheet, but is included in a Table node, and Table is included in Worksheet, and Worksheet can only have a Table object. It is estimated that this design is to facilitate the convenience of other documents such as the Word public Table element.

There is not only Worksheet in Workbook, but also a Styles byte. STYLES is some Style nodes for saving properties of cells, such as font information, borders, and background fills, etc. Style has a styleid property that references the corresponding style through a StyleID string. Only the product of the cell is saved in Styles, other objects such as ROW, there is a RowHeight property, just simple as a property of the ROW object Not using a separate style node. A fairly simple EXCEL file is approximately structured: