CN108268525A - A kind of report implementation method and device based on Excel template - Google Patents
A kind of report implementation method and device based on Excel template Download PDFInfo
- Publication number
- CN108268525A CN108268525A CN201611264132.0A CN201611264132A CN108268525A CN 108268525 A CN108268525 A CN 108268525A CN 201611264132 A CN201611264132 A CN 201611264132A CN 108268525 A CN108268525 A CN 108268525A
- Authority
- CN
- China
- Prior art keywords
- report
- page
- configuration
- sub
- configuration information
- 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
Links
Classifications
-
- G—PHYSICS
- G06—COMPUTING; CALCULATING OR COUNTING
- G06F—ELECTRIC DIGITAL DATA PROCESSING
- G06F16/00—Information retrieval; Database structures therefor; File system structures therefor
- G06F16/30—Information retrieval; Database structures therefor; File system structures therefor of unstructured textual data
- G06F16/33—Querying
- G06F16/338—Presentation of query results
-
- G—PHYSICS
- G06—COMPUTING; CALCULATING OR COUNTING
- G06F—ELECTRIC DIGITAL DATA PROCESSING
- G06F16/00—Information retrieval; Database structures therefor; File system structures therefor
- G06F16/30—Information retrieval; Database structures therefor; File system structures therefor of unstructured textual data
- G06F16/33—Querying
- G06F16/3331—Query processing
Landscapes
- Engineering & Computer Science (AREA)
- Theoretical Computer Science (AREA)
- Computational Linguistics (AREA)
- Data Mining & Analysis (AREA)
- Databases & Information Systems (AREA)
- Physics & Mathematics (AREA)
- General Engineering & Computer Science (AREA)
- General Physics & Mathematics (AREA)
- Information Transfer Between Computers (AREA)
Abstract
The invention discloses a kind of report implementation methods and device based on Excel template.The method of the present invention includes：Preset Excel template is read, which includes the configuration information for generating report and the configuration information for generating enquiring component；Enquiring component includes the querying condition for screening report data；According to reading for generating the configuration information of report, the first report is generated, and enquiring component is generated for generating the configuration information of enquiring component according to reading；Querying condition in enquiring component screens the report data in the first report, obtains the second report that report data meets querying condition；Second report is converted into be output on web page after hypertext markup language with enquiring component and is shown.The present invention provides a kind of reports that can flexibly generate simultaneously can show and inquire the report implementation of report on same web page.
Description
Technical field
The present invention relates to Internet technical field more particularly to a kind of report implementation methods and dress based on Excel template
It puts.
Background technology
Report has very important ground as part essential in business management software in business management software
Position, and grow with the continuous development of internet, web exploitations are constantly universal, and displaying demand of the report on web page is further strong
It is strong, particularly in financial field, often relate to the displaying of a large amount of reports.
Have some report tools at present, such as based on the plug-in unit business intelligence report tool (Business that increases income
Intelligence and Reporting Tools, BIRT) plug-in unit report tool, increase income program library JasperReports
Tool etc., but these current report tools, some need disposition data source, can be in exploitation work if data source mismatch
It is constantly looked on tool, leads to a large amount of consumption of resource；The report display web page generated having can only show what plug-in unit carried
Fixed pattern, can not generate self-defined report form；The file of some compiling generations is parsed after needing lead-in item, is being changed
During dynamic report, need first to change file on software, be then compiled in lead-in item again and parse, toggle tool and insert
Part, cumbersome and workload is also big, some developing instruments when generating report, without querying condition limit, when data volume compared with
When big, query result can be caused very slow, and cause data can not also without addition enquiring component on web page
Flexible Query.
It can be seen that can flexibly generate report there is no one kind at present simultaneously can show and inquire report on same web page
The report implementation of table.
Invention content
The application provides a kind of report implementation method and device based on Excel template, can flexibly be given birth to provide one kind
The report implementation of report simultaneously can be shown and inquired on same web page into report.
In a first aspect, the application provides a kind of report implementation method based on Excel template, this method includes：
Preset Excel template is read, the Excel template includes the configuration information for generating report and is used for
Generate the configuration information of enquiring component；The enquiring component includes the querying condition for screening report data；
According to reading for generating the configuration information of report, the first report is generated, and be used to give birth to according to what is read
Into the configuration information of enquiring component, enquiring component is generated；
Querying condition in the enquiring component screens the report data in first report, obtains report data
Meet the second report of the querying condition；
It is output on web page after second report and the enquiring component are converted into hypertext markup language html
Displaying.
By technical solution provided herein, Excel reports, the opposing party on the one hand can be shown on web page
Face additionally provides support of the same web page to inquiry Excel reports, and querying condition configuration is added in Excel template file
Information so that the report shown on web page can flexibly be generated based on querying condition, quickly obtain accurate data.
In a kind of possible realization method, it is output to after second report is converted into html with the enquiring component
After being shown on web page, further include：
If getting the querying condition selected by the enquiring component shown on the web page, selected by
The querying condition gone out screens the report data in first report, obtain report data meet it is selected go out querying condition
Third report；
The third report is converted into after html to be output on the web page and is shown.
It can be seen that by technical solution provided herein, can same web page realize report displaying and
It inquires, overcome in current report implementation can not Flexible Query data, the defects of workload needed for report change is larger.
In a kind of possible realization method, the configuration information of report style is further included in the Excel template, it is different
Report style corresponds to the different configuration informations for being used to generate report；
According to reading for generating the configuration information of report, before generating the first report, further include：
Report style is determined according to the configuration information of report style in the Excel template；
According to identified report style, the corresponding configuration information for being used to generate report of the report style is read.
It can be seen that technical solution provided herein extends the class that can generate report by setting report style
Type supports User-defined report, and user is in self-defined report, by changing report style and corresponding in Excel template
The corresponding sub- configuration page of modification, it is possible to realize the purpose for generating the various required reports of different service types.
In a kind of possible realization method, the Excel template includes system setting page and the configuration of at least three
Page；The sub- configuration page of at least three corresponds to a kind of report style；
Include the configuration information of report style, index information, the Yi Jiyong of each sub- configuration page in the system setting page
In the index information of the script language files of generation querying condition；
Being included at least in the first sub- configuration page in 3 sub- configuration pages has what statement form was shown on web page
Configuration information, the configuration information of report name and the configuration information of report database；
It is included at least in the second sub- configuration page in 3 sub- configuration pages and is useful for the inquiry shown on web page
The configuration information of condition, inquiry field name and query type；
The configuration information and report for having statement form are included at least in the sub- configuration page of third in 3 sub- configuration pages
The configuration information of field；
Preset Excel template is read, including：
Every a line of the system setting page is read, obtains report style, the report style corresponds to each sub- configuration page
The index of index and the script language files for being used to generate querying condition；
According to the configuration information for being used to generate report read and the configuration information for showing report, the first report of generation
Table, including：
According to the described first sub- configuration page and the index of the sub- configuration page of third, the first sub- configuration page and described the are read
Three sub- configuration pages；
According to the configuration information per a line in the described first sub- configuration page and the sub- configuration page of the third, the first report of generation
Table；
According to the configuration information for being used to generate enquiring component read, enquiring component is generated, including：
According to the index of the described second sub- configuration page, the second sub- configuration page is read；
According to described for generating the index of the script language files of querying condition, reading is described to be used to generate querying condition
Script language files；
According to the configuration information per a line in the described second sub- configuration page, the script for being used to generate querying condition is used
Language file generates the enquiring component.
It can be seen that in technical solution provided herein, the configuration in preset Excel template in multiple configuration pages
Information can flexibly be set, and each configuration page functional stratification understands；It can be with configuration querying component and query type in configuration；Report
It can be filtered before web page displaying with querying condition so that the report shown on web page can be based on querying condition spirit
Generation living, quickly obtains accurate data..
In a kind of possible realization method, query window title is further included in the system setting page matches confidence
Breath；The query window title is used to verify report name in first configuration page；The method further includes：
If parse the report that the query window title that the system setting page obtains is obtained with parsing first configuration page
Title is inconsistent, then prompts report style abnormal on web page.
It can be seen that in technical solution provided herein, query window title can be used for being configured to described first
Report name is verified in page, ensures the accuracy of generated report.
Second aspect, the application provide a kind of report realization device based on Excel template, which includes：
Read module, for reading preset Excel template, the Excel template includes generating matching for report
Confidence ceases and the configuration information for generating enquiring component；The enquiring component includes the inquiry for screening report data
Condition；
Generation module for generating the configuration information of report according to reading, generates the first report, and according to reading
That gets is used to generate the configuration information of enquiring component, generates enquiring component；
Screening module screens the report number in first report for the querying condition in the enquiring component
According to obtaining the second report that report data meets the querying condition；
Output module, it is defeated after hypertext markup language html for second report and the enquiring component to be converted into
Go out to showing on web page.
In a kind of possible realization method, the screening module is additionally operable to：
It is output on web page after second report and the enquiring component are converted into html by the output module
After displaying, if getting the querying condition selected by the enquiring component shown on the web page, selected by
The querying condition gone out screens the report data in first report, obtain report data meet it is selected go out querying condition
Third report；
The output module, is additionally operable to：The third report is converted into after html to be output on the web page and is opened up
Show.
In a kind of possible realization method, the configuration information of report style is further included in the Excel template, it is different
Report style corresponds to the different configuration informations for being used to generate report；
The generation module, is additionally operable to：
Report style is determined according to the configuration information of report style in the Excel template；According to identified report sample
Formula reads the corresponding configuration information for being used to generate report of the report style.
In a kind of possible realization method, the Excel template includes system setting page and the configuration of at least three
Page；The sub- configuration page of at least three corresponds to a kind of report style；
Include the configuration information of report style, index information, the Yi Jiyong of each sub- configuration page in the system setting page
In the index information of the script language files of generation querying condition；
Being included at least in the first sub- configuration page in 3 sub- configuration pages has what statement form was shown on web page
Configuration information, the configuration information of report name and the configuration information of report database；
It is included at least in the second sub- configuration page in 3 sub- configuration pages and is useful for the inquiry shown on web page
The configuration information of condition, inquiry field name and query type；
The configuration information and report for having statement form are included at least in the sub- configuration page of third in 3 sub- configuration pages
The configuration information of field；
The read module, is specifically used for：
Every a line of the system setting page is read, obtains report style, the report style corresponds to each sub- configuration page
The index of index and the script language files for being used to generate querying condition；
The generation module, is specifically used for：
According to the described first sub- configuration page and the index of the sub- configuration page of third, the first sub- configuration page and described the are read
Three sub- configuration pages；
According to the configuration information per a line in the described first sub- configuration page and the sub- configuration page of the third, the first report of generation
Table；And
According to the index of the described second sub- configuration page, the second sub- configuration page is read；
According to described for generating the index of the script language files of querying condition, reading is described to be used to generate querying condition
Script language files；
According to the configuration information per a line in the described second sub- configuration page, the script for being used to generate querying condition is used
Language file generates the enquiring component.
In a kind of possible realization method, query window title is further included in the system setting page matches confidence
Breath；The query window title is used to verify report name in first configuration page；Described device further includes：
Correction verification module, for parsing query window title and parsing first configuration that the system setting page obtains
When the report name that page obtains is inconsistent, prompt report style abnormal on web page.
The principle and advantageous effect solved the problems, such as due to the device may refer to above-mentioned first aspect and first aspect
The embodiment and caused advantageous effect of each possible report implementation method based on Excel template, therefore the device
Implementation may refer to above-mentioned first aspect and first aspect each possible report implementation method based on Excel template reality
It applies, overlaps will not be repeated.
Description of the drawings
To describe the technical solutions in the embodiments of the present invention more clearly, make required in being described below to embodiment
Attached drawing is briefly introduced, it should be apparent that, the accompanying drawings in the following description is only some embodiments of the present invention, for this
For the those of ordinary skill in field, without having to pay creative labor, it can also be obtained according to these attached drawings
His attached drawing.
Fig. 1 is Excel report generations and the system structure diagram shown in web page；
Fig. 2 is the flow diagram of the report implementation method based on Excel template that some embodiments of the invention provide；
Fig. 3 is the schematic diagram of some embodiments of the invention preset Excel template in practical applications；
Fig. 4 is that the system of preset Excel template in some embodiments of the invention sets the schematic diagram of page；
Fig. 5 is the schematic diagram of the report configuration page of preset Excel template in some embodiments of the invention；
Fig. 6 is the schematic diagram of the querying condition page of preset Excel template in some embodiments of the invention；
Fig. 7 is the schematic diagram of the statement form page of preset Excel template in some embodiments of the invention；
Fig. 8 is illustrated in the schematic diagram on web page by the report that some embodiments of the invention are realized；
Fig. 9 is the report realization device structure diagram based on Excel template that some embodiments of the invention provide.
Specific embodiment
To make the objectives, technical solutions, and advantages of the present invention clearer, the present invention is made below in conjunction with attached drawing into
It is described in detail to one step, it is clear that the described embodiments are only some of the embodiments of the present invention rather than whole implementation
Example.Based on the embodiments of the present invention, those of ordinary skill in the art are obtained without making creative work
All other embodiment, shall fall within the protection scope of the present invention.
Excels of the Excel as Global prevalence, it is easy to use, powerful, use it is extensive, it is most of
Data are presented all using Excel as the preferred ways of presentation of report, using the report generation form based on Excel template in enterprise,
I.e. by data by the modes such as storing process or structured query language (Structured Query Language, SQL) sentence
It is loaded into inside preset Excel template, is presented to the user after generating new Excel data files.
In order to which such as template in the presence of current report realization method is overcome to fix, self-defined report form can not be generated
Report；The displaying and inquiry of report can not be realized in same web page；It can not Flexible Query data；Work needed for report change
Many defects, the embodiment of the present invention such as work amount is larger propose a kind of report implementation method and device based on Excel template, use
The report implementation of report simultaneously can be shown and inquired on same web page to provide a kind of report that can flexibly generate so that
The report generated has customized report style, and non-required display data can be filtered out before displaying, while can be with
Generated report is shown in same web page and query function to report is provided.
Specifically, the report implementation based on Excel template that the embodiment of the present invention is provided is mainly pre- by parsing
If Excel template, according to the configuration information in default Excel template, generate report and enquiring component, and according to enquiring component
In querying condition screening report in report data, obtain the result data for meeting querying condition, by result data with inquiry
Component is converted into after html to be output on web page and be shown.It can be seen that the technology provided through the embodiment of the present invention
On the one hand scheme can show Excel reports on web page, on the other hand additionally provide same web page to inquiry
The support of Excel reports, the report shown on web page can flexibly be generated based on querying condition, it is thus possible to overcome mesh
In preceding report implementation can not same web page realize report displaying and inquiry, can not Flexible Query data, report change
Many defects such as workload needed for dynamic is larger.
The embodiment of the present invention is described in detail below in conjunction with the accompanying drawings.
Fig. 1 shows Excel report generations and the system structure diagram shown in web page.
As shown in Figure 1, include terminal 101, web server 102, file server 103 and number in the system structure
According to library server 104.Web server 102, file server 103 and database server 104 can be independent from each other object
It manages equipment or is realized by same physical equipment.
Specifically, file server 103 can be used for storing Excel template file；Database server 104 is used to store
Master data, wherein master data refer to generate the required initial data of report；
The FTP client FTP for accessing web, such as web browser, web application etc. can be installed, to send in terminal 101
Report request message is to web server；Web server 102, can be according to the report request after report request message is received
Message obtains Excel template file from file server 103, and is obtained needed for generation report from database server 104
Business datum according to the business datum and Excel template file generated report got, and is presented in a manner of web page
Terminal 101.
Specifically, web server 102, can be real by way of executing program instructions after Excel template is got
Now to the read-write operation of Excel file, for example, the open source code function library POI of Apache (Apache) software foundation at present
(Poor Obfuscation Implementation) is just capable of providing application programming interface (Application
Programming Interface, API) it is realized to java applet to MS Office Applications (Microsoft Office) form
The read-write capability of archives.
Based on system structure diagram shown in FIG. 1, Excel template is based on Fig. 2 shows provided in an embodiment of the present invention
Report implementation method flow diagram.
Specifically, flow as shown in Figure 2 can be by being implemented in combination with, such as can by hardware, software programming or software and hardware
It realizes in the equipment with processor and memory, is performed by the data in processor reading memory and instruction, specifically
Such as web server 102 shown in FIG. 1.
As shown in Fig. 2, the flow includes the following steps：
Step 201：Read preset Excel template.
Wherein, which includes configuration information for generating report and for generating inquiry group
The configuration information of part；Enquiring component includes the querying condition for screening report data.
Step 202：According to the configuration information read for generating report, first report is generated, and according to reading
For generating the configuration information of enquiring component, generate enquiring component.
Step 203：Querying condition in enquiring component screens the report data in the first report, obtains report data
Meet the second report of querying condition.
Step 204：Second report is converted into be output on web page after html with enquiring component and is shown.
Although it should be understood that term " first ", " second ", " third " etc. may in this application be used for describe it is various
Element (such as report), but these elements are not limited by these terms, these terms be used only to by an element with it is another
One element distinguishes.For example, the first report can be named as the second report, the second report can be named as the first report
Table, and the scope of the present invention is not departed from, the first report and the second report both reports, but they are not same reports.
Specifically, preset Excel template can be stored in local template file or can also be taken from file
The template file read in business device.After Excel template is got, it can be realized by way of executing program instructions pair
The read-write operation of accessed preset Excel template, for example, being realized by the API that POI is called to provide to Excel lattice
The read-write of formula file.
Specifically, the configuration information for being used to generate report in preset Excel template can such as include to be generated
The configuration information of statement form, report to be generated are illustrated in the database configuration of the configuration information, report to be generated on web page
Information etc. by the reading to this kind of configuration information, can generate the first report；For generating the configuration information of enquiring component
Such as can include the configuration information of querying condition, inquire the configuration information of field name, query type configuration information and
Configuration information of script file (JavaScript, JS) file etc., by the reading to this kind of configuration information, can generate and look into
Ask component.
And then the report data in the first report can be screened according to the querying condition in enquiring component, obtain report number
According to the second report for meeting querying condition, the second report is converted into be output on web page after html with enquiring component shows.
It can be seen that on the one hand the technical solution provided through the embodiment of the present invention can be shown on web page
On the other hand Excel reports additionally provide support of the same web page to inquiry Excel reports, in Excel template file
Adding querying condition configuration information so that the report shown on web page can flexibly be generated based on querying condition, quick
To accurate data.Can overcome in current report implementation can not realize the displaying of report and inquiry, nothing in same web page
Many defects such as workload is larger needed for method Flexible Query data, report change.
In some embodiments of the invention, in order to enrich the pattern that can generate report, may be used also in preset Excel template
To include the configuration information of report style, different report styles corresponds to the different configuration informations for being used to generate report.
And then in some embodiments of the invention, according to the configuration information read for generating report, generation the
Before one report, procedure below can also be performed：Report sample is determined according to the configuration information of report style in the Excel template
Formula；So as to according to identified report style, read the corresponding configuration information for being used to generate report of the report style.
It can be seen that by setting report style, the type that can generate report is extended, supports User-defined report,
User is in self-defined report, by changing report style in Excel template and accordingly changing corresponding sub- configuration page, so that it may
To realize the purpose for generating the various required reports of different service types.
Specifically, Excel file can include multiple pages (sheet), the arbitrary element in the arbitrary page
With using the arbitrary element in this page or other pages as data source, by the data source through pre-set transformation
And/or value of the result obtained after operation as this element.
Above-mentioned characteristic based on Excel file, in the report based on Excel template that some embodiments of the present invention are provided
In table implementation, system setting page and the sub- configuration page of at least three can be included by being specifically included in preset Excel template；
Wherein, this 3 sub- configuration pages can correspond to a kind of report style.
Specifically, the configuration information of report style, the index letter of each sub- configuration page can be included in system sets page
Breath and the index information for generating the script language files of querying condition；
Can be included at least in this 3 sub- configuration pages, in the first sub- configuration page has statement form to be shown on web page
Configuration information, the configuration information of report name and the configuration information of report database；
It can be included at least in second sub- configuration page and be useful for the querying condition shown on web page, inquiry field name
And the configuration information of query type；
The configuration information for having statement form and the configuration information of report field can be included at least in the sub- configuration page of third.
Based on configuration information included in each page in above-mentioned Excel template, in some embodiments of the invention, such as
It the step of in flow shown in Fig. 2 by reading preset Excel template, generating the first report and enquiring component, specifically can be with
Including procedure below：
Reading system sets every a line of page, and acquisition report style, the report style correspond to the index letter of each sub- configuration page
Breath and the index for generating the script language files of querying condition；
According to the index of accessed the first sub- configuration page and the sub- configuration page of third, the first sub- configuration page and third are read
Sub- configuration page；So as to according to the configuration information per a line in the first sub- configuration page and the sub- configuration page of third, generate the first report；
According to the index of the second accessed sub- configuration page, the second sub- configuration page is read；And according to accessed
For generating the index of the script language files of querying condition, the script language files for generating querying condition are read；So as to
Can enquiring component be generated using the script language files according to the configuration information per a line in the second sub- configuration page.
It, can be according to the querying condition in enquiring component to giving birth to and then after generating the first report and enquiring component
Into the first report in data be filtered, obtain the second report, the second report and enquiring component be converted into html forms
Afterwards, the web page that can export html to browser is shown.
It can be seen that in the scheme provided in the above embodiment of the present invention, there are multiple configurations in preset Excel
Page, the configuration information in multiple configuration pages can flexibly be set, and the functional stratification of each configuration page understands；It meanwhile can in configuration
With configuration querying component and query type, and then can be passed through before web page displaying based on the report that configuration information is generated
Querying condition is filtered, thus can quickly obtain accurate data, optimizes the generating process of report.
Specifically, the configuration information of query window title can also be included in system sets page；The query window name
Title can be used for verifying report name in first configuration page.
Specifically, if the report that the query window title that resolution system setting page obtains is obtained with the first sub- configuration page of parsing
Table name is inconsistent, then can prompt report style abnormal on web page.
Specifically, to be output to web page after the second report is converted into html with enquiring component by step 104 enterprising
After row displaying, procedure below can also be further performed：
If getting the querying condition selected by the enquiring component shown on the web page, go out selected by
Querying condition, screen the report data in the first report, obtain report data meet it is selected go out querying condition third
Report；
Third report is converted into be output on web page after html and is shown.
It can be seen that by the above process, since there is enquiring component simultaneously on the web page of displaying report, thus it is logical
The enquiring component is crossed, user can directly be inquired on web page, data needed for acquisition.
By above description as can be seen that the report realization side based on Excel template that some embodiments of the invention provide
Case, by parsing preset Excel template, configuration information in assembled Excel template simultaneously carries out data query, finally can be
Data sheet of the generation with enquiring component on web page.
It, below will be with the present invention one for the clearer above-mentioned report implementation method flow based on Excel template of explanation
For the application of report implementation in practice based on Excel template that a little embodiments provide, to illustrate the present invention
The report implementation based on Excel template that embodiment is provided.
Fig. 3 shows the schematic diagram of some embodiments of the invention preset Excel template in practical applications.
As shown in figure 3, include system setting page 301, report configuration page 302, inquiry item in the preset Excel template
Part page 303 and statement form page 304.Wherein, system setting page 301 is equivalent to the system setting described in above-mentioned flow
Page, report configuration page 302 are equivalent to the first sub- configuration page described in above-mentioned flow, and querying condition page 303 is equivalent to above-mentioned
The second sub- configuration page described in flow, statement form page 304 are equivalent to the sub- configuration page of the described third of above-mentioned flow.
Fig. 3 also shows configuration information signal included in system setting page, it can be seen that, it is illustrated that in system setting page
A key (key) is configured with per a line, the key assignments (value) corresponding to each key represents a kind of configuration information, divides below
Each key in system shown in Figure 3 setting page and corresponding key assignments are not described：
1st, report style (ShowType)：The key indicates the pattern of generated report, in the example depicted in fig. 3,
The key is configured as detail list (detail) pattern.The key can be additionally configured to statistical form (statistic) etc., different
Report style correspond to a set of different sub- configuration page (i.e. different report styles, which corresponds to, different to be used to generate matching for report
Confidence ceases)；
The technical solution that the embodiment of the present invention is provided can be realized by setting report style to User-defined report
The support of pattern, the report style of report, Yong Hu can be generated by extending the technical solution provided based on the embodiment of the present invention
It, can be by setting the corresponding key assignments of report style in Excel template and accordingly changing in Excel template during self-defined report
Sub- configuration page, to achieve the purpose that the various required reports of different service types of generation.
It for the convenience of description, below will be by the corresponding key assignments of report style to be specifically described for detail.
2nd, report configuration page (DetailSetSheet2)：The key indicates the index information of report configuration page, in Fig. 3 institutes
In the example shown, which is configured as 2, i.e. the 2nd in the Excel template page (sheet) (is equivalent to above-mentioned for report configuration page
First sub- configuration page).
By parsing the corresponding key assignments of report configuration page, report configuration page can be found, and then report configuration page can be parsed
In element.The configuration of some forms, the title of report, query SQL sentence etc. when mainly having report displaying in report configuration page.
3rd, querying condition page (QuerySheet3) configuration information：The key indicates the index information of querying condition page, is scheming
In example shown in 3, which is configured as 3, i.e. the 4th in the Excel template page (sheet) (is equivalent to for querying condition page
Above-mentioned second sub- configuration page).
By parsing the corresponding key assignments of querying condition page, querying condition page can be found, and then querying condition page can be parsed
In element.Querying condition when mainly having report displaying in querying condition page etc..
4th, report displaying page (DetailStyleSheet4) configuration information：The key indicates the index letter of report displaying page
Breath, in the example depicted in fig. 3, the key are configured as 4, i.e. the 5th in the Excel template page (sheet) shows page for report
(being equivalent to the sub- configuration page of above-mentioned third).
The corresponding key assignments of page is shown by parsing report, can find report displaying page, and then can parse report displaying page
In element.Mainly there are statement form during report exhibition, field etc. in report displaying page.
5th, query window title (QueryFormName) configuration information：The key indicates query window title, in Fig. 3 institutes
In the example shown, which is configured as " appropriation analysis ", which is used to verify report style.Specifically,
The key is mainly used for being compared with the report name information in report configuration page, identical, can generate the report of required pattern
Table.
By parsing the corresponding key assignments of query window title, the report style of report to be generated can be verified.
6th, querying condition JS files (QueryFile) configuration information：The key indicates the index letter of querying condition JS files
Breath, in the example depicted in fig. 3, which is configured as the store path of querying condition JS files in systems.
By parsing the corresponding key assignments of querying condition JS files, querying condition JS (JavaScript) file can be found,
And then JS controls can be carried out to the control form by parsing the obtained querying condition of querying condition page, wherein, querying condition
Control form whether include be empty, query type (such as search box (searchbox), combo box (combobox), text
Frame (textbox), dat frame (datebox) etc.).
It can be seen that by parsing the element in the setting page of the system in Excel template, (each key and each key correspond to
Key assignments), report configuration page, querying condition page and report display page will be accessed, and then item can be inquired to report configuration page
Element in part page and report display page is parsed, report needed for generation.
Thus, the configuration information in above system setting page, which may be considered, to be used to generate report in the Excel template
Configuration information and for generating the part in the configuration information of enquiring component.
It should be understood that Fig. 3 is only a specific example of system setting page, system setting page is not limited to only include
Element in example shown in Fig. 3 can be defined according to the needs of practical application, for example may include more elements or can
Include different element etc., to parse to obtain the configuration information of Excel reports to be generated, the application sets in page system
Element form and be not especially limited.
Specifically, Fig. 4 shows configuration information signal included in report configuration page, it can be seen that, it is illustrated that report is matched
It puts in page and is also configured with a key per a line, the corresponding key assignments of each key represents a kind of configuration information, will retouch respectively below
State each key in report configuration page shown in Fig. 4 and corresponding key assignments：
1st, report name (TABLENAME) configuration information：The key indicates the title of report, in the example depicted in fig. 4,
The key is configured as " appropriation analysis ", which should set the configuration information of the query window in page with aforementioned system
It is consistent, and then the configuration information of the query window in page can be set to carry out school to report configuration page by aforementioned system
It tests.
2nd, paging mode (PAGINATION)：The key indicates when report is illustrated in web page whether have page format,
In example shown in Fig. 4, which is configured as " YES ", indicates page format.
3rd, gauge outfit row (TABLEHEADS)：The gauge outfit that the key indicates report when report is illustrated in web page accounts for several rows,
In example shown in Fig. 4, the key be configured as " 1,3 ", represent that the gauge outfit of report accounts for 1-3 rows.
4th, field bodies row (TABLEDATAS)：The key indicate report when report is illustrated in web page field bodies account for it is several
Row, in the example depicted in fig. 4, which is configured as " 4 ", and the field data for representing report is the 4th row.
5th, table tail row (TABLETAILS)：The table tail that the key indicates report when report is illustrated in web page accounts for several rows,
In example shown in Fig. 4, which is configured as sky.
6th, total columns (TOTALCOLUMNS)：All fields that the key indicates report when report is illustrated in web page account for
How much web page arranges, and in the example depicted in fig. 4, which is configured as 19, represents that report accounts for web page totally 19 row.
7th, SQL_1 (PERSQL_1) is performed：The key indicate may need to perform before inquiry report some storing process or
Person SQL, in the example depicted in fig. 4, the key are configured as sky；
8th, SQL_2 (PERSQL_2) is performed：The key is the extension for performing SQL_1, in the example depicted in fig. 4, the key quilt
It is configured to sky；
9th, query SQL _ 3 (QUERYSQL_3)：The key indicate inquiry data after data are handled (such as：Polymerization,
Multiply, average), in the example depicted in fig. 4, which is configured as sky；
10th, query SQL _ 4 (QUERYSQL_4) is the data for the report of being extracted, in the example depicted in fig. 4, the key quilt
It is configured to " select*from user2 ", represent the data for the report of being extracted in the user2 of database.
By parsing the element in report configuration page, can obtain matching confidence when report to be generated is illustrated in web page
Breath and data base querying information, the configuration information in above-mentioned report configuration page may be considered in the Excel template for giving birth to
A part into the configuration information of report.
Correspondingly, similar with the aforementioned explanation to system shown in Figure 3 setting page, Fig. 4 is only one of report configuration page
Specific example, the application is to the element form in report configuration page and is not especially limited.
Specifically, Fig. 5 shows configuration information signal included in querying condition page, it can be seen that, it is illustrated that inquiry item
Each row in part page indicates respectively querying condition, inquiry state (Search Condition), inquire field name, type,
Combobox values and whether must input；
Wherein, the element in querying condition row is the querying condition of required report that can be added, than as shown in Figure 5
Include department, personnel's name, Start Date, Close Date in the querying condition gone out；These querying conditions are corresponding to be looked into
It askes field name and includes DEPARTMENT, NAME, STARTDATE, ENDDATE；The corresponding inquiry class of these querying conditions
Type includes searchbox, combobox, textbox, datebox；Whether these querying conditions are corresponding must inputs
It is NO；Search Condition row are sky, and combobox values row refer to that querying condition can specify some fixed item
Part is also sky in the example illustrated in fig. 5.
Specifically, query type and whether be that the function that must input can be as JS files (shown by system setting page
QueryFile) value therein is extracted to be controlled.
By parsing the element in querying condition page, the configuration information of enquiring component to be generated, above-mentioned inquiry can be obtained
Configuration information in condition page is regarded as in the Excel template generating the part in the configuration information of enquiring component.
Correspondingly, similar with the aforementioned explanation to system shown in Figure 3 setting page, Fig. 5 is only one of querying condition page
Specific example, the application is to the element form in querying condition page and is not especially limited.
Specifically, Fig. 6 shows configuration information signal included in statement form page, it can be seen that, it is illustrated that report lattice
1-3 behavior gauge outfits in formula page；Each field (DATA) in 4th behavior statement form；It is wherein each in statement form
Field and the inquiry field famous prime minister of query SQL sentence in report configuration page are mutually corresponding, to generate Excel form reports.
By the element in statement form page, report tableau format to be generated can be obtained, matching in above-mentioned statement form page
Confidence breath is regarded as in the Excel template generating the part in the configuration information of report.
Correspondingly, similar with the aforementioned explanation to system shown in Figure 3 setting page, Fig. 6 is only one of statement form page
Specific example, the application is to the element form in statement form page and is not especially limited.
Based on the example of preset Excel template in some embodiments of the present invention shown by Fig. 3-6, Fig. 7 is shown
The flow diagram that the report based on Excel template is realized in some embodiments of the invention.
As shown in fig. 7, the flow includes the resolving to preset Excel template first, based on above-mentioned Excel moulds
Each page of definition in plate, first resolution system set page (step 701), take out the value values of this page of key key, obtain report
Configuration page, querying condition page and statement form page, then parse these pages respectively, that is, parse report configuration page, parsing inquiry
Condition page and parsing statement form page (step 702)；
The above-mentioned parsing to presetting Excel template can be specifically after Excel template is got, by performing program
What the mode of instruction was realized, Apache POI is called to be provided by the way that the program (such as java applet) realized in software programming is middle
API, can realize the read-write capability to Excel form archives, Excel template is parsed by program, parse system therein
The data of page are set to extract the data of other Excel, extract the required SQL of report, the pattern of report, the inquiry of report
Condition and form etc. in web page displaying.
It, on the one hand can be according to parsing report configuration page and the obtained configuration of statement form page after parsing Excel template
Information generates report, on the one hand can be obtained according to the configuration information and resolution system setting page that parsing querying condition page obtains
To for generating the JS files of enquiring component, generate enquiring component；
Specifically, after parsing Excel masterplates, two parts (step 703) is divided into according to obtained configuration information：Extraction
The configuration information of report configuration page and statement form page generates the Excel form reports with self-defined report pattern and (is equivalent to figure
The first report in flow shown in 2) (step 704)；And it extracts the configuration information of querying condition page and obtains system setting page
The JS files for being used to generate enquiring component of middle instruction, generation enquiring component (being equivalent to the enquiring component in flow shown in Fig. 2)
(step 705)；
It, can be according to the querying condition in enquiring component to giving birth to after generating Excel forms report and enquiring component
Into Excel form reports inquired (step 706), according to the querying condition of enquiring component to the Excel lattice of the generation
Data in formula report are filtered, and then, result data (being equivalent to the second above-mentioned report) and enquiring component can be turned
Html form (steps 707) are changed to, html is to browser (step 708) for output, is shown in web page.For example Fig. 8 is shown
The report that some embodiments of the invention are realized is illustrated in the schematic diagram on web page.
Further, by enquiring component, also user can be supported to manually select querying condition (step 709), so as to
It is inquired according to the selected querying condition of user, then to the Excel form reports generated, query result is converted to
The web page that refreshing is shown on browser is output to after html forms.
It can be seen that the configuration information in above-mentioned Excel template in multiple configuration pages can flexibly be set, each configuration page
Functional stratification understands；It can be with configuration querying component and query type in configuration；Report can be with inquiry item before web page displaying
Part filters；Further, it is also possible to the pattern of self-defined generation report.
In conclusion the technical solution provided through the embodiment of the present invention, on the one hand can show on web page
On the other hand Excel reports additionally provide support of the same web page to inquiry Excel reports, in Excel template file
Adding querying condition configuration information so that the report shown on web page can flexibly be generated based on querying condition, quick
To accurate data.Can overcome in current report implementation can not realize the displaying of report and inquiry, nothing in same web page
Many defects such as workload is larger needed for method Flexible Query data, report change.
Based on identical technical concept, the embodiment of the present invention also provides a kind of report realization device based on Excel template,
The device can perform above method embodiment.Fig. 9 shows the report based on Excel template that some embodiments of the invention provide
The structure diagram of realization device, described device include：
Read module 901, for reading preset Excel template, the Excel template includes generating report
Configuration information and the configuration information for generating enquiring component；The enquiring component includes screening looking into for report data
Inquiry condition；
Generation module 902 for generating the configuration information of report according to reading, generates the first report, and root
According to reading for generating the configuration information of enquiring component, enquiring component is generated；
Screening module 903 screens the report in first report for the querying condition in the enquiring component
Data obtain the second report that report data meets the querying condition；
Output module 904, for being output to web page after second report and the enquiring component are converted into html
Upper displaying.
In some embodiments of the invention, screening module 903 are additionally operable to：
It is output on web page after second report and the enquiring component are converted into html by the output module
After displaying, if getting the querying condition selected by the enquiring component shown on the web page, selected by
The querying condition gone out screens the report data in first report, obtain report data meet it is selected go out querying condition
Third report；
Output module 904, is additionally operable to：The third report is converted into after html to be output on the web page and is shown.
In some embodiments of the invention, the configuration information of report style is further included in the Excel template, it is different
Report style corresponds to the different configuration informations for being used to generate report；
Generation module 902, is additionally operable to：
Report style is determined according to the configuration information of report style in the Excel template；According to identified report sample
Formula reads the corresponding configuration information for being used to generate report of the report style.
In some embodiments of the invention, the Excel template includes system setting page and the configuration of at least three
Page；The sub- configuration page of at least three corresponds to a kind of report style；
Include the configuration information of report style, index information, the Yi Jiyong of each sub- configuration page in the system setting page
In the index information of the script language files of generation querying condition；
Being included at least in the first sub- configuration page in 3 sub- configuration pages has what statement form was shown on web page
Configuration information, the configuration information of report name and the configuration information of report database；
It is included at least in the second sub- configuration page in 3 sub- configuration pages and is useful for the inquiry shown on web page
The configuration information of condition, inquiry field name and query type；
The configuration information and report for having statement form are included at least in the sub- configuration page of third in 3 sub- configuration pages
The configuration information of field；
Read module 901, is specifically used for：
Every a line of the system setting page is read, obtains report style, the report style corresponds to each sub- configuration page
The index of index and the script language files for being used to generate querying condition；
Generation module 902, is specifically used for：
According to the described first sub- configuration page and the index of the sub- configuration page of third, the first sub- configuration page and described the are read
Three sub- configuration pages；
According to the configuration information per a line in the described first sub- configuration page and the sub- configuration page of the third, the first report of generation
Table；And
According to the index of the described second sub- configuration page, the second sub- configuration page is read；
According to described for generating the index of the script language files of querying condition, reading is described to be used to generate querying condition
Script language files；
According to the configuration information per a line in the described second sub- configuration page, the script for being used to generate querying condition is used
Language file generates the enquiring component.
In some embodiments of the invention, query window title is further included in the system setting page matches confidence
Breath；The query window title is used to verify report name in first configuration page；Described device further includes：
Correction verification module, for parsing query window title and parsing first configuration that the system setting page obtains
When the report name that page obtains is inconsistent, prompt report style abnormal on web page.
Based on identical technical concept, the report based on Excel template that the above embodiment of the present invention is provided realizes dress
It puts the principle solved the problems, such as and advantageous effect may refer to the report implementation method based on Excel template shown in above-mentioned Fig. 2
The description of embodiment and caused advantageous effect, being somebody's turn to do the implementation of the report realization device based on Excel template can join
See the implementation of the above-mentioned report implementation method embodiment based on Excel template, overlaps will not be repeated.
For software implementation, these technologies can use module (such as program, the function etc. for realizing function described herein
Deng) realize.Software code can store in a memory cell, and be performed by processor.Memory cell can handled
It realizes in device or outside the processor.
The present invention be with reference to according to the method for the embodiment of the present invention, the flow of equipment (system) and computer program product
Figure and/or block diagram describe.It should be understood that it can be realized by computer program instructions every first-class in flowchart and/or the block diagram
The combination of flow and/or box in journey and/or box and flowchart and/or the block diagram.These computer programs can be provided
The processor of all-purpose computer, special purpose computer, Embedded Processor or other programmable data processing devices is instructed to produce
A raw machine so that the instruction performed by computer or the processor of other programmable data processing devices is generated for real
The device of function specified in present one flow of flow chart or one box of multiple flows and/or block diagram or multiple boxes.
These computer program instructions, which may also be stored in, can guide computer or other programmable data processing devices with spy
Determine in the computer-readable memory that mode works so that the instruction generation being stored in the computer-readable memory includes referring to
Enable the manufacture of device, the command device realize in one flow of flow chart or multiple flows and/or one box of block diagram or
The function of being specified in multiple boxes.
These computer program instructions can be also loaded into computer or other programmable data processing devices so that counted
Series of operation steps are performed on calculation machine or other programmable devices to generate computer implemented processing, so as in computer or
The instruction offer performed on other programmable devices is used to implement in one flow of flow chart or multiple flows and/or block diagram one
The step of function of being specified in a box or multiple boxes.
Although the section Example of the present invention has been described, those skilled in the art once know basic creation
Property concept, then additional changes and modifications may be made to these embodiments.So appended claims be intended to be construed to include it is excellent
It selects embodiment and falls into all change and modification of the scope of the invention.
Obviously, various changes and modifications can be made to the invention without departing from model of the invention by those skilled in the art
It encloses.In this way, if these modifications and changes of the present invention belongs within the scope of the claims in the present invention and its equivalent technologies, then
The present invention is also intended to include these modifications and variations.
Claims (10)
1. a kind of report implementation method based on Excel template, which is characterized in that this method includes：
Read preset Excel template, the Excel template includes configuration information for generating report and for generating
The configuration information of enquiring component；The enquiring component includes the querying condition for screening report data；
According to reading for generating the configuration information of report, the first report is generated, and looked into for generating according to reading
The configuration information of component is ask, generates enquiring component；
Querying condition in the enquiring component screens the report data in first report, obtains report data and meets
Second report of the querying condition；
Second report is converted into be output on web page after hypertext markup language html with the enquiring component and is opened up
Show.
2. the method as described in claim 1, which is characterized in that second report and the enquiring component are converted into html
After be output on web page show after, further include：
If getting the querying condition selected by the enquiring component shown on the web page, go out selected by
Querying condition screens the report data in first report, obtain report data meet it is selected go out querying condition the
Three reports；
The third report is converted into after html to be output on the web page and is shown.
3. method as claimed in claim 1 or 2, which is characterized in that the configuration of report style is further included in the Excel template
Information, different report styles correspond to the different configuration informations for being used to generate report；
According to reading for generating the configuration information of report, before generating the first report, further include：
Report style is determined according to the configuration information of report style in the Excel template；
According to identified report style, the corresponding configuration information for being used to generate report of the report style is read.
4. method as claimed in claim 3, which is characterized in that the Excel template includes system setting page and at least 3
A sub- configuration page；The sub- configuration page of at least three corresponds to a kind of report style；
Include the configuration information of report style, the index information of each sub- configuration page and in the system setting page for giving birth to
Into the index information of the script language files of querying condition；
Being included at least in the first sub- configuration page in 3 sub- configuration pages has the configuration that statement form is shown on web page
Information, the configuration information of report name and the configuration information of report database；
In the second sub- configuration page in 3 sub- configuration pages include at least be useful for the querying condition shown on web page,
Inquire the configuration information of field name and query type；
Being included at least in the sub- configuration page of third in 3 sub- configuration pages has the configuration information of statement form and report field
Configuration information；
Preset Excel template is read, including：
Read every a line of system setting page, acquisition report style, the report style correspond to each sub- configuration page index,
And the index of the script language files for being used to generate querying condition；
According to the configuration information for being used to generate report read and the configuration information for showing report, the first report is generated,
Including：
According to the described first sub- configuration page and the index of the sub- configuration page of third, the first sub- configuration page and third are read
Configuration page；
According to the configuration information per a line in the described first sub- configuration page and the sub- configuration page of the third, the first report is generated；
According to the configuration information for being used to generate enquiring component read, enquiring component is generated, including：
According to the index of the described second sub- configuration page, the second sub- configuration page is read；
According to described for generating the index of the script language files of querying condition, the foot for being used to generate querying condition is read
This language file；
According to the configuration information per a line in the described second sub- configuration page, the script for being used to generate querying condition is used
Enquiring component described in file generated.
5. method as claimed in claim 4, which is characterized in that further include query window title in the system setting page
Configuration information；The query window title is used to verify report name in first configuration page；The method is also wrapped
It includes：
If parse the report name that the query window title that the system setting page obtains is obtained with parsing first configuration page
It is inconsistent, then prompt report style abnormal on web page.
6. a kind of report realization device based on Excel template, which is characterized in that the device includes：
Read module, for reading preset Excel template, the Excel template include for generate report with confidence
Breath and the configuration information for generating enquiring component；The enquiring component includes the inquiry item for screening report data
Part；
Generation module, for according to the configuration information read for generating report, generating first report, and according to reading
For generating the configuration information of enquiring component, generate enquiring component；
Screening module is screened the report data in first report for the querying condition in the enquiring component, is obtained
Meet the second report of the querying condition to report data；
Output module, for being output to after second report is converted into hypertext markup language html with the enquiring component
It is shown on web page.
7. device as claimed in claim 6, which is characterized in that the screening module is additionally operable to：
It is output on web page and shows after second report is converted into html by the output module with the enquiring component
Later, if getting the querying condition selected by the enquiring component shown on the web page, go out selected by
Querying condition screens the report data in first report, obtain report data meet it is selected go out querying condition the
Three reports；
The output module, is additionally operable to：
The third report is converted into after html to be output on the web page and is shown.
8. device as claimed in claims 6 or 7, which is characterized in that the configuration of report style is further included in the Excel template
Information, different report styles correspond to the different configuration informations for being used to generate report；
The generation module, is additionally operable to：
Report style is determined according to the configuration information of report style in the Excel template；
According to identified report style, the corresponding configuration information for being used to generate report of the report style is read.
9. device as claimed in claim 8, which is characterized in that the Excel template includes system setting page and at least 3
A sub- configuration page；The sub- configuration page of at least three corresponds to a kind of report style；
Include the configuration information of report style, the index information of each sub- configuration page and in the system setting page for giving birth to
Into the index information of the script language files of querying condition；
Being included at least in the first sub- configuration page in 3 sub- configuration pages has the configuration that statement form is shown on web page
Information, the configuration information of report name and the configuration information of report database；
In the second sub- configuration page in 3 sub- configuration pages include at least be useful for the querying condition shown on web page,
Inquire the configuration information of field name and query type；
Being included at least in the sub- configuration page of third in 3 sub- configuration pages has the configuration information of statement form and report field
Configuration information；
The read module, is specifically used for：
Read every a line of system setting page, acquisition report style, the report style correspond to each sub- configuration page index,
And the index of the script language files for being used to generate querying condition；
The generation module, is specifically used for：
According to the described first sub- configuration page and the index of the sub- configuration page of third, the first sub- configuration page and third are read
Configuration page；
According to the configuration information per a line in the described first sub- configuration page and the sub- configuration page of the third, the first report is generated；With
And
According to the index of the described second sub- configuration page, the second sub- configuration page is read；
According to described for generating the index of the script language files of querying condition, the foot for being used to generate querying condition is read
This language file；
According to the configuration information per a line in the described second sub- configuration page, the script for being used to generate querying condition is used
Enquiring component described in file generated.
10. device as claimed in claim 9, which is characterized in that further included query window title in the system setting page
Configuration information；The query window title is used to verify report name in first configuration page；Described device is also
Including：
Correction verification module, the query window title for being obtained in the parsing system setting page are obtained with parsing first configuration page
When the report name arrived is inconsistent, prompt report style abnormal on web page.
Priority Applications (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN201611264132.0A CN108268525A (en) | 2016-12-30 | 2016-12-30 | A kind of report implementation method and device based on Excel template |
Applications Claiming Priority (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN201611264132.0A CN108268525A (en) | 2016-12-30 | 2016-12-30 | A kind of report implementation method and device based on Excel template |
Publications (1)
| Publication Number | Publication Date |
|---|---|
| CN108268525A true CN108268525A (en) | 2018-07-10 |
Family
ID=62755352
Family Applications (1)
| Application Number | Title | Priority Date | Filing Date |
|---|---|---|---|
| CN201611264132.0A Pending CN108268525A (en) | 2016-12-30 | 2016-12-30 | A kind of report implementation method and device based on Excel template |
Country Status (1)
| Country | Link |
|---|---|
| CN (1) | CN108268525A (en) |
Cited By (12)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN109255114A (en) * | 2018-09-17 | 2019-01-22 | 四川长虹电器股份有限公司 | The system and method for Excel table and legend is generated based on data configuration |
| CN109255065A (en) * | 2018-09-18 | 2019-01-22 | 郑州云海信息技术有限公司 | A kind of method and reporting system of report form processing |
| CN109558552A (en) * | 2018-11-20 | 2019-04-02 | 山东中创软件工程股份有限公司 | A kind of contents access method, device, equipment and the medium of Office file |
| CN109857735A (en) * | 2018-12-29 | 2019-06-07 | 上海瑞家信息技术有限公司 | A kind of data configuration method and system carrying out regular description by excel |
| CN110673848A (en) * | 2019-09-30 | 2020-01-10 | 厦门荆艺软件有限公司 | Enterprise information management system configuration platform based on JavaWeb |
| CN111339087A (en) * | 2020-02-20 | 2020-06-26 | 重庆锐云科技有限公司 | Method for automatically exporting real estate marketing data monitoring result report as Excel file |
| CN112100994A (en) * | 2020-09-27 | 2020-12-18 | 中国建设银行股份有限公司 | Excel-based report display method and device |
| WO2021218178A1 (en) * | 2020-04-28 | 2021-11-04 | 平安科技（深圳）有限公司 | Automatic report generation method, device, computer apparatus, and storage medium |
| CN113962206A (en) * | 2021-10-22 | 2022-01-21 | 中电金信软件有限公司 | Report generation method and device |
| CN115080575A (en) * | 2022-08-23 | 2022-09-20 | 深圳市金政软件技术有限公司 | Componentized table generation method, device, equipment and storage medium |
| CN116340398A (en) * | 2023-05-25 | 2023-06-27 | 北京六一六信息技术有限公司 | Method and system for deriving online custom report query |
| CN116562258A (en) * | 2023-07-05 | 2023-08-08 | 商飞软件有限公司 | Method for generating aircraft histories based on element templates |
Citations (7)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN101650712A (en) * | 2009-08-18 | 2010-02-17 | 深圳市科陆电子科技股份有限公司 | Generating management method and system of self-defined report |
| US20100318451A1 (en) * | 2009-06-12 | 2010-12-16 | MCMCAP Partners, LLC | Systems and methods for asset valuation |
| CN103064689A (en) * | 2013-01-04 | 2013-04-24 | 大唐软件技术股份有限公司 | Implementation method and system for dynamically generating report pages |
| CN103914438A (en) * | 2012-12-30 | 2014-07-09 | 航天信息股份有限公司 | Template and tag implementation based excel display and export method and system |
| CN104573065A (en) * | 2015-01-23 | 2015-04-29 | 广东能龙教育股份有限公司 | Report display engine based on metadata |
| CN105138501A (en) * | 2015-08-10 | 2015-12-09 | 北京思特奇信息技术股份有限公司 | Configurable dynamic report generating method and system |
| US20160132495A1 (en) * | 2014-11-06 | 2016-05-12 | Accenture Global Services Limited | Conversion of documents of different types to a uniform and an editable or a searchable format |
-
2016
- 2016-12-30 CN CN201611264132.0A patent/CN108268525A/en active Pending
Patent Citations (7)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| US20100318451A1 (en) * | 2009-06-12 | 2010-12-16 | MCMCAP Partners, LLC | Systems and methods for asset valuation |
| CN101650712A (en) * | 2009-08-18 | 2010-02-17 | 深圳市科陆电子科技股份有限公司 | Generating management method and system of self-defined report |
| CN103914438A (en) * | 2012-12-30 | 2014-07-09 | 航天信息股份有限公司 | Template and tag implementation based excel display and export method and system |
| CN103064689A (en) * | 2013-01-04 | 2013-04-24 | 大唐软件技术股份有限公司 | Implementation method and system for dynamically generating report pages |
| US20160132495A1 (en) * | 2014-11-06 | 2016-05-12 | Accenture Global Services Limited | Conversion of documents of different types to a uniform and an editable or a searchable format |
| CN104573065A (en) * | 2015-01-23 | 2015-04-29 | 广东能龙教育股份有限公司 | Report display engine based on metadata |
| CN105138501A (en) * | 2015-08-10 | 2015-12-09 | 北京思特奇信息技术股份有限公司 | Configurable dynamic report generating method and system |
Non-Patent Citations (1)
| Title |
|---|
| 黄锦 等: "基于Excel的报表生成工具的设计与实现", 《成都信息工程学院学报》 * |
Cited By (16)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN109255114A (en) * | 2018-09-17 | 2019-01-22 | 四川长虹电器股份有限公司 | The system and method for Excel table and legend is generated based on data configuration |
| CN109255065A (en) * | 2018-09-18 | 2019-01-22 | 郑州云海信息技术有限公司 | A kind of method and reporting system of report form processing |
| CN109558552A (en) * | 2018-11-20 | 2019-04-02 | 山东中创软件工程股份有限公司 | A kind of contents access method, device, equipment and the medium of Office file |
| CN109857735A (en) * | 2018-12-29 | 2019-06-07 | 上海瑞家信息技术有限公司 | A kind of data configuration method and system carrying out regular description by excel |
| CN109857735B (en) * | 2018-12-29 | 2021-05-04 | 上海瑞家信息技术有限公司 | Data construction method and system for rule description through excel |
| CN110673848A (en) * | 2019-09-30 | 2020-01-10 | 厦门荆艺软件有限公司 | Enterprise information management system configuration platform based on JavaWeb |
| CN110673848B (en) * | 2019-09-30 | 2022-12-02 | 厦门荆艺软件有限公司 | Enterprise information management system configuration device based on JavaWeb |
| CN111339087A (en) * | 2020-02-20 | 2020-06-26 | 重庆锐云科技有限公司 | Method for automatically exporting real estate marketing data monitoring result report as Excel file |
| WO2021218178A1 (en) * | 2020-04-28 | 2021-11-04 | 平安科技（深圳）有限公司 | Automatic report generation method, device, computer apparatus, and storage medium |
| CN112100994A (en) * | 2020-09-27 | 2020-12-18 | 中国建设银行股份有限公司 | Excel-based report display method and device |
| CN113962206A (en) * | 2021-10-22 | 2022-01-21 | 中电金信软件有限公司 | Report generation method and device |
| CN115080575A (en) * | 2022-08-23 | 2022-09-20 | 深圳市金政软件技术有限公司 | Componentized table generation method, device, equipment and storage medium |
| CN116340398A (en) * | 2023-05-25 | 2023-06-27 | 北京六一六信息技术有限公司 | Method and system for deriving online custom report query |
| CN116340398B (en) * | 2023-05-25 | 2023-08-18 | 北京六一六信息技术有限公司 | Method and system for deriving online custom report query |
| CN116562258A (en) * | 2023-07-05 | 2023-08-08 | 商飞软件有限公司 | Method for generating aircraft histories based on element templates |
| CN116562258B (en) * | 2023-07-05 | 2023-10-10 | 商飞软件有限公司 | Method for generating aircraft histories based on element templates |
Similar Documents
| Publication | Publication Date | Title |
|---|---|---|
| CN108268525A (en) | A kind of report implementation method and device based on Excel template | |
| CN113094037B (en) | Interaction method, development platform, equipment and storage medium for forms and workflows | |
| JP5255443B2 (en) | Specify, set, and discover parameters for spreadsheet documents | |
| CN109062567B (en) | B/S structure-based information management system rapid development platform | |
| CN106599039B (en) | Statistical representation method supporting free combination nesting of relational database data | |
| CN110543303B (en) | Visual service platform | |
| CN111444696B (en) | Report form display and editing method and device | |
| US20100121879A1 (en) | Data Integration Portlet | |
| CN111126019B (en) | Report generation method and device based on mode customization and electronic equipment | |
| CN107491427A (en) | Data sheet processing method and processing device | |
| US6959429B1 (en) | System for developing data collection software applications | |
| CN104657274B (en) | software interface test method and device | |
| US20130339835A1 (en) | Dynamic presentation of a results set by a form-based software application | |
| CN114995801A (en) | Visual application development method and system based on Internet of things platform | |
| CN113608955A (en) | Log recording method, device, equipment and storage medium | |
| CN115715393A (en) | System and method for dynamically defining digital forms | |
| CN116301856B (en) | Design method, device, equipment and medium of visual form designer | |
| CN109725891A (en) | The method and device that business module quickly generates | |
| CN110928540A (en) | Page generation method and device | |
| CN113485746B (en) | Method and device for generating application program interface document | |
| CN111916164B (en) | Method and device for realizing center-started investigation system in clinical research | |
| CN111858595B (en) | Dynamic configuration method and system for electric power engineering examination record table | |
| CN114840251A (en) | Script processing method, terminal, storage medium and program product | |
| CN114238724A (en) | Data visualization method and device | |
| CN112000366B (en) | System parameter configuration method and device based on code generator |
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: 20180710 |