CN105354240A - Report file processing method and apparatus - Google Patents
Report file processing method and apparatus Download PDFInfo
- Publication number
- CN105354240A CN105354240A CN201510664418.7A CN201510664418A CN105354240A CN 105354240 A CN105354240 A CN 105354240A CN 201510664418 A CN201510664418 A CN 201510664418A CN 105354240 A CN105354240 A CN 105354240A
- Authority
- CN
- China
- Prior art keywords
- excel
- report
- file
- calculating
- data
- Prior art date
- Legal status (The legal status is an assumption and is not a legal conclusion. Google has not performed a legal analysis and makes no representation as to the accuracy of the status listed.)
- Granted
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
Landscapes
- Engineering & Computer Science (AREA)
- Theoretical Computer Science (AREA)
- Data Mining & Analysis (AREA)
- Databases & Information Systems (AREA)
- Physics & Mathematics (AREA)
- General Engineering & Computer Science (AREA)
- General Physics & Mathematics (AREA)
- Information Retrieval, Db Structures And Fs Structures Therefor (AREA)
Abstract
The present invention provides a method for processing a report file. The method comprises: opening an Excel file in a client, and exporting data of a to-be-processed report file into an Excel table; acquiring a first report object constructed by Excel according to data content in the Excel table, and according to the first report object, calling a server computing interface to compute the Excel table; receiving a computing result returned from the server, converting the computing result into a second report object, and sending the second report object to the Excel for refreshing the Excel table according to the second report object; and acquiring a third report object constructed by Excel according to data content in the refreshed Excel table, and according to the third report object, calling a server storing interface to store the refreshed Excel file. Therefore, complex processing of the report file can be realized online by interaction between Excel and the server in the client, and the deficiency of data processing in an ERP system can be made up for. Moreover, the present invention provides an apparatus for processing the report file.
Description
Technical field
The present invention relates to Computer Applied Technology field, particularly relate to a kind of report file disposal route and device.
Background technology
Current increasing enterprise use ERP (EnterpriseResourcePlanning, Enterprise Resources Plan) system realizes the process to all kinds of things of enterprise.Wherein can often use ERP system and carry out prepare statement, and when adopting ERP system to carry out the process of some complexity to form, as realize by ERP system to the diversified graphic analyses of form with or mutually quoting worksheet cell data, usually cannot realize, thus bring the restriction in use to user.
Summary of the invention
Based on this, be necessary for above-mentioned technical matters, provide a kind of and can realize report file disposal route to the complex process of report file and device.
Process a method for report file, described method comprises: open Excel file in the client, by the statistical conversion in pending report file in Excel form; Obtain the first REPORT-OBJECT that Excel builds according to the data content in described Excel form, call service end according to described first REPORT-OBJECT and calculate Interface realization to the calculating of described Excel form; Receive the result of calculation that service end returns, described result of calculation changed into Secondary Report table object and is sent to Excel, making Excel refresh described Excel form according to described Secondary Report table object; Obtain the 3rd REPORT-OBJECT that Excel builds according to the data content in the Excel form after refreshing, call the preservation of service end saving interface realization to the Excel file after described refreshing according to described 3rd REPORT-OBJECT.
Wherein in an embodiment, the described step opening Excel file in the client, comprising: establish a communications link with Excel; Call third party's class libraries and open Excel file and Excel template file; Call the initialization of client initialization Interface realization to Excel.
Wherein in an embodiment, described according to described first REPORT-OBJECT call service end calculate Interface realization to the step of the calculating of described Excel form, comprise: check whether the calculating data that described first REPORT-OBJECT relates to are up-to-date data, if not, then refresh the calculating data that described first REPORT-OBJECT relates to, realize the calculating to described Excel form according to the calculating data after refreshing.
Wherein in an embodiment, after call the step of service end saving interface realization to the preservation of the Excel file after described refreshing according to described 3rd REPORT-OBJECT, comprising: saving result is changed into the 4th REPORT-OBJECT and send to Excel.
Wherein in an embodiment, described first REPORT-OBJECT, Secondary Report table object, the 3rd REPORT-OBJECT, the 4th REPORT-OBJECT are the character string of JSON form.
Process a device for report file, described device comprises: statistical conversion module, for opening Excel file in the client, by the statistical conversion in pending report file in Excel form; First processing module, for obtaining the first REPORT-OBJECT that Excel builds according to the data content in described Excel form, calling service end according to described first REPORT-OBJECT and calculating Interface realization to the calculating of described Excel form; Second processing module, for receiving the result of calculation that service end returns, changing into Secondary Report table object by described result of calculation and being sent to Excel, makes Excel refresh described Excel form according to described Secondary Report table object; 3rd processing module, for obtaining the 3rd REPORT-OBJECT that Excel builds according to the data content in the Excel form after refreshing, calls the preservation of service end saving interface realization to the Excel file after described refreshing according to described 3rd REPORT-OBJECT.
Wherein in an embodiment, described statistical conversion module is also for establishing a communications link with Excel; Call third party's class libraries and open Excel file and Excel template file; Call the initialization of client initialization Interface realization to Excel.
Wherein in an embodiment, described first processing module is also for checking whether the calculating data that described first REPORT-OBJECT relates to are up-to-date data, if not, then refresh the calculating data that described first REPORT-OBJECT relates to, realize the calculating to described Excel form according to the calculating data after refreshing.
Wherein in an embodiment, described device also comprises: the 4th processing module, sends to Excel for saving result being changed into the 4th REPORT-OBJECT.
Wherein in an embodiment, described first REPORT-OBJECT, Secondary Report table object, the 3rd REPORT-OBJECT, the 4th REPORT-OBJECT are the character string of JSON form.
Above-mentioned report file disposal route and device, by opening Excel file in the client, by the statistical conversion in pending report file in Excel form; Then obtain the first REPORT-OBJECT that Excel builds according to the data content in Excel form, call service end according to the first REPORT-OBJECT and calculate Interface realization to the calculating of Excel form; Receive the result of calculation that service end returns again, result of calculation changed into Secondary Report table object and be sent to Excel, make Excel refresh Excel form according to Secondary Report table object; Finally obtain the 3rd REPORT-OBJECT that Excel builds according to the data content in the Excel form after refreshing, call according to the 3rd REPORT-OBJECT the preservation that service end saving interface realizes the Excel file after to refreshing.Like this, mutual by the client with Excel and service end, canbe used on line is to the complex process of report file.
Accompanying drawing explanation
Fig. 1 is the schematic flow sheet of report file disposal route in an embodiment;
Fig. 2 is the schematic flow sheet opening the step of Excel file in an embodiment in the client;
Fig. 3 is the sequential chart of report file disposal route in an embodiment;
Fig. 4 is the structural representation of report file treating apparatus in an embodiment;
Fig. 5 is the structural representation of report file treating apparatus in another embodiment.
Embodiment
In one embodiment, as shown in Figure 1, provide a kind of report file disposal route, the method may be used in the ERP software of each enterprise.The method comprises:
Step 102, opens Excel file in the client, by the statistical conversion in pending report file in Excel form.
In the present embodiment, when Excel file is opened at the form sequential interface that active user enters into ERP client, ERP client will start Excel process, by the statistical conversion of pending report file in Excel form, and in Excel, show pending report file.The data of pending report file comprise the form attribute, cell data, cell formats, picture, figure selection formula, report item formula, benchmark information, dynamic sieve list information etc. of pending report file, and can be stored in the database in ERP service end.
Step 104, obtains the first REPORT-OBJECT that Excel builds according to the data content in Excel form, calls service end calculate Interface realization to the calculating of Excel form according to the first REPORT-OBJECT.
In the present embodiment, active user can operate Excel form in Excel, as the amendment to cell value in Excel form, Excel form is carried out to diversified graphic analyses or to mutually the quoting of worksheet cell data in Excel form, calculating etc.Excel end, according to obtained current user operation behavior, builds the first REPORT-OBJECT.First REPORT-OBJECT is a kind of character string that can realize exchanges data, have collected all Excel list datas involved by current user operation behavior in this character string.In Excel form, involved cell data, cell formats, picture, figure selection formula, report item formula, benchmark information, dynamically sieve list information etc. are operated as comprised active user.
Concrete, this first REPORT-OBJECT can be an XML (ExtensibleMarkupLanguage, extend markup language) character string of data interchange format, also can be a JSON (JavaScriptObjectNotation, a kind of data interchange format of lightweight) character string, also can be a YAML (YetAnotherMarkupLanguage, another kind of markup language) character string etc.Same, the Secondary Report table object hereinafter occurred, the 3rd REPORT-OBJECT and the 4th REPORT-OBJECT are all the same with the first REPORT-OBJECT, also be a kind of character string that can realize exchanges data, and also can be an XML character string or JSON character string or YAML character string etc.
ERP client receives the first REPORT-OBJECT that Excel builds, and resolves this first REPORT-OBJECT, obtains computing information concrete in the Excel form comprised in this first REPORT-OBJECT.And RPC (RemoteProcedureCallProtocol can be adopted, remote procedure call protocol) agreement call ERP service end calculate port, this computing information is sent to ERP service end, in ERP service end, realizes the calculating of related data involved in Excel.
Step 106, receives the result of calculation that service end returns, result of calculation is changed into Secondary Report table object and be sent to Excel, makes Excel refresh Excel form according to Secondary Report table object.
In the present embodiment, result of calculation, after completing the calculating to the correlation computations information received from ERP client, is returned to ERP client by ERP service end.ERP client receives the result of calculation that ERP service end returns, and generates Secondary Report table object.This Secondary Report table object contains the result of calculation information to the cell data involved by current user operation, cell formats, picture, figure selection formula, report item formula, benchmark information, dynamically sieve list information etc., concrete, this object information also can comprise cell data, cell formats, picture, figure selection formula, report item formula, benchmark information, dynamically sieve list information etc.Generated Secondary Report table object is sent to Excel by ERP client, makes Excel can resolve this Secondary Report table object, gets result of calculation, and refreshes this result of calculation in Excel form.
In one embodiment, be do not allow general active user to modify or situation that general active user does not have authority to modify to it due to partial data can be had in REPORT-OBJECT.Therefore, before this result of calculation is refreshed to Excel form, also detect active user to the authority information of respective cells data modification in this Excel form, when having result of calculation and relating to the cell data that active user in Excel form can not revise, then stop the amendment to the cell data can not revised in Excel form, unchangeable information can be ejected simultaneously.
Step 108, obtains the 3rd REPORT-OBJECT that Excel builds according to the data content in the Excel form after refreshing, calls according to the 3rd REPORT-OBJECT the preservation that service end saving interface realizes the Excel file after to refreshing.
In the present embodiment, after active user processes Excel form, need to preserve it.After Excel gets the preservation operational order of active user, then respond this instruction, generate the 3rd REPORT-OBJECT that the data content in the Excel form after according to refreshing builds, and the 3rd REPORT-OBJECT is sent to ERP client.Concrete, contain the preservation information to Excel table content in the 3rd REPORT-OBJECT.ERP client, after getting the 3rd REPORT-OBJECT, is resolved it, obtains the information of preserving Excel file.And call ERP service end saving interface according to the information of this preservation Excel file, realize the preservation of the Excel file after to refreshing.Same, the saving interface that ERP client can adopt RPC agreement to call ERP service end realizes the preservation of the Excel file after to refreshing.
In the present embodiment, pass through above-mentioned steps, enable ERP client mutual with Excel and ERP service end, canbe used on line is to the complex process of report file, as canbe used on line is quoted mutually to the diversified graphic analyses of report file and multiplex's tabulation cell data, compensate for the deficiency of ERP system to data processing.
In one embodiment, as shown in Figure 2, open the step of Excel file in the client, comprising:
Step 202, establishes a communications link with Excel.
In the present embodiment, when ERP client gets after active user chooses the operational order opening pending report file with Excel, then start communication thread, set up with Excel and communicate.The communication mode of ERP client and Excel can adopt HTTP (HyperTextTransferProtocol, HTML (Hypertext Markup Language)) agreement, TCP (TransmissionControlProtocol, transport control protocol is discussed) agreement, UDP (UserDatagramProtocol, User Datagram Protoco (UDP)) agreement etc.When closing Excel, this communication thread also terminates simultaneously.
Step 204, calls third party's class libraries and opens Excel file and Excel template file.
Concrete, Jacob mode can be adopted to open Excel file.Third party's class libraries can be the database be stored in ERP service end, stores Excel file and Excel template file in this database.Wherein, this Excel template file be ERP client preset a kind of with grand Excel template file.The set of grand VBA (VisualBasicforApplications, the VisualBasic macrolanguage) code for realizing simple function or sophisticated functions in Excel template file.This Excel template file can make ERP client and Excel realize alternately, namely can calculate and the operation such as preservation the pending report file of importing in Excel.
Further, developer can carry out renewal upgrading to Excel template file, makes ERP client can realize with Excel more or mutual more efficiently by upgrading the Excel template file after upgrading.Therefore, in one embodiment, after calling third party's class libraries and opening the step of Excel file and Excel template file, can also check whether Excel template file is up-to-date Excel template file.If so, then Excel template file is upgraded; Otherwise, without the need to upgrading Excel template file.
Step 206, calls the initialization of client initialization Interface realization to Excel.
In the present embodiment, Excel template file http communication mode can initiate initialization Excel request to ERP client.Same, the data layout identical with the first REPORT-OBJECT can be adopted to communicate with ERP client, such as, JSON string format can be adopted to transmit initialization Excel solicited message.ERP client receives the JSON character string that this Excel template file sends, and resolves it, obtains initialization Excel request.Call ERP client initialization Interface realization again to the initialization of Excel, concrete, the mode of reflection can be adopted to call ERP client initialization interface.
In the present embodiment, by establishing a communications link with Excel; Call third party's class libraries open Excel file and be with grand Excel template; Call the initialization of client initialization Interface realization to Excel.What make ERP client can realize with Excel is mutual, and can utilize the powerful data analysis of Excel and the ability of calculating, realizes calculating the pending report file of importing and the operation such as preservation in Excel.
In one embodiment, call service end according to the first REPORT-OBJECT and calculate Interface realization to the step of the calculating of Excel form, comprise: check whether the calculating data that the first REPORT-OBJECT relates to are up-to-date data, if not, then refresh the calculating data that the first REPORT-OBJECT relates to, realize the calculating to Excel form according to the calculating data after refreshing.
In the present embodiment, the pending report file carrying out editing owing to there will be active user is also the situation of the same file that other user is editing.Have updated the data in this pending report file before the calculating that other user may complete pending report file active user, the calculating data that namely may relate to the first REPORT-OBJECT upgrade.
Therefore, whether the calculating data also needing inspection first REPORT-OBJECT to relate to are up-to-date data.Namely check that whether the data that the pending report file that stores in the database of calculating data and the ERP service end related in this Excel form is corresponding are identical.If not identical, then illustrate that the calculating data that the first REPORT-OBJECT relates to are not up-to-date data, now, refresh the calculating data that the first REPORT-OBJECT relates to, realize the calculating to Excel form according to the calculating data after refreshing.If identical, then without the need to refreshing the calculating data that the first REPORT-OBJECT relates to, directly realize the calculating to Excel form according to the calculating data in the first REPORT-OBJECT.
In the present embodiment, by checking whether the calculating data that the first REPORT-OBJECT relates to are up-to-date data, if not, then refresh the calculating data that described first REPORT-OBJECT relates to, realize the calculating to described Excel form according to the calculating data after refreshing.Make ERP client can carry out effective real-time online calculating to pending report file.
In one embodiment, call according to the 3rd REPORT-OBJECT service end saving interface realize to refresh after Excel file preservation step after, comprising: saving result is changed into the 4th REPORT-OBJECT and send to Excel.
In the present embodiment, ERP client, completing after to the preservation to the Excel file after refreshing, also builds the 4th REPORT-OBJECT according to this saving result, and the 4th REPORT-OBJECT is sent to Excel.Comprise the preservation success of this Excel file as the 4th REPORT-OBJECT or preserve unsuccessful information.Excel by receiving the 4th REPORT-OBJECT, and resolves it, obtains the concrete saving result to this Excel file, thus whether active user can be known the preservation of pending report file successful.
In one embodiment, the first REPORT-OBJECT, Secondary Report table object, the 3rd REPORT-OBJECT, the 4th REPORT-OBJECT are the character string of JSON form.
Adopt the character string of JSON form to carry out exchanges data, be not only easy to resolve and generate, what also make between ERP client and Excel, ERP service end is mutual more convenient simultaneously.
In one embodiment, as shown in Figure 3, provide a kind of report file disposal route, the method is to be described at EAS applied environment.Specifically comprise the steps:
Step 302, opens Excel file.
When EAS client gets after active user selects to open with Excel the operational order of pending report file, EAS client terminal start-up Excel process, establishes a communications link with Excel.Open default Excel template file to realize the mutual of EAS client and Excel, and open Excel file in Jacob mode.
Step 304, by the statistical conversion in pending report file in Excel form.
Pending report file is stored in the database of EAS service end, and can by EAS client-access.EAS client by the statistical conversion in pending report file in the Excel form of opened Excel file.The data of pending report file comprise the form attribute, cell data, cell formats, picture, figure selection formula, report item formula, benchmark information, dynamic sieve list information etc. of pending report file.
Step 306, builds a JSON character string.
Excel builds a JSON character string according to obtained active user to the operation behavior of Excel form.Contain all Excel list datas involved by current user operation behavior in one JSON character string, as comprised amendment to cell value in Excel form, Excel form is carried out to diversified graphic analyses or to information such as mutually the quoting of worksheet cell data in Excel form, calculating.And send HTTP request by Excel template file to EAS client, a constructed JSON character string is sent to EAS client.
Step 308, obtains a JSON character string.
EAS client receives the JSON character string that Excel sends, and resolves it, gets the computing information to this Excel form.
Step 310, calls EAS service end and calculates port.
EAS client is called EAS client according to this computing information and is calculated interface, calculating interface calling EAS service end calculating port, completing the calculating to data involved in this Excel form in EAS service end by EAS client.
Step 312, returns result of calculation.
The result of calculation completed is returned to EAS client by EAS service end.
Step 314, builds the 2nd JSON character string according to the result of calculation returned.
EAS client, after getting the result of calculation that EAS service end returns, builds the 2nd JSON character string according to this result of calculation.
Step 316, sends the 2nd JSON character string.
The 2nd constructed JSON character string is sent to Excel by EAS client.
Step 318, builds the 3rd JSON character string.
Excel obtains the 2nd JSON character constructed by EAS client, and resolves it, gets relevant result of calculation, this result of calculation is updated in Excel form, complete the calculating to pending report file.And when getting active user and preserving the operation behavior of this Excel form, then build the 3rd JSON character string.Same, send HTTP request by Excel template file to EAS client, the 3rd constructed JSON character string is sent to EAS client.
Step 320, obtains the 3rd JSON character string.
EAS client receives the 3rd JSON character string that Excel sends, and resolves it, gets the information of preserving Excel.
Step 322, calls EAS service end saving interface.
EAS client calls EAS service end saving interface according to the information of resolving the preservation Excel form obtained, and realizes the preservation to Excel form, namely realizes the preservation to pending report file.
Step 324, returns saving result.
This saving result information, after completing the preservation to pending report file, is sent to EAS client by EAS service end.
Step 326, builds the 4th JSON character string according to the saving result returned.
EAS client builds the 4th JSON character string according to the saving result returned.The saving result information to pending report file is contained, as " preserving successfully " or " preserving unsuccessful " in 4th JSON character string.
Step 328, sends the 4th JSON character string.
The 4th constructed JSON character string is sent to Excel by EAS client, enables Excel by resolving the 4th JSON character string, thus learns the saving result to pending report file.
In above-described embodiment, by in EAS client and Excel and EAS service end mutual, canbe used on line can treat the complex process of EAS process report file, the PivotTables carried as utilized Excel and data analysis capabilities, online generation is shown the diversified graphic analyses of report file and multidimensional report data, makes up the deficiency of EAS system to data processing of knowing clearly.
In one embodiment, as shown in Figure 4, a kind of device processing report file is provided.This device comprises:
Statistical conversion module 402, for opening Excel file in the client, by the statistical conversion in pending report file in Excel form.
First processing module 404, for obtaining the first REPORT-OBJECT that Excel builds according to the data content in Excel form, calling service end according to the first REPORT-OBJECT and calculating Interface realization to the calculating of Excel form.
Second processing module 406, for receiving the result of calculation that service end returns, changing into Secondary Report table object by result of calculation and being sent to Excel, makes Excel refresh Excel form according to Secondary Report table object.
The 3rd REPORT-OBJECT that 3rd processing module 408 builds according to the data content in the Excel form after refreshing for obtaining Excel, calls according to the 3rd REPORT-OBJECT the preservation that service end saving interface realizes the Excel file after to refreshing.
In one embodiment, statistical conversion module 402 is also for establishing a communications link with Excel; Call third party's class libraries and open Excel file and Excel template file; Call the initialization of client initialization Interface realization to Excel.
In one embodiment, first processing module 404 is also for checking whether the calculating data that the first REPORT-OBJECT relates to are up-to-date data, if not, then refresh the calculating data that the first REPORT-OBJECT relates to, realize the calculating to Excel form according to the calculating data after refreshing.
In one embodiment, as shown in Figure 5, the device of another kind of process report file is provided.This device also comprises: the 4th processing module 410, sends to Excel for saving result being changed into the 4th REPORT-OBJECT.
In one embodiment, the first REPORT-OBJECT, Secondary Report table object, the 3rd REPORT-OBJECT, the 4th REPORT-OBJECT are the character string of JSON form.
Each technical characteristic of the above embodiment can combine arbitrarily, for making description succinct, the all possible combination of each technical characteristic in above-described embodiment is not all described, but, as long as the combination of these technical characteristics does not exist contradiction, be all considered to be the scope that this instructions is recorded.
The above embodiment only have expressed several embodiment of the present invention, and it describes comparatively concrete and detailed, but can not therefore be construed as limiting the scope of the patent.It should be pointed out that for the person of ordinary skill of the art, without departing from the inventive concept of the premise, can also make some distortion and improvement, these all belong to protection scope of the present invention.Therefore, the protection domain of patent of the present invention should be as the criterion with claims.
Claims (10)
1. process a method for report file, it is characterized in that, described method comprises:
Open Excel file in the client, by the statistical conversion in pending report file in Excel form;
Obtain the first REPORT-OBJECT that Excel builds according to the data content in described Excel form, call service end according to described first REPORT-OBJECT and calculate Interface realization to the calculating of described Excel form;
Receive the result of calculation that service end returns, described result of calculation changed into Secondary Report table object and is sent to Excel, making Excel refresh described Excel form according to described Secondary Report table object;
Obtain the 3rd REPORT-OBJECT that Excel builds according to the data content in the Excel form after refreshing, call the preservation of service end saving interface realization to the Excel file after described refreshing according to described 3rd REPORT-OBJECT.
2. method according to claim 1, is characterized in that, the described step opening Excel file in the client, comprising:
Establish a communications link with Excel;
Call third party's class libraries and open Excel file and Excel template file;
Call the initialization of client initialization Interface realization to Excel.
3. method according to claim 1, is characterized in that, described according to described first REPORT-OBJECT call service end calculate Interface realization to the step of the calculating of described Excel form, comprising:
Check whether the calculating data that described first REPORT-OBJECT relates to are up-to-date data, if not, then refresh the calculating data that described first REPORT-OBJECT relates to, realize the calculating to described Excel form according to the calculating data after refreshing.
4. method according to claim 1, is characterized in that, after call the step of service end saving interface realization to the preservation of the Excel file after described refreshing according to described 3rd REPORT-OBJECT, comprising:
Saving result is changed into the 4th REPORT-OBJECT and send to Excel.
5. method according to claim 4, is characterized in that, described first REPORT-OBJECT, Secondary Report table object, the 3rd REPORT-OBJECT, the 4th REPORT-OBJECT are the character string of JSON form.
6. process a device for report file, it is characterized in that, described device comprises:
Statistical conversion module, for opening Excel file in the client, by the statistical conversion in pending report file in Excel form;
First processing module, for obtaining the first REPORT-OBJECT that Excel builds according to the data content in described Excel form, calling service end according to described first REPORT-OBJECT and calculating Interface realization to the calculating of described Excel form;
Second processing module, for receiving the result of calculation that service end returns, changing into Secondary Report table object by described result of calculation and being sent to Excel, makes Excel refresh described Excel form according to described Secondary Report table object;
3rd processing module, for obtaining the 3rd REPORT-OBJECT that Excel builds according to the data content in the Excel form after refreshing, calls the preservation of service end saving interface realization to the Excel file after described refreshing according to described 3rd REPORT-OBJECT.
7. device according to claim 6, is characterized in that, described statistical conversion module is also for establishing a communications link with Excel; Call third party's class libraries and open Excel file and Excel template file; Call the initialization of client initialization Interface realization to Excel.
8. device according to claim 6, it is characterized in that, described first processing module is also for checking whether the calculating data that described first REPORT-OBJECT relates to are up-to-date data, if not, then refresh the calculating data that described first REPORT-OBJECT relates to, realize the calculating to described Excel form according to the calculating data after refreshing.
9. device according to claim 6, is characterized in that, described device also comprises:
4th processing module, sends to Excel for saving result being changed into the 4th REPORT-OBJECT.
10. device according to claim 9, is characterized in that, described first REPORT-OBJECT, Secondary Report table object, the 3rd REPORT-OBJECT, the 4th REPORT-OBJECT are the character string of JSON form.
Priority Applications (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN201510664418.7A CN105354240B (en) | 2015-10-14 | 2015-10-14 | Report file treating method and apparatus |
Applications Claiming Priority (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN201510664418.7A CN105354240B (en) | 2015-10-14 | 2015-10-14 | Report file treating method and apparatus |
Publications (2)
| Publication Number | Publication Date |
|---|---|
| CN105354240A true CN105354240A (en) | 2016-02-24 |
| CN105354240B CN105354240B (en) | 2019-09-06 |
Family
ID=55330213
Family Applications (1)
| Application Number | Title | Priority Date | Filing Date |
|---|---|---|---|
| CN201510664418.7A Active CN105354240B (en) | 2015-10-14 | 2015-10-14 | Report file treating method and apparatus |
Country Status (1)
| Country | Link |
|---|---|
| CN (1) | CN105354240B (en) |
Cited By (6)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN107992343A (en) * | 2017-12-08 | 2018-05-04 | 珠海华索软件科技有限公司 | A kind of method and system of logging data |
| CN108897877A (en) * | 2018-07-03 | 2018-11-27 | 浙江赛佳控股有限公司 | Big data analysis tool and method based on EXCEL |
| CN109033059A (en) * | 2018-08-15 | 2018-12-18 | 优信数享（北京）信息技术有限公司 | A kind of calculation method and device of list data |
| CN109658215A (en) * | 2018-12-10 | 2019-04-19 | 平安科技（深圳）有限公司 | Transaction account calculation method, device and computer readable storage medium |
| CN110286269A (en) * | 2019-06-13 | 2019-09-27 | 广合科技（广州）有限公司 | A kind of pcb board impedance information automatic collection and analysis method |
| CN111651968A (en) * | 2020-04-29 | 2020-09-11 | 天津钢铁集团有限公司 | Automatic EXCEL report generation method and system and information data processing terminal |
Citations (7)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| US20050222931A1 (en) * | 2003-08-27 | 2005-10-06 | Ascential Software Corporation | Real time data integration services for financial information data integration |
| CN101650710A (en) * | 2009-08-03 | 2010-02-17 | 金蝶软件（中国）有限公司 | Online software service system as well as method and device for generating report |
| CN103034658A (en) * | 2011-09-29 | 2013-04-10 | 福建睿能电子有限公司 | Method and system for querying data and exporting report |
| CN103294691A (en) * | 2012-02-24 | 2013-09-11 | 镇江华扬信息科技有限公司 | XML (extensive makeup language)-based EXCEL report generation method in JAVA environment |
| CN103646016A (en) * | 2013-12-30 | 2014-03-19 | 金蝶软件（中国）有限公司 | Implementation method of user-defined financial statement and server |
| CN103744982A (en) * | 2014-01-15 | 2014-04-23 | 北京神州普惠科技股份有限公司 | Method for importing Excel data into database |
| CN104572048A (en) * | 2013-10-18 | 2015-04-29 | 镇江鼎拓科技信息有限公司 | XML-based EXCEL report generation method in JSP environment |
-
2015
- 2015-10-14 CN CN201510664418.7A patent/CN105354240B/en active Active
Patent Citations (7)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| US20050222931A1 (en) * | 2003-08-27 | 2005-10-06 | Ascential Software Corporation | Real time data integration services for financial information data integration |
| CN101650710A (en) * | 2009-08-03 | 2010-02-17 | 金蝶软件（中国）有限公司 | Online software service system as well as method and device for generating report |
| CN103034658A (en) * | 2011-09-29 | 2013-04-10 | 福建睿能电子有限公司 | Method and system for querying data and exporting report |
| CN103294691A (en) * | 2012-02-24 | 2013-09-11 | 镇江华扬信息科技有限公司 | XML (extensive makeup language)-based EXCEL report generation method in JAVA environment |
| CN104572048A (en) * | 2013-10-18 | 2015-04-29 | 镇江鼎拓科技信息有限公司 | XML-based EXCEL report generation method in JSP environment |
| CN103646016A (en) * | 2013-12-30 | 2014-03-19 | 金蝶软件（中国）有限公司 | Implementation method of user-defined financial statement and server |
| CN103744982A (en) * | 2014-01-15 | 2014-04-23 | 北京神州普惠科技股份有限公司 | Method for importing Excel data into database |
Non-Patent Citations (1)
| Title |
|---|
| 黄锦,唐慧佳: "基于Excel的报表生成工具的设计与实现", 《成都信息工程学院学报》 * |
Cited By (6)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN107992343A (en) * | 2017-12-08 | 2018-05-04 | 珠海华索软件科技有限公司 | A kind of method and system of logging data |
| CN108897877A (en) * | 2018-07-03 | 2018-11-27 | 浙江赛佳控股有限公司 | Big data analysis tool and method based on EXCEL |
| CN109033059A (en) * | 2018-08-15 | 2018-12-18 | 优信数享（北京）信息技术有限公司 | A kind of calculation method and device of list data |
| CN109658215A (en) * | 2018-12-10 | 2019-04-19 | 平安科技（深圳）有限公司 | Transaction account calculation method, device and computer readable storage medium |
| CN110286269A (en) * | 2019-06-13 | 2019-09-27 | 广合科技（广州）有限公司 | A kind of pcb board impedance information automatic collection and analysis method |
| CN111651968A (en) * | 2020-04-29 | 2020-09-11 | 天津钢铁集团有限公司 | Automatic EXCEL report generation method and system and information data processing terminal |
Also Published As
| Publication number | Publication date |
|---|---|
| CN105354240B (en) | 2019-09-06 |
Similar Documents
| Publication | Publication Date | Title |
|---|---|---|
| CN105354240A (en) | Report file processing method and apparatus | |
| CN111401903B (en) | Block chain message processing method, device, computer and readable storage medium | |
| CN109760041B (en) | Chat robot-based cloud management system and operation method thereof | |
| CN110347560A (en) | Abnormal prompt method, apparatus, system, equipment and the medium of big data product | |
| CN102185901B (en) | Client message conversion method | |
| CN101379785A (en) | Contact list display system and method | |
| CN103854168A (en) | Heterogeneous process to-do task centralized processing method and device | |
| CN112100277A (en) | Method, system, equipment and product for realizing enterprise data chaining prediction machine | |
| CN104462237B (en) | Show the method and device of public's message | |
| CA2511912A1 (en) | System and method for building and execution of platform-neutral generic services' client applications | |
| US20210034338A1 (en) | Communications Enablement Platform, System, and Method | |
| CN109857524B (en) | Stream computing method, device, equipment and computer readable storage medium | |
| CN114760286B (en) | Remote cabinet opening method, device, equipment and storage medium of shared cabinet | |
| CN113626002A (en) | Service execution method and device | |
| CN109189584A (en) | Communication means, device, electronic equipment and storage medium between application program | |
| CN115022304B (en) | Method, device and system for realizing IA (IA-IA) cross-platform file processing based on RPA (remote procedure A) and AI (advanced technology attachment) | |
| CN108900627A (en) | A kind of network request method, terminal installation and storage medium | |
| CN111552901B (en) | H5 cross-engine client data automation updating method and storage medium | |
| US20090106280A1 (en) | Semantic-Based Lossy Compression | |
| RU2604983C2 (en) | Service parsing method flexibly adapted to ims system service tag | |
| CN109725887A (en) | Data interactive method, device and terminal device based on message research and development frame | |
| CN109299173A (en) | Data transmission method, device and storage medium | |
| WO2023208132A1 (en) | Api conversion system and access request processing method therefor, and electronic device and medium | |
| CN117171316A (en) | Service provider dialogue processing method and device, storage medium and electronic equipment | |
| CN117131179A (en) | Dialogue processing method and device, storage medium and electronic equipment |
Legal Events
| Date | Code | Title | Description |
|---|---|---|---|
| C06 | Publication | ||
| PB01 | Publication | ||
| C10 | Entry into substantive examination | ||
| SE01 | Entry into force of request for substantive examination | ||
| GR01 | Patent grant | ||
| GR01 | Patent grant |