Form file generation method and device, electronic equipment and storage medium

By obtaining and using table header definition data, style definition data and table data to generate Workbook model objects, the problem of low efficiency in table file generation in the existing technology is solved, and the generation of Excel table files is realized automatically, which improves efficiency.

CN118940736APending Publication Date: 2024-11-12SHANGHAI YIBAO HEALTH MANAGEMENT CO LTD
View PDF 0 Cites 0 Cited by

Patent Information

Application Number
CN202411176525.0
Authority / Receiving Office
CN · China
Patent Type
Applications(China)
Current Assignee / Owner
Filing Date
2024-08-26
Publication Date
2024-11-12

AI Technical Summary

Technical Problem

In the prior art, the efficiency of generating table files is low, and it relies on manual operations, resulting in inefficiency.

Method used

By obtaining the data set of the current sheet page, the Workbook model object in the POI component is generated based on the table header definition data, the style definition data and the table data, and the Workbook model object in the POI component is called, and the write method is called to generate the current sheet page in the Excel table file, realizing automatic generation.

Benefits of technology

It improves the efficiency of table file generation, is faster and more accurate than manual methods, and can automatically process table file generation tasks that process large batches of data.

✦ Generated by Eureka AI based on patent content.

Smart Images

  • Figure CN118940736A_ABST
    Figure CN118940736A_ABST
Patent Text Reader

Abstract

The invention provides a form file generation method and device, electronic equipment and a storage medium. The method comprises the following steps: acquiring a data set of a current sheet page, wherein the data set comprises header definition data of the current sheet page, style definition data of the current sheet page and table data of each table in the current sheet page; generating a corresponding Workbook model object in the POI component based on header definition data of a current sheet page in the data set, style definition data of each column in the current sheet page and table data of each table in the current sheet page; and calling a write method in the POI component through the Workbook model object so as to generate a current sheet page in the Excel table file. Therefore, each sheet page in the Excel form file can be used as the current sheet page, and the current sheet page is generated by the method provided by the embodiment of the invention, so that the Excel form file is finally generated, and compared with the form file generated by a manual mode at present, the efficiency can be improved by the method.
Need to check novelty before this filing date? Find Prior Art