.Exact match by header nameMatching

Sultanamow02

Then uses the header fields to completely match the system fields. If they match, then this column refers to a specific field. The header field is often the first row, which can be understood as a Key, and the second row starts with the Value based on header coordinates means that the first row is not necessarily regarded as the key of the header, but the coordinates are used to determine what the key of the header is. For example, you can write a bunch of instructions for filling out the form in the first line. [size=14.6667px]


Then the second line is the real header, and the third line starts with the Value. Then A2 B2 C2 are the header fields, and A3 B3 C3 below are the specific values.Match by header coordinates5. Fixed template import and Iceland Phone Number  parsing template importFixed template import means that I preset the corresponding Excel template in advance, and then the user fills in the corresponding fields according to my Excel template, and then when importing, match according to.





The name of the field or according to the coordinates of the field (A1:B1:C2 ) to match the corresponding data. The main premise of this method is that the user cannot modify the order of the template or the field names of the template, etc. It is also the most commonly used imported design solution.Preset template importParsing template import means that I import according to your customized template, then I parse all your columns, and then manually match your Excel columns with the fields that exist in the system. After matching, you can save it as a parsing template. . Later, when you import Excel with a similar structure, you can directly use this template to parse it.