File conversion method, device and equipment

Abstract

The invention relates to the technical field of big data processing, and particularly discloses a file conversion method, device and equipment, and the method comprises the steps: obtaining a basic parameter table corresponding to a business data table, wherein the basic parameter table is determined based on position information and labeling information of labeling cells in a sample table corresponding to the business data table, and the annotation information at least comprises node parameters of xml nodes to which data corresponding to the annotation cells need to be filled; reading node parameters in the basic data table, and extracting data values corresponding to the read node parameters from a service data table based on the position information of the marked cells corresponding to the read node parameters; and filling the extracted data value into an xml node corresponding to the read node parameter in an xml tree structure to obtain a submitted xml file corresponding to the service data table. By utilizing each embodiment of the specification, the file conversion efficiency and accuracy can be greatly improved.

Description

technical field [0001] This specification relates to the technical field of big data processing, and in particular, relates to a file conversion method, device and equipment. Background technique [0002] Overseas branches of financial institutions usually need to regularly report some operational data to local regulatory authorities. The reported data is usually generated by the transaction, and is generated into an excel report through the internal reporting system, and then submitted to the local regulatory authority. At present, when regulatory requirements in some regions require data submission, in addition to submitting normal excel report data, data files in xml (Extensible Markup Language, Extensible Markup Language) format must also be submitted. The types of data involved in financial excel reports are complex and changeable, and the requirements for xml files required by the regulatory requirements of various regions are also quite different. Therefore, it is di...

AI Technical Summary

Problems solved by technology

The types of data involved in financial excel reports are complex and changeable, and the requirements for xml files required by the regulatory requirements of various regions are also quite different, so it is difficult to directly use general conversion tools to convert each excel report into an xml file that meets the requirements of various regions

At present, the data in excel is basically taken out manually by relevant business personnel, and then converted into xml files by using general conversion tools. The conversion work is time-consuming, laborious and error-prone

Images