CN105138497A - Report uploadingmethod in report system and report system - Google Patents
Report uploadingmethod in report system and report system Download PDFInfo
- Publication number
- CN105138497A CN105138497A CN201510411140.2A CN201510411140A CN105138497A CN 105138497 A CN105138497 A CN 105138497A CN 201510411140 A CN201510411140 A CN 201510411140A CN 105138497 A CN105138497 A CN 105138497A
- Authority
- CN
- China
- Prior art keywords
- excel
- reporting system
- user
- excel file
- report
- 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
Landscapes
- Information Retrieval, Db Structures And Fs Structures Therefor (AREA)
Abstract
The invention discloses a report uploadingmethod in a report system. The report uploading method comprises the following steps of: receiving an Excel file imported by a user; identifying the Excel file; and uploadingthe Excel file as a report to the report system for storage. The invention also discloses the report system. According to the report uploadingmethod and the report system, an Excel table format familiar to a user is taken as a report format to report uploading, and thus, the report uploadingmethod and the report system better conform to the operation habit of the user; and moreover, a change of system codes is unnecessary when the user operates field definitions and the like of the Excel table format, namely the report format, and it is more convenient for the user to report.
Description
Technical field
The present invention relates to field of computer technology, particularly relate to the form report method in a kind of reporting system and reporting system.
Background technology
The statement form uploaded in existing reporting system is solidificated in system code, and user can only use the single statement form solidified to carry out typing, upload form.When requiring to need to modify to reporting of user statement form according to different user, system code must be revised, as user need to modify to statement form, the operation such as custom field time all need corresponding amendment system code, bother very much, be not easy to user operation.
Summary of the invention
Fundamental purpose of the present invention is to provide the form report method in a kind of reporting system and reporting system, is intended to facilitate user to carry out form and reports.
For achieving the above object, the form report method in a kind of reporting system provided by the invention, said method comprising the steps of:
Receive the Excel file that user imports;
Identify described Excel file, and described Excel file is reported to reporting system as form store.
Preferably, described Excel file is user-defined Excel form document or the user Excel form document according to the Excel form masterplate typing preset.
Preferably, described reception user import Excel file step before also comprise:
Pre-define the type of different field in Excel form masterplate, logical relation and/or operational formula.
Preferably, the described Excel file of described identification, and described Excel file is reported to as form the step that reporting system carries out storing comprise:
Determine the two-dimensional structure data in described Excel file according to the row and column header field identification of Excel form in described Excel file, and the Excel file identified is reported to reporting system as form store.
Preferably, described form is insurance class data sheet.
In addition, for achieving the above object, the present invention also provides a kind of reporting system, and described reporting system comprises:
Receiver module, for receiving the Excel file that user imports;
Identify reporting module, for identifying described Excel file, and described Excel file is reported to reporting system as form store.
Preferably, described Excel file is user-defined Excel form document or the user Excel form document according to the Excel form masterplate typing preset.
Preferably, also comprise:
Definition module, for the type of different field in pre-defined Excel form masterplate, logical relation and/or operational formula.
Preferably, described identification reporting module also for:
Determine the two-dimensional structure data in described Excel file according to the row and column header field identification of Excel form in described Excel file, and the Excel file identified is reported to reporting system as form store.
Preferably, described form is insurance class data sheet.
Form report method in a kind of reporting system that the present invention proposes and reporting system, when reporting of user form, identify the Excel file that user imports, and this Excel file is reported to reporting system as form store.Owing to being that the Excel table format user be familiar with is as statement form to report form, more meet the operating habit of user, and without the need to revising system code during the operation such as field definition of user to Excel table format also i.e. statement form, convenient user carries out form and reports.
Accompanying drawing explanation
Fig. 1 is the schematic flow sheet of form report method first embodiment in reporting system of the present invention;
Fig. 2 is the schematic flow sheet of form report method second embodiment in reporting system of the present invention;
Fig. 3 is the high-level schematic functional block diagram of reporting system first embodiment of the present invention;
Fig. 4 is the high-level schematic functional block diagram of reporting system second embodiment of the present invention.
The realization of the object of the invention, functional characteristics and advantage will in conjunction with the embodiments, are described further with reference to accompanying drawing.
Embodiment
Should be appreciated that specific embodiment described herein only in order to explain the present invention, be not intended to limit the present invention.
The invention provides the form report method in a kind of reporting system.
With reference to the schematic flow sheet that Fig. 1, Fig. 1 are form report method first embodiment in reporting system of the present invention.
In a first embodiment, the form report method in this reporting system comprises:
Step S10, receives the Excel file that user imports;
In the present embodiment, when user needs to report form in reporting system, be entered into by report data in Excel form, and the Excel file formed is imported reporting system, reporting system receives the Excel file that user imports.
Step S20, identifies described Excel file, and described Excel file is reported to reporting system as form stores.
After receiving the Excel file that user imports, can identify this Excel file, judge that whether this Excel file is meet to carry out the file that reports, as identifiable design judges whether this Excel file is effective document, whether comprises valid data etc. as form.If judge, this Excel meets carries out as form the file that reports, then identify, the valid data obtained in this Excel, and this Excel file is reported to reporting system as form stores.
The present embodiment, when reporting of user form, identifies the Excel file that user imports, and this Excel file is reported to reporting system as form stores.Owing to being that the Excel table format user be familiar with is as statement form to report form, more meet the operating habit of user, and without the need to revising system code during the operation such as field definition of user to Excel table format also i.e. statement form, convenient user carries out form and reports.
Further, in other embodiments, the Excel file that in above-mentioned steps S10, user imports is user-defined Excel form document or the user Excel form document according to the Excel form masterplate typing preset.
Wherein, when this Excel file is user-defined Excel form document, user can according to the requirement of self reported data type user-defined dada type, logic etc. in the Excel form of blank, and typing needs the data reported to form Excel file in self-defining Excel form, and import reporting system, identify for reporting system.When the Excel form document that this Excel file is user according to the Excel form masterplate typing preset, user can obtain pre-set conventional Excel form masterplate from reporting system, and typing needs the data reported to form Excel file in the Excel form masterplate obtained, and import reporting system, identify for reporting system.
As shown in Figure 2, second embodiment of the invention proposes the form report method in a kind of reporting system, on the basis of above-described embodiment, also comprises before above-mentioned steps S10:
Step S30, pre-defines the type of different field in Excel form masterplate, logical relation and/or operational formula.
In the present embodiment, the report data type can commonly used according to the user of reporting system presets the Excel form masterplate of several correspondence, and can pre-define the type of different field in Excel form masterplate, logical relation and/or operational formula.
Concrete, after pre-defining Excel form masterplate, Excel form masterplate is needed to be directed in reporting system, wherein, when importing Excel form masterplate to reporting system, ensure that this Excel form masterplate is closed condition, and when having multiple sheet to show in this Excel form masterplate, need to supply user to select to show as the sheet of form by dropdown arrow.After Excel form masterplate is directed into reporting system, can defines the attribute of cell in Excel form masterplate, comprise the definition of title, index and Articulation.
By providing pre-defined Excel form masterplate for user in the present embodiment, and the type of different field in Excel form masterplate, logical relation and/or operational formula etc. are defined, can by user according to practical application need define the statement form that needs report flexibly, and the statement form reported due to the cell attribute defined function of Excel form self only need be utilized namely to can customize needs, and without the need to carrying out the amendment of system code when defining statement form, convenient, quick.
Further, in other embodiments, above-mentioned steps S20 can comprise:
Determine the two-dimensional structure data in described Excel file according to the row and column header field identification of Excel form in described Excel file, and the Excel file identified is reported to reporting system as form store.
In the present embodiment, after the Excel file receiving user's importing, the valid data in the Excel file that can import user identify.Concrete, the two-dimensional structure data in described Excel file can be determined according to the row and column header field identification of Excel form in described Excel file.Like this, even if owing to there is the nonstandard situation such as null, empty row in the self-defined Excel form document that user imports, reporting system also accurately can identify the valid data in the self-defined Excel form document of user's importing, thus to identify the self-defined Excel form document that user imports be the effective document with valid data, and the self-defined Excel form document that user imports is reported to reporting system as form and stores.
Determined the two-dimensional structure data in described Excel file by the row and column header field identification of Excel form in described Excel file in the present embodiment, thus accurately judge that this Excel file is the report file that can carry out reporting, make user carry out form by self-defined Excel form document and report more flexible, convenient.
Further, in other embodiments, described form is insurance class data sheet.Fast-developing owing to insuring professional intermediary, mechanism's quantity and business scale sustainable growth.Mainly rely on a large amount of insurance class data sheets to manage to insurance intermediaries routine monitoring, and insure the impact that class data sheet relates to the factors such as different object, varying environment, type, the form of different insurance class data sheet are also different.In the present embodiment, when user needs to report insurance class data sheet, the Excel file that user imports is identified, and this Excel file is reported to reporting system as insurance class data sheet store.Owing to being that the Excel table format user be familiar with is as insurance class data sheet form to report form, more meet the operating habit of different object user, and without the need to revising system code during the operation such as field definition of different object user to Excel table format also i.e. statement form, very convenient user carries out insuring class data sheet and reports and routine monitoring to a large amount of insurance class data sheet.
The present invention further provides a kind of reporting system.
With reference to the high-level schematic functional block diagram that Fig. 3, Fig. 3 are reporting system first embodiment of the present invention.
In a first embodiment, this reporting system comprises:
Receiver module 01, for receiving the Excel file that user imports;
In the present embodiment, when user needs to report form in reporting system, be entered into by report data in Excel form, and the Excel file formed is imported reporting system, reporting system receives the Excel file that user imports.
Identify reporting module 02, for identifying described Excel file, and described Excel file is reported to reporting system as form store.
After receiving the Excel file that user imports, can identify this Excel file, judge that whether this Excel file is meet to carry out the file that reports, as identifiable design judges whether this Excel file is effective document, whether comprises valid data etc. as form.If judge, this Excel meets carries out as form the file that reports, then identify, the valid data obtained in this Excel, and this Excel file is reported to reporting system as form stores.
The present embodiment, when reporting of user form, identifies the Excel file that user imports, and this Excel file is reported to reporting system as form stores.Owing to being that the Excel table format user be familiar with is as statement form to report form, more meet the operating habit of user, and without the need to revising system code during the operation such as field definition of user to Excel table format also i.e. statement form, convenient user carries out form and reports.
Further, in other embodiments, the Excel file that the user received in above-mentioned receiver module 01 imports is user-defined Excel form document or the user Excel form document according to the Excel form masterplate typing preset.
Wherein, when this Excel file is user-defined Excel form document, user can according to the requirement of self reported data type user-defined dada type, logic etc. in the Excel form of blank, and typing needs the data reported to form Excel file in self-defining Excel form, and import reporting system, identify for reporting system.When the Excel form document that this Excel file is user according to the Excel form masterplate typing preset, user can obtain pre-set conventional Excel form masterplate from reporting system, and typing needs the data reported to form Excel file in the Excel form masterplate obtained, and import reporting system, identify for reporting system.
As shown in Figure 4, second embodiment of the invention proposes a kind of reporting system, on the basis of above-described embodiment, also comprises:
Definition module 03, for the type of different field in pre-defined Excel form masterplate, logical relation and/or operational formula.
In the present embodiment, the report data type can commonly used according to the user of reporting system presets the Excel form masterplate of several correspondence, and can pre-define the type of different field in Excel form masterplate, logical relation and/or operational formula.
Concrete, after pre-defining Excel form masterplate, Excel form masterplate is needed to be directed in reporting system, wherein, when importing Excel form masterplate to reporting system, ensure that this Excel form masterplate is closed condition, and when having multiple sheet to show in this Excel form masterplate, need to supply user to select to show as the sheet of form by dropdown arrow.After Excel form masterplate is directed into reporting system, can defines the attribute of cell in Excel form masterplate, comprise the definition of title, index and Articulation.
By providing pre-defined Excel form masterplate for user in the present embodiment, and the type of different field in Excel form masterplate, logical relation and/or operational formula etc. are defined, can by user according to practical application need define the statement form that needs report flexibly, and the statement form reported due to the cell attribute defined function of Excel form self only need be utilized namely to can customize needs, and without the need to carrying out the amendment of system code when defining statement form, convenient, quick.
Further, in other embodiments, above-mentioned identification reporting module 02 may be used for:
Determine the two-dimensional structure data in described Excel file according to the row and column header field identification of Excel form in described Excel file, and the Excel file identified is reported to reporting system as form store.
In the present embodiment, after the Excel file receiving user's importing, the valid data in the Excel file that can import user identify.Concrete, the two-dimensional structure data in described Excel file can be determined according to the row and column header field identification of Excel form in described Excel file.Like this, even if owing to there is the nonstandard situation such as null, empty row in the self-defined Excel form document that user imports, reporting system also accurately can identify the valid data in the self-defined Excel form document of user's importing, thus to identify the self-defined Excel form document that user imports be the effective document with valid data, and the self-defined Excel form document that user imports is reported to reporting system as form and stores.
Determined the two-dimensional structure data in described Excel file by the row and column header field identification of Excel form in described Excel file in the present embodiment, thus accurately judge that this Excel file is the report file that can carry out reporting, make user carry out form by self-defined Excel form document and report more flexible, convenient.
Further, in other embodiments, described form is insurance class data sheet.Fast-developing owing to insuring professional intermediary, mechanism's quantity and business scale sustainable growth.Mainly rely on a large amount of insurance class data sheets to manage to insurance intermediaries routine monitoring, and insure the impact that class data sheet relates to the factors such as different object, varying environment, type, the form of different insurance class data sheet are also different.In the present embodiment, when user needs to report insurance class data sheet, the Excel file that user imports is identified, and this Excel file is reported to reporting system as insurance class data sheet store.Owing to being that the Excel table format user be familiar with is as insurance class data sheet form to report form, more meet the operating habit of different object user, and without the need to revising system code during the operation such as field definition of different object user to Excel table format also i.e. statement form, very convenient user carries out insuring class data sheet and reports and routine monitoring to a large amount of insurance class data sheet.
The invention described above embodiment sequence number, just to describing, does not represent the quality of embodiment.Through the above description of the embodiments, those skilled in the art can be well understood to the mode that above-described embodiment method can add required general hardware platform by software and realize, hardware can certainly be passed through, but in a lot of situation, the former is better embodiment.Based on such understanding, technical scheme of the present invention can embody with the form of software product the part that prior art contributes in essence in other words, this computer software product is stored in a storage medium (as ROM/RAM, magnetic disc, CD), comprising some instructions in order to make a station terminal equipment (can be mobile phone, computing machine, server, or the network equipment etc.) perform method described in each embodiment of the present invention.
These are only the preferred embodiments of the present invention; not thereby the scope of the claims of the present invention is limited; every utilize instructions of the present invention and accompanying drawing content to do equivalent structure or equivalent flow process conversion; or be directly or indirectly used in other relevant technical fields, be all in like manner included in scope of patent protection of the present invention.
Claims (10)
1. the form report method in reporting system, is characterized in that, said method comprising the steps of:
Receive the Excel file that user imports;
Identify described Excel file, and described Excel file is reported to reporting system as form store.
2. the form report method in reporting system as claimed in claim 1, is characterized in that, described Excel file is that user-defined Excel form document or user are according to the Excel form document of the Excel form masterplate typing preset.
3. the form report method in reporting system as claimed in claim 2, is characterized in that, also comprises before the step of the Excel file that described reception user imports:
Pre-define the type of different field in Excel form masterplate, logical relation and/or operational formula.
4. the form report method in reporting system as claimed in claim 1 or 2, is characterized in that, the described Excel file of described identification, and described Excel file is reported to as form the step that reporting system carries out storing comprises:
Determine the two-dimensional structure data in described Excel file according to the row and column header field identification of Excel form in described Excel file, and the Excel file identified is reported to reporting system as form store.
5. the form report method in reporting system as claimed in claim 4, is characterized in that, described form is insurance class data sheet.
6. a reporting system, is characterized in that, described reporting system comprises:
Receiver module, for receiving the Excel file that user imports;
Identify reporting module, for identifying described Excel file, and described Excel file is reported to reporting system as form store.
7. reporting system as claimed in claim 6, is characterized in that, described Excel file is that user-defined Excel form document or user are according to the Excel form document of the Excel form masterplate typing preset.
8. reporting system as claimed in claim 7, is characterized in that, also comprise:
Definition module, for the type of different field in pre-defined Excel form masterplate, logical relation and/or operational formula.
9. reporting system as claimed in claims 6 or 7, is characterized in that, described identification reporting module also for:
Determine the two-dimensional structure data in described Excel file according to the row and column header field identification of Excel form in described Excel file, and the Excel file identified is reported to reporting system as form store.
10. reporting system as claimed in claim 9, is characterized in that, described form is insurance class data sheet.
Priority Applications (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN201510411140.2A CN105138497A (en) | 2015-07-13 | 2015-07-13 | Report uploadingmethod in report system and report system |
Applications Claiming Priority (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN201510411140.2A CN105138497A (en) | 2015-07-13 | 2015-07-13 | Report uploadingmethod in report system and report system |
Publications (1)
| Publication Number | Publication Date |
|---|---|
| CN105138497A true CN105138497A (en) | 2015-12-09 |
Family
ID=54723848
Family Applications (1)
| Application Number | Title | Priority Date | Filing Date |
|---|---|---|---|
| CN201510411140.2A Pending CN105138497A (en) | 2015-07-13 | 2015-07-13 | Report uploadingmethod in report system and report system |
Country Status (1)
| Country | Link |
|---|---|
| CN (1) | CN105138497A (en) |
Cited By (2)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN105786785A (en) * | 2016-02-29 | 2016-07-20 | 浪潮软件集团有限公司 | User-defined financial statement collection method |
| WO2019062191A1 (en) * | 2017-09-30 | 2019-04-04 | 平安科技（深圳）有限公司 | Electronic device, method and system for extracting data in data table, and storage medium |
Citations (4)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN101719120A (en) * | 2010-01-28 | 2010-06-02 | 北京中南融海数据软件有限公司 | Method for dynamically generating and processing report data |
| US20120173476A1 (en) * | 2011-01-04 | 2012-07-05 | Nasir Rizvi | System and Method for Rule-Based Asymmetric Data Reporting |
| CN102855229A (en) * | 2011-06-30 | 2013-01-02 | 镇江雅迅软件有限责任公司 | Self-defined statistical report form generating system based on EXCEL form |
| CN103744982A (en) * | 2014-01-15 | 2014-04-23 | 北京神州普惠科技股份有限公司 | Method for importing Excel data into database |
-
2015
- 2015-07-13 CN CN201510411140.2A patent/CN105138497A/en active Pending
Patent Citations (4)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN101719120A (en) * | 2010-01-28 | 2010-06-02 | 北京中南融海数据软件有限公司 | Method for dynamically generating and processing report data |
| US20120173476A1 (en) * | 2011-01-04 | 2012-07-05 | Nasir Rizvi | System and Method for Rule-Based Asymmetric Data Reporting |
| CN102855229A (en) * | 2011-06-30 | 2013-01-02 | 镇江雅迅软件有限责任公司 | Self-defined statistical report form generating system based on EXCEL form |
| CN103744982A (en) * | 2014-01-15 | 2014-04-23 | 北京神州普惠科技股份有限公司 | Method for importing Excel data into database |
Cited By (3)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN105786785A (en) * | 2016-02-29 | 2016-07-20 | 浪潮软件集团有限公司 | User-defined financial statement collection method |
| CN105786785B (en) * | 2016-02-29 | 2018-06-19 | 浪潮软件集团有限公司 | User-defined financial statement collection method |
| WO2019062191A1 (en) * | 2017-09-30 | 2019-04-04 | 平安科技（深圳）有限公司 | Electronic device, method and system for extracting data in data table, and storage medium |
Similar Documents
| Publication | Publication Date | Title |
|---|---|---|
| CN102237969B (en) | Channel state information transmission method and device | |
| CN102609483B (en) | General Excel import method based on configuration | |
| CN105404507A (en) | Process template construction method and system | |
| CN101808370A (en) | Method and device for reporting status information of channel | |
| CN103490962A (en) | Internet of Things access platform system and Internet of Things access method | |
| CN104317839A (en) | Method and device for generating report form template | |
| CN101986588A (en) | Channel state information feedback method and terminal | |
| CN101771510A (en) | Method and system for feeding backing MIMO channel information | |
| CN105279228A (en) | Report processing method and device based on extensible markup language | |
| US20180294849A1 (en) | Method, apparatus and system for acquiring codebook by channel state information report type | |
| CN102468923B (en) | Feedback and obtaining methods of channel state information, and equipment | |
| CN101000677A (en) | Matching method and system of marketing business recommended | |
| CN105138497A (en) | Report uploadingmethod in report system and report system | |
| CN106326062A (en) | Method and device for controlling running state of application program | |
| CN107733506B (en) | CSI processing method, CSI measurement pilot frequency resource transmission method and device | |
| CN106649210A (en) | Data conversion method and device | |
| CN106982445A (en) | A kind of transmission method, equipment and the system of abnormal information of upgrading | |
| CN101751436A (en) | Method and system for generating reports | |
| CN103581846A (en) | User business card updating method and system | |
| CN110889272A (en) | Data processing method, device, equipment and storage medium | |
| CN102468924B (en) | Feedback and acquisition method of channel state information and equipment | |
| CN103034934A (en) | Input method of express packages | |
| CN102831160B (en) | A kind of method and system saved short message | |
| CN105577328A (en) | Channel state information feedback method and terminal | |
| CN101729473B (en) | Method for feeding back quality index of channel and receiver |
Legal Events
| Date | Code | Title | Description |
|---|---|---|---|
| C06 | Publication | ||
| PB01 | Publication | ||
| C10 | Entry into substantive examination | ||
| SE01 | Entry into force of request for substantive examination | ||
| CB02 | Change of applicant information |
Address after: 518057 Shenzhen Software Park, Nanshan District high tech Industrial Park, Guangdong, China,, 6 401-402 Applicant after: Yongxing Shenzhen Polytron Technologies Inc Address before: 518057 Shenzhen Software Park, Nanshan District high tech Industrial Park, Guangdong, China,, 6 401-402 Applicant before: Shenzhen Longrise Technology Co., Ltd. |
|
| COR | Change of bibliographic data | ||
| RJ01 | Rejection of invention patent application after publication | ||
| RJ01 | Rejection of invention patent application after publication |
Application publication date: 20151209 |