Method and device for automatically generating spreadsheet, equipment and storage medium

An electronic form, automatic generation technology, applied in the direction of electrical digital data processing, natural language data processing, special data processing applications, etc., can solve problems such as difficult to understand and debug, error-prone, and poor flexibility

Active Publication Date: 2020-01-31
SHENZHEN LUOJIHUI TECH CO LTD
View PDF24 Cites 7 Cited by
  • Summary
  • Abstract
  • Description
  • Claims
  • Application Information

AI Technical Summary

Problems solved by technology

Existing methods for generating spreadsheets are either erro

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
  • Method and device for automatically generating spreadsheet, equipment and storage medium
  • Method and device for automatically generating spreadsheet, equipment and storage medium
  • Method and device for automatically generating spreadsheet, equipment and storage medium

Examples

Experimental program
Comparison scheme
Effect test

Embodiment 1

[0170] Embodiment 1. A computer-implemented method for automatically generating an electronic form, the method comprising:

[0171] obtaining a hierarchical structure for the spreadsheet, wherein the hierarchical structure includes one or more levels having a plurality of nodes, wherein each level has at least one node and has a corresponding level type, Each node corresponds to one or more cells in the spreadsheet, wherein the hierarchical structure further includes affiliation among the plurality of nodes;

[0172] obtaining metadata for each node in the plurality of nodes;

[0173] obtain raw data for said spreadsheet; and

[0174] The electronic form is generated based on at least a hierarchical structure for the electronic form, the metadata, and the raw data.

Embodiment 2

[0175] Embodiment 2, the method according to embodiment 1, further comprising:

[0176] For each node, the layer type of the layer where the node is located, the child nodes of the node, and the metadata of the node are stored.

Embodiment 3

[0177] Embodiment 3. The method according to embodiment 1, wherein obtaining the hierarchical structure for the electronic form includes:

[0178] providing a graphical user interface editor, wherein the graphical user interface editor includes components for specifying different levels of nodes;

[0179] receiving input for components specifying different levels of nodes; and

[0180] The hierarchical structure is generated based on the input.

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 method and a device for automatically generating a spreadsheet, equipment and a storage medium. One embodiment relates to a computer-implemented method for automatically generating spreadsheets, the method comprises the following steps: obtaining a hierarchical structure for the spreadsheet, wherein the hierarchical structure comprises one or more hierarchies, the one ormore hierarchies have a plurality of nodes, each hierarchy has at least one node and has a corresponding hierarchy type, each node corresponds to one or more cells in the spreadsheet, and the hierarchical structure further comprises a membership relationship among the plurality of nodes; obtaining metadata of each node in the plurality of nodes; acquiring original data for the spreadsheet; and generating a spreadsheet based at least on the hierarchy for the spreadsheet, the metadata, and the raw data.

Description

technical field [0001] The present disclosure relates to a method, device, device and storage medium for automatically generating electronic forms. Background technique [0002] In many industries, complex spreadsheets are frequently edited. For example, in the process of financial analysis, financial analysts usually need to build a spreadsheet model for financial analysis to calculate the intrinsic value of financial assets. Spreadsheet models are spreadsheets that can include values, text, and formulas to calculate the value of a variable or variables. Spreadsheets used for financial analysis usually include dozens of pages, thousands of rows, and tens of thousands of cells, and there are complex inter-calculation relationships among the cells, most of which are calculated based on other cells. Existing methods for generating spreadsheets are either error-prone and difficult to understand and debug, or are inflexible. Therefore, there is a need for an improved method, ...

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
IPC IPC(8): G06F40/186G06F16/22G06F16/25
CPCG06F16/2282G06F16/25
Inventor 丛明舒瞿中明曲嘉宝曾凯
Owner SHENZHEN LUOJIHUI TECH CO LTD
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