[go: up one dir, main page]

WO2020134989A1 - Excel数据的导入方法、装置、计算机设备和存储介质 - Google Patents

Excel数据的导入方法、装置、计算机设备和存储介质 Download PDF

Info

Publication number
WO2020134989A1
WO2020134989A1 PCT/CN2019/123875 CN2019123875W WO2020134989A1 WO 2020134989 A1 WO2020134989 A1 WO 2020134989A1 CN 2019123875 W CN2019123875 W CN 2019123875W WO 2020134989 A1 WO2020134989 A1 WO 2020134989A1
Authority
WO
WIPO (PCT)
Prior art keywords
imported
excel file
version
excel
business object
Prior art date
Application number
PCT/CN2019/123875
Other languages
English (en)
French (fr)
Inventor
车光爱
翁浦益
初旭
Original Assignee
益萃网络科技（中国）有限公司
Priority date (The priority date is an assumption and is not a legal conclusion. Google has not performed a legal analysis and makes no representation as to the accuracy of the date listed.)
Filing date
Publication date
Application filed by 益萃网络科技（中国）有限公司 filed Critical 益萃网络科技（中国）有限公司
Publication of WO2020134989A1 publication Critical patent/WO2020134989A1/zh

Links

Images

Classifications

    • G—PHYSICS
    • G06—COMPUTING; CALCULATING OR COUNTING
    • G06F—ELECTRIC DIGITAL DATA PROCESSING
    • G06F16/00—Information retrieval; Database structures therefor; File system structures therefor
    • G06F16/20—Information retrieval; Database structures therefor; File system structures therefor of structured data, e.g. relational data
    • G06F16/25—Integrating or interfacing systems involving database management systems

Definitions

  • This application relates to the field of computer technology, and in particular to an Excel data import method, device, computer equipment, and storage medium.
  • an embodiment of the present application provides a method for importing Excel data.
  • the method includes:
  • the method before importing the converted business object, the method further includes: obtaining configuration information of the Excel file to be imported; verifying the converted business object according to the configuration information; when the verification is passed, then Import the converted business object.
  • it also includes: when the verification fails, it returns an alarm prompt.
  • identifying the version of the Excel file to be imported includes: reading the Excel file to be imported; converting the Excel file to be imported into a stream object; determining the Excel file to be imported according to the starting byte recorded in the stream object Version, where the version of the Excel file to be imported includes the first version or the second version.
  • determining the corresponding processing method according to the version of the Excel file to be imported includes: when it is determined that the version of the Excel file to be imported is the first version, the POI component is used to convert the Excel file to be imported into a corresponding business object ; When it is determined that the version of the Excel file to be imported is the second version, the mode based on event analysis is used to convert the Excel file to be imported into the corresponding business object.
  • the POI component is used to convert the Excel file to be imported into the corresponding business object, including: the POI component is used to convert the Excel file to be imported that has been converted into a stream object into a workbook object; according to the preset mapping relationship, The workbook object is converted to the corresponding business object.
  • the event-based analysis mode is used to convert the Excel file to be imported into corresponding business objects, including: using the event-based analysis mode to read each of the Excel files to be imported that have been converted into stream objects The content of the cell; according to the preset mapping relationship, the content of each cell is encapsulated into the corresponding business object.
  • an embodiment of the present application also provides an apparatus for importing Excel data, including:
  • Identification module used to identify the version of the Excel file to be imported
  • the processing mode determination module is used to determine the corresponding processing mode according to the version of the Excel file to be imported;
  • the conversion module is used to convert the Excel file to be imported into the corresponding business object according to the determined processing method
  • Import module for importing converted business objects.
  • an embodiment of the present application further provides a computer device, including a memory and a processor, where the memory stores a computer program, and when the processor executes the computer program, the steps of the method described above are implemented.
  • an embodiment of the present application further provides a computer-readable storage medium on which a computer program is stored, and when the computer program is executed by a processor, the steps of the method described above are implemented.
  • the above-mentioned Excel data import method, device, computer equipment and storage medium identify the corresponding processing method according to the version of the Excel file to be imported by identifying the version of the Excel file to be imported, so as to convert the Excel file to be imported into Corresponding business object to import the converted business object, so that when the offline data is transferred to the online, the offline Excel file is automatically imported into the online system, which improves the efficiency of data import and avoids manual entry Errors generated during data increase the accuracy of data import.
  • FIG. 1 is a schematic flowchart of an Excel data import method in an embodiment
  • FIG. 2 is a schematic flowchart of a step of identifying a version of an Excel file to be imported in an embodiment
  • FIG. 3 is a schematic flowchart of steps for processing an Excel file to be imported according to an embodiment
  • FIG. 4 is an example diagram of a business object in an embodiment
  • FIG. 5 is an example diagram of an Excel file to be imported in an embodiment
  • FIG. 6 is a diagram of an example of mapping business objects in an embodiment
  • FIG. 7 is a schematic flowchart of steps for processing an Excel file according to a version to be imported in another embodiment
  • FIG. 9 is a structural block diagram of an apparatus for importing Excel data in an embodiment
  • FIG. 10 is an internal structure diagram of a computer device in an embodiment.
  • An embodiment of the present application provides a method for importing Excel data. As shown in FIG. 1, the method may include the following steps:
  • Step 102 Identify the version of the Excel file to be imported.
  • Step 104 Determine the corresponding processing method according to the version of the Excel file to be imported.
  • Step 106 Convert the Excel file to be imported into a corresponding business object according to the determined processing method.
  • the imported Excel file can be processed according to the corresponding processing method
  • the Excel file to be imported is converted into a corresponding business object that the system can directly operate.
  • the business object is a form that has a certain mapping relationship with the Excel file to be imported and has a specific format and content, and the system can directly operate the form.
  • Step 108 Import the converted business object.
  • the converted business objects can be imported into the required system, so as to realize automatic import of Excel data.
  • the above-mentioned Excel data import method recognizes the version of the Excel file to be imported and determines the corresponding processing method according to the version of the Excel file to be imported, thereby converting the Excel file to be imported into the corresponding business object according to the determined processing method to convert the
  • the offline Excel files are automatically imported into the online system when the offline data is transferred to the online system, which improves the efficiency of data import, and avoids the errors generated when manually entering data.
  • the accuracy of data import is possible to be imported.
  • identifying the version of the Excel file to be imported may specifically include the following steps:
  • Step 202 read the Excel file to be imported.
  • Step 204 Convert the Excel file to be imported into a stream object.
  • Step 206 Determine the version of the Excel file to be imported according to the starting byte recorded in the stream object.
  • the import of Excel data in this embodiment is also completed by the computer. Therefore, when the computer reads the Excel file to be imported, the Excel file to be imported is converted into a stream object, where the stream object may be a java object. Also, when the Excel file is stored in the computer, the content of the first few bytes (ie, the magic number) is fixed, and the file type can usually be determined by the content of the first few bytes. Therefore, the computer according to the stream The starting byte recorded in the object and parsed to determine the version of the Excel file to be imported.
  • the version of the Excel file to be imported includes the first version or the second version.
  • the first version may specifically be a version before Office2007 (excluding Office2007), which may be referred to as a low version
  • the second version may specifically be a version starting from Office2007 (including Office2007), which may be referred to as a high version.
  • the computer determines whether the corresponding Excel file type belongs to "xls" or "xlsx” through the start byte recorded in the stream object, so as to determine the version of the Excel file to be imported according to the corresponding relationship between the file type and the version.
  • the version of the Excel file to be imported is taken as the first version for example, such as As shown in Figure 3, the following steps can be included:
  • Step 302 when it is determined that the version of the Excel file to be imported is the first version, the POI component is used to convert the Excel file to be imported that has been converted into a stream object into a workbook object.
  • the POI component refers to an API (Application Programming Interface) that provides Java programs with functions for reading and writing Microsoft Office format files.
  • Workbook is a high-level representation of a workbook, which is the superior object of a sheet.
  • an excel file can be considered as a workbook, and a workbook can contain multiple worksheets (ie sheets).
  • the POI component can be used to read the converted to stream
  • the object's Excel file to be imported is converted into a workbook object that can be manipulated by software (such as a Java program).
  • Step 304 Convert the workbook object to the corresponding business object according to the preset mapping relationship.
  • the mapping relationship between the Excel file to be imported and the business object can be established in advance according to the user's demand for the business object and the pre-analysis of the Excel file to be imported in the early stage. Specifically, the mapping relationship between each row or column of the corresponding sheet in the Excel file to be imported and the attribute values recorded in the business object may be defined in advance.
  • the first column of records in the Excel file to be imported can be created in advance
  • the mapping relationship between the "serial number" and the "order number” in the business object, the mapping relationship between the "customer name” recorded in the second column of the Excel file and the "purchase unit” in the business object, and the third in the Excel file The mapping relationship between the "product name” in the column record and the "purchase name” in the business object..., the mapping relationship between the "total price” recorded in the last column in the Excel file and the "sale amount” in the business object.
  • Step 702 When it is determined that the version of the Excel file to be imported is the second version, the content of each cell in the Excel file to be imported that has been converted into a stream object is read in a mode based on event resolution.
  • step 704 the content of each cell is packaged as a corresponding business object according to a preset mapping relationship.
  • the version of the Excel file to be imported is determined to be the second version (that is, the high version) through the above steps, since the high-level Excel file is stored in text form, if the POI component is used for conversion at this time, it will occupy The large amount of memory in the computer even causes the risk of computer paralysis. Therefore, in this embodiment, for the high-level Excel file, the Excel file to be imported that has been converted into a stream object is read in the mode based on event analysis, that is, the content of each cell in the Excel file to be imported is read one by one, Furthermore, according to the preset mapping relationship, the content of each cell is encapsulated into a corresponding business object.
  • various data types recorded in the Excel file to be imported can be processed, such as text data, numeric data, date data, formula data, or picture data, etc., and supports Import of multiple worksheets. Therefore, the method of this embodiment has a wide application range, can meet the basic needs of customers, and has a high degree of intelligence.
  • the method may further include the following steps:
  • Step 802 Obtain configuration information of an Excel file to be imported.
  • step 804 the converted business object is verified according to the configuration information. If the verification is passed, step 806 is executed, otherwise step 808 is executed.
  • Step 806 Import the converted business object.
  • Step 808 return to the alarm prompt.
  • the configuration information of the Excel file to be imported may specifically be the configuration information set when establishing the mapping relationship between the Excel file to be imported and the business object, such as specific requirements for the attribute values in the mapped business object, for example, The regulation of the data format after mapping, the regulation of the data range, etc.
  • the mapping relationship is stipulated that the method of "Chinese capitalization” should be used to map it to the business object, the corresponding form of the "unit price of goods" after the mapping should be: "One hundred two pick three rounds”.
  • the converted business object can also be checked according to the preset configuration information, only when the converted business object conforms to the Import the converted business objects only when relevant requirements are met. Otherwise, the import operation is not performed and the alarm prompt is returned.
  • specific prompt information can be displayed in the alarm prompt, for example, which attribute value in the business object does not meet the requirements, so that the relevant operator can find the problem in time and repair it, thereby ensuring the data in the imported business object accuracy.
  • steps in the flowcharts of FIGS. 1-8 are displayed in order according to the arrows, these steps are not necessarily executed in the order indicated by the arrows. Unless clearly stated in this article, the execution of these steps is not strictly limited in order, and these steps may be executed in other orders. Moreover, at least some of the steps in FIGS. 1-8 may include multiple sub-steps or multiple stages. These sub-steps or stages are not necessarily executed at the same time, but may be executed at different times. These sub-steps or stages The execution order of is not necessarily sequential, but may be executed in turn or alternately with at least a part of other steps or sub-steps or stages of other steps.
  • an Excel data import device including: an identification module 901, a processing mode determination module 902, a conversion module 903, and an import module 904, where:
  • the identification module 901 is used to identify the version of the Excel file to be imported
  • the processing mode determination module 902 is used to determine the corresponding processing mode according to the version of the Excel file to be imported;
  • the conversion module 903 is used to convert the Excel file to be imported into the corresponding business object according to the determined processing method
  • the import module 904 is used to import the converted business object.
  • it also includes a verification module: used to obtain configuration information of the Excel file to be imported; verifying the converted business object according to the configuration information; when the verification is passed, importing the converted business object.
  • a verification module used to obtain configuration information of the Excel file to be imported; verifying the converted business object according to the configuration information; when the verification is passed, importing the converted business object.
  • the verification module is also used to return an alarm prompt when the verification fails.
  • identifying the version of the Excel file to be imported includes: reading the Excel file to be imported; converting the Excel file to be imported into a stream object; determining the version of the Excel file to be imported according to the starting byte recorded in the stream object , Where the version of the Excel file to be imported includes the first version or the second version.
  • determining the corresponding processing method according to the version of the Excel file to be imported includes: when it is determined that the version of the Excel file to be imported is the first version, the POI component is used to convert the Excel file to be imported into a corresponding business object; When it is determined that the version of the Excel file to be imported is the second version, the mode based on event analysis is used to convert the Excel file to be imported into the corresponding business object.
  • using the POI component to convert the Excel file to be imported into a corresponding business object includes: using the POI component to convert the Excel file to be imported that has been converted into a stream object into a workbook object; converting the workbook according to a preset mapping relationship The object is converted to the corresponding business object.
  • the event-based analysis mode is used to convert the Excel file to be imported into corresponding business objects, including: using the event-based analysis mode to read each unit in the Excel file to be imported that has been converted into a stream object The content of the cell; encapsulate the content of each cell into the corresponding business object according to the preset mapping relationship.
  • Each module in the above-mentioned Excel data importing device may be implemented in whole or in part by software, hardware, and a combination thereof.
  • the above modules may be embedded in the hardware form or independent of the processor in the computer device, or may be stored in the memory in the computer device in the form of software so that the processor can call and execute the operations corresponding to the above modules.
  • a computer device is provided.
  • the computer device may be a terminal, and an internal structure diagram thereof may be as shown in FIG.
  • the computer equipment includes a processor, a memory, a network interface, a display screen, and an input device connected through a system bus.
  • the processor of the computer device is used to provide computing and control capabilities.
  • the memory of the computer device includes a non-volatile storage medium and an internal memory.
  • the non-volatile storage medium stores an operating system and computer programs.
  • the internal memory provides an environment for the operating system and computer programs in the non-volatile storage medium.
  • the network interface of the computer device is used to communicate with external terminals through a network connection. When the computer program is executed by the processor, an Excel data import method is realized.
  • the display screen of the computer device may be a liquid crystal display screen or an electronic ink display screen
  • the input device of the computer device may be a touch layer covered on the display screen, or may be a button, a trackball, or a touchpad provided on the computer device housing , Can also be an external keyboard, touchpad or mouse.
  • FIG. 10 is only a block diagram of a part of the structure related to the solution of the present application, and does not constitute a limitation on the computer device to which the solution of the present application is applied.
  • the specific computer device may It includes more or less components than shown in the figure, or some components are combined, or have different component arrangements.
  • a computer device including a memory and a processor, and a computer program is stored in the memory, and the processor implements the computer program to implement the following steps when executing the computer program:
  • the method before importing the converted business object, the method further includes: obtaining configuration information of the Excel file to be imported; verifying the converted business object according to the configuration information; when the verification is passed, then The converted business objects are imported.
  • the method further includes: when the verification fails, returning an alarm prompt.
  • identifying the version of the Excel file to be imported includes: reading the Excel file to be imported; converting the Excel file to be imported into a stream object; determining the version of the Excel file to be imported according to the starting byte recorded in the stream object Where the version of the Excel file to be imported includes the first version or the second version.
  • determining the corresponding processing method according to the version of the Excel file to be imported includes: when it is determined that the version of the Excel file to be imported is the first version, the POI component is used to convert the Excel file to be imported into a corresponding business object; When it is determined that the version of the Excel file to be imported is the second version, the mode based on event analysis is used to convert the Excel file to be imported into the corresponding business object.
  • using the POI component to convert the Excel file to be imported into a corresponding business object includes: using the POI component to convert the Excel file to be imported that has been converted into a stream object into a workbook object; converting the workbook according to a preset mapping relationship The object is converted to the corresponding business object.
  • the event-based analysis mode is used to convert the Excel file to be imported into corresponding business objects, including: using the event-based analysis mode to read each unit in the Excel file to be imported that has been converted into a stream object The content of the cell; encapsulate the content of each cell into the corresponding business object according to the preset mapping relationship.
  • a computer-readable storage medium on which a computer program is stored, and when the computer program is executed by a processor, the following steps are implemented:
  • the method before importing the converted business object, the method further includes: obtaining configuration information of the Excel file to be imported; verifying the converted business object according to the configuration information; when the verification is passed, then The converted business objects are imported.
  • the method further includes: when the verification fails, returning an alarm prompt.
  • identifying the version of the Excel file to be imported includes: reading the Excel file to be imported; converting the Excel file to be imported into a stream object; determining the version of the Excel file to be imported according to the starting byte recorded in the stream object , Where the version of the Excel file to be imported includes the first version or the second version.
  • determining the corresponding processing method according to the version of the Excel file to be imported includes: when it is determined that the version of the Excel file to be imported is the first version, the POI component is used to convert the Excel file to be imported into a corresponding business object; When it is determined that the version of the Excel file to be imported is the second version, the mode based on event analysis is used to convert the Excel file to be imported into the corresponding business object.
  • using the POI component to convert the Excel file to be imported into a corresponding business object includes: using the POI component to convert the Excel file to be imported that has been converted into a stream object into a workbook object; converting the workbook according to a preset mapping relationship The object is converted to the corresponding business object.
  • the event-based analysis mode is used to convert the Excel file to be imported into corresponding business objects, including: using the event-based analysis mode to read each unit in the Excel file to be imported that has been converted into a stream object The content of the cell; encapsulate the content of each cell into the corresponding business object according to the preset mapping relationship.
  • Non-volatile memory may include read-only memory (ROM), programmable ROM (PROM), electrically programmable ROM (EPROM), electrically erasable programmable ROM (EEPROM), or flash memory.
  • Volatile memory can include random access memory (RAM) or external cache memory.
  • RAM is available in many forms, such as static RAM (SRAM), dynamic RAM (DRAM), synchronous DRAM (SDRAM), double data rate SDRAM (DDRSDRAM), enhanced SDRAM (ESDRAM), synchronous chain (Synchlink) DRAM (SLDRAM), memory bus (Rambus) direct RAM (RDRAM), direct memory bus dynamic RAM (DRDRAM), and memory bus dynamic RAM (RDRAM), etc.
  • SRAM static RAM
  • DRAM dynamic RAM
  • SDRAM synchronous DRAM
  • DDRSDRAM double data rate SDRAM
  • ESDRAM enhanced SDRAM
  • SLDRAM synchronous chain (Synchlink) DRAM
  • SLDRAM synchronous chain (Synchlink) DRAM
  • Rambus direct RAM
  • DRAM direct memory bus dynamic RAM
  • RDRAM memory bus dynamic RAM

Landscapes

  • Engineering & Computer Science (AREA)
  • Databases & Information Systems (AREA)
  • Theoretical Computer Science (AREA)
  • Data Mining & Analysis (AREA)
  • Physics & Mathematics (AREA)
  • General Engineering & Computer Science (AREA)
  • General Physics & Mathematics (AREA)
  • Information Retrieval, Db Structures And Fs Structures Therefor (AREA)

Abstract

本申请涉及一种Excel数据的导入方法、装置、计算机设备和存储介质，其中方法包括：识别待导入Excel文件的版本；根据待导入Excel文件的版本确定对应的处理方式；根据确定的处理方式将待导入Excel文件转换为对应的业务对象；将转换后的业务对象导入。本申请实施例通过识别待导入Excel文件的版本，根据待导入Excel文件的版本确定对应的处理方式，从而根据确定的处理方式将待导入Excel文件转换为对应的业务对象，以将转换后的业务对象导入，从而实现了在对线下数据向线上转移时，将线下Excel文件自动导入线上系统，提高了数据导入效率，且避免了人工录入数据时产生的错误，提高了数据导入的准确性。

Description

Excel数据的导入方法、装置、计算机设备和存储介质 技术领域
本申请涉及计算机技术领域，特别是涉及一种Excel数据的导入方法、装置、计算机设备和存储介质。
背景技术
随着互联网技术的发展，各类管理系统的应用也越来越广泛。每个企业在应用管理系统时，都面临将线下数据向线上管理系统转移的问题。目前线下数据一般通过Excel记录，但由于Excel文件不能直接被其他管理系统直接操作，因此无法将Excel文件中的数据直接导入到管理系统。
目前一般通过人工手动录入的方式将线下数据向线上转移，但是由于人工手动录入效率较低，从而严重影响了管理系统的正常使用。
发明内容
基于此，有必要针对上述线下数据向线上转移时人工录入效率低的问题，提供一种能够自动将线下数据导入线上的Excel数据的导入方法、装置、计算机设备和存储介质。
为了实现上述目的，一方面，本申请实施例提供了一种Excel数据的导入方法，所述方法包括：
识别待导入Excel文件的版本；
根据待导入Excel文件的版本确定对应的处理方式；
根据确定的处理方式将待导入Excel文件转换为对应的业务对象；
将转换后的业务对象导入。
在其中一个实施例中，将转换后的业务对象导入之前，所述方法还包括：获取待导入Excel文件的配置信息；根据配置信息对转换后的业务对象进行校验；当校验通过，则将转换后的业务对象导入。
在其中一个实施例中，还包括：当校验不通过，则返回报警提示。
在其中一个实施例中，识别待导入Excel文件的版本，包括：读取待导入Excel文件；将待导入Excel文件转换为流对象；根据流对象中记录的起始字节确定待导入Excel文件的版本，其中，待导入Excel文件的版本包括第一版本或第二版本。
在其中一个实施例中，根据待导入Excel文件的版本确定对应的处理方式，包括：当确定待导入Excel文件的版本为第一版本，则采用POI组件将待导入Excel文件转换为对应的业务对象；当确定待导入Excel文件的版本为第二版本，则采用基于事件解析的模式将待导入Excel文件转换为对应的业务对象。
在其中一个实施例中，采用POI组件将待导入Excel文件转换为对应的业务对象，包括：采用POI组件将已转换为流对象的待导入Excel文件转换为workbook对象；根据预设的映射关系将workbook对象转换为对应的业务对象。
在其中一个实施例中，采用基于事件解析的模式将所述待导入Excel文件转换为对应的业务对象，包括：采用基于事件解析的模式读取已转换为流对象的待导入Excel文件中每个单元格的内容；根据预设的映射关系将每个单元格的内容封装为对应的业务对象。
另一方面，本申请实施例还提供了一种Excel数据的导入装置，包括：
识别模块，用于识别待导入Excel文件的版本；
处理方式确定模块，用于根据待导入Excel文件的版本确定对应的处理方式；
转换模块，用于根据确定的处理方式将待导入Excel文件转换为对应的业务对象；
导入模块，用于将转换后的业务对象导入。
又一方面，本申请实施例还提供了一种计算机设备，包括存储器和处理器，所述存储器存储有计算机程序，所述处理器执行所述计算机程序时实现如上所述方法的步骤。
再一方面，本申请实施例还提供了一种计算机可读存储介质，其上存储有计算机程序，所述计算机程序被处理器执行时实现如上所述方法的步骤。
上述Excel数据的导入方法、装置、计算机设备和存储介质，通过识别待导入Excel文件的版本，根据待导入Excel文件的版本确定对应的处理方式，从而根据确定的处理方式将待导入Excel文件转换为对应的业务对象，以将转换后的业务对象导入，从而实现了在对线下数据向线上转移时，将线下Excel文件自动导入线上系统，提高了数据导入效率，且避免了人工录入数据时产生的错误，提高了数据导入的准确性。
附图说明
图1为一个实施例中Excel数据的导入方法的流程示意图；
图2为一个实施例中识别待导入Excel文件的版本步骤的流程示意图；
图3为一个实施例中根据待导入Excel文件的版本对其进行处理的步骤的流程示意图；
图4为一个实施例中业务对象的示例图；
图5为一个实施例中待导入Excel文件的示例图；
图6为一个实施例中业务对象的映射示例图；
图7为另一个实施例中根据待导入Excel文件的版本对其进行处理的步骤的流程示意图；
图8为另一个实施例中Excel数据的导入方法的流程示意图；
图9为一个实施例中Excel数据的导入装置的结构框图；
图10为一个实施例中计算机设备的内部结构图。
具体实施方式
为了使本申请的目的、技术方案及优点更加清楚明白，以下结合附图及实施例，对本申请进行进一步详细说明。应当理解，此处描述的具体实施例仅仅用以解释本申请，并不用于限定本申请。
本申请实施例提供了一种Excel数据的导入方法，如图1所示，该方法可以包括以下步骤：
步骤102，识别待导入Excel文件的版本。
需要说明的是，由于Excel文件目前存在两种版本，且两种版本分别对应的文件格式是不同的。例如，在Office2007之前(不包括Office2007)，Excel文件是以二进制格式存储数据，其文件拓展名通常为“xls”。而从Office2007开始(包括Office2007)，Excel文件是以文本格式存储数据，其文件拓展名通常为“xlsx”。而对于不同格式的Excel文件，在对其进行处理时需要采用不同的方法，因此，在本实施例中，当要导入Excel文件时，首先需要对待导入Excel文件的版本进行识别，从而确定待导入Excel文件具体的版本类型。
步骤104，根据待导入Excel文件的版本确定对应的处理方式。
由于不同格式的Excel文件，在对其进行处理时需要采用不同的方法，因此，可以根据Excel文件版本的不同，预先设置对应的处理方式，当通过上述步骤识别出待导入Excel文件的版本后，即可根据待导入Excel文件的版本确定对应的处理方式。
步骤106，根据确定的处理方式将待导入Excel文件转换为对应的业务对象。
如背景技术所述，由于Excel文件不能被其他管理系统直接操作，因此，在确定待导入Excel文件的版本以及对应的处理方式后，则可以根据对应的处理方式对待导入Excel文件进行处理，以将待导入Excel文件转换为系统可以直接操作的对应的业务对象。其中，业务对象是与待导入Excel文件具有一定映射关系、且具有特定格式及内容的表单，系统可以直接对该表单进行操作。
步骤108，将转换后的业务对象导入。
在完成上述处理后，即可将转换后的业务对象导入需要的系统，从而实现Excel数据的自动导入。
上述Excel数据的导入方法，通过识别待导入Excel文件的版本，根据待导入Excel文件的版本确定对应的处理方式，从而根据确定的处理方式将待导入Excel文件转换为对应的业务对象，以将转换后的业务对象导入，从而实现了在对线下数据向线上转移时，将线下Excel文件自动导入线上系统，提高了数据导入效率，且避免了人工录入数据时产生的错误，提高了数据导入的准确性。
在一个实施例中，如图2所示，识别待导入Excel文件的版本，具体可以包括如下步骤：
步骤202，读取待导入Excel文件。
步骤204，将待导入Excel文件转换为流对象。
步骤206，根据流对象中记录的起始字节确定待导入Excel文件的版本。
具体的，由于文件在计算机中都是以字节的形式进行存储的，而本实施例中对Excel数据的导入也是通过计算机来完成的。因此，计算机读取待导入Excel文件时，将待导入Excel文件转换为流对象，其中，流对象可以是java对象。又由于Excel文件存储在计算机中时，其起始的几个字节的内容(即魔数)是固定的，通常通过起始几个字节的内容即可确定文件类型，因此，计算机根据流对象中记录的起始字节并对其进行解析，即可确定待导入Excel文件的版本。
其中，待导入Excel文件的版本包括第一版本或第二版本。在本实施例中，第一版本具体可以是Office2007之前(不包括Office2007)的版本，可以简称为低版本，第二版本具体可以是从Office2007开始(包括Office2007)的版本，可以简称为高版本。具体的，计算机通过流对象中记录的起始字节而确定对应的Excel文件类型是属于“xls”还是“xlsx”，从而根据文件类型与版本的对应的关系确定待导入Excel文件的版本。本实施例通过自动识别待导入Excel文件的版本，从而极大的提高了自动导入Excel文件的兼容性，不管待导入Excel文件是何种版本均可实现自动导入，而无需开发人员处理Excel导入细节，极大的提高了用户体验度，且实现了较高的自动化程度。
以下通过具体实施例进一步说明对于待导入Excel文件的不同版本及其对应的处理方式的不同，具体的，在一个实施例中，以待导入Excel文件的版本为第一版本为例进行说明，如图3所示，可以包括如下步骤：
步骤302，当确定待导入Excel文件的版本为第一版本时，采用POI组件将已转换为流 对象的待导入Excel文件转换为workbook对象。
其中，POI组件是指提供给Java程序对Microsoft Office格式档案读和写的功能的API(Application Programming Interface，应用程序编程接口)。workbook则是工作簿的高级表现形式，是sheet的上级对象，举例来说，一个excel文件即可以认为是一个工作簿，一个工作簿中又可以包含有多个工作表(即sheet)。
具体的，当通过上述步骤确定待导入Excel文件的版本为第一版本(即低版本)时，由于低版本的Excel文件是以二进制形式进行存储，因此，可以通过POI组件读取已转换为流对象的待导入Excel文件，将其转换为可通过软件(如Java程序)对其进行操作的workbook对象。
步骤304，根据预设的映射关系将workbook对象转换为对应的业务对象。
在本实施例中，根据用户对业务对象的需求以及前期对待导入Excel文件的预分析，可以预先建立待导入Excel文件与业务对象之间的映射关系。具体的，可以预先定义待导入Excel文件中对应sheet的每行或每列与业务对象中记录的属性值之间的映射关系。举例来说，假设业务对象为销售单，其中记录的属性值包括如图4所示的内容，而待导入Excel文件如图5所示，因此，可以预先建立待导入Excel文件中第一列记录的“序号”与业务对象中“订单编号”的映射关系，待导入Excel文件中第二列记录的“客户名称”与业务对象中“购货单位”的映射关系，待导入Excel文件中第三列记录的“产品名称”与业务对象中“购货名称”的映射关系……，待导入Excel文件中最后一列记录的“总价”与业务对象中“销售金额”的映射关系。从而根据建立的映射关系将待导入Excel文件中具体的数据(如客户名称为A的销售单)写入业务对象中，如图6所示。以便在完成对业务对象的导入后，可以在系统中实现直接对业务对象的操作，如按某一筛选条件进行汇总、查询、分析、导出或打印等，从而极大的方便了用户的操作。
在一个实施例中，以待导入Excel文件的版本为第二版本为例进行说明，如图7所示，可以包括如下步骤：
步骤702，当确定待导入Excel文件的版本为第二版本时，采用基于事件解析的模式读取已转换为流对象的待导入Excel文件中每个单元格的内容。
步骤704，根据预设的映射关系将每个单元格的内容封装为对应的业务对象。
具体的，当通过上述步骤确定待导入Excel文件的版本为第二版本(即高版本)时，由于高版本的Excel文件是以文本形式进行存储，若此时采用POI组件进行转换，则会占用计算机的大量内存，甚至引起计算机瘫痪的风险。因此，在本实施例中，对于高版本的Excel 文件则通过基于事件解析的模式读取已转换为流对象的待导入Excel文件，即逐个读取待导入Excel文件中每个单元格的内容，进而根据预设的映射关系将每个单元格的内容封装为对应的业务对象。由于本实施例中基于事件解析的模式是对Excel文件中每个单元格的内容进行逐个读取与封装，不同于POI组件读取整个文件的形式，因此，其处理过程占用内存较少，处理效率较高。由于本实施例中具体映射关系的建立与上述实施例中相类似，从而此处不再展开赘述。
在一个实施例中，不管是上述何种处理方式，均能实现对待导入Excel文件中记录的多种数据类型进行处理，如文本数据、数字数据、日期数据、公式数据或图片数据等，并支持多个工作表的导入。因此，本实施例的方法适用范围较广，能够满足客户的基本需求，且智能化程度较高。
在一个实施例中，如图8所示，将转换后的业务对象导入之前，该方法还可以包括如下步骤：
步骤802，获取待导入Excel文件的配置信息。
步骤804，根据配置信息对转换后的业务对象进行校验，若检验通过，则执行步骤806，否则执行步骤808。
步骤806，将转换后的业务对象导入。
步骤808，返回报警提示。
其中，待导入Excel文件的配置信息具体可以是在建立待导入Excel文件与业务对象之间的映射关系时设置的配置信息，如对映射后的业务对象中的属性值的具体要求，例如，对映射后的数据格式的规定、数据范围的规定等。举例来说，以图4、图5为例进行说明，假设待导入Excel文件中记录的“单价”，其具体展现格式为“货币”，如图5中客户名称为B的单据中记录的某一产品的具体单价为“￥123.00”，若在建立映射关系时规定了其映射到业务对象中应采用“中文大写金额”的方式，则其映射后对应的“货品单价”的表现形式应为“壹佰贰拾叁圆”。
因此，在经过上述转换后，即将待导入Excel文件转换为对应的业务对象后，还可以根据预先设置的配置信息对转换后的业务对象进行检验，只有当转换后的业务对象符合配置信息中的相关要求时，才将转换后的业务对象导入。否则不进行导入操作，并返回报警提示。其中，报警提示中可以展现具体的提示信息，如提示具体是业务对象中哪个属性值不符合要求，从而使得相关操作人员能够及时发现问题，对其进行修复，进而确保导入的业务对象中数据的准确性。
需要说明的是，本实施例提供的上述方法可以应用于各种需要对Excel文件进行导入或解析的场景，可以将其封装为对应的软件接口，使用时根据具体需求修改映射关系以及配置信息后即可直接调用该接口，从而提高了开发效率，降低了开发成本。
应该理解的是，虽然图1-8的流程图中的各个步骤按照箭头的指示依次显示，但是这些步骤并不是必然按照箭头指示的顺序依次执行。除非本文中有明确的说明，这些步骤的执行并没有严格的顺序限制，这些步骤可以以其它的顺序执行。而且，图1-8中的至少一部分步骤可以包括多个子步骤或者多个阶段，这些子步骤或者阶段并不必然是在同一时刻执行完成，而是可以在不同的时刻执行，这些子步骤或者阶段的执行顺序也不必然是依次进行，而是可以与其它步骤或者其它步骤的子步骤或者阶段的至少一部分轮流或者交替地执行。
在一个实施例中，如图9所示，提供了一种Excel数据的导入装置，包括：识别模块901、处理方式确定模块902、转换模块903和导入模块904，其中：
识别模块901，用于识别待导入Excel文件的版本；
处理方式确定模块902，用于根据待导入Excel文件的版本确定对应的处理方式；
转换模块903，用于根据确定的处理方式将待导入Excel文件转换为对应的业务对象；
导入模块904，用于将转换后的业务对象导入。
在一个实施例中，还包括校验模块：用于获取待导入Excel文件的配置信息；根据配置信息对转换后的业务对象进行校验；当校验通过，则将转换后的业务对象导入。
在一个实施例中，校验模块还用于：当校验不通过，则返回报警提示。
在一个实施例中，识别待导入Excel文件的版本，包括：读取待导入Excel文件；将待导入Excel文件转换为流对象；根据流对象中记录的起始字节确定待导入Excel文件的版本，其中，待导入Excel文件的版本包括第一版本或第二版本。
在一个实施例中，根据待导入Excel文件的版本确定对应的处理方式，包括：当确定待导入Excel文件的版本为第一版本，则采用POI组件将待导入Excel文件转换为对应的业务对象；当确定待导入Excel文件的版本为第二版本，则采用基于事件解析的模式将待导入Excel文件转换为对应的业务对象。
在一个实施例中，采用POI组件将待导入Excel文件转换为对应的业务对象，包括：采用POI组件将已转换为流对象的待导入Excel文件转换为workbook对象；根据预设的映射关系将workbook对象转换为对应的业务对象。
在一个实施例中，采用基于事件解析的模式将所述待导入Excel文件转换为对应的业务对象，包括：采用基于事件解析的模式读取已转换为流对象的待导入Excel文件中每个单元 格的内容；根据预设的映射关系将每个单元格的内容封装为对应的业务对象。
关于Excel数据的导入装置的具体限定可以参见上文中对于Excel数据的导入方法的限定，在此不再赘述。上述Excel数据的导入装置中的各个模块可全部或部分通过软件、硬件及其组合来实现。上述各模块可以硬件形式内嵌于或独立于计算机设备中的处理器中，也可以以软件形式存储于计算机设备中的存储器中，以便于处理器调用执行以上各个模块对应的操作。
在一个实施例中，提供了一种计算机设备，该计算机设备可以是终端，其内部结构图可以如图10所示。该计算机设备包括通过系统总线连接的处理器、存储器、网络接口、显示屏和输入装置。其中，该计算机设备的处理器用于提供计算和控制能力。该计算机设备的存储器包括非易失性存储介质、内存储器。该非易失性存储介质存储有操作系统和计算机程序。该内存储器为非易失性存储介质中的操作系统和计算机程序的运行提供环境。该计算机设备的网络接口用于与外部的终端通过网络连接通信。该计算机程序被处理器执行时以实现一种Excel数据的导入方法。该计算机设备的显示屏可以是液晶显示屏或者电子墨水显示屏，该计算机设备的输入装置可以是显示屏上覆盖的触摸层，也可以是计算机设备外壳上设置的按键、轨迹球或触控板，还可以是外接的键盘、触控板或鼠标等。
本领域技术人员可以理解，图10中示出的结构，仅仅是与本申请方案相关的部分结构的框图，并不构成对本申请方案所应用于其上的计算机设备的限定，具体的计算机设备可以包括比图中所示更多或更少的部件，或者组合某些部件，或者具有不同的部件布置。
在一个实施例中，提供了一种计算机设备，包括存储器和处理器，存储器中存储有计算机程序，该处理器执行计算机程序时实现以下步骤：
识别待导入Excel文件的版本；
根据待导入Excel文件的版本确定对应的处理方式；
根据确定的处理方式将待导入Excel文件转换为对应的业务对象；
将转换后的业务对象导入。
在一个实施例中，将转换后的业务对象导入之前，所述方法还包括：获取待导入Excel文件的配置信息；根据配置信息对转换后的业务对象进行校验；当校验通过，则将转换后的业务对象导入。
在一个实施例中，还包括：当校验不通过，则返回报警提示。
在一个实施例中，识别待导入Excel文件的版本，包括：读取待导入Excel文件；将待导入Excel文件转换为流对象；根据流对象中记录的起始字节确定待导入Excel文件的版本， 其中，待导入Excel文件的版本包括第一版本或第二版本。
在一个实施例中，根据待导入Excel文件的版本确定对应的处理方式，包括：当确定待导入Excel文件的版本为第一版本，则采用POI组件将待导入Excel文件转换为对应的业务对象；当确定待导入Excel文件的版本为第二版本，则采用基于事件解析的模式将待导入Excel文件转换为对应的业务对象。
在一个实施例中，采用POI组件将待导入Excel文件转换为对应的业务对象，包括：采用POI组件将已转换为流对象的待导入Excel文件转换为workbook对象；根据预设的映射关系将workbook对象转换为对应的业务对象。
在一个实施例中，采用基于事件解析的模式将所述待导入Excel文件转换为对应的业务对象，包括：采用基于事件解析的模式读取已转换为流对象的待导入Excel文件中每个单元格的内容；根据预设的映射关系将每个单元格的内容封装为对应的业务对象。
在一个实施例中，提供了一种计算机可读存储介质，其上存储有计算机程序，计算机程序被处理器执行时实现以下步骤：
识别待导入Excel文件的版本；
根据待导入Excel文件的版本确定对应的处理方式；
根据确定的处理方式将待导入Excel文件转换为对应的业务对象；
将转换后的业务对象导入。
在一个实施例中，将转换后的业务对象导入之前，所述方法还包括：获取待导入Excel文件的配置信息；根据配置信息对转换后的业务对象进行校验；当校验通过，则将转换后的业务对象导入。
在一个实施例中，还包括：当校验不通过，则返回报警提示。
在一个实施例中，识别待导入Excel文件的版本，包括：读取待导入Excel文件；将待导入Excel文件转换为流对象；根据流对象中记录的起始字节确定待导入Excel文件的版本，其中，待导入Excel文件的版本包括第一版本或第二版本。
在一个实施例中，根据待导入Excel文件的版本确定对应的处理方式，包括：当确定待导入Excel文件的版本为第一版本，则采用POI组件将待导入Excel文件转换为对应的业务对象；当确定待导入Excel文件的版本为第二版本，则采用基于事件解析的模式将待导入Excel文件转换为对应的业务对象。
在一个实施例中，采用POI组件将待导入Excel文件转换为对应的业务对象，包括：采用POI组件将已转换为流对象的待导入Excel文件转换为workbook对象；根据预设的映射关 系将workbook对象转换为对应的业务对象。
在一个实施例中，采用基于事件解析的模式将所述待导入Excel文件转换为对应的业务对象，包括：采用基于事件解析的模式读取已转换为流对象的待导入Excel文件中每个单元格的内容；根据预设的映射关系将每个单元格的内容封装为对应的业务对象。
本领域普通技术人员可以理解实现上述实施例方法中的全部或部分流程，是可以通过计算机程序来指令相关的硬件来完成，所述的计算机程序可存储于一非易失性计算机可读取存储介质中，该计算机程序在执行时，可包括如上述各方法的实施例的流程。其中，本申请所提供的各实施例中所使用的对存储器、存储、数据库或其它介质的任何引用，均可包括非易失性和/或易失性存储器。非易失性存储器可包括只读存储器(ROM)、可编程ROM(PROM)、电可编程ROM(EPROM)、电可擦除可编程ROM(EEPROM)或闪存。易失性存储器可包括随机存取存储器(RAM)或者外部高速缓冲存储器。作为说明而非局限，RAM以多种形式可得，诸如静态RAM(SRAM)、动态RAM(DRAM)、同步DRAM(SDRAM)、双数据率SDRAM(DDRSDRAM)、增强型SDRAM(ESDRAM)、同步链路(Synchlink)DRAM(SLDRAM)、存储器总线(Rambus)直接RAM(RDRAM)、直接存储器总线动态RAM(DRDRAM)、以及存储器总线动态RAM(RDRAM)等。
以上实施例的各技术特征可以进行任意的组合，为使描述简洁，未对上述实施例中的各个技术特征所有可能的组合都进行描述，然而，只要这些技术特征的组合不存在矛盾，都应当认为是本说明书记载的范围。
以上所述实施例仅表达了本申请的几种实施方式，其描述较为具体和详细，但并不能因此而理解为对发明专利范围的限制。应当指出的是，对于本领域的普通技术人员来说，在不脱离本申请构思的前提下，还可以做出若干变形和改进，这些都属于本申请的保护范围。因此，本申请专利的保护范围应以所附权利要求为准。

Claims (10)

  1. 一种Excel数据的导入方法，其特征在于，所述方法包括：
    识别待导入Excel文件的版本；
    根据所述待导入Excel文件的版本确定对应的处理方式；
    根据确定的处理方式将所述待导入Excel文件转换为对应的业务对象；
    将转换后的业务对象导入。
  2. 根据权利要求1所述的Excel数据的导入方法，其特征在于，所述将转换后的业务对象导入之前，所述方法还包括：
    获取所述待导入Excel文件的配置信息；
    根据所述配置信息对转换后的业务对象进行校验；
    当校验通过，则将转换后的业务对象导入。
  3. 根据权利要求2所述的Excel数据的导入方法，其特征在于，所述方法还包括：
    当校验不通过，则返回报警提示。
  4. 根据权利要求1至3任一项所述的Excel数据的导入方法，其特征在于，所述识别待导入Excel文件的版本，包括：
    读取所述待导入Excel文件；
    将所述待导入Excel文件转换为流对象；
    根据所述流对象中记录的起始字节确定所述待导入Excel文件的版本，所述待导入Excel文件的版本包括第一版本或第二版本。
  5. 根据权利要求4所述的Excel数据的导入方法，其特征在于，所述根据所述待导入Excel文件的版本确定对应的处理方式，包括：
    当确定所述待导入Excel文件的版本为第一版本，则采用POI组件将所述待导入Excel文件转换为对应的业务对象；
    当确定所述待导入Excel文件的版本为第二版本，则采用基于事件解析的模式将所述待导入Excel文件转换为对应的业务对象。
  6. 根据权利要求5所述的Excel数据的导入方法，其特征在于，所述采用POI组件将所述待导入Excel文件转换为对应的业务对象，包括：
    采用POI组件将已转换为流对象的待导入Excel文件转换为workbook对象；
    根据预设的映射关系将所述workbook对象转换为对应的业务对象。
  7. 根据权利要求5所述的Excel数据的导入方法，其特征在于，所述采用基于事件解析的模式将所述待导入Excel文件转换为对应的业务对象，包括：
    采用基于事件解析的模式读取已转换为流对象的待导入Excel文件中每个单元格的内容；
    根据预设的映射关系将每个单元格的内容封装为对应的业务对象。
  8. 一种Excel数据的导入装置，其特征在于，所述装置包括：
    识别模块，用于识别待导入Excel文件的版本；
    处理方式确定模块，用于根据所述待导入Excel文件的版本确定对应的处理方式；
    转换模块，用于根据确定的处理方式将所述待导入Excel文件转换为对应的业务对象；
    导入模块，用于将转换后的业务对象导入。
  9. 一种计算机设备，包括存储器和处理器，所述存储器存储有计算机程序，其特征在于，所述处理器执行所述计算机程序时实现权利要求1至7中任一项所述方法的步骤。
  10. 一种计算机可读存储介质，其上存储有计算机程序，其特征在于，所述计算机程序被处理器执行时实现权利要求1至7中任一项所述方法的步骤。
PCT/CN2019/123875 2018-12-28 2019-12-09 Excel数据的导入方法、装置、计算机设备和存储介质 WO2020134989A1 (zh)

Applications Claiming Priority (2)

Application Number Priority Date Filing Date Title
CN201811621421.0 2018-12-28
CN201811621421.0A CN109783558A (zh) 2018-12-28 2018-12-28 Excel数据的导入方法、装置、计算机设备和存储介质

Publications (1)

Publication Number Publication Date
WO2020134989A1 true WO2020134989A1 (zh) 2020-07-02

Family

ID=66498698

Family Applications (1)

Application Number Title Priority Date Filing Date
PCT/CN2019/123875 WO2020134989A1 (zh) 2018-12-28 2019-12-09 Excel数据的导入方法、装置、计算机设备和存储介质

Country Status (2)

Country Link
CN (1) CN109783558A (zh)
WO (1) WO2020134989A1 (zh)

Families Citing this family (8)

* Cited by examiner, † Cited by third party
Publication number Priority date Publication date Assignee Title
CN109783558A (zh) * 2018-12-28 2019-05-21 益萃网络科技（中国）有限公司 Excel数据的导入方法、装置、计算机设备和存储介质
CN111240688B (zh) * 2020-01-10 2023-08-18 深圳前海环融联易信息科技服务有限公司 excel文件的解析方法、装置、计算机设备及存储介质
CN111460017A (zh) * 2020-03-20 2020-07-28 平安国际智慧城市科技股份有限公司 文档数据导入方法、文档数据导出方法、装置和存储介质
CN113448960A (zh) * 2020-03-27 2021-09-28 北京沃东天骏信息技术有限公司 一种导入表格文件的方法和装置
CN111898351B (zh) * 2020-08-03 2021-06-22 汇链通供应链科技(上海)有限公司 基于Aviator的Excel数据自动导入方法、装置、终端设备及存储介质
CN112256778A (zh) * 2020-10-20 2021-01-22 大唐融合通信股份有限公司 一种数据导入方法、装置及设备
CN112801319A (zh) * 2021-02-01 2021-05-14 神州数码融信云技术服务有限公司 一种运维工作流程推进方法
CN116757170B (zh) * 2023-08-21 2023-10-20 成都数联云算科技有限公司 一种基于JAVA语言的Excel表格导入方法和系统

Citations (4)

* Cited by examiner, † Cited by third party
Publication number Priority date Publication date Assignee Title
US20050251812A1 (en) * 2004-04-27 2005-11-10 Convertabase, Inc. Data conversion system, method, and apparatus
CN106933835A (zh) * 2015-12-29 2017-07-07 航天信息软件技术有限公司 一种兼容性解析Excel文件的数据导入方法及系统
CN108763185A (zh) * 2018-05-31 2018-11-06 苏州市计量测试院 Excel文件的校验方法及系统
CN109783558A (zh) * 2018-12-28 2019-05-21 益萃网络科技（中国）有限公司 Excel数据的导入方法、装置、计算机设备和存储介质

Family Cites Families (3)

* Cited by examiner, † Cited by third party
Publication number Priority date Publication date Assignee Title
US20120303642A1 (en) * 2011-05-23 2012-11-29 Gbs Corp. Automated file-conversion system and process for a media-generation system
CN107368593B (zh) * 2017-07-25 2020-09-01 万帮充电设备有限公司 数据导入方法、装置及服务器
CN108763275B (zh) * 2018-04-09 2025-01-17 中国电力科学研究院有限公司 一种将Excel数据源转存到大数据平台的方法及系统

Patent Citations (4)

* Cited by examiner, † Cited by third party
Publication number Priority date Publication date Assignee Title
US20050251812A1 (en) * 2004-04-27 2005-11-10 Convertabase, Inc. Data conversion system, method, and apparatus
CN106933835A (zh) * 2015-12-29 2017-07-07 航天信息软件技术有限公司 一种兼容性解析Excel文件的数据导入方法及系统
CN108763185A (zh) * 2018-05-31 2018-11-06 苏州市计量测试院 Excel文件的校验方法及系统
CN109783558A (zh) * 2018-12-28 2019-05-21 益萃网络科技（中国）有限公司 Excel数据的导入方法、装置、计算机设备和存储介质

Also Published As

Publication number Publication date
CN109783558A (zh) 2019-05-21

Similar Documents

Publication Publication Date Title
WO2020134989A1 (zh) Excel数据的导入方法、装置、计算机设备和存储介质
CN107704479B (zh) 文件生成方法和装置
CN109254969A (zh) 数据表处理方法、装置、设备及存储介质
CN111027295B (zh) 数据处理方法、装置、计算机设备和存储介质
CN111177113B (zh) 数据迁移方法、装置、计算机设备和存储介质
US11914574B2 (en) Generation of inconsistent testing data
CN110362630B (zh) 数据管理方法、装置、设备与计算机可读存储介质
CN111708971A (zh) 页面配置方法、装置、计算机设备和存储介质
CN111399857A (zh) 一种fru数据烧录方法、系统、设备及计算机存储介质
WO2022068316A1 (zh) 数据对账方法、装置、设备及存储介质
CN116166629A (zh) 一种文件格式转换方法、装置、设备及可读存储介质
CN112559541A (zh) 一种单证的审核方法、装置、设备及存储介质
CN114254022B (zh) 基于rpa及ai的流程任务处理方法、装置、系统及服务器
EP4392890A1 (en) Using a custom printer driver to automatically electronically create, capture and manage all documents utilized in a transaction
CN111125008A (zh) 一种异常inode的动态修复方法、系统及相关组件
CN114691602A (zh) 数据导入方法、装置、计算机设备和存储介质
CN117874002A (zh) 一种用于异构数据迁移的方法及系统
KR20240117827A (ko) 문서 자동화 처리 방법 및 이를 구현하는 장치
CN115409014A (zh) 单据模板生成方法、装置、计算机设备和存储介质
CN113779947A (zh) 自动生成会计凭证的方法、装置、设备及存储介质
CN113888337A (zh) 基于大数据的资金结算方法、装置、设备及存储介质
CN106528718A (zh) 用于处理来自第三方的数据的方法及装置
CN110599271A (zh) 票据检测方法、装置、计算机设备和存储介质
CN112597058B (zh) 一种基于卷创建的网页测试方法、装置、设备及存储介质
CN104866481A (zh) 产品监督抽样打单软件系统

Legal Events

Date Code Title Description
121 Ep: the epo has been informed by wipo that ep was designated in this application

Ref document number: 19903073

Country of ref document: EP

Kind code of ref document: A1

NENP Non-entry into the national phase

Ref country code: DE

122 Ep: pct application non-entry in european phase

Ref document number: 19903073

Country of ref document: EP

Kind code of ref document: A1

122 Ep: pct application non-entry in european phase

Ref document number: 19903073

Country of ref document: EP

Kind code of ref document: A1

32PN Ep: public notification in the ep bulletin as address of the adressee cannot be established

Free format text: NOTING OF LOSS OF RIGHTS PURSUANT TO RULE 02/02/2022)

122 Ep: pct application non-entry in european phase

Ref document number: 19903073

Country of ref document: EP

Kind code of ref document: A1