Data version comparison method used for Excel documents

An excel and format technology, applied in the field of data version comparison, can solve problems such as inability to solve Excel version comparison, and achieve the effect of improving efficiency and reducing complexity

Active Publication Date: 2018-05-08
BEIJING AEROSPACE MEASUREMENT & CONTROL TECH
View PDF4 Cites 16 Cited by
  • Summary
  • Abstract
  • Description
  • Claims
  • Application Information

AI Technical Summary

Problems solved by technology

[0007] Therefore, in the Excel software, the version comparison of the Excel table format document is performed by using the VBA script method, but the problem of convenient and fast Excel version comparison cannot be solved, and it is not suitable for most non-professional technicians to operate

Method used

the structure of the environmentally friendly knitted fabric provided by the present invention; figure 2 Flow chart of the yarn wrapping machine for environmentally friendly knitted fabrics and storage devices; image 3 Is the parameter map of the yarn covering machine
View more

Image

Smart Image Click on the blue labels to locate them in the text.
Viewing Examples
Smart Image
  • Data version comparison method used for Excel documents
  • Data version comparison method used for Excel documents
  • Data version comparison method used for Excel documents

Examples

Experimental program
Comparison scheme
Effect test

Embodiment Construction

[0030] Such as figure 1 As shown, the present invention provides a method for comparing data versions of Excel format documents, specifically comprising:

[0031] Step 1) select Excel format document, and carry out data structure processing to it, in the process of described data structure processing, by carrying out structure respectively by different form object of workbook, form page, row, column, cell Description, and respectively converted into corresponding structured data;

[0032] Step 2) After obtaining the data structure of step 1), use the predefined XML Schema (Extensible Markup Language Specification) data format to describe the data of the original Excel format document, and convert the structured data of the Excel format document into an XML format document structure The structured data is obtained to obtain the structured data of the first XML format document;

[0033] Step 3) repeat step 1)-step 2), obtain the structured data of the second XML format documen...

the structure of the environmentally friendly knitted fabric provided by the present invention; figure 2 Flow chart of the yarn wrapping machine for environmentally friendly knitted fabrics and storage devices; image 3 Is the parameter map of the yarn covering machine
Login to view more

PUM

No PUM Login to view more

Abstract

The invention relates to a data version comparison method used for Excel documents. The method specifically comprises the steps of 1) selecting the Excel documents, performing data structuring processing on the Excel documents, and converting the Excel documents into structured data; 2) after the structured data in the step 1) is obtained, performing data description of original Excel documents ina predefined XML Schema data format, and converting the structured data of the Excel documents into structured data of XML documents, thereby obtaining the structured data of the first XML document;3) repeating the steps 1)-2) to obtain the structured data of the second XML document; and 4) comparing the step 2) with the step 3), performing comparison by adopting a bidirectional comparison method through traversing an XML data mode according to different data of an XML document memory to obtain a comparison result of the structured data of the first XML document and a comparison result of the structured data of the second XML document, storing the comparison results, and performing display.

Description

technical field [0001] The invention relates to the technical field of data version comparison of documents, in particular to a method for comparing data versions of documents in Excel format. Background technique [0002] During the progress of an engineering project, a large number of technical documents will be produced in various forms, such as WORD format, Excel format, PPT format, etc., and there may be multiple versions of the same document. [0003] At present, the version management technology is also gradually applied in the document management process, and the version of each stage of the document can be effectively managed through the version management software. For the differences between different versions of documents, in the version management software, the version differences of documents can only be described by means of remarks, etc., and the differences between documents cannot be intuitively understood. [0004] In some cases, the operator needs to com...

Claims

the structure of the environmentally friendly knitted fabric provided by the present invention; figure 2 Flow chart of the yarn wrapping machine for environmentally friendly knitted fabrics and storage devices; image 3 Is the parameter map of the yarn covering machine
Login to view more

Application Information

Patent Timeline
no application Login to view more
Patent Type & Authority Applications(China)
IPC IPC(8): G06F17/30
CPCG06F16/219
Inventor 刘剑高鹏刘媛王丽王刚王永飞王本元杨晓辉李俊杰马英杰
Owner BEIJING AEROSPACE MEASUREMENT & CONTROL TECH
Who we serve
  • R&D Engineer
  • R&D Manager
  • IP Professional
Why Eureka
  • Industry Leading Data Capabilities
  • Powerful AI technology
  • Patent DNA Extraction
Social media
Try Eureka
PatSnap group products

Browse by: Latest US Patents, China's latest patents, Technical Efficacy Thesaurus, Application Domain, Technology Topic.

© 2024 PatSnap. All rights reserved.Legal|Privacy policy|Modern Slavery Act Transparency Statement|Sitemap