CN101183356A - Realization method of Excel report forms and Excel reporting system - Google Patents
Realization method of Excel report forms and Excel reporting system Download PDFInfo
- Publication number
- CN101183356A CN101183356A CNA2007101609888A CN200710160988A CN101183356A CN 101183356 A CN101183356 A CN 101183356A CN A2007101609888 A CNA2007101609888 A CN A2007101609888A CN 200710160988 A CN200710160988 A CN 200710160988A CN 101183356 A CN101183356 A CN 101183356A
- Authority
- CN
- China
- Prior art keywords
- data
- page
- excel
- report
- form template
- 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.)
- Granted
Links
Images
Landscapes
- Management, Administration, Business Operations System, And Electronic Commerce (AREA)
Abstract
The invention discloses an Excel realizing method for formatted reporting, comprising a constructive process for Excel reporting templates and a generative process for Excel, which is characterized in that: by constructing data pages for displaying returned fields of acquired data objects; and regarding the data pages as data sources for pages of the Excel templates in the constructive process of the Excel templates. The invention enables data in the data pages to be directly quoted when the Excel templates or custom Excel templates are constructed while relationships between the data in the data pages and the returned fields of acquired data objects are not needed. The invention also discloses an Excel reporting system; and has the advantages of realizing the separation of data layers from presentation layers, and providing functions as what you see is what you get for the construction of Excel templates.
Description
Technical field
The present invention relates to the form technology, particularly the implementation method of Excel form and Excel reporting system.
Background technology
The function that reporting system is used to create report form template, support form realizes, generates form.Usually, reporting system need provide the report form template of What You See Is What You Get to create function, so that the establishment of report form template fast, efficiently.Below the related key concept of reporting system is briefly introduced:
Template elements: the fundamental element that constitutes report form template; When creating report form template, common value of coming the representation template element with some variable expressions, when generating form, determine the concrete value of relevant variable according to the data that collect, and the value of definite variable expression, then with the value filling template element position of determined variable expression.
The image data object: the image data object is used to carry out data acquisition, obtain data.The image data object can comprise: storing process, SQL statement etc.The image data object can define according to the needs of practical application, that is: define this image data object how to carry out data acquisition, return which field, return field number, return the data type of field etc.
Final user: the user who finally uses form.
Self-defined report: the process that the final user revised or created report form template is called self-defined report.
Because the Excel use is extensive, powerful, editor is flexible, and, can in the Excel file, create chart and form, therefore, some reporting system manufacturers provide the function of Excel report form template in its reporting system, just: with the information carrier of Excel file as report form template, the user can directly create report form template in the Excel file.
The implementation method of existing Excel form may further comprise the steps:
The 1st step: create the Excel report form template.
This step is exactly to create a page (sheet) in the Excel file, and creates some template elements in the described page, and the Excel page that comprises template elements is called the report form template page.In the Excel file during drawing template establishment element (for example: form), directly use the pairing variable of field that returns of image data object to come the constructed variable expression formula.
The 2nd step: generate the Excel form.
The process of the described generation of this step Excel form is: at first resolve the variable in the report form template, and obtain the value of described variable corresponding field from database, determine the value of variable expression then according to described value, the value of determined variable expression is filled into the position at corresponding variable expression place in the Excel file.
The present inventor finds in realizing process of the present invention: above-mentioned existing method is when creating the Excel report form template, directly used the pairing variable of field that returns of image data object to come the constructed variable expression formula, this requires the developer to be familiar with very much the described corresponding relation that returns between field and the variable, the mode of this establishment Excel report form template is very not directly perceived, makes the developer be easy to make mistakes in the process of creating report form template.In addition,, also be difficult to know field and the corresponding relation between the variable in the report form template in the database, therefore, be difficult to the realization self-defined report the final user because the final user is difficult to understand the implication of variable in the report form template.As seen, the implementation method of existing Excel form does not meet the report form template establishment functional requirement of reporting system " What You See Is What You Get ".
Summary of the invention
In view of this, the embodiment of the invention provides a kind of implementation method of Excel form, provides the report form template of What You See Is What You Get to create function.
The embodiment of the invention also provides a kind of Excel reporting system, provides the report form template of What You See Is What You Get to create function.
For achieving the above object, the technical scheme of the embodiment of the invention specifically is achieved in that
A kind of implementation method of Excel form comprises: Excel report form template constructive process and Excel report generation process;
Described Excel report form template constructive process comprises:
In reporting system, create the data form that is used to generate page of data;
According to described data form the data of image data object acquisition are filled into described page of data;
Described page of data is imported the Excel file;
In described Excel file, create the report form template page, the described report form template page with described page of data as Data Source;
With the described Excel file of the page of data and the report form template page that comprises as the Excel report form template;
Described Excel report generation process comprises:
According to described data form the data of image data object acquisition are filled into described page of data;
Described page of data is imported the Excel file;
According to the data in the described page of data, determine the value of corresponding report element in the report form template page, obtain the Excel form.
A kind of Excel reporting system comprises:
Excel report form template creation module, be used for creating the data form that is used to generate page of data at reporting system, according to described data form the data of image data object acquisition are filled into described page of data, described page of data is imported the Excel file, and be used for creating the report form template page at described Excel file, the described report form template page with described page of data as Data Source, with the described Excel file of the page of data and the report form template page that comprises as the Excel report form template;
Excel report generation module, be used for the data of image data object acquisition being filled into described page of data according to described data form, described page of data is imported the Excel file, and be used for data according to described page of data, determine the value of corresponding report element in the report form template page, obtain the Excel form.
As seen from the above technical solution, the implementation method of the Excel form that the embodiment of the invention provides, by in Excel report form template constructive process, creating the page of data of returning field that is used to show the image data object, and with the data source of this page of data as the report form template page, make and when creating report form template or self-defined report template, can directly quote data in the described page of data, and need not to know that data in the described page of data and image data object return the relation between the field.And, because the ability of Excel demonstrating data is very powerful, flexible, the processing that can be mutually between the different pages in the same Excel file carry out relevant data as data source with represent, thereby make the described technical scheme of the embodiment of the invention can by with data Layer with represent layer and separate, provide the report form template of What You See Is What You Get to create function.
Description of drawings
Fig. 1 is the schematic flow sheet of the implementation method of a preferable Excel form in the embodiment of the invention;
Fig. 2 is the composition structural representation of a preferable Excel reporting system in the embodiment of the invention;
Fig. 3 is the structural representation of the form that is used to generate page of data in the embodiment of the invention;
Fig. 4 is the structural representation of the page of data that generates in the embodiment of the invention;
Fig. 5 is the structural representation of the Excel form that generates in the embodiment of the invention.
Embodiment
For making purpose of the present invention, technical scheme and advantage clearer, below with reference to the accompanying drawing embodiment that develops simultaneously, the present invention is described in further detail.
The implementation method of the Excel form that the embodiment of the invention provided comprises: Excel report form template constructive process and Excel report generation process; Wherein:
Described Excel report form template constructive process comprises:
In reporting system, create the data form that is used to generate page of data;
According to described data form the data of image data object acquisition are filled into described page of data;
Described page of data is imported the Excel file;
In described Excel file, create the report form template page, the described report form template page with described page of data as Data Source;
With the described Excel file of the page of data and the report form template page that comprises as the Excel report form template;
Described Excel report generation process comprises:
According to described data form the data of image data object acquisition are filled into described page of data;
Described page of data is imported the Excel file;
According to the data in the described page of data, determine the value of corresponding report element in the report form template page, obtain the Excel form.
An Excel file can comprise a plurality of pages (sheet), arbitrarily the arbitrary element in the page all can be with the arbitrary element in this page or other pages as Data Source, with described Data Source through setting in advance conversion and/or computing after the result that obtains as the value of this element.Element in the described page can be: form, chart etc.
In the implementation method of the above-mentioned Excel form that the embodiment of the invention provided, utilized the above-mentioned characteristic of Excel file.By in Excel report form template constructive process, creating the page of data of returning field that is used to show the image data object, and with the Data Source of this page of data as the report form template page, make and when creating report form template or self-defined report template, can directly quote data in the described page of data, and need not to know that data in the described page of data and image data object return the relation between the field, thereby make the described technical scheme of the embodiment of the invention can realize data Layer and represent separating of layer, provide the report form template of What You See Is What You Get to create function.
Fig. 1 is the schematic flow sheet of the implementation method of a preferable Excel form in the embodiment of the invention.Referring to Fig. 1, this method comprises: Excel report form template constructive process and Excel report generation process, wherein:
Excel report form template constructive process comprises:
Step 101: definition of data source and image data object.
In this step, can be according to the needs definition of data source and the image data object of practical application.Wherein, the definition of data source is exactly: specify the Data Source of report form template, because the image data object can obtain and return field, therefore, the image data object is specified in the definition of data source exactly, and specifies the type etc. of returning field and returning field.Definition image data object is exactly: define this image data object how to carry out data acquisition, return which field, return field number, return the data type of field etc.
Step 102: in reporting system, create data form.
The described data form of the embodiment of the invention is used to generate page of data, and page of data is used for the data that field is returned in appointment that display data sources carry out to specify the image data object to be obtained, is used to the raw data that shows that report form template is required that is:.The requirement that the data form that this step is created need satisfy is: provide the data source of What You See Is What You Get for creating report form template or self-defined report template, that is: make the developer when creating report form template or final user during in the self-defined report template, content that can be shown according to page of data determines to use which data and data in the described page of data of use in report form template how in the page of data in report form template.Therefore, as long as the data form of being created can show the field of returning that gets access in the mode that developer and final user can understand in page of data.Therefore, the simplest mode that realizes the described establishment data form of this step is exactly:
In reporting system, create a form, in described form, create with described data source appointment return field field one to one, using the pairing variable of field that returns of described data source appointment is field assignment corresponding in the described page.Preferably, the field in the described data form can use developer and final user to name than the mode that is easier to understand.
Step 103: use the image data object of the data source execution appointment of described definition, obtain and specify the data of returning field, the data of obtaining are filled in the described page of data according to described data form.
In this step, can take following mode that the data of obtaining are filled in the described page of data: at first, the variable in the resolution data form, then, determine the value of described variable according to the described data of obtaining, and fill the field of correspondence in the described page of data with described definite value.
Step 104: described page of data is imported the Excel file.
Step 105: in described Excel file, create the report form template page, with the Data Source of described page of data as form element in the described report form template page.
After above-mentioned steps, obtained an Excel file that comprises page of data, in this step, can in described Excel file, create at least one page again, as the report form template page, and in the described report form template page drawing template establishment element, for example: form, chart etc.When the drawing template establishment element, with described page of data as data source.
As previously mentioned, Excel has very powerful and the ability of demonstrating data very flexibly, the processing that can be mutually between the different pages and between the element in the page in the same Excel file carry out relevant data as data source with represent, therefore, can use the Excel prior function, with the data source of page of data as the report form template page, the establishment of carrying out report form template with represent.
Excel report generation process comprises:
Step 106: use the image data object of the data source execution appointment of described definition, obtain and specify the data of returning field.
Step 107: the data of obtaining are filled in the described page of data according to described data form.
This step can be filled in the page of data according to the field of returning that the mode identical with step 103 will be obtained, and the data in the page of data can refresh automatically according to the renewal of data in the data source.
Step 108: described page of data is imported the Excel file.
Step 109: according to the data that are presented in the described Excel report generation process in the page of data, determine the value of corresponding report element in the report form template page, obtain the Excel form.
When this step relates to the page in the same Excel file and is data source with another page, how according to the described content of determining described another page as the data in the page of data source.Excel can finish the described operation of this step automatically, obtains the Excel form.
So far, finish the implementation method of present embodiment Excel form.
The page of data of utilizing the embodiment of the invention to be created in Excel report form template constructive process, the final user can realize easily that the Excel report form template is self-defined.The self-defined process of Excel report form template can comprise: in the report form template page of described establishment, create and/or revise and/or deletion form element, described form element with data presented in the described page of data as data source.Certainly, in actual applications, the final user may at first need from reporting system needs to be carried out self-defining report form template and download to this locality, then according to data presented in the page of data, create and/or revise and/or delete the operation of form element at this report form template, and described self-defined report template uploaded in the reporting system, cover original report form template.
As seen from the above technical solution, the implementation method of the Excel form that the embodiment of the invention provides, by in Excel report form template constructive process, creating the page of data of returning field that is used to show the image data object, and with the Data Source of this page of data as the report form template page, make and when creating report form template or self-defined report template, can directly quote data in the described page of data, and need not to know that data in the described page of data and image data object return the relation between the field.And, because the ability of Excel demonstrating data is very powerful, flexible, the processing that can be mutually between the different pages in the same Excel file carry out relevant data as data source with represent, thereby make the described technical scheme of the embodiment of the invention can by with data Layer with represent layer and separate, provide the report form template of What You See Is What You Get to create function.
Corresponding to the method that the embodiment of the invention provided, also provide corresponding Excel reporting system in the embodiment of the invention.This Excel reporting system comprises:
Excel report form template creation module, be used for creating the data form that is used to generate page of data at reporting system, be filled in the described page of data according to the data of described data form the image data object acquisition, described page of data is imported the Excel file, and be used for creating the report form template page at described Excel file, the described report form template page with described page of data as Data Source, with the described Excel file of the page of data and the report form template page that comprises as the Excel report form template;
Excel report generation module, be used for the data of image data object acquisition being filled into described page of data according to described data form, described page of data is imported the Excel file, and be used for data according to described page of data, determine the value of corresponding report element in the report form template page, obtain the Excel form.
Embodiment below in conjunction with description of drawings embodiment of the invention Excel reporting system.
Fig. 2 is the composition structural representation of a preferable Excel reporting system in the embodiment of the invention.Referring to Fig. 2, this Excel reporting system comprises:
Excel report form template creation module 210, be used for definition of data source and image data object, and be used for creating the data form that is used to generate page of data at reporting system, use the image data object of the data source execution appointment of described definition, obtain and specify the data of returning field, according to described data form the data of image data object acquisition are filled into described page of data, with described page of data Excel file, and be used for creating the report form template page at described Excel file, with the Data Source of described page of data as form element in the described report form template page, with the described Excel file of the page of data and the report form template page that comprises as the Excel report form template;
Excel report generation module 220, be used to use the data source of described definition to carry out the image data object of appointment, obtain and specify the data of returning field, be filled in the described page of data according to the data of described data form the image data object acquisition, described page of data is imported the Excel file, and be used for data according to described page of data, and determine the value of corresponding report element in the report form template page, obtain the Excel form.
Can comprise in the Excel report form template creation module 210 shown in Figure 2:
Data source definitions submodule 211 is used for definition of data source and image data object; Described definition of data source comprises: specify the image data object, return field, return the type of field;
Page of data is created submodule 212, be used for creating the data form that is used to generate page of data at reporting system, use the image data object acquisition of the data source execution appointment of described definition to specify the data of returning field, according to described data form the data of image data object acquisition are filled into described page of data, described page of data is imported the Excel file;
Report form template page creation submodule 213, be used for creating the report form template page at described Excel file, in the described report form template page form element with described page of data as Data Source, with the described Excel file of the page of data and the report form template page that comprises as the Excel report form template.
Page of data shown in Figure 2 is created in the submodule 212 and can be comprised:
Data form creating unit 214, be used for creating a form at reporting system, in described form, create with described data source appointment return field field one to one, using the pairing variable of field that returns of described data source appointment is field assignment corresponding in the described page;
Page of data generation unit 215, be used to use described data source to carry out the image data object of appointment, obtain and specify the data of returning field, variable in the resolution data form, the data of returning field according to described appointment of obtaining are determined the value of described variable, with corresponding field in described definite value padding data page;
Page of data imports unit 216, and the page of data that is used for described filling is obtained imports the Excel file.
Can comprise in the Excel report generation module 220 shown in Figure 2:
Data acquisition submodule 221 is used to use the data source of described definition to carry out the image data object of appointment, obtains and specifies the data of returning field;
Page of data generates submodule 222, is used for the variable of resolution data form, returns the value that field is determined described variable according to described data form with what the data acquisition submodule obtained, fills field corresponding in the described page of data with described definite value;
Page of data imports submodule 223, and the page of data that is used for filling is obtained imports the Excel file;
Report generation submodule 224 is used for the data according to the page of data of described importing Excel file, determines the value of corresponding report element in the report form template page, obtains the Excel form.
Can also comprise in the Excel reporting system shown in Figure 2:
Excel report form template custom block 230 is used for creating and/or revising and/or deletion form element at the report form template page of described establishment, described form element with data presented in the described page of data as data source.
Below by a concrete example, illustrate how the technical scheme that the embodiment of the invention provides realizes report capability in Excel.In this example, realize that in Excel report capability comprises the steps:
The 1st step: according to the data in the database, definition of data source and image data object.Suppose this image data object appointment to return field as shown in table 1:
| Field name | Field type |
| The city | String |
| Population | Integer |
| Time | Integer |
| The area | Float |
Table 1
The 2nd step: create a form, this form is used to generate page of data.
Need " time " shown in the indicator gauge 1 and " population " field in the tentation data page, and the hypothesis variable corresponding with " time " field is: XMLDS.Year, the variable corresponding with " population " field is: XMLDS.Population, then the form created of this step can be as shown in Figure 3.Among Fig. 3, Sum: " XMLDS.Population ") expression: to the value summation of population field.
The 3rd step: generate the data of this form, reporting system will import to the result of this form in the Excel file automatically, as the page of data of Excel template, as shown in Figure 4.
The 4th step: supposing needs a report form template, and this report form template will reflect the quantity of each year population with the form of post figure.Can increase a page in comprising the Excel file of page of data, and create a post figure in this page, the employed data of post figure are exactly the data in the Excel file data page, so, can obtain Excel report form template as shown in Figure 5.
The 5th step: by above-mentioned steps, the Excel report form template has been created and has been finished.In follow-up use, when the final user generates form according to this report form template, data in the Excel report form template page of data will refresh automatically according to the data in the data source, and the chart of the report form template page also can refresh according to latest data in the Excel report form template.
The 6th step: if the final user thinks self-defined this report form template (that is: the user wants to revise this report form template), can directly from reporting system, this Excel report form template be downloaded to this locality, in Excel, revise the form element of the corresponding report form template page then, and preserve, upload to reporting system according to the demand of oneself.So far, the final user has just finished the self-defined process of report form template.
As seen from the above-described embodiment, the technical scheme that in Excel, realizes report capability that the embodiment of the invention provided, by in Excel report form template constructive process, creating the page of data of returning field that is used to show the image data object, and with the data source of this page of data as the report form template page, make and when creating report form template or self-defined report template, can directly quote data in the described page of data, and need not to know that data in the described page of data and image data object return the relation between the field.And, because the ability of Excel demonstrating data is very powerful, flexible, the processing that can be mutually between the different pages in the same Excel file carry out relevant data as data source with represent, thereby make the described technical scheme of the embodiment of the invention can by with data Layer with represent layer and separate, provide the report form template of What You See Is What You Get to create function.
One of ordinary skill in the art will appreciate that and realize that the process that realizes report capability in the foregoing description method in Excel can finish by the relevant hardware of programmed instruction, described program can be stored in the read/write memory medium of Excel reporting system, and this program is carried out the corresponding step in the said method when carrying out.Described storage medium can be as ROM/RAM, magnetic disc, CD etc.
The above is preferred embodiment of the present invention only, is not to be used to limit protection scope of the present invention.All any modifications of being done within the spirit and principles in the present invention, be equal to replacement, improvement etc., all should be included within protection scope of the present invention.
Claims (11)
1. the implementation method of an Excel form is characterized in that, comprising: Excel report form template constructive process and Excel report generation process;
Described Excel report form template constructive process comprises:
In reporting system, create the data form that is used to generate page of data;
According to described data form the data of image data object acquisition are filled into described page of data;
Described page of data is imported the Excel file;
In described Excel file, create the report form template page, the described report form template page with described page of data as Data Source;
With the described Excel file of the page of data and the report form template page that comprises as the Excel report form template;
Described Excel report generation process comprises:
According to described data form the data of image data object acquisition are filled into described page of data;
Described page of data is imported the Excel file;
According to the data in the described page of data, determine the value of corresponding report element in the report form template page, obtain the Excel form.
2. the implementation method of Excel form according to claim 1 is characterized in that:
Described Excel report form template constructive process also comprises:
Definition of data source and image data object, described definition of data source comprises: specify the image data object, return field, return the type of field;
Use the image data object of the data source execution appointment of described definition, obtain and specify the data of returning field;
In the report form template page of described establishment, create the form element, with the Data Source of described page of data as form element in the described report form template page;
Described Excel report generation process also comprises: use the image data object of the data source execution appointment of described definition, obtain and specify the data of returning field.
3. the implementation method of Excel form according to claim 2 is characterized in that, after described Excel report form template constructive process, further comprises: the self-defined process of Excel report form template;
The self-defined process of described Excel report form template comprises: in the report form template page of described establishment, create and/or revise and/or deletion form element, described form element with data presented in the described page of data as data source.
4. according to the implementation method of claim 2 or 3 described Excel forms, it is characterized in that, the described data form be used for generating page of data of creating in reporting system comprises: create a form at reporting system, in described form, create with described data source appointment return field field one to one, using the pairing variable of field that returns of described data source appointment is field assignment corresponding in the described page;
Describedly be filled into described page of data and comprise: the variable in the resolution data form according to the field of returning of data form with the image data object acquisition, the data of returning field according to described appointment of obtaining are determined the value of described variable, fill field corresponding in the described page of data with described definite value.
5. according to the implementation method of claim 2 or 3 described Excel forms, it is characterized in that, the described report form template page of in described Excel file, creating, the described report form template page comprises as Data Source with described page of data:
Create a page in described Excel file, create the form element in the described page, using the data in the described page of data is described form element assignment, with the described page as the report form template page.
6. an Excel reporting system is characterized in that, comprising:
Excel report form template creation module, be used for creating the data form that is used to generate page of data at reporting system, according to described data form the data of image data object acquisition are filled into described page of data, described page of data is imported the Excel file, and be used for creating the report form template page at described Excel file, the described report form template page with described page of data as Data Source, with the described Excel file of the page of data and the report form template page that comprises as the Excel report form template;
Excel report generation module, be used for the data of image data object acquisition being filled into described page of data according to described data form, described page of data is imported the Excel file, and be used for data according to described page of data, determine the value of corresponding report element in the report form template page, obtain the Excel form.
7. Excel reporting system according to claim 6 is characterized in that, comprising:
Described Excel report form template creation module, also be used for definition of data source and image data object, use the image data object of the data source execution appointment of described definition, obtain and specify the data of returning field, and be used for creating the form element at the report form template page of described establishment, with the Data Source of described page of data as form element in the described report form template page;
Described Excel report generation module also is used to use the data source of described definition to carry out the image data object of appointment, obtains and specifies the data of returning field.
8. Excel reporting system according to claim 7 is characterized in that, also comprises in the described Excel reporting system:
Excel report form template custom block is used for creating and/or revising and/or deletion form element at the report form template page of described establishment, described form element with data presented in the described page of data as data source.
9. according to claim 7 or 8 described Excel reporting systems, it is characterized in that described Excel report form template creation module comprises:
The data source definitions submodule is used for definition of data source and image data object; Described definition of data source comprises: specify the image data object, return field, return the type of field;
Page of data is created submodule, be used for creating the data form that is used to generate page of data at reporting system, use the image data object acquisition of the data source execution appointment of described definition to specify the data of returning field, according to described data form the data of image data object acquisition are filled into described page of data, described page of data is imported the Excel file;
Report form template page creation submodule, be used for creating the report form template page at described Excel file, in the described report form template page form element with described page of data as Data Source, with the described Excel file of the page of data and the report form template page that comprises as the Excel report form template.
10. Excel reporting system according to claim 9 is characterized in that, described page of data is created submodule and comprised:
The data form creating unit, be used for creating a form at reporting system, in described form, create with described data source appointment return field field one to one, using the pairing variable of field that returns of described data source appointment is field assignment corresponding in the described page;
The page of data generation unit, be used to use described data source to carry out the image data object of appointment, obtain and specify the data of returning field, variable in the resolution data form, the data of returning field according to described appointment of obtaining are determined the value of described variable, with corresponding field in described definite value padding data page;
Page of data imports the unit, and the page of data that is used for described filling is obtained imports the Excel file.
11., it is characterized in that described Excel report generation module comprises according to claim 7 or 8 described Excel reporting systems:
The data acquisition submodule is used to use the data source of described definition to carry out the image data object of appointment, obtains and specifies the data of returning field;
Page of data generates submodule, is used for the variable of resolution data form, returns the value that field is determined described variable according to described data form with what the data acquisition submodule obtained, fills field corresponding in the described page of data with described definite value;
Page of data imports submodule, and the page of data that is used for filling is obtained imports the Excel file;
The report generation submodule is used for the data according to the page of data of described importing Excel file, determines the value of corresponding report element in the report form template page, obtains the Excel form.
Priority Applications (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CNB2007101609888A CN100557602C (en) | 2007-12-14 | 2007-12-14 | The implementation method of Excel form and Excel reporting system |
Applications Claiming Priority (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CNB2007101609888A CN100557602C (en) | 2007-12-14 | 2007-12-14 | The implementation method of Excel form and Excel reporting system |
Publications (2)
| Publication Number | Publication Date |
|---|---|
| CN101183356A true CN101183356A (en) | 2008-05-21 |
| CN100557602C CN100557602C (en) | 2009-11-04 |
Family
ID=39448637
Family Applications (1)
| Application Number | Title | Priority Date | Filing Date |
|---|---|---|---|
| CNB2007101609888A Expired - Fee Related CN100557602C (en) | 2007-12-14 | 2007-12-14 | The implementation method of Excel form and Excel reporting system |
Country Status (1)
| Country | Link |
|---|---|
| CN (1) | CN100557602C (en) |
Cited By (27)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN101436177B (en) * | 2008-12-15 | 2011-01-05 | 北大方正集团有限公司 | Method and apparatus for importing data film to form |
| CN101944082A (en) * | 2010-09-10 | 2011-01-12 | 中国恩菲工程技术有限公司 | Excel-like report processing method |
| CN102163188A (en) * | 2011-04-07 | 2011-08-24 | 北京数码大方科技有限公司 | Generation method and device thereof for EXCEL report in application system |
| CN102467421A (en) * | 2010-11-19 | 2012-05-23 | 深圳市金蝶友商电子商务服务有限公司 | Tenant-data-based processing method and computer |
| CN102880620A (en) * | 2011-07-15 | 2013-01-16 | 深圳市金蝶友商电子商务服务有限公司 | Method for creating spreadsheet |
| CN103383678A (en) * | 2012-05-02 | 2013-11-06 | 富士胶片株式会社 | Data generating apparatus, data generating method, and storage medium |
| CN103810153A (en) * | 2014-02-17 | 2014-05-21 | 深圳市世纪安软信息技术有限公司 | Temperature measurement form generation method and device for temperature measurement terminal and temperature measurement system |
| CN103823793A (en) * | 2014-03-05 | 2014-05-28 | 成都交大光芒科技股份有限公司 | Realizing method for dynamic report based on Excel template |
| CN101661460B (en) * | 2009-09-18 | 2014-09-03 | 上海宝信软件股份有限公司 | Method and device for generating management system report |
| CN104021219A (en) * | 2014-06-23 | 2014-09-03 | 东莞市西奥计算机智能科技有限公司 | Method and device for generating data template |
| CN105022724A (en) * | 2015-06-25 | 2015-11-04 | 中国人民解放军信息工程大学 | Automatic selection method of statistical symbol on the basis of statistical data and charting requirements |
| CN105446948A (en) * | 2015-11-13 | 2016-03-30 | 武汉鸿图节能技术有限公司 | Report automatic generation method and system |
| CN105608132A (en) * | 2015-12-16 | 2016-05-25 | 北京奇虎科技有限公司 | Method and device for providing self-defined diagram generation service |
| CN105740368A (en) * | 2016-01-27 | 2016-07-06 | 浪潮通信信息系统有限公司 | Method and device for generating report form |
| CN106295919A (en) * | 2015-05-13 | 2017-01-04 | 国网辽宁省电力有限公司丹东供电公司 | A kind of distribution transformer protection definite value automatic adjusting interface system |
| CN106649239A (en) * | 2016-12-23 | 2017-05-10 | 郑州云海信息技术有限公司 | Method and device for generating report in cloud monitoring system based on visualization |
| CN106933791A (en) * | 2017-03-10 | 2017-07-07 | 山东浪潮云服务信息科技有限公司 | One kind generation license method and device |
| CN107832371A (en) * | 2017-10-27 | 2018-03-23 | 安徽经邦软件技术有限公司 | A kind of Excel intelligent Matchings import system and method based on financial statement |
| CN107861933A (en) * | 2017-11-29 | 2018-03-30 | 北京百度网讯科技有限公司 | The method and apparatus for generating O＆M form |
| CN108595372A (en) * | 2017-12-27 | 2018-09-28 | 广东电网有限责任公司东莞供电局 | A kind of large-scale data quick calculation method based on 10 KV distribution net generalized information systems |
| CN110502515A (en) * | 2019-08-15 | 2019-11-26 | 中国平安财产保险股份有限公司 | Collecting method, device, equipment and computer readable storage medium |
| CN111221289A (en) * | 2019-04-09 | 2020-06-02 | 国网福建省电力有限公司 | Ammeter data interaction system and method |
| CN111291302A (en) * | 2020-03-20 | 2020-06-16 | 成都药王科技股份有限公司 | Method for quickly creating active page |
| CN111339087A (en) * | 2020-02-20 | 2020-06-26 | 重庆锐云科技有限公司 | Method for automatically exporting real estate marketing data monitoring result report as Excel file |
| CN112015764A (en) * | 2020-08-13 | 2020-12-01 | 仁励家网络科技(杭州)有限公司 | Data processing method and device of business system, electronic equipment and storage medium |
| CN112416209A (en) * | 2020-10-27 | 2021-02-26 | 山东浪潮通软信息科技有限公司 | Filling assembly based on front-end and back-end separation and filling task method |
| CN113126981A (en) * | 2019-12-31 | 2021-07-16 | 贵州医渡云技术有限公司 | Excel-based medical data processing method and device |
-
2007
- 2007-12-14 CN CNB2007101609888A patent/CN100557602C/en not_active Expired - Fee Related
Cited By (38)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN101436177B (en) * | 2008-12-15 | 2011-01-05 | 北大方正集团有限公司 | Method and apparatus for importing data film to form |
| CN101661460B (en) * | 2009-09-18 | 2014-09-03 | 上海宝信软件股份有限公司 | Method and device for generating management system report |
| CN101944082A (en) * | 2010-09-10 | 2011-01-12 | 中国恩菲工程技术有限公司 | Excel-like report processing method |
| CN102467421A (en) * | 2010-11-19 | 2012-05-23 | 深圳市金蝶友商电子商务服务有限公司 | Tenant-data-based processing method and computer |
| CN102467421B (en) * | 2010-11-19 | 2014-04-16 | 深圳市金蝶友商电子商务服务有限公司 | Tenant-data-based processing method and computer |
| CN102163188A (en) * | 2011-04-07 | 2011-08-24 | 北京数码大方科技有限公司 | Generation method and device thereof for EXCEL report in application system |
| CN102880620A (en) * | 2011-07-15 | 2013-01-16 | 深圳市金蝶友商电子商务服务有限公司 | Method for creating spreadsheet |
| CN102880620B (en) * | 2011-07-15 | 2015-07-15 | 深圳市金蝶友商电子商务服务有限公司 | Method for creating spreadsheet |
| CN103383678A (en) * | 2012-05-02 | 2013-11-06 | 富士胶片株式会社 | Data generating apparatus, data generating method, and storage medium |
| CN103810153A (en) * | 2014-02-17 | 2014-05-21 | 深圳市世纪安软信息技术有限公司 | Temperature measurement form generation method and device for temperature measurement terminal and temperature measurement system |
| CN103823793B (en) * | 2014-03-05 | 2016-09-14 | 成都交大光芒科技股份有限公司 | Dynamic statement implementation method based on Excel template |
| CN103823793A (en) * | 2014-03-05 | 2014-05-28 | 成都交大光芒科技股份有限公司 | Realizing method for dynamic report based on Excel template |
| CN104021219A (en) * | 2014-06-23 | 2014-09-03 | 东莞市西奥计算机智能科技有限公司 | Method and device for generating data template |
| CN104021219B (en) * | 2014-06-23 | 2017-07-21 | 广东西奥物联网科技股份有限公司 | The generation method and device of a kind of data template |
| CN106295919A (en) * | 2015-05-13 | 2017-01-04 | 国网辽宁省电力有限公司丹东供电公司 | A kind of distribution transformer protection definite value automatic adjusting interface system |
| CN105022724A (en) * | 2015-06-25 | 2015-11-04 | 中国人民解放军信息工程大学 | Automatic selection method of statistical symbol on the basis of statistical data and charting requirements |
| CN105022724B (en) * | 2015-06-25 | 2018-01-16 | 中国人民解放军信息工程大学 | A kind of statistical symbol automatic selecting method based on statistics with drawing demand |
| CN105446948A (en) * | 2015-11-13 | 2016-03-30 | 武汉鸿图节能技术有限公司 | Report automatic generation method and system |
| CN105608132A (en) * | 2015-12-16 | 2016-05-25 | 北京奇虎科技有限公司 | Method and device for providing self-defined diagram generation service |
| CN105608132B (en) * | 2015-12-16 | 2019-04-30 | 北京奇虎科技有限公司 | It is a kind of that the method and apparatus of the customized service for generating chart are provided |
| CN105740368A (en) * | 2016-01-27 | 2016-07-06 | 浪潮通信信息系统有限公司 | Method and device for generating report form |
| CN106649239A (en) * | 2016-12-23 | 2017-05-10 | 郑州云海信息技术有限公司 | Method and device for generating report in cloud monitoring system based on visualization |
| CN106933791A (en) * | 2017-03-10 | 2017-07-07 | 山东浪潮云服务信息科技有限公司 | One kind generation license method and device |
| CN107832371A (en) * | 2017-10-27 | 2018-03-23 | 安徽经邦软件技术有限公司 | A kind of Excel intelligent Matchings import system and method based on financial statement |
| CN107861933A (en) * | 2017-11-29 | 2018-03-30 | 北京百度网讯科技有限公司 | The method and apparatus for generating O＆M form |
| CN108595372B (en) * | 2017-12-27 | 2020-08-04 | 广东电网有限责任公司东莞供电局 | Large-scale data rapid calculation method based on 10 kV power distribution network GIS system |
| CN108595372A (en) * | 2017-12-27 | 2018-09-28 | 广东电网有限责任公司东莞供电局 | A kind of large-scale data quick calculation method based on 10 KV distribution net generalized information systems |
| CN111221289B (en) * | 2019-04-09 | 2021-07-27 | 国网福建省电力有限公司 | Ammeter data interaction system and method |
| CN111221289A (en) * | 2019-04-09 | 2020-06-02 | 国网福建省电力有限公司 | Ammeter data interaction system and method |
| CN110502515A (en) * | 2019-08-15 | 2019-11-26 | 中国平安财产保险股份有限公司 | Collecting method, device, equipment and computer readable storage medium |
| CN110502515B (en) * | 2019-08-15 | 2023-06-20 | 中国平安财产保险股份有限公司 | Data acquisition method, device, equipment and computer readable storage medium |
| CN113126981A (en) * | 2019-12-31 | 2021-07-16 | 贵州医渡云技术有限公司 | Excel-based medical data processing method and device |
| CN113126981B (en) * | 2019-12-31 | 2023-10-03 | 北京懿医云科技有限公司 | Medical data processing method and device based on Excel |
| CN111339087A (en) * | 2020-02-20 | 2020-06-26 | 重庆锐云科技有限公司 | Method for automatically exporting real estate marketing data monitoring result report as Excel file |
| CN111291302A (en) * | 2020-03-20 | 2020-06-16 | 成都药王科技股份有限公司 | Method for quickly creating active page |
| CN112015764A (en) * | 2020-08-13 | 2020-12-01 | 仁励家网络科技(杭州)有限公司 | Data processing method and device of business system, electronic equipment and storage medium |
| CN112416209A (en) * | 2020-10-27 | 2021-02-26 | 山东浪潮通软信息科技有限公司 | Filling assembly based on front-end and back-end separation and filling task method |
| CN112416209B (en) * | 2020-10-27 | 2022-06-14 | 山东浪潮通软信息科技有限公司 | Filling device based on front-end and back-end separation |
Also Published As
| Publication number | Publication date |
|---|---|
| CN100557602C (en) | 2009-11-04 |
Similar Documents
| Publication | Publication Date | Title |
|---|---|---|
| CN100557602C (en) | The implementation method of Excel form and Excel reporting system | |
| Lomax et al. | Estimating population attribute values in a table:“get me started in” iterative proportional fitting | |
| CN104346149A (en) | Descriptive framework used for data visualization | |
| CN108153886A (en) | User-defined visual methods of exhibiting of the real time data in web applications | |
| CN102779040A (en) | Method and device for generating user-defined form | |
| CN108268525A (en) | A kind of report implementation method and device based on Excel template | |
| CN104881275A (en) | Electronic spreadsheet generating method and device | |
| CN102567027A (en) | Interface framework construction system and interface framework construction method | |
| HUP0004097A2 (en) | Method and system for generating corporate information, as well as providing it for system users | |
| CN106415548B (en) | Computing platform for integrated design of products, materials and manufacturing processes | |
| CN104182484A (en) | Method and device for realizing mapping of HBase data and Java domain objects | |
| CN109684387B (en) | Report generation method and device | |
| Rink et al. | Visual data exploration for hydrological analysis | |
| CN105608119A (en) | Rapid thematic map drawing technology | |
| Chaturvedi et al. | Dynamizers-Modeling and implementing dynamic properties for semantic 3D city models | |
| CN107526813A (en) | A kind for the treatment of method and apparatus for the data that desensitize | |
| Hughes et al. | A generic database and spatial interface for the application of hydrological and water resource models | |
| CN115840567A (en) | Application editing method and related equipment | |
| CN115358204A (en) | Report generation method and device, electronic equipment and storage medium | |
| Žurić et al. | Integrating HBIM and sustainability certification: A pilot study using GBC historic building certification | |
| CN111400799A (en) | Method, system and storage medium for giving non-geometric information of BIM (building information modeling) model | |
| Morel et al. | Managing Temporal Change of Cities with CityGML. | |
| CN114037493A (en) | Method and system for generating bidding document | |
| CN115017348A (en) | Method and device for realizing grid data graph | |
| CN111752552A (en) | Industrial software design and application platform |
Legal Events
| Date | Code | Title | Description |
|---|---|---|---|
| C06 | Publication | ||
| PB01 | Publication | ||
| C10 | Entry into substantive examination | ||
| SE01 | Entry into force of request for substantive examination | ||
| C14 | Grant of patent or utility model | ||
| GR01 | Patent grant | ||
| CF01 | Termination of patent right due to non-payment of annual fee |
Granted publication date: 20091104 Termination date: 20171214 |
|
| CF01 | Termination of patent right due to non-payment of annual fee |