Excel data import and export method and device

• Main Authors: CAI KUNYING, CHEN CHANGWEI, HONG ZHIQUAN, YU CHONGGANG, ZHUANG SHICHAO
• Format: Patent
• Language: Chinese; English
• Published: 21.03.2023
• Subjects: CALCULATING; COMPUTING; COUNTING; ELECTRIC DIGITAL DATA PROCESSING; PHYSICS

The invention relates to an Excel data import and export method and device.The Excel data import and export method comprises the steps that imported or exported data is matched with table information of a preset database, newly added field information is generated, and obtaining of the preset database comprises uploading of the table information of an Excel template; creating a data object, wherein the data object does not contain field information; respectively combining the data object with the field name, the field attribute and the field value of the newly added field information to generate a new field name, a new field attribute and a new field value; creating a target object by using a code generation package, and assigning the new field name, the new field attribute and the new field value to the target object; and importing or exporting the data according to the target object, so that the method has the advantages that the table information is flexibly configured, the change part of the corresponding