Automatic Excel data import method and device based on Aviator, terminal equipment and storage medium

Abstract

The invention relates to the field of data processing, in particular to an automatic Excel data import method and device based on an Aviator, terminal equipment and a storage medium. The method comprises the steps: obtaining and analyzing a typesetting mode of excel data, and determining a matching extraction rule of an Aviator expression; determining an absolute position and a relative position of excel data based on the Aviator expression, and extracting a data object; assembling the data object, and configuring associated information corresponding to the view data and a mapping relationshipwith standard output data; and outputting standard json data. An aviator technology is used; through software reading configuration, irregular, messy and complex excel is automatically converted intostandard excel to be output to an application software system according to aviator expression configuration data matched with any excel template, so that the intellectualization of excel import is realized.

Description

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

AI Technical Summary

Benefits of technology

This technology allows an aircraft's engine control program (ECP) to read its configurations without generating excessive amounts of paper that needs to be manually converted before being used again). By doing this automatic transformation, these patterns are translated onto different formats like XML, JSON, etc., making them easier to process while maintaining their original formality. Additionally, they have various functions such as searching tables, analyzing documents, creating new emails, editing email messages, displaying images, performing calculations, and more. Overall, this technology helps improve flight performance and reduce operational expenses.

Problems solved by technology

This technical problem addressed by this patented describes how developers create executable programs like Microsoft Powerpoint® from Java code without relying heavily upon predefined standards such as Standard Template Language (STL) files. Users often require multiple copies of their own codes due to limitations associated with older versions of those languages. However, existing methods involve manual organization and inputting complicated rules, leading to wasted effort resources during repetitive taskings.

Images