Data list refers to the data area composed of the structural characteristics of records and fields in Excel.
Excel can perform various data management and analysis functions on data lists, including basic database functions such as query, sorting, filtering, and classification and summary. operate. The data list is an Excel worksheet that contains one column header and multiple rows of data, and the data in each row and column are exactly the same type and format.
In Excel 2000, the database is treated as a data list. We can understand that the data list is the database. In a database, information is stored by records. The items containing information content in each record are called fields.
In order for Excel to automatically treat the data list as a database, the main requirements for constructing the data list are:
The column mark should be located in the first row of the data list for search and organize data and create reports.
The type and format of data items in each row in the same column should be exactly the same.
Avoid placing blank rows or columns in the middle of the data list, but when you need to separate the data list from other data, you should leave at least one blank row or column between them.
Try to create a data list on a worksheet.
Users can follow the following steps to create a data list.
(1) Enter the field names of each column in the first row of the worksheet, and then enter data in the columns corresponding to each field name.
(2) Select any cell in the data list, select the "Data" → "Record Sheet" command, and the record sheet "Sheet1" dialog box will pop up, which displays the record just created. .
(3) Click the "New" button to create a new record. The user can enter the data corresponding to each field of the record in the dialog box.
(4) After adding all records, click the "Close" button to return to the worksheet editing window, where the user can view all records in the data list.
For more Excel-related technical articles, please visit the Excel Tutorial column to learn!
The above is the detailed content of excel data list. For more information, please follow other related articles on the PHP Chinese website!