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

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, ...

Images