Looking for breakthrough ideas for innovation challenges? Try Patsnap Eureka!

Excel report exporting method and device and storage medium

An excel and report technology, applied in the direction of digital data information retrieval, special data processing applications, instruments, etc., can solve the problem that it is difficult to meet the needs of business analysis and view, row color, chart, row folding, formula calculation can not be well Support, can not realize automatic report format customization and other issues

Pending Publication Date: 2022-03-22
ZHONGAN ONLINE P&C INSURANCE CO LTD
View PDF0 Cites 0 Cited by
  • Summary
  • Abstract
  • Description
  • Claims
  • Application Information

AI Technical Summary

Problems solved by technology

[0003] If it involves external output scenarios, the default Excel template output report can only set simple formats such as the font and header color of the output report, which is basically difficult to meet the business analysis and view needs. For some other Format, such as row color, chart, row folding, formula calculation and other functions are not well supported, and the format customization of automated reports cannot be realized

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
  • Excel report exporting method and device and storage medium
  • Excel report exporting method and device and storage medium
  • Excel report exporting method and device and storage medium

Examples

Experimental program
Comparison scheme
Effect test

Embodiment 1

[0046] refer to figure 1 as shown, figure 1 It is a flow chart of the first method of the Excel report exporting method of the present invention.

[0047] The Excel report exporting method of the present embodiment comprises the following steps:

[0048] S1, receiving the Excel template format customized by the user according to their own needs;

[0049] When it comes to the scenario of exporting reports, the default Excel templates are generally fixed, and the reports output by the fixed Excel templates can only set simple formats such as the font and header color of the output report, which is basically difficult. To meet the analysis and view needs of the business, some other formats, such as line color, chart, line folding, formula calculation, etc., cannot be well supported, and the format customization of automated reports cannot be realized. Therefore, the present invention proposes a method for exporting an Excel report, through which the user can customize the form...

Embodiment 2

[0082] refer to figure 2 as shown, figure 2 It is a flow chart of the second method of the Excel report exporting method of the present invention.

[0083] The Excel report exporting method of the present embodiment comprises the following steps:

[0084] S10, receiving an Excel template format customized by the user according to his own needs;

[0085] Each user's own report has its own custom format. Through this method, users can customize the format of the report template according to their own needs and habits, so as to realize the function of customizing the format, which is very convenient to meet the format requirements of business personnel for automated reports. .

[0086] S20, configure the name of the data table through the key-value, so that the name of the data table corresponds to the name of the underlying data;

[0087] Configure the name of the data table through key-value, so that the name of the data table corresponds to the name of the underlying dat...

Embodiment 3

[0099] refer to image 3 as shown, image 3 Export the device structure diagram of the device for the Excel report.

[0100] The Excel report exporting device of the present embodiment comprises:

[0101] Format definition module, used to customize the format of the display table;

[0102] Each user's own report has its own custom format. Users can customize the format of the report template according to their own needs and habits through the format definition module, so as to realize the function of customizing the format, which is very convenient to meet the business personnel's requirements for the format of the automated report. Require.

[0103] The data import module is used to extract the underlying data into the data table;

[0104] The name of each bottom layer data corresponds to the name of the data table, and the content of each bottom layer data is stored in the data table corresponding to its name through the data import module.

[0105] The function configu...

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 an Excel report exporting method and device and a storage medium. The method comprises the following steps that S1, a user customizes the format of an Excel template according to the requirement of the user; s2, extracting bottom layer data, and storing the bottom layer data into a data table in the Excel template; and S3, mapping data of the data table in the Excel template to a display table in the Excel template through a function. According to the Excel report exporting method and device and the storage medium, when the data of the report is updated, the code reads the new underlying data and updates the new underlying data into the data table, then the code can automatically activate the function of each cell in the display table, the mapping relation between the display table and the data table is reestablished, and the data table is exported. Therefore, the data in the display table can be automatically updated, the automatically updated data in the display table can have a format customized by a user, and the functions of an automatic report form and a customized format are realized at the same time.

Description

technical field [0001] The invention relates to the technical field of report export, in particular to an Excel report export method, device and storage medium. Background technique [0002] Now most companies have deployed automatic reporting platforms, which can provide efficient data display and data visualization functions. [0003] If it involves external output scenarios, the default Excel template output report can only set simple formats such as the font and header color of the output report, which is basically difficult to meet the business analysis and view needs. For some other Formats, such as row colors, charts, row folding, and formulaic calculations, are not well supported, and the format customization of automated reports cannot be realized. Contents of the invention [0004] In order to solve the above technical problems, the present invention provides an Excel report export method, which can realize the format customization of the automatic report. [0...

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/186G06F40/183G06F16/23G06F16/2455G06F16/248
CPCG06F40/186G06F40/183G06F16/23G06F16/2455G06F16/248
Inventor 黄帅
Owner ZHONGAN ONLINE P&C INSURANCE CO LTD
Who we serve
  • R&D Engineer
  • R&D Manager
  • IP Professional
Why Patsnap Eureka
  • Industry Leading Data Capabilities
  • Powerful AI technology
  • Patent DNA Extraction
Social media
Patsnap Eureka Blog
Learn More
PatSnap group products

Browse by: Latest US Patents, China's latest patents, Technical Efficacy Thesaurus, Application Domain, Technology Topic, Popular Technical Reports.

© 2024 PatSnap. All rights reserved.Legal|Privacy policy|Modern Slavery Act Transparency Statement|Sitemap|About US| Contact US: help@patsnap.com