The main processing object of Excel is tables, that is, Fang Gezi seen when opening Excel files. Basically, all the functions of Excel revolve around tables (that is, these Fang Gezi). The table mainly includes the following parts: (1) cells for storing data; (2) Built-in computing function; (3) sorting and screening the rows or columns of the table; (4) Data statistics and visualization. How is the data in 1.Excel stored and called? Office series products are compressed and stored in office open xml file format. We see that the xlsx file is actually a compressed file. They compressed several plain texts in xml format together, and Excel read the information of these compressed files, and finally presented us with a graphical table.

"Reward data. The xlsx file in the above picture is the Excel file we usually use. Add ". Zip "file name becomes" reward data. Xlsx.zip ",and unzip this zip file to get an xml file and three folders.

The xl folder stores most of the topics of Excel. Theme: Save the theme settings of this Excel; SharedString: stores the information in each cell; Worksheets: record the mutual calling relationship between worksheets.

You can see how the characters in the table are stored as text. In other words, Excel will use various codes to read these xml plain texts later, and then display these texts in the graphical interface. Excel stores information by tagging all kinds of information and storing it in xml file in the form of plain text. When we need to read information, it decodes the plain text into the table we see by retrieving the relationship between these texts.