Excel document data analysis method and device

Abstract

The invention relates to an Excel document data analysis method. The method comprises steps as follows: step 10, acquiring a document flow of an Excel document requiring analysis; step 20, analyzing the document flow, and acquiring information about workbooks and worksheets in the document flow; step 30, reading xml (extensive markup language) documents corresponding to the worksheets respectively through multiple threads; step 40, analyzing xml documents of shared data in the document flow, and finding storage locations of the shared data corresponding to the worksheets and reading the storage locations through the multiple threads; step 50, performing analysis in combination of the xml documents corresponding to the worksheets and the shared data corresponding to the worksheets through the multiple threads so as to acquire data of the Excel document. The invention further relates to an Excel document data analysis device. The Excel document data analysis method and device are generally applicable to the all kinds of formats of Excel documents and can be applied to larger Excel documents, and the data analysis efficiency is improved.

Description

technical field [0001] The present application relates to the technical field of data processing, in particular to a data analysis method and device for an Excel document. Background technique [0002] Microsoft Excel is one of the components of Microsoft Office, the office software of Microsoft Corporation, and since version 2007, Microsoft Office has used the Office Open XML file format which is different from the previous version (using the binary file format). The container for the new file format is a compressed ZIP file format based on simple components that include XML files that describe application data, metadata, and custom data, as well as relationships between components, images embedded in documents, or Non-XML files such as OLE object binaries use some XML reference schemas and a ZIP container at the core of the new Office Open XML Formats. Take the newly created blank Excel document with the suffix xlsx as an example. After decompressing it, the folders _rels...

AI Technical Summary

Problems solved by technology

These two methods have inevitable defects: the first parsing method can only parse Excel documents in a specific format, so it cannot be generally applied; the second parsing method cannot deal with larger Excel documents because the second method Loading the entire document into memory during parsing may cause memory overflow and make it impossible to continue parsing Excel document data

Images