Method and device of converting XML document into Excel document

Abstract

The invention belongs to document applying field, discloses a method and a device of converting XML document into Excel document; the method comprises the following steps: reading basic element information in XML document; processing composing for the basic element information of read XML document according to composing format of Excel so as to obtain a composing result; generating XML 2003 document according to the composing result; and calling Com interface of Excel tool MS-Excel to convert generated XML2003 document into Excel document. The invention only needs once Com calling in the process of generating one Excel document, thereby furthest preventing low efficiency and instability of Com calling and reducing resource occupying quantity.

Description

technical field [0001] The invention belongs to the field of document application, and in particular relates to a method and a device for converting an XML document into an Excel document. Background technique [0002] With the continuous popularization of computers, paperless office has been more and more applied, and a large number of various documents have also appeared in front of users. [0003] Microsoft Excel is one of the components of Microsoft Office, Microsoft's office software. It is a spreadsheet software written and run by Microsoft for computers with Windows and Apple Macintosh operating systems. [0004] Excel is an important part of Microsoft Office suite software. It can process various data, perform statistical analysis and assist decision-making operations, and is widely used in many fields such as management, statistics, finance, and finance. [0005] Now the industry's more popular several schemes for converting XML format files to Excel format files i...

AI Technical Summary

Problems solved by technology

[0009] Disadvantages of Solution 1: Since most database software only provide some functions of converting known data into basic tables, they will be powerless when encountering cell merging, table header setting and data type setting

This kind of form does not support formula calculations, does not meet the needs of users to directly edit calculations, and the user experience is relatively poor

[0010] Disadvantages of Solution 2: The Com interface of MS-Excel has high requirements on the configuration environment and the format of the input data. In the case of frequent and multiple calls, the program often hangs.

And each input of a unit (Cell) data will involve a Com call, so the efficiency of this scheme is low

And it takes up a lot of system resources, resulting in a heavy load on the machine

[0011] Disadvantages of Solution 3: Since the internal format of the xls file is not disclosed, some mainstream open source software does not support it perfectly, which often results in element loss and typesetting confusion

Images