CN111651968A - Automatic EXCEL report generation method and system and information data processing terminal - Google Patents

Automatic EXCEL report generation method and system and information data processing terminal Download PDF

Info

Publication number
CN111651968A
CN111651968A CN202010355601.XA CN202010355601A CN111651968A CN 111651968 A CN111651968 A CN 111651968A CN 202010355601 A CN202010355601 A CN 202010355601A CN 111651968 A CN111651968 A CN 111651968A
Authority
CN
China
Prior art keywords
report
excel
original data
module
data
Prior art date
Legal status (The legal status is an assumption and is not a legal conclusion. Google has not performed a legal analysis and makes no representation as to the accuracy of the status listed.)
Pending
Application number
CN202010355601.XA
Other languages
Chinese (zh)
Inventor
吴婕
朱立明
李维
董文扬
刘艳静
Current Assignee (The listed assignees may be inaccurate. Google has not performed a legal analysis and makes no representation or warranty as to the accuracy of the list.)
Tianjin Iron and Steel Group Co Ltd
Original Assignee
Tianjin Iron and Steel Group Co Ltd
Priority date (The priority date is an assumption and is not a legal conclusion. Google has not performed a legal analysis and makes no representation as to the accuracy of the date listed.)
Filing date
Publication date
Application filed by Tianjin Iron and Steel Group Co Ltd filed Critical Tianjin Iron and Steel Group Co Ltd
Priority to CN202010355601.XA priority Critical patent/CN111651968A/en
Publication of CN111651968A publication Critical patent/CN111651968A/en
Pending legal-status Critical Current

Links

Images

Classifications

    • G—PHYSICS
    • G06—COMPUTING; CALCULATING OR COUNTING
    • G06F—ELECTRIC DIGITAL DATA PROCESSING
    • G06F40/00—Handling natural language data
    • G06F40/10—Text processing
    • G06F40/166—Editing, e.g. inserting or deleting
    • G06F40/177—Editing, e.g. inserting or deleting of tables; using ruled lines
    • G—PHYSICS
    • G06—COMPUTING; CALCULATING OR COUNTING
    • G06F—ELECTRIC DIGITAL DATA PROCESSING
    • G06F16/00—Information retrieval; Database structures therefor; File system structures therefor
    • G06F16/20—Information retrieval; Database structures therefor; File system structures therefor of structured data, e.g. relational data
    • G06F16/22—Indexing; Data structures therefor; Storage structures
    • G06F16/2282—Tablespace storage structures; Management thereof
    • G—PHYSICS
    • G06—COMPUTING; CALCULATING OR COUNTING
    • G06F—ELECTRIC DIGITAL DATA PROCESSING
    • G06F16/00—Information retrieval; Database structures therefor; File system structures therefor
    • G06F16/20—Information retrieval; Database structures therefor; File system structures therefor of structured data, e.g. relational data
    • G06F16/23—Updating
    • G—PHYSICS
    • G06—COMPUTING; CALCULATING OR COUNTING
    • G06Q—INFORMATION AND COMMUNICATION TECHNOLOGY [ICT] SPECIALLY ADAPTED FOR ADMINISTRATIVE, COMMERCIAL, FINANCIAL, MANAGERIAL OR SUPERVISORY PURPOSES; SYSTEMS OR METHODS SPECIALLY ADAPTED FOR ADMINISTRATIVE, COMMERCIAL, FINANCIAL, MANAGERIAL OR SUPERVISORY PURPOSES, NOT OTHERWISE PROVIDED FOR
    • G06Q10/00—Administration; Management
    • G06Q10/10—Office automation; Time management

Landscapes

  • Engineering & Computer Science (AREA)
  • Theoretical Computer Science (AREA)
  • Physics & Mathematics (AREA)
  • General Physics & Mathematics (AREA)
  • Data Mining & Analysis (AREA)
  • General Engineering & Computer Science (AREA)
  • Business, Economics & Management (AREA)
  • Databases & Information Systems (AREA)
  • Strategic Management (AREA)
  • Human Resources & Organizations (AREA)
  • Entrepreneurship & Innovation (AREA)
  • General Health & Medical Sciences (AREA)
  • Computational Linguistics (AREA)
  • Audiology, Speech & Language Pathology (AREA)
  • Artificial Intelligence (AREA)
  • Health & Medical Sciences (AREA)
  • Software Systems (AREA)
  • Economics (AREA)
  • Marketing (AREA)
  • Operations Research (AREA)
  • Quality & Reliability (AREA)
  • Tourism & Hospitality (AREA)
  • General Business, Economics & Management (AREA)
  • Management, Administration, Business Operations System, And Electronic Commerce (AREA)

Abstract

The invention relates to an EXCEL report automatic generation method, a system and an information data processing terminal, belonging to the technical field of steel production data processing and comprising the following steps: s1, acquiring the original data of each project module from the manufacturing MES system, and exporting the original data to a designated storage unit; a summary report is preset in the storage unit; s2, storing the original data into different EXCEL reports in a classified manner; s3, matching the original data in the EXCEL report to the cells of the summary report; and S4, processing the matched original data by each cell of the summary report according to a preset calculation model, and updating the processing result to the summary report. According to the method, the original data of each project module in the MES system are automatically extracted, the original data are classified and stored, the original data are matched into the appointed EXCEL report to carry out model calculation statistics, and finally, the report is automatically generated.

Description

Automatic EXCEL report generation method and system and information data processing terminal
Technical Field
The invention belongs to the technical field of steel production data processing, and particularly relates to an EXCEL report automatic generation method and system and an information data processing terminal.
Background
As is well known, with the rapid development of internet electronic technology, paperless office is more and more concerned by people with the advantages of rapidness and environmental protection, and in some large-scale production enterprises (such as steel-making enterprises), because of numerous departments, the hysteresis of the traditional paper report is more and more difficult to meet the requirement of the next high-efficiency intelligent production, so that the enterprises all put forward higher requirements on the report, namely, higher requirements on the real-time performance and accuracy of the report; such as: every department of an enterprise needs to make a department daily report every day, and the enterprise needs to integrate screened preset data of a plurality of business system interfaces into one report every day, and calculate indexes such as accumulated values, qualification rate and the like in the report. The traditional EXCEL file can only be used for making reports through manual screening, copying and calculation, the required time is long, and errors are easy to occur due to large data volume and multiple repeated steps. The prior art (201910677169.X) matches reports uploaded by users by developing multiple pre-configured tables separately in a business system. The technology has long development period and high development cost, and is not beneficial to cost reduction and efficiency improvement of enterprises. Therefore, it is very important to develop an automatic EXCEL report generation method, system and information data processing terminal.
Disclosure of Invention
The invention provides an EXCEL report automatic generation method, a system and an information data processing terminal for solving the technical problems in the prior art.
The invention provides an automatic EXCEL report generation method, which comprises the following steps:
s1, acquiring the original data of each project module from the manufacturing MES system, and exporting the original data to a designated storage unit; a summary report is preset in the storage unit;
s2, storing the original data into different EXCEL reports in a classified manner;
s3, matching the original data in the EXCEL report to the cells of the summary report;
and S4, processing the matched original data by each cell of the summary report according to a preset calculation model, and updating the processing result to the summary report.
Further, the summary report is an EXCEL file, and a timing module and a trigger module for controlling the state of the calculation model are embedded in the summary report.
Still further, the project module includes one or more of a sinter module, molten iron, and iron slag.
Still further, the calculation model includes a cumulative production sum calculation model and/or a qualification rate statistical quotient calculation module and/or a qualification rate identification logical comparison model.
The second purpose of the present invention is to provide an automatic EXCEL report generation system, which at least comprises:
a data extraction module: acquiring the original data of each project module from a manufacturing MES system, and exporting the original data to a designated storage unit; a summary report is preset in the storage unit;
a data classification module: storing the original data into different EXCEL reports in a classified manner;
a data matching module: matching the original data in the EXCEL report to the cells of the summary report;
a data processing module: and each cell of the summary report processes the matched original data according to a preset calculation model, and updates the processed result to the summary report.
Furthermore, a timing module and a trigger module for controlling the state of the calculation model are embedded in the summary report.
Still further, the project module includes one or more of a sinter module, molten iron, and iron slag.
Still further, the calculation model includes a cumulative production sum calculation model and/or a qualification rate statistical quotient calculation module and/or a qualification rate identification logical comparison model.
The third purpose of the invention is to provide an information data processing terminal for realizing the automatic EXCEL report generation method.
It is a fourth object of the present invention to provide a computer-readable storage medium comprising instructions which, when run on a computer, cause the computer to perform the above-mentioned EXCEL report automatic generation method.
The invention has the advantages and positive effects that:
by adopting the technical scheme, the method and the system automatically extract the original data of each project module in the MES system, firstly classify and store the original data, then match the original data into the appointed EXCEL report form to carry out model calculation statistics, and finally realize the automatic generation of the report form. Compared with the traditional discrete manual extraction statistical calculation, the method has stronger timeliness and accuracy, and because the report has stronger timeliness and accuracy, a manager can better master the production progress and make a decision correctly and safely.
Drawings
FIG. 1 is a flow chart of a preferred embodiment of the present invention;
FIG. 2 is a block diagram of the structural modules of the preferred embodiment of the present invention;
FIG. 3 is a steel daily schedule diagram of the preferred embodiment of the present invention;
fig. 4 is a flowchart illustrating daily molten iron yield calculation according to a preferred embodiment of the present invention.
Detailed Description
In order to further understand the contents, features and effects of the present invention, the following embodiments are illustrated and described in detail with reference to the accompanying drawings:
as shown in fig. 1 to 3, the technical solution of the present invention is:
VBA (Visual Basic for applications) is a macro language for Visual Basic, which is a programming language for performing common automation (OLE) tasks in its desktop applications. The method can be mainly used for expanding the application program functions of Windows, in particular Microsoft Office software. It may also be said to be a Basic script that is visualized by an application.
An EXCEL report automatic generation method comprises the following steps:
s1, acquiring the original data of each project module from the manufacturing MES system, and exporting the original data to a designated storage unit; a summary report is preset in the storage unit;
s2, storing the original data into different EXCEL reports in a classified manner;
s3, matching the original data in the EXCEL report to the cells of the summary report;
and S4, processing the matched original data by each cell of the summary report according to a preset calculation model, and updating the processing result to the summary report.
Preferably, the summary report is an EXCEL file, and a timing module and a trigger module for controlling the state of the calculation model are embedded in the summary report.
The project module comprises one or more of a sinter module, molten iron and iron slag.
The calculation model comprises a summation calculation model of accumulated yield and/or a quotient calculation module of qualified rate statistics and/or a logic comparison model of qualified rate identification.
And (3) summing calculation models:
such as: cumulative yield calculation
Cumulative yield Wtotal Wi+W1-(i-1)
Wherein Wi-counting the daily output, t, for the report;
W1-(i-1)-making statistics of the cumulative production the day before the day for the report.
A quotient calculation module:
such as: daily qualified rate and accumulative qualified rate of molten iron: for the blast furnace index area of the template, the daily qualified rate and the accumulated qualified rate of the molten iron need to be calculated, and all the components which are not in the following table range are unqualified according to the key points of the sky steel on the molten iron.
The daily qualified rate of the molten iron is equal to the qualified furnace number i/the total daily road number n multiplied by 100 percent
The cumulative qualified rate of the molten iron is equal to the cumulative qualified furnace number/cumulative total furnace number multiplied by 100 percent
Table 1: daily qualified rate table for molten iron
[Si]% upper limit 0.50 [P],％ ≤0.120
[Si]Lower limit of% 0.3 [S],％ ≤0.030
An EXCEL report automatic generation system, comprising:
a data extraction module: acquiring the original data of each project module from a manufacturing MES system, and exporting the original data to a designated storage unit; a summary report is preset in the storage unit;
a data classification module: storing the original data into different EXCEL reports in a classified manner;
a data matching module: matching the original data in the EXCEL report to the cells of the summary report;
a data processing module: and each cell of the summary report processes the matched original data according to a preset calculation model, and updates the processed result to the summary report.
And a timing module and a trigger module for controlling the state of the calculation model are embedded in the summary report.
The project module comprises one or more of a sinter module, molten iron and iron slag.
The calculation model comprises a summation calculation model of accumulated yield and/or a quotient calculation module of qualified rate statistics and/or a logic comparison model of qualified rate identification.
An information data processing terminal for realizing the automatic EXCEL report generation method.
A computer-readable storage medium comprising instructions which, when executed on a computer, cause the computer to perform the above-described method for automatic EXCEL report generation.
For convenience of explanation, the following takes the production process of daily reports (which may be monthly reports or other reports) as an example:
an EXCEL daily report automatic generation method comprises the following steps:
the method comprises the following steps: predefining a daily report of a first EXCEL file (namely a summary report), and determining modules and names thereof to be contained in the daily report and the format of the report; the daily statement sheet of the first EXCEL file is named in a date format and used for distinguishing the date of the daily statement to be made; the report form format is set in advance to enable the historical daily report form format stored in the step eight to have uniformity, so that other problems of format loss and the like in the report form storage or copying operation process are avoided.
Step two: exporting at least one second EXCEL file (raw data classification) from at least one business system (manufacturing MES system) according to daily reporting requirements; the name of the second EXCEL file is named according to a certain rule, so that the second EXCEL file can be in one-to-one correspondence with the daily statement module through a VBA (visual basic application) programming language;
step three: according to the name of the daily statement module, carrying out file identification on a second EXCEL file in the first EXCEL file based on a VBA technology; and the file identification means that a second EXCEL file corresponding to the daily statement module is automatically found out through VBA program statements and is opened.
Step four: according to the processing rule, data processing is carried out on data in the second EXCEL file in the first EXCEL file based on the VBA technology; wherein the data processing comprises: performing a revocation protection operation on the opened second EXCEL file, so that the second EXCEL file exported by the system can be subjected to data processing based on the VBA technology; and then screening out the data meeting the module requirement according to the processing rule. The processing rule refers to a rule for screening out data of rows and columns meeting requirements from the second EXCEL file according to the requirements of different modules of the daily statement.
Step five: performing data matching on the data processed in the step four in the first EXCEL file based on the VBA technology; and the data matching refers to copying the screened data to the corresponding position of the module corresponding to the daily statement. After the data are matched, the program automatically closes the opened second EXCEL file, and the second EXCEL file subjected to the data processing is not stored, so that the working time is saved, and the complete traceability of the original data is reserved.
Step six: the third step and the fifth step are circulated until the data in all the files are matched with the corresponding positions in the first EXCEL file;
step seven: index calculation is carried out on the first EXCEL file based on the VBA technology, and a calculation result is matched to a corresponding position in the first EXCEL file; the index calculation means automatically calculating the index to be calculated in the daily report based on the module data and the corresponding calculation rule.
Step eight: the report form of the first EXCEL file is automatically saved to the third EXCEL file storing the historical daily report form based on the VBA technology, so that the whole report form process can be completed in one step, time is saved, and other problems of format loss and the like caused by operations such as copying, saving and the like are avoided. The historical daily statement refers to an EXCEL file for storing all the daily statements in a month, year, half year or other time unit.
The daily statement sheet of the first EXCEL file is named in a date format and used for distinguishing the date of the daily statement to be made;
the reason for setting the format of the daily statement in advance is to have uniformity with the format of the daily statement stored in the step eight, so that other problems of format loss and the like in the process of storing the statement in another way or copying operation are avoided.
The name of the second EXCEL file is named according to a certain rule, so that the second EXCEL file can be in one-to-one correspondence with the daily statement module through a VBA (visual basic application) programming language;
and the file identification means that the second EXCEL file corresponding to the daily statement module is automatically found out through VBA program statements and is opened.
The data processing comprises:
carrying out protection canceling operation on the opened second EXCEL file;
and screening out data meeting the module requirement according to the processing rule.
The processing rule refers to a rule for screening out data of rows and columns meeting requirements from the second EXCEL file according to the requirements of different modules of the daily statement.
And the data matching refers to copying the screened data to the corresponding position of the module corresponding to the daily statement.
The index calculation means that the index required to be calculated in the daily report is automatically calculated based on the module data and the corresponding calculation rule.
The historical daily statement refers to an EXCEL file storing all daily statements in month, year, half year or other time units.
An automatic daily statement generation system, comprising:
the daily report presetting module is used for presetting a daily report of the first EXCEL file by a user, and determining a module to be contained in the daily report, the name of the module and the format of the report; the daily statement sheet of the first EXCEL file is named in a date format and used for distinguishing the date of the daily statement to be made; the report form format is set in advance to enable the historical daily report form format stored in the step eight to have uniformity, so that other problems of format loss and the like in the report form storage or copying operation process are avoided.
The file identification module is used for carrying out file identification on the second EXCEL file in the first EXCEL file based on the VBA technology according to the name of the daily reporting module; the name of the second EXCEL file is named according to a certain rule, so that the second EXCEL file can be in one-to-one correspondence with the daily statement module through a VBA (visual basic application) programming language;
the data processing module is used for processing data in the second EXCEL file in the first EXCEL file based on the VBA technology according to the processing rule; wherein the data processing comprises: performing a revocation protection operation on the opened second EXCEL file, so that the second EXCEL file exported by the system can be subjected to data processing based on the VBA technology; and then screening out the data meeting the module requirement according to the processing rule. The processing rule refers to a rule for screening out data of rows and columns meeting requirements from the second EXCEL file according to the requirements of different modules of the daily statement.
The data matching module is used for performing data matching on the processed data in the second EXCEL file in the first EXCEL file based on the VBA technology; and the data matching refers to copying the screened data to the corresponding position of the module corresponding to the daily statement. After the data are matched, the program automatically closes the opened second EXCEL file, and the second EXCEL file subjected to the data processing is not stored, so that the working time is saved, and the complete traceability of the original data is reserved.
The index calculation module is used for performing index calculation on the first EXCEL file based on the VBA technology and matching a calculation result to a corresponding position in the first EXCEL file; the index calculation means automatically calculating the index to be calculated in the daily report based on the module data and the corresponding calculation rule.
And the automatic saving module comprises a third EXCEL file which is used for saving the historical daily statement and automatically saving the first EXCEL file statement based on the VBA technology. Therefore, the whole report process can be finished in one step, time is saved, and other problems of format loss and the like caused by operations such as copying, additional storage and the like are avoided. The historical daily statement refers to an EXCEL file for storing all the daily statements in a month, year, half year or other time unit.
In the above embodiments, the implementation may be wholly or partially realized by software, hardware, firmware, or any combination thereof. When used in whole or in part, can be implemented in a computer program product that includes one or more computer instructions. When loaded or executed on a computer, cause the flow or functions according to embodiments of the invention to occur, in whole or in part. The computer may be a general purpose computer, a special purpose computer, a network of computers, or other programmable device. The computer instructions may be stored in a computer readable storage medium or transmitted from one computer readable storage medium to another, for example, the computer instructions may be transmitted from one website site, computer, server, or data center to another website site, computer, server, or data center via wire (e.g., coaxial cable, fiber optic, Digital Subscriber Line (DSL), or wireless (e.g., infrared, wireless, microwave, etc.)). The computer-readable storage medium can be any available medium that can be accessed by a computer or a data storage device, such as a server, a data center, etc., that includes one or more of the available media. The usable medium may be a magnetic medium (e.g., floppy Disk, hard Disk, magnetic tape), an optical medium (e.g., DVD), or a semiconductor medium (e.g., Solid State Disk (SSD)), among others.
The above description is only for the preferred embodiment of the present invention, and is not intended to limit the present invention in any way, and all simple modifications, equivalent changes and modifications made to the above embodiment according to the technical spirit of the present invention are within the scope of the technical solution of the present invention.

Claims (10)

1. An automatic EXCEL report generation method is characterized by at least comprising the following steps:
s1, acquiring the original data of each project module from the manufacturing MES system, and exporting the original data to a designated storage unit; a summary report is preset in the storage unit;
s2, storing the original data into different EXCEL reports in a classified manner;
s3, matching the original data in the EXCEL report to the cells of the summary report;
and S4, processing the matched original data by each cell of the summary report according to a preset calculation model, and updating the processing result to the summary report.
2. The method for automatically generating EXCEL reports according to claim 1, characterized in that the summary report is an EXCEL file, and a timing module and a trigger module for controlling the state of the calculation model are embedded in the summary report.
3. The method for automatically generating EXCEL reports according to claim 1 or 2, characterized in that the project modules comprise one or more of sinter modules, molten iron, iron slag.
4. The method for automatic EXCEL report generation according to claim 3, characterized in that said calculation model comprises a cumulative yield calculation model and/or a qualification rate statistic quotient calculation module and/or a qualification rate identification logical comparison model.
5. An automatic EXCEL report generation system, characterized by comprising at least:
a data extraction module: acquiring the original data of each project module from a manufacturing MES system, and exporting the original data to a designated storage unit; a summary report is preset in the storage unit;
a data classification module: storing the original data into different EXCEL reports in a classified manner;
a data matching module: matching the original data in the EXCEL report to the cells of the summary report;
a data processing module: and each cell of the summary report processes the matched original data according to a preset calculation model, and updates the processed result to the summary report.
6. The EXCEL report automatic generation system according to claim 5, characterized in that a timing module and a trigger module controlling the state of the calculation model are embedded in the summary report.
7. The EXCEL report automatic generation system according to claim 5 or 6, characterized in that the project modules comprise one or more of sinter modules, molten iron, iron slag.
8. The EXCEL report automatic generation system of claim 7, wherein the calculation model comprises a cumulative yield calculation model and/or a qualification rate statistics quotient calculation module and/or a qualification rate recognition logical comparison model.
9. An information data processing terminal for implementing the EXCEL report automatic generation method according to any one of claims 1 to 4.
10. A computer-readable storage medium comprising instructions which, when executed on a computer, cause the computer to perform the method for automatic EXCEL report generation according to any of claims 1-4.
CN202010355601.XA 2020-04-29 2020-04-29 Automatic EXCEL report generation method and system and information data processing terminal Pending CN111651968A (en)

Priority Applications (1)

Application Number Priority Date Filing Date Title
CN202010355601.XA CN111651968A (en) 2020-04-29 2020-04-29 Automatic EXCEL report generation method and system and information data processing terminal

Applications Claiming Priority (1)

Application Number Priority Date Filing Date Title
CN202010355601.XA CN111651968A (en) 2020-04-29 2020-04-29 Automatic EXCEL report generation method and system and information data processing terminal

Publications (1)

Publication Number Publication Date
CN111651968A true CN111651968A (en) 2020-09-11

Family

ID=72351932

Family Applications (1)

Application Number Title Priority Date Filing Date
CN202010355601.XA Pending CN111651968A (en) 2020-04-29 2020-04-29 Automatic EXCEL report generation method and system and information data processing terminal

Country Status (1)

Country Link
CN (1) CN111651968A (en)

Cited By (3)

* Cited by examiner, † Cited by third party
Publication number Priority date Publication date Assignee Title
CN112381519A (en) * 2020-11-20 2021-02-19 北京云族佳科技有限公司 Method and device for processing work logs and readable storage medium
CN112861493A (en) * 2021-02-03 2021-05-28 河南开祥精细化工有限公司 Data analysis and summarization method, device, equipment and storage medium
CN113343657A (en) * 2021-04-30 2021-09-03 青海省药品检验检测院 Automatic processing and report generating system for cosmetic inspection data

Citations (10)

* Cited by examiner, † Cited by third party
Publication number Priority date Publication date Assignee Title
CN101719119A (en) * 2009-11-18 2010-06-02 上海众恒信息产业有限公司 Report management system and method
CN102855229A (en) * 2011-06-30 2013-01-02 镇江雅迅软件有限责任公司 Self-defined statistical report form generating system based on EXCEL form
CN103631969A (en) * 2013-12-20 2014-03-12 北京中电普华信息技术有限公司 Generation method and device of report data
CN104715052A (en) * 2015-03-27 2015-06-17 国家电网公司 Method and system for generating statement
CN105354240A (en) * 2015-10-14 2016-02-24 金蝶软件（中国）有限公司 Report file processing method and apparatus
CN105446948A (en) * 2015-11-13 2016-03-30 武汉鸿图节能技术有限公司 Report automatic generation method and system
CN107122961A (en) * 2017-05-16 2017-09-01 上海斐晟企业管理有限公司 Excel nested report data processing methods based on SAP system
CN108345673A (en) * 2018-02-09 2018-07-31 弘成科技发展有限公司 Online adult education institution of higher learning customize report deriving method
CN109471890A (en) * 2018-10-16 2019-03-15 深圳壹账通智能科技有限公司 Generation method, terminal device and the medium of report file
CN110414926A (en) * 2019-07-03 2019-11-05 平安科技（深圳）有限公司 Account management method, device and computer readable storage medium

Patent Citations (10)

* Cited by examiner, † Cited by third party
Publication number Priority date Publication date Assignee Title
CN101719119A (en) * 2009-11-18 2010-06-02 上海众恒信息产业有限公司 Report management system and method
CN102855229A (en) * 2011-06-30 2013-01-02 镇江雅迅软件有限责任公司 Self-defined statistical report form generating system based on EXCEL form
CN103631969A (en) * 2013-12-20 2014-03-12 北京中电普华信息技术有限公司 Generation method and device of report data
CN104715052A (en) * 2015-03-27 2015-06-17 国家电网公司 Method and system for generating statement
CN105354240A (en) * 2015-10-14 2016-02-24 金蝶软件（中国）有限公司 Report file processing method and apparatus
CN105446948A (en) * 2015-11-13 2016-03-30 武汉鸿图节能技术有限公司 Report automatic generation method and system
CN107122961A (en) * 2017-05-16 2017-09-01 上海斐晟企业管理有限公司 Excel nested report data processing methods based on SAP system
CN108345673A (en) * 2018-02-09 2018-07-31 弘成科技发展有限公司 Online adult education institution of higher learning customize report deriving method
CN109471890A (en) * 2018-10-16 2019-03-15 深圳壹账通智能科技有限公司 Generation method, terminal device and the medium of report file
CN110414926A (en) * 2019-07-03 2019-11-05 平安科技（深圳）有限公司 Account management method, device and computer readable storage medium

Cited By (3)

* Cited by examiner, † Cited by third party
Publication number Priority date Publication date Assignee Title
CN112381519A (en) * 2020-11-20 2021-02-19 北京云族佳科技有限公司 Method and device for processing work logs and readable storage medium
CN112861493A (en) * 2021-02-03 2021-05-28 河南开祥精细化工有限公司 Data analysis and summarization method, device, equipment and storage medium
CN113343657A (en) * 2021-04-30 2021-09-03 青海省药品检验检测院 Automatic processing and report generating system for cosmetic inspection data

Similar Documents

Publication Publication Date Title
CN111651968A (en) Automatic EXCEL report generation method and system and information data processing terminal
CN102117306B (en) Method and system for monitoring ETL (extract-transform-load) data processing process
CN106570260B (en) Automatic generation method of electrical connection relation
CN111045907B (en) System capacity prediction method based on traffic
CN102087657B (en) IO (Input/output) to point method and IO (Input/output) to point for nuclear power plant simulation platform
CN113557517A (en) Automatic generation device and method of electrical design drawing
CN111124917B (en) Method, device, equipment and storage medium for managing and controlling public test cases
CN110543303A (en) Visual business platform
CN111680420A (en) Simulation system dynamics model for industrial policy influence and implementation method thereof
CN108509198B (en) Neutral BOM-based product electronic album construction method
CN112446683A (en) Contract performance information management and control system
CN110032154B (en) Production control method and system for small-batch products
CN109871378A (en) The data acquisition and processing (DAP) method and system of big data platform
CN117036062A (en) Accounting resource calculation method and device
CN111752958A (en) Intelligent associated label method, device, computer equipment and storage medium
Li Simulation study of coordinating layout change and quality improvement for adapting job shop manufacturing to CONWIP control
CN109492209B (en) Automatic generation method of form signature column
CN108376361A (en) A kind of budget with comparison function and financial analysis system and its application method
CN115617790A (en) Data warehouse creation method, electronic device and storage medium
CN111563790A (en) Quotation platform of automatic control system
KR100958969B1 (en) Estimation Method and Corporation Support by using Module
CN111401022A (en) Management standard template rapid generation system and method
CN113094861B (en) Data storage method, device, equipment and storage medium
CN115952174B (en) Data table connection method, system, terminal and storage medium
CN114511394A (en) Production man-hour management control method and device, computer equipment and storage medium

Legal Events

Date Code Title Description
PB01 Publication
PB01 Publication
SE01 Entry into force of request for substantive examination
SE01 Entry into force of request for substantive examination
WD01 Invention patent application deemed withdrawn after publication
WD01 Invention patent application deemed withdrawn after publication

Application publication date: 20200911