CN110263316A - A kind of document handling method, device and computer equipment - Google Patents
A kind of document handling method, device and computer equipment Download PDFInfo
- Publication number
- CN110263316A CN110263316A CN201910569703.9A CN201910569703A CN110263316A CN 110263316 A CN110263316 A CN 110263316A CN 201910569703 A CN201910569703 A CN 201910569703A CN 110263316 A CN110263316 A CN 110263316A
- Authority
- CN
- China
- Prior art keywords
- file
- field
- data
- typesetting
- fund
- 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
- 238000000034 method Methods 0.000 title claims abstract description 66
- 238000012545 processing Methods 0.000 claims abstract description 36
- 239000003292 glue Substances 0.000 claims description 29
- 230000015654 memory Effects 0.000 claims description 29
- 230000004044 response Effects 0.000 claims description 23
- 238000006243 chemical reaction Methods 0.000 claims description 18
- 230000014759 maintenance of location Effects 0.000 claims description 7
- 238000012360 testing method Methods 0.000 claims description 7
- 238000005516 engineering process Methods 0.000 abstract description 6
- 238000010586 diagram Methods 0.000 description 20
- 230000006870 function Effects 0.000 description 20
- 230000008569 process Effects 0.000 description 20
- 238000012986 modification Methods 0.000 description 13
- 230000004048 modification Effects 0.000 description 13
- 239000003607 modifier Substances 0.000 description 13
- 238000012795 verification Methods 0.000 description 8
- 238000004590 computer program Methods 0.000 description 7
- 238000004891 communication Methods 0.000 description 6
- 238000012937 correction Methods 0.000 description 4
- 238000007689 inspection Methods 0.000 description 4
- 235000013399 edible fruits Nutrition 0.000 description 3
- 229910000906 Bronze Inorganic materials 0.000 description 2
- 230000009286 beneficial effect Effects 0.000 description 2
- 239000010974 bronze Substances 0.000 description 2
- 238000004364 calculation method Methods 0.000 description 2
- KUNSUQLRTQLHQQ-UHFFFAOYSA-N copper tin Chemical compound [Cu].[Sn] KUNSUQLRTQLHQQ-UHFFFAOYSA-N 0.000 description 2
- 238000011161 development Methods 0.000 description 2
- 238000007726 management method Methods 0.000 description 2
- 230000007246 mechanism Effects 0.000 description 2
- 238000011017 operating method Methods 0.000 description 2
- 230000003068 static effect Effects 0.000 description 2
- 230000009471 action Effects 0.000 description 1
- 230000006399 behavior Effects 0.000 description 1
- 230000033228 biological regulation Effects 0.000 description 1
- 230000005540 biological transmission Effects 0.000 description 1
- 230000008859 change Effects 0.000 description 1
- 238000012790 confirmation Methods 0.000 description 1
- 238000013497 data interchange Methods 0.000 description 1
- 238000001514 detection method Methods 0.000 description 1
- 230000003203 everyday effect Effects 0.000 description 1
- 238000009434 installation Methods 0.000 description 1
- 230000010354 integration Effects 0.000 description 1
- 238000004519 manufacturing process Methods 0.000 description 1
- 230000001404 mediated effect Effects 0.000 description 1
- 238000012544 monitoring process Methods 0.000 description 1
- 230000003287 optical effect Effects 0.000 description 1
- 238000005192 partition Methods 0.000 description 1
- 239000007787 solid Substances 0.000 description 1
Classifications
-
- G—PHYSICS
- G06—COMPUTING; CALCULATING OR COUNTING
- G06F—ELECTRIC DIGITAL DATA PROCESSING
- G06F40/00—Handling natural language data
- G06F40/10—Text processing
- G06F40/166—Editing, e.g. inserting or deleting
- G06F40/177—Editing, e.g. inserting or deleting of tables; using ruled lines
- G06F40/18—Editing, e.g. inserting or deleting of tables; using ruled lines of spreadsheets
-
- G—PHYSICS
- G06—COMPUTING; CALCULATING OR COUNTING
- G06F—ELECTRIC DIGITAL DATA PROCESSING
- G06F40/00—Handling natural language data
- G06F40/10—Text processing
- G06F40/189—Automatic justification
Landscapes
- Engineering & Computer Science (AREA)
- Theoretical Computer Science (AREA)
- Health & Medical Sciences (AREA)
- Artificial Intelligence (AREA)
- Audiology, Speech & Language Pathology (AREA)
- Computational Linguistics (AREA)
- General Health & Medical Sciences (AREA)
- Physics & Mathematics (AREA)
- General Engineering & Computer Science (AREA)
- General Physics & Mathematics (AREA)
- Information Retrieval, Db Structures And Fs Structures Therefor (AREA)
- Document Processing Apparatus (AREA)
Abstract
The invention discloses a kind of document handling method, device and computer equipments, are related to financial technology field, for providing a kind of new processing mode for fund file, improve the accuracy of processing fund file.This method comprises: determining fund file to be converted；Read the transaction record data in fund file, wherein, transaction record data include the M strip transaction data formed according to predetermined order splicing, and every strip transaction data in M strip transaction data includes the field data of N number of field, and the field name of each field in N number of field is different；According to the typesetting format of EXCEL file, N number of field of every strip transaction data is divided into N column and EXCEL typesetting is carried out according to the column mark that the column are arranged in the field name of the field of corresponding each column, to obtain the first typesetting result for being directed to transaction record data；According to the first typesetting as a result, generating EXCEL file corresponding with fund file.
Description
Technical field
The present invention relates to financial technology (Fintech) technical field, in particular to a kind of document handling method, device and meters
Calculate machine equipment.
Background technique
In the prior art, with the continuous development of science and technology, more and more technical applications are in financial field, traditional financial industry
Gradually change to financial technology.Specifically, present fund file is both needed to meet central data when carrying out data record
Switching plane open-ended fund business datum exchange agreement, i.e., every transaction data is all fixed in the data file in fund file
Long message, including multiple field parameters.
If only relying on however, needing to check data file or modify etc. processing and manually checking some to position
The corresponding value of field is how many or modifies to the value of the field that not only treatment effeciency is low, but also error-prone.
There is a problem of that treatment effeciency is lower, accuracy is poor when as it can be seen that handling in the prior art fund file.
Summary of the invention
The embodiment of the present invention provides a kind of document handling method, device and computer equipment, for providing for fund file
A kind of new processing mode, to improve the accuracy of processing fund file and improve the efficiency to file process.
In a first aspect, a kind of document handling method is provided, this method comprises:
Determine fund file to be converted；
Read the transaction record data in the fund file, wherein the transaction record data include suitable according to making a reservation for
Sequence splices the M strip transaction data of composition, and every strip transaction data in the M strip transaction data includes N number of field
The field name of field data, each field in N number of field is different, and M and N are the integer more than or equal to 1；
According to the typesetting format of EXCEL file, N number of field of every strip transaction data is divided into N column and according to right
The column mark for answering the field name of the field of each column that the column are arranged carries out EXCEL typesetting, is directed to the transaction record data to obtain
The first typesetting result；
According to first typesetting as a result, generating EXCEL file corresponding with the fund file.
In above-mentioned technical proposal, by the transaction record data formed in fund file according to the N number of field splicing of M row according to general
N number of field of every strip transaction data is divided into N column and the column mark of the column is arranged according to the field name of the field of corresponding each column
The mode for carrying out EXCEL typesetting is known, to realize the division to different field in every strip transaction record data, so as to be convenient for
User clearly knows field contents in every strip transaction record data, to improve the accuracy of processing fund file.
In a kind of optional embodiment, the method also includes:
The field name of N number of field is translated with being different from the second languages of the first languages, to obtain with described
N number of field identification that second languages indicate, wherein the field name of N number of field in the first typesetting result is with described
First languages indicate；
It, will be with second language in such a way that the field identification and column mark for indicating same field name are correspondingly arranged
N number of field identification that kind indicates is correspondingly arranged with N number of column mark in the first typesetting result carries out typesetting for a column respectively,
To obtain the second typesetting result for being directed to N number of field；
Then, according to first typesetting as a result, generating EXCEL file corresponding with the fund file, comprising:
According to the first typesetting result and second typesetting as a result, generating EXCEL corresponding with the fund file
File.
In above-mentioned technical proposal, by being turned over the second languages for being different from the first languages to the field name of N number of field
Translate, and by the second languages indicate N number of field identification respectively in the first typesetting result N number of column mark be correspondingly arranged for
One column carry out typesetting, in this way, can be accustomed to that different language reads is indicated with can directly get field name per family
Meaning, reduce the operation of user, to promote user experience.
In a kind of optional embodiment, the second typesetting for the N subsegment is obtained as a result, including:
According to digit occupied by each field in N number of field, the corresponding digit mark of each field is determined；
The digit of each field is identified into field identification corresponding with the field or arranges the corresponding typesetting of mark, to obtain field
Digit typesetting result；
According to the field digit typesetting as a result, updating the second typesetting result.
In above-mentioned technical proposal, identified by the corresponding digit of each field of determination, then by the digit mark of each field
Know field identification corresponding with the field or column identify corresponding typesetting, to obtain field digit typesetting result, that is to say, that user
It can be seen that the EXCEL file of the digit mark of N number of field is shown, thus when user needs to go to check whether field digit accords with
When closing agreement regulation, it can directly be identified and be determined according to the digit of N number of field of display, improve the processing of processing fund file
Efficiency.
In a kind of optional embodiment, the method also includes:
Determine that the glue file in the fund file describes data, wherein the glue file describe data include with
The identical data of the type for including in all fund files represented by finance data agreement used by the fund file；
Typesetting format of the data in the fund file is described according to the glue file, the glue file is described
Data carry out EXCEL typesetting, to obtain the third typesetting result for describing data for the glue file；
Then, according to first typesetting as a result, generating EXCEL file corresponding with the fund file, comprising:
According to the first typesetting result and the third typesetting as a result, generating EXCEL corresponding with the fund file
File.
In above-mentioned technical proposal, by the glue file in fund file describe data carry out typesetting, then with the first typesetting
As a result combination producing EXCEL file corresponding with fund file, in this case, the EXCEL file of generation is and fund file pair
It answers, the data content that user can be all by the accurate fund file of the EXCEL file promotes the usage experience of user.
In a kind of optional embodiment, after generating EXCEL file corresponding with the fund file, the method is also
Include:
Receive the edit operation for being directed to the EXCEL file；
According to the edit operation, the response of data to be edited to the edit operation in the EXCEL file is determined
As a result；
Legitimacy verifies are carried out to the response results according to the data attribute of the data to be edited；Wherein, described
Data attribute includes digit shared by data and/or data retention rank；
If the test fails, the response to the edit operation is cancelled.
In above-mentioned technical proposal, the edit operation (such as modification operation) for EXCEL file can receive, then basis
Edit operation determines data to be edited in EXCEL file to the response results of edit operation, thus according to data to be edited
Data attribute legitimacy verifies are carried out to response results, that is to say, that, can be with when user edits EXCEL file
It edits data to user to verify, to improve the accuracy of processing file.When verification does not pass through, it can cancel and editor is grasped
The response of work prevents the illegal editor of user in edit operation, with the legal of determination data to be edited
Property.
In a kind of optional embodiment, the method also includes:
Determine EXCEL file to be converted, wherein the EXCEL file to be converted is converted according to fund file
The EXCEL file arrived；
According to the typesetting format of the fund file, typesetting conversion is carried out to the EXCEL file to be converted, to obtain
4th typesetting result；
According to the 4th typesetting as a result, generating fund file corresponding with the EXCEL file to be converted.
In above-mentioned technical proposal, the EXCEL file being converted to according to fund file can also be handled, i.e., according to
The typesetting format of fund file, carries out typesetting conversion to EXCEL file to be converted, then generates and EXCEL to be converted text
The corresponding fund file of part.That is, the EXCEL file reconvert being converted to fund file can be convenient for user
It is handled in transaction record data of the EXCEL file to fund file, then will treated that EXCEL file is converted to base
Inscription on ancient bronze objects part, to promote user experience.
In a kind of optional embodiment, the method also includes:
During being converted to corresponding fund file by the EXCEL file to be converted, critical data is carried out
Legitimacy is examined；Wherein, the critical data includes at least one of field length, number of parameters, number of data lines；
When critical data progress legitimacy is upchecked, then continue by the EXCEL file to be converted
To the conversion of corresponding fund file.
It, can also be in the process for being converted to corresponding fund file by EXCEL file to be converted in above-mentioned technical proposal
In, legitimacy inspection is carried out to critical data, so as to be further ensured that the conjunction for the fund file being converted into EXCEL file
Method improves the accuracy to file process.
Second aspect, the application provide a kind of document handling apparatus, and described device includes:
First determining module, for determining fund file to be converted；
Read module, for reading the transaction record data in the fund file, wherein the transaction record data packet
The M strip transaction data according to predetermined order splicing composition is included, every strip transaction data in the M strip transaction data wraps
The field data of N number of field is included, the field name of each field in N number of field is different, and M and N are to be greater than or wait
In 1 integer；
First type-setting module draws N number of field of every strip transaction data for the typesetting format according to EXCEL file
It is divided into N column and EXCEL typesetting is carried out according to the column mark that the column are arranged in the field name of the field of corresponding each column, is directed to
First typesetting result of the transaction record data；
First processing module is used for according to first typesetting as a result, generating EXCEL text corresponding with the fund file
Part.
In a kind of optional embodiment, described device further includes the second determining module, is used for:
The field name of N number of field is translated with being different from the second languages of the first languages, to obtain with described
N number of field identification that second languages indicate, wherein the field name of N number of field in the first typesetting result is with described
First languages indicate；
Described device further includes the second type-setting module, is used for: according to for indicating the field identification and column of same field name
The mode being correspondingly arranged is identified, by the N number of field identification indicated with second languages respectively and in the first typesetting result
N number of column mark be correspondingly arranged for one column carry out typesetting, with obtain be directed to N number of field the second typesetting result；
Described device further includes Second processing module, is used for: according to the first typesetting result and the second typesetting knot
Fruit generates EXCEL file corresponding with the fund file.
In a kind of optional embodiment, the second determining module is also used to:
According to digit occupied by each field in N number of field, the corresponding digit mark of each field is determined；
Second type-setting module, is used for: the digit of each field being identified field identification corresponding with the field or column identify
Corresponding typesetting, to obtain field digit typesetting result；
According to the field digit typesetting as a result, updating the second typesetting result.
In a kind of optional embodiment, described device further includes third determining module, is used for:
Determine that the glue file in the fund file describes data, wherein the glue file describe data include with
The identical data of the type for including in all fund files represented by finance data agreement used by the fund file；
Described device further includes third type-setting module, is used for: describing data in the fund text according to the glue file
Typesetting format in part describes data to the glue file and carries out EXCEL typesetting, described with obtaining for the glue file
The third typesetting result of data；
Described device further includes third processing module, is used for: according to the first typesetting result and the third typesetting knot
Fruit generates EXCEL file corresponding with the fund file.
In a kind of optional embodiment, described device further includes correction verification module, corresponding with the fund file generating
After EXCEL file, it is used for:
Receive the edit operation for being directed to the EXCEL file；
According to the edit operation, the response of data to be edited to the edit operation in the EXCEL file is determined
As a result；
Legitimacy verifies are carried out to the response results according to the data attribute of the data to be edited；Wherein, described
Data attribute includes digit shared by data and/or data retention rank；
If the test fails, the response to the edit operation is cancelled.
In a kind of optional embodiment, described device further includes conversion module, is used for:
Determine EXCEL file to be converted, wherein the EXCEL file to be converted is converted according to fund file
The EXCEL file arrived；
According to the typesetting format of the fund file, typesetting conversion is carried out to the EXCEL file to be converted, to obtain
4th typesetting result；
According to the 4th typesetting as a result, generating fund file corresponding with the EXCEL file to be converted.
In a kind of optional embodiment, the correction verification module is also used to:
During being converted to corresponding fund file by the EXCEL file to be converted, critical data is carried out
Legitimacy is examined；Wherein, the critical data includes at least one of field length, number of parameters, number of data lines；
The conversion module, is also used to:
When critical data progress legitimacy is upchecked, then continue by the EXCEL file to be converted
To the conversion of corresponding fund file.
The beneficial effect of above-mentioned second aspect and each embodiment of second aspect can refer to above-mentioned first aspect and first
The beneficial effect of each embodiment of aspect, which is not described herein again.
The third aspect, provides a kind of computer equipment, and the computer equipment includes:
Memory, for storing program instruction；
Processor executes first according to the program instruction of acquisition for calling the program instruction stored in the memory
Method includes the steps that either in aspect.
Fourth aspect provides a kind of storage medium, which is stored with computer executable instructions, the computer
Executable instruction for make computer execute first aspect in either method include the steps that.
These aspects or other aspects of the application can more straightforward in the following description.
Detailed description of the invention
In order to illustrate the technical solutions in the embodiments of the present application or in the prior art more clearly, to embodiment or will show below
There is attached drawing needed in technical description to be briefly described, it should be apparent that, the accompanying drawings in the following description is only this
Apply embodiment, for those of ordinary skill in the art, without creative efforts, can also basis mention
The attached drawing of confession obtains other attached drawings.
Fig. 1 be the embodiment of the present application in fund file in content data file schematic diagram；
Fig. 2 is the schematic diagram of data content in data file in fund file in the embodiment of the present application；
Fig. 3 is the interface schematic diagram of the modifier in the embodiment of the present application；
Fig. 4 is the interface schematic diagram of the selection opening ZIP file in the embodiment of the present application；
Fig. 5 is the schematic diagram of the EXCLE file in the embodiment of the present application；
Fig. 6 is the method flow diagram that EXCLE file is converted to fund file in the embodiment of the present application；
Fig. 7 is the flow chart of the document handling method in the embodiment of the present application；
Fig. 8 be the embodiment of the present application in fund file in data file data content arrangement mode schematic diagram；
Fig. 9 be the embodiment of the present application in fund file in data file another schematic diagram of data content arrangement mode；
Figure 10 is the structural block diagram of the document handling apparatus in the embodiment of the present application；
Figure 11 is the structural schematic diagram of the computer equipment in the embodiment of the present application；
Figure 12 is another structural schematic diagram of the computer equipment in the embodiment of the present application.
Specific embodiment
For the purposes, technical schemes and advantages of the application are more clearly understood, below in conjunction in the embodiment of the present application
Attached drawing, the technical scheme in the embodiment of the application is clearly and completely described, it is clear that described embodiment is only
It is some embodiments of the present application, instead of all the embodiments.Based on the embodiment in the application, ordinary skill people
Member's every other embodiment obtained without making creative work, shall fall in the protection scope of this application.?
In the case where not conflicting, the features in the embodiments and the embodiments of the present application can mutual any combination.Although also, flowing
Logical order is shown in journey figure, but in some cases, it can be to be different from shown or described by sequence execution herein
The step of.
Technical solution provided by the embodiments of the present application in order to facilitate understanding, the part that first the embodiment of the present application is used here
Term explains:
1, central data switching plane open-ended fund business datum exchange agreement: the agreement defines asset management product
In (including but not limited to public offering fund, non-public offering fund, set asset management plan etc., in text referred to as " fund ") related service
Used data format, data definition and data content when data exchange are carried out between mechanism.
2, fund file: in accordance with the file letter of central data switching plane open-ended fund business datum exchange agreement specification
Claim fund file, including data directory file and data file.Wherein, the naming rule of data directory file is " OFI/OFJ/
OFS/OFK/OFC "+" _ "+document creation people code+" _ "+file reception people code+" _ "+date (YYYYMMDD)+" .TXT ",
And its content is data file list, the naming rule of data file are as follows: " OFD "+" _ "+document creation people code+" _ "+file
+ two file type coding+" .TXT " contents of (YYYYMMDD)+" _ ", recipient's code+" _ "+date exchange between mechanism
Data content.
3, graphic user interface (Graphical User Interface, GUI): refer to the meter shown using graphics mode
Calculation machine operates user interface.Graphic user interface is a kind of interface display formats that people communicates with computer, and user is allowed to use
The input equipments such as mouse manipulate the icon or menu option on screen, with select command, call file, startup program or execute it
Its some everyday tasks.
4, Tkinter interface: the interface of the standard Tk gui tool packet of Python.
In addition, " multiple " can indicate at least two in the embodiment of the present application, such as it can be two, three or more
Multiple, the embodiment of the present application is with no restrictions.The terms "and/or", only it is a kind of describe affiliated partner incidence relation,
Indicate may exist three kinds of relationships, for example, A and/or B, can indicate: individualism A exists simultaneously A and B, individualism B this
Three kinds of situations.In addition, character "/" herein, in the case where not illustrating, it is a kind of for typicallying represent forward-backward correlation object
The relationship of "or".
Technical solution provided by the embodiments of the present application in order to better understand first introduces the technology of the embodiment of the present application below
Background.
In the prior art, referring to Figure 1, Fig. 1 is the data file schematic diagram in existing traded fund file, fund
Data file in file is to identify i.e. OFDCFDAT by 1 style of writing part, and 8 row fixed fields, fixed field includes center
Data interchange platform open-ended fund business datum exchange agreement version number, information creating people code, information recipient code, number
According to date, file order of transmission mark, file type, sender, recipient, i.e. in Fig. 1 21,03,918,20170106,
999, App Sheet Serial shown in 116, n row field name, that is, Fig. 1 in 04,03,918,1 row field number n, that is, Fig. 1
No、Transaction Cfm Date、Currency Type、Confirmed Vol、Confirmed Amount、Fund
Code, Large Rede mption Flag (8 field names are only shown in Fig. 1) and 1 row data content line number (m) are 8, m
The i.e. 8 row data contents of row data content (partial data content is only shown in Fig. 1) and 1 style of writing part end of identification i.e. OFDCFEND group
At.
Fig. 2 is referred to, Fig. 2 is the data content of the data file in traded fund file shown in Fig. 1, can from figure
To find out the first data content and the second data content includes multiple characters, manually checks or go to text if relying solely on
Part is handled, it is easy to mistake occurs.
In consideration of it, present inventor develops a kind of function of having and fund file is converted into EXCEL file
Modifier, the modifier can be applied in computer equipment.Wherein, which uses python development language and use
Tkinter interface is packaged into exe executable file using Pyinstaller, and in this case, user need not installation python
It is largely convenient for users to use Deng exploitation the integration environment.
Fig. 3 is referred to, is the gui interface of modifier in the application, includes tool log output area in the interface, specifically
, tool log output area includes the particular content for the operation that user is carried out using the time of modifier and user, can be made
User quickly checks processing time and specific treatment process to fund file, so that user can clearly know pair
The treatment process of the action of fund file.Further, tool log output area further includes select file region and function
Energy region, such as generation file, the function of opening xls file, open zip file and hand-off process file shown in Fig. 3.
In the embodiment of the present application, the opening xls file function and opening zip text shown in aforementioned modifications device gui interface
Part function can directly obtain corresponding file, i.e., two functions above-mentioned can make when user uses the two functions
User can not have to that file manager oneself is gone to double-click the generated EXCLE file or fund file of opening, but pass through
Corresponding file can be opened by clicking the functionality buttons that modifier provides, and reduce the operating procedure of user, to improve
To the treatment effeciency of fund file.
In the specific implementation process, when user selects to open ZIP file function, Fig. 4 is referred to, in the GUI of modifier
Interface can show multiple data files and data index file in open fund file, and then user, which can choose, opens it
In a data file then can be with for example, open OFD_03_918_20170106_04.TXT data file as shown in Figure 4
See the content of the data file, and can see data content portion since the mode between field and field being splicing is aobvious
Show, user is caused to be difficult to read and modify.When user opens the OFD_03_918_ of fund file to selection above-mentioned
After 20170106_04.TXT data file carries out generation file operation, Fig. 5 is referred to, Fig. 5 is by the data text in fund file
Part FD_03_918_20170106_04.TXT is converted into the gui interface figure of EXCLE file.
In the embodiment of the present application, the hand-off process file function shown in aforementioned modifications device gui interface, when user uses
When the function, user can easily, quickly switch " fund file changes into excel file " and " excel file changes into fund text
The two functions of part ", that is, reduce the operating procedure of user, save the time, improves the treatment effeciency to fund file.
Further, figure is referred to using the process that modifier handles fund file in the specific implementation process
6, the specific steps are as follows:
Step 601: obtaining the selection operation for being directed to fund file to be processed.
Step 602: according to selection operation, fund file to be processed being converted into EXLCE file.
Step 603: obtaining the processing operation for opening xls file, and the EX LCE file generated according to processing operation display.
Step 604: obtaining the modification for the EXLCE file of display or check operation, and according to modifying or check operation
To EXLCE file process, to obtain target EXLCE file.
Step 605: obtaining the conversion operation for being directed to target EXLCE file, target EXLCE file is converted into target fund
File.
Step 606: the inspection obtained for target fund file operates, to check the fund file generated.
As previously mentioned, modifier, which can be used, in user is converted into EXLCE file for fund file, then using utilization
The search of the offer of EXLCE, the functions such as hiding, can quickly navigate to the certain field of data file in fund file, then
The processing such as the field is checked or modified, unnecessary field can also be hidden.Further, it can also modify again
In EXLCE file after the value of certain field, the hand-off process file function that can reuse modifier converts EXLCE file to
Fund file.
The implementation principle part for being by fund file to be processed conversion EXLCE file in this programme is described in detail below, asks
It is the flow chart of the document handling method in the embodiment of the present application referring to Fig. 7, Fig. 7.
Step 701: determining fund file to be converted.
Step 702: reading the transaction record data in fund file, wherein transaction record data include suitable according to making a reservation for
Sequence splices the M strip transaction data of composition, and every strip transaction data in M strip transaction data includes the field of N number of field
The field name of data, each field in N number of field is different, and M and N are the integer more than or equal to 1.
In the embodiment of the present application, the method that the application proposition can be executed by modifier above-mentioned, specifically, can
To be that user clicks fund file above-mentioned and determines fund file to be converted.
When modifier obtains the operation for the data file progress in fund file, modifier can obtain data text
Data content in data file for ease of description, is referred to as note of trading in the embodiment of the present application by the data content in part
Record data, wherein transaction record data include according to the M strip transaction data of predetermined order splicing composition, M strip transaction data
In every strip transaction data include N number of field field data, each not phase of the field name of each field in N number of field
Together.
For example, as shown in figure 8, transaction record data include 3 strip transaction record data, the respectively first son transaction note altogether
Record data, the second sub- transaction record data and the sub- transaction record data of third, and the first sub- transaction record data, the second son transaction
Record data and the sub- transaction record data of third respectively include field 1, field 2, field 3, field 4, field 5, field 6, field
7, field 8.Continuing with reference to Fig. 8, the first sub- transaction record data are by field 1, field 2, field 3, field 4, field 5, word
Section 6, field 7 and the corresponding data of field 8 are spliced to form.Further, transaction record data can also be by first
Sub- transaction record data, the second sub- transaction record data and the sub- transaction record data of third are spliced to form.In addition, in Fig. 8
First sub- transaction record data, the first sub- transaction record data, the second sub- transaction record data and the transaction of third can be managed
Solution is the data content in attached drawing 1.
It in practical applications, include predetermined mark between every strip transaction record data, wherein predetermined mark is used for will
Data between sub- transaction record data separate, specifically, predetermined mark can be space, can also be *, it is of course also possible to
For #, in the embodiment of the present application without limitation.
For example, transaction record data include 3 strip transaction record data altogether as shown in figure 9, predetermined be identified as space, point
Not Wei the first sub- transaction record data, the second sub- transaction record data and the sub- transaction record data of third, and first son transaction note
Record data, the second sub- transaction record data and the sub- transaction record data of third respectively include field 1, field 2, field 3, field 4,
Field 5.Continuing with reference to Fig. 9, the first sub- transaction record data can also be by field 1, field 2, field 3, field 4 and
The corresponding data of field 5 are spliced to form, and the second sub- transaction record data and the sub- transaction record data of third are also by field
1, field 2, field 3, field 4 and the corresponding data of field 5 are spliced to form.First sub- transaction record data and second
Include space among sub- transaction record data, includes sky between the second sub- transaction record data and the sub- transaction record data of third
Lattice.In this way, the first sub- transaction record data, the second sub- transaction record data and the sub- transaction record number of third can be distinguished clearly
According to.
Step 703: according to the typesetting format of EXCEL file, by N number of field of every strip transaction data be divided into N arrange with
And EXCEL typesetting is carried out according to the column mark that the column are arranged in the field name of the field of corresponding each column, the transaction is directed to obtain
Record the first typesetting result of data；
It in the embodiment of the present application, can be according to EXCEL file after reading the transaction record data in fund file
N number of field of every strip transaction data is divided into N column and is arranged according to the field name of the field of corresponding each column by typesetting format
The column mark of the column carries out EXCEL typesetting.That is, by every strip transaction data by splicing N number of field of arrangement originally, often
A field occupies a column, and the mode that every strip transaction data occupies a line carries out typesetting to transaction record data.
In the specific implementation process, with transaction record data instance as shown in Figure 4, according to the typesetting of EXCEL file
Transaction record data are divided into row and column to carry out typesetting to transaction record data, specifically, can be according to N number of by format
The character length limitation of each field in field, to the division that every strip transaction record data are arranged, it is hereby achieved that row
Version result.That is, by the division mode of row and column, so that the display of transaction record data is clearer, thus user
The content of each field can be accurately known, to enhance the accuracy of the processing to fund file.
Step 704: according to first typesetting as a result, generating EXCEL file corresponding with the fund file.
In the embodiment of the present application, it can arrange and according to N number of field of every strip transaction data is divided into N according to right
The column mark for answering the field name of the field of each column that the column are arranged carries out the first typesetting of EXCEL typesetting acquisition as a result, generation and base
The corresponding EXCEL file of inscription on ancient bronze objects part.
That is, by the field name for including in sub- transaction record data and sub- transaction record data N Jing Guo typesetting
The corresponding arrangement of column data, is then as previously described handled transaction record data, so as to generate and fund file
Corresponding EXCEL file.
Fig. 5 specifically is referred to, field name is shown in the 13rd row in EXCEL file, and 14-18 row shows to be fund
The transaction record data of file, such display mode, user can understand the content for determining field, so as to accurately right
Field contents are checked and/or modification processing, improve the treatment effeciency to fund file.
Specifically, can also determine target configuration corresponding with target fund file in a kind of possible embodiment
File determines the field name with each field, then with difference according to the field name of N number of field from target configuration file
The field name of N number of field is translated in the second languages of the first languages, to obtain the N number of field mark indicated with the second languages
Know, wherein the field name of N number of field in the first typesetting result is indicated with the first languages；For example, the first languages of field name are
English, N number of field identification that the second languages can indicate for the languages such as Chinese, German, French, Portuguese, i.e. the second languages
It can be the field identification of Chinese, or the field identification of French.
It then, will be with the second language in such a way that the field identification and column mark for indicating same field name are correspondingly arranged
N number of field identification that kind indicates is correspondingly arranged with N number of column mark in the first typesetting result carries out typesetting for a column respectively, thus
Obtain the second typesetting result for being directed to N number of field.It is possible to further according to the first typesetting result and the second typesetting as a result, raw
At EXCEL file corresponding with fund file.
For example, it is shown in Figure 5, it is converted using the field identification that the second languages indicate as Chinese.In this case, may be used
So that the user of different language accustomed to using can clearly know field name, user experience is promoted.
Specifically, in a kind of possible embodiment, it can also the position according to occupied by each field in N number of field
Number determines the corresponding digit mark of each field, the digit of each field is then identified field identification corresponding with the field
Or column identify corresponding typesetting, to obtain the typesetting of field digit as a result, according to the typesetting of field digit as a result, updating the second typesetting knot
Fruit.
Please continue to refer to Fig. 5, wherein the field identification of each field and the data bits of each field are in a column, this
It if sample, can targetedly be modified in order to user when modifying, reduce appearance modification digit as far as possible and agreement is wanted
Seek inconsistent problem.
Specifically, determining that the glue file in fund file describes data in a kind of possible embodiment, wherein
It includes in all fund files represented by finance data agreement used by the fund file that glue file, which describes data,
Including the identical data of type, specifically, it may include file identifier, fixed record, field that glue file, which describes data,
Name and end of file identifier.Then typesetting format of the data in fund file can be described according to glue file, to solid
Determine document description data and carry out EXCEL typesetting, obtains and describe the third typesetting of data as a result, so as to root for glue file
According to the first typesetting result and third typesetting as a result, generating EXCEL file corresponding with fund file.Certainly, specifically implementing
It in the process, can also be according to the first typesetting result, the second typesetting result and third typesetting as a result, generating corresponding with fund file
EXCEL file.
Such mode, the EXCEL file of generation be it is corresponding with fund file, user can pass through the EXCEL file
All data contents of accurate fund file, promote the usage experience of user.
Specifically, in a kind of possible embodiment, when user wishes to modify to fund file or check processing
When, user can carry out data modification operation after generating EXCEL file corresponding with fund file in EXCEL file,
Then computer equipment can receive the edit operation (such as modification) for EXCEL file, determining then according to edit operation
The response results of data to be edited to edit operation in EXCEL file.
Further, after data to be edited are to the response results of edit operation in determining EXCEL file, Ke Yigen
Legitimacy verifies are carried out to institute's response results according to the data attribute of data to be edited；Wherein, data attribute includes shared by data
Digit and/or data retention rank, when the test fails, then response of the revocation to edit operation.
In the specific implementation process, when user carries out certain field data in the transaction record data in EXCEL file
When modification operation, computer equipment, can after data to be edited are to the response results of edit operation in determining EXCEL file
The field data is verified with the digit according to shared by data, shared by field data digit to be edited and the field data
(for example, field data digit to be edited is greater than digit or field data to be edited shared by the field when digit is not identical
Digit is less than digit shared by the field), then it can be confirmed that verification does not pass through, thus response of the revocation to edit operation, i.e. user
The field data for not showing modification is found in gui interface.
In the specific implementation process, data retention rank can characterize the data and can delete when carrying out file conversion
Or cannot delete, it, can be with specifically, be changeless data in view of the glue file in fund file describes data
By the glue file in fund file describe data be determined as retain rank it is lower (data that can be deleted), transaction record data
It is higher (data that cannot be deleted) to be determined as retention rank.
When the data attribute of data to be edited is that glue file describes data, i.e. confirmation legitimacy verifies pass through；When
When the data attribute of data to be edited is transaction record data, however, it is determined that the field number of data to be edited and the data institute
When accounting for field number difference, such as the field number of data to be edited is greater than field number, i.e. legitimacy shared by the data
When verification does not pass through, the response to edit operation can be cancelled.In this case, it can accurately ensure the conjunction of transaction record data
Method.
In the embodiment of the present application, when user edits EXCEL file, data can be edited to user and carry out school
It tests, to improve the accuracy of processing file.When verification does not pass through, the response to edit operation can be cancelled, i.e., is grasped in editor
The illegal editor of user is prevented when making, with the legitimacy of determination data to be edited.
Specifically, in a kind of possible embodiment, the EXCEL file that can also will be converted to according to fund file
Be converted to fund file.Specifically, EXCEL file to be converted can be determined, wherein EXCEL file to be converted is basis
The EXCEL file that fund file is converted to.Then according to the typesetting format of fund file, to EXCEL file to be converted into
Row typesetting conversion can obtain the 4th typesetting as a result, thus according to the 4th typesetting as a result, generating and EXCEL file to be converted
Corresponding fund file.
Such mode, can be by the EXCEL file reconvert being converted to fund file, convenient for user in EXCEL
File handles the transaction record data of fund file, then will treated that EXCEL file is converted to fund file,
To promote user experience.
Specifically, in a kind of possible embodiment, can also be converted to by EXCEL file to be converted it is corresponding
During fund file, to critical data carry out legitimacy inspection, wherein critical data include field length, number of parameters,
At least one of number of data lines can then continue by be converted when critical data progress legitimacy is upchecked
Conversion of the EXCEL file to corresponding fund file.
It in the embodiment of the present application, can also be in the mistake for being converted to corresponding fund file by EXCEL file to be converted
Cheng Zhong carries out legitimacy inspection to critical data, so as to be further ensured that the fund file being converted into EXCEL file
Legitimacy improves the accuracy to file process.
Based on the same inventive concept, the embodiment of the present application provides a kind of document handling apparatus.This document processing unit can be with
It is that hardware configuration, software module or hardware configuration add software module.This document processing unit can realize by chip system, core
Piece system can be made of chip, also may include chip and other discrete devices.It is shown in Figure 10, the embodiment of the present application
In document handling apparatus include:
First determining module 1001, for determining fund file to be converted；
Read module 1002, for reading the transaction record data in the fund file, wherein the transaction record number
According to including every strip transaction data according to the M strip transaction data of predetermined order splicing composition, in the M strip transaction data
It include the field data of N number of field, the field name of each field in N number of field is different, and M and N are to be greater than
Or the integer equal to 1；
First type-setting module 1003, for the typesetting format according to EXCEL file, by N number of word of every strip transaction data
Section is divided into N column and carries out EXCEL typesetting according to the column mark that the column are arranged in the field name of the field of corresponding each column, to obtain
For the first typesetting result of the transaction record data；
First processing module 1004 is used for according to first typesetting as a result, generating corresponding with the fund file
EXCEL file.
In a kind of optional embodiment, document handling apparatus further includes the second determining module, is used for:
The field name of N number of field is translated with being different from the second languages of the first languages, to obtain with the second languages
The N number of field identification indicated, wherein the field name of N number of field in the first typesetting result is indicated with the first languages；
Document handling apparatus further includes the second type-setting module, is used for: according to for indicating the field identification of same field name
With the mode that is correspondingly arranged of column mark, by the N number of field identification indicated with the second languages respectively with it is N number of in the first typesetting result
Column mark, which is correspondingly arranged, carries out typesetting for a column, to obtain the second typesetting result for being directed to N number of field；
Document handling apparatus further includes Second processing module, is used for: according to the first typesetting result and the second typesetting as a result, raw
At EXCEL file corresponding with fund file.
In a kind of optional embodiment, the second determining module is also used to:
According to digit occupied by each field in N number of field, the corresponding digit mark of each field is determined；
Second type-setting module, is used for: the digit of each field being identified field identification corresponding with the field or column identify
Corresponding typesetting, to obtain field digit typesetting result；
According to the typesetting of field digit as a result, updating the second typesetting result.
In a kind of optional embodiment, document handling apparatus further includes third determining module, is used for:
Determine that the glue file in fund file describes data, wherein it includes with fund file that glue file, which describes data,
The identical data of type for including in all fund files represented by used finance data agreement；
Document handling apparatus further includes third type-setting module, is used for: describing data in fund file according to glue file
Typesetting format, to glue file describe data carry out EXCEL typesetting, with obtain for glue file describe data third row
Version result；
Document handling apparatus further includes third processing module, is used for: according to the first typesetting result and third typesetting as a result, raw
At EXCEL file corresponding with fund file.
In a kind of optional embodiment, document handling apparatus further includes correction verification module, corresponding with fund file generating
After EXCEL file, it is used for:
Receive the edit operation for being directed to EXCEL file；
According to edit operation, determine that data to be edited are to the response results of edit operation in EXCEL file；
Legitimacy verifies are carried out to response results according to the data attribute of data to be edited；Wherein, data attribute includes
Digit shared by data and/or data retention rank；
If the test fails, the response to edit operation is cancelled.
In a kind of optional embodiment, document handling apparatus further includes conversion module, is used for:
Determine EXCEL file to be converted, wherein EXCEL file to be converted is converted to according to fund file
EXCEL file；
According to the typesetting format of fund file, typesetting conversion is carried out to EXCEL file to be converted, to obtain the 4th typesetting
As a result；
According to the 4th typesetting as a result, generating fund file corresponding with EXCEL file to be converted.
In a kind of optional embodiment, correction verification module is also used to:
During being converted to corresponding fund file by EXCEL file to be converted, it is legal to carry out to critical data
Property examine；Wherein, critical data includes at least one of field length, number of parameters, number of data lines；
Conversion module is also used to:
When critical data carries out legitimacy and upchecks, then continue by EXCEL file to be converted to corresponding
The conversion of fund file.
It is schematical, only a kind of logical function partition to the division of module in the embodiment of the present application, it is practical to realize
When there may be another division manner, in addition, each functional module in each embodiment of the application can integrate at one
It manages in device, is also possible to physically exist alone, can also be integrated in two or more modules in a module.It is above-mentioned integrated
Module both can take the form of hardware realization, can also be realized in the form of software function module.
Based on the same inventive concept, the embodiment of the present application also provides a kind of computer equipment.As shown in figure 11, the application is real
Applying the computer equipment in example includes at least one processor 1101, and the memory connecting at least one processor 1101
1102 and communication interface 1103, the specific connection not limited between processor 1101 and memory 1102 in the embodiment of the present application is situated between
Matter is for passing through bus 1100 between processor 1101 and memory 1102 and connect in Figure 11, and bus 1100 is in Figure 11
It is indicated with thick line, the connection type between other components is only to be schematically illustrated, does not regard it as and be limited.Bus 1100 can
To be divided into address bus, data/address bus, control bus etc., only to be indicated with a thick line in Figure 11, but not table convenient for indicating
Show only a bus or a type of bus.
In the embodiment of the present application, memory 1102 is stored with the instruction that can be executed by least one processor 1101, until
The instruction that a few processor 1101 is stored by executing memory 1102, can execute and be wrapped in fault detection method above-mentioned
The step of including.
Wherein, processor 1101 is the control centre of computer equipment, can use various interfaces and connection is entire
The various pieces of fault test set are stored in by running or executing the instruction being stored in memory 1102 and calling
Data in reservoir 1102 calculate the various functions and processing data of equipment, to carry out integral monitoring to equipment is calculated.It is optional
, processor 1101 may include one or more processing units, and processor 1101 can integrate application processor and modulatedemodulate is mediated
Manage device, wherein the main processing operation system of processor 1101, user interface and application program etc., modem processor is main
Processing wireless communication.It is understood that above-mentioned modem processor can not also be integrated into processor 1101.Some
In embodiment, processor 1101 and memory 1102 can be realized on the same chip, and in some embodiments, they can also be with
It is realized respectively on independent chip.
Processor 1101 can be general processor, such as central processing unit (CPU), digital signal processor, dedicated collection
At circuit, field programmable gate array or other programmable logic device, discrete gate or transistor logic, discrete hard
Part component may be implemented or execute each method, step disclosed in the embodiment of the present application and logic diagram.General processor can
To be microprocessor or any conventional processor etc..The step of method in conjunction with disclosed in the embodiment of the present application, can be direct
Be presented as that hardware processor executes completion, or in processor hardware and software module combination execute completion.
Memory 1102 is used as a kind of non-volatile computer readable storage medium storing program for executing, can be used for storing non-volatile software journey
Sequence, non-volatile computer executable program and module.Memory 1102 may include the storage medium of at least one type,
It such as may include flash memory, hard disk, multimedia card, card-type memory, random access storage device (Random Access
Memory, RAM), static random-access memory (Static Random Access Memory, SRAM), may be programmed read-only deposit
Reservoir (Programmable Read Only Memory, PROM), read-only memory (Read Only Memory, ROM), band
Electrically erasable programmable read-only memory (Electrically Erasable Programmable Read-Only Memory,
EEPROM), magnetic storage, disk, CD etc..Memory 1102 can be used for carrying or storing have instruction or data
The desired program code of structure type and can by any other medium of computer access, but not limited to this.The application is real
Applying the memory 1102 in example can also be circuit or other devices that arbitrarily can be realized store function, for storing program
Instruction and/or data.
Communication interface 1103 can be used for the coffret communicated, can receive data by communication interface 1103
Or send data.
The structural schematic diagram further of computer equipment shown in Figure 12, the computer equipment further include helping
The basic input/output (I/O system) 1201 of information is transmitted between each device in computer equipment, for storing behaviour
Make the mass-memory unit 1205 of system 1202, application program 1203 and other program modules 1204.
Basic input/output 1201 includes display 1206 for showing information and inputs information for user
Such as mouse, keyboard etc input equipment 1207.Wherein display 1206 and input equipment 1207 are all by being connected to
The basic input/output 1201 of system bus 1100 is connected to processor 1101.The basic input/output 1201 is also
It may include input and output controller to be set for receiving and handling from multiple other such as keyboard, mouse or electronic touch pen
Standby input.Similarly, input and output controller also provides output to display screen, printer or other kinds of output equipment.
The mass-memory unit 1205 (is not shown by being connected to the bulk memory controller of system bus 1100
It is connected to processor 1101 out).The mass-memory unit 1205 and its associated computer-readable medium are the service
Device packet provides non-volatile memories.That is, mass-memory unit 1205 may include that such as hard disk or CD-ROM drive
The computer-readable medium (not shown) of dynamic device etc.
According to the various embodiments of the application, which can also pass through the network connections such as internet to net
Remote computer operation on network.Namely the calculating equipment can be by the communication interface that is connected on the system bus 1100
1103 are connected to network 1208, in other words, communication interface 1103 can be used also to be connected to other kinds of network or long-range
Computer system (not shown).
Based on the same inventive concept, the embodiment of the present application also provides a kind of computer readable storage medium, which can
It reads storage medium and is stored with computer instruction, when the computer instruction is run on computers, so that computer is executed as before
The step of former sequence mask method stated.
Based on the same inventive concept, the embodiment of the present application also provides a kind of chip system, which includes processor,
It can also include memory, the step of for realizing document handling method as the aforementioned.The chip system can be made of chip,
Also chip and other discrete devices be may include.
In some possible embodiments, the various aspects of document handling method provided by the embodiments of the present application can be with
It is embodied as a kind of form of program product comprising program code, when described program product is run on computers, the journey
Sequence code is used to that the computer to be made to execute the file process according to the various illustrative embodiments of the application for stating description above
Step in method.
It should be understood by those skilled in the art that, embodiments herein can provide as method, system or computer program
Product.Therefore, complete hardware embodiment, complete software embodiment or reality combining software and hardware aspects can be used in the application
Apply the form of example.Moreover, it wherein includes the computer of computer usable program code that the application, which can be used in one or more,
The shape for the computer program product implemented in usable storage medium (including but not limited to magnetic disk storage and optical memory etc.)
Formula.
The application is referring to method, the process of equipment (system) and computer program product according to the embodiment of the present application
Figure and/or block diagram describe.It should be understood that every one stream in flowchart and/or the block diagram can be realized by computer program instructions
The combination of process and/or box in journey and/or box and flowchart and/or the block diagram.It can provide these computer programs
Instruct the processor of general purpose computer, special purpose computer, Embedded Processor or other programmable data processing devices to produce
A raw machine, so that being generated by the instruction that computer or the processor of other programmable data processing devices execute for real
The device for the function of being specified in present one or more flows of the flowchart and/or one or more blocks of the block diagram.
These computer program instructions, which may also be stored in, is able to guide computer or other programmable data processing devices with spy
Determine in the computer-readable memory that mode works, so that it includes referring to that instruction stored in the computer readable memory, which generates,
Enable the manufacture of device, the command device realize in one box of one or more flows of the flowchart and/or block diagram or
The function of being specified in multiple boxes.
These computer program instructions also can be loaded onto a computer or other programmable data processing device, so that counting
Series of operation steps are executed on calculation machine or other programmable devices to generate computer implemented processing, thus in computer or
The instruction executed on other programmable devices is provided for realizing in one or more flows of the flowchart and/or block diagram one
The step of function of being specified in a box or multiple boxes.
Obviously, those skilled in the art can carry out various modification and variations without departing from the essence of the application to the application
Mind and range.In this way, if these modifications and variations of the application belong to the range of the claim of this application and its equivalent technologies
Within, then the application is also intended to include these modifications and variations.
Claims (10)
1. a kind of document handling method, which is characterized in that the described method includes:
Determine fund file to be converted；
Read the transaction record data in the fund file, wherein the transaction record data include spelling according to predetermined order
The M strip transaction data of composition is connect, every strip transaction data in the M strip transaction data includes the field of N number of field
The field name of data, each field in N number of field is different, and M and N are the integer more than or equal to 1；
According to the typesetting format of EXCEL file, N number of field of every strip transaction data is divided into N column and according to corresponding every
The column mark that the column are arranged in the field name of the field of column carries out EXCEL typesetting, to obtain for the transaction record data
One typesetting result；
According to first typesetting as a result, generating EXCEL file corresponding with the fund file.
2. the method as described in claim 1, which is characterized in that the method also includes:
The field name of N number of field is translated with being different from the second languages of the first languages, to obtain with described second
N number of field identification that languages indicate, wherein the field name of N number of field in the first typesetting result is with described first
Languages indicate；
It, will be with the second languages table in such a way that the field identification and column mark for indicating same field name are correspondingly arranged
The N number of field identification shown is correspondingly arranged with N number of column mark in the first typesetting result carries out typesetting for a column respectively, to obtain
Obtain the second typesetting result for N number of field；
Then, according to first typesetting as a result, generating EXCEL file corresponding with the fund file, comprising:
According to the first typesetting result and second typesetting as a result, generating EXCEL file corresponding with the fund file.
3. method according to claim 2, which is characterized in that obtain the second typesetting for the N subsegment as a result, including:
According to digit occupied by each field in N number of field, the corresponding digit mark of each field is determined；
The digit of each field is identified into field identification corresponding with the field or arranges the corresponding typesetting of mark, to obtain field digit
Typesetting result；
According to the field digit typesetting as a result, updating the second typesetting result.
4. the method as described in claim 1, which is characterized in that the method also includes:
Determine that the glue file in the fund file describes data, wherein it includes with described that the glue file, which describes data,
The identical data of the type for including in all fund files represented by finance data agreement used by fund file；
Typesetting format of the data in the fund file is described according to the glue file, data are described to the glue file
EXCEL typesetting is carried out, to obtain the third typesetting result for describing data for the glue file；
Then, according to first typesetting as a result, generating EXCEL file corresponding with the fund file, comprising:
According to the first typesetting result and the third typesetting as a result, generating EXCEL file corresponding with the fund file.
5. the method as described in claim 1, which is characterized in that generate corresponding with fund file EXCEL file it
Afterwards, the method also includes:
Receive the edit operation for being directed to the EXCEL file；
According to the edit operation, determine that data to be edited are to the response results of the edit operation in the EXCEL file；
Legitimacy verifies are carried out to the response results according to the data attribute of the data to be edited；Wherein, the data
Attribute includes digit shared by data and/or data retention rank；
If the test fails, the response to the edit operation is cancelled.
6. method a method as claimed in any one of claims 1 to 5, which is characterized in that the method also includes:
Determine EXCEL file to be converted, wherein the EXCEL file to be converted is converted to according to fund file
EXCEL file；
According to the typesetting format of the fund file, typesetting conversion is carried out to the EXCEL file to be converted, to obtain the 4th
Typesetting result；
According to the 4th typesetting as a result, generating fund file corresponding with the EXCEL file to be converted.
7. method as claimed in claim 6, which is characterized in that the method also includes:
During being converted to corresponding fund file by the EXCEL file to be converted, it is legal to carry out to critical data
Property examine；Wherein, the critical data includes at least one of field length, number of parameters, number of data lines；
The critical data carry out legitimacy upcheck when, then continue by the EXCEL file to be converted to pair
The conversion for the fund file answered.
8. a kind of document handling apparatus, which is characterized in that described device includes:
First determining module, for determining fund file to be converted；
Read module, for reading the transaction record data in the fund file, wherein the transaction record data include pressing
According to the M strip transaction data of predetermined order splicing composition, every strip transaction data in the M strip transaction data includes N
The field name of the field data of a field, each field in N number of field is different, and M and N are more than or equal to 1
Integer；
N number of field of every strip transaction data is divided into N for the typesetting format according to EXCEL file by the first type-setting module
Column and the column mark progress EXCEL typesetting that the column are set according to the field name of the field of corresponding each column, to obtain for described
First typesetting result of transaction record data；
First processing module is used for according to first typesetting as a result, generating EXCEL file corresponding with the fund file.
9. a kind of computer equipment, which is characterized in that the computer equipment includes:
Memory, for storing program instruction；
Processor, for calling the program instruction stored in the memory, according to the program instruction perform claim requirement of acquisition
Any method of 1-7 includes the steps that.
10. a kind of storage medium, which is characterized in that the storage medium is stored with computer executable instructions, the computer
Executable instruction is used to make computer perform claim that any method of 1-7 be required to include the steps that.
Priority Applications (2)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN201910569703.9A CN110263316A (en) | 2019-06-27 | 2019-06-27 | A kind of document handling method, device and computer equipment |
| PCT/CN2020/091378 WO2020259141A1 (en) | 2019-06-27 | 2020-05-20 | File processing method and apparatus, and computer device |
Applications Claiming Priority (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN201910569703.9A CN110263316A (en) | 2019-06-27 | 2019-06-27 | A kind of document handling method, device and computer equipment |
Publications (1)
| Publication Number | Publication Date |
|---|---|
| CN110263316A true CN110263316A (en) | 2019-09-20 |
Family
ID=67922528
Family Applications (1)
| Application Number | Title | Priority Date | Filing Date |
|---|---|---|---|
| CN201910569703.9A Pending CN110263316A (en) | 2019-06-27 | 2019-06-27 | A kind of document handling method, device and computer equipment |
Country Status (2)
| Country | Link |
|---|---|
| CN (1) | CN110263316A (en) |
| WO (1) | WO2020259141A1 (en) |
Cited By (5)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN110929485A (en) * | 2019-12-06 | 2020-03-27 | 中国银联股份有限公司 | File generation method, device, equipment and medium |
| CN111221738A (en) * | 2020-01-10 | 2020-06-02 | 深圳前海环融联易信息科技服务有限公司 | Data execution file generation method and device, computer equipment and storage medium |
| CN112037074A (en) * | 2020-09-11 | 2020-12-04 | 中国银行股份有限公司 | Visualization-based data file analysis method and device |
| WO2020259141A1 (en) * | 2019-06-27 | 2020-12-30 | 深圳前海微众银行股份有限公司 | File processing method and apparatus, and computer device |
| CN114048939A (en) * | 2021-09-26 | 2022-02-15 | 深圳市高腾科技服务有限公司 | Escrow data cash checking method, device, equipment and storage medium for fund |
Families Citing this family (1)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN115146608B (en) * | 2022-05-13 | 2024-07-23 | 抖音视界有限公司 | Content typesetting method, device, equipment and storage medium |
Citations (8)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| EP1043674A2 (en) * | 1999-04-09 | 2000-10-11 | Hewlett-Packard Company | Method for retrieval, update and storage of data |
| CN102279847A (en) * | 2011-08-17 | 2011-12-14 | 瑞斯康达科技发展股份有限公司 | Method and device for internationalizing software system |
| CN103020024A (en) * | 2012-12-27 | 2013-04-03 | 北京经纬恒润科技有限公司 | File format converting method |
| CN103092993A (en) * | 2013-02-18 | 2013-05-08 | 五八同城信息技术有限公司 | Data exporting method and data exporting device |
| CN105117378A (en) * | 2015-08-05 | 2015-12-02 | 联动优势电子商务有限公司 | Method and apparatus for converting JSON file into EXCEL file |
| CN107291674A (en) * | 2017-06-12 | 2017-10-24 | 广东川田卫生用品有限公司 | A kind of method that Excel list datas are converted to database format |
| CN107341109A (en) * | 2017-07-07 | 2017-11-10 | 中国银行股份有限公司 | The generation method and system of a kind of test data |
| CN109918343A (en) * | 2019-03-25 | 2019-06-21 | 苏州中晟宏芯信息科技有限公司 | A kind of method and system automatically generating ralf file |
Family Cites Families (3)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| US10127209B2 (en) * | 2015-11-24 | 2018-11-13 | Bank Of America Corporation | Transforming unstructured documents |
| CN106095992B (en) * | 2016-06-21 | 2019-07-05 | 浪潮通用软件有限公司 | Method for exchanging ERP data and Excel document data |
| CN110263316A (en) * | 2019-06-27 | 2019-09-20 | 深圳前海微众银行股份有限公司 | A kind of document handling method, device and computer equipment |
-
2019
- 2019-06-27 CN CN201910569703.9A patent/CN110263316A/en active Pending
-
2020
- 2020-05-20 WO PCT/CN2020/091378 patent/WO2020259141A1/en active Application Filing
Patent Citations (8)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| EP1043674A2 (en) * | 1999-04-09 | 2000-10-11 | Hewlett-Packard Company | Method for retrieval, update and storage of data |
| CN102279847A (en) * | 2011-08-17 | 2011-12-14 | 瑞斯康达科技发展股份有限公司 | Method and device for internationalizing software system |
| CN103020024A (en) * | 2012-12-27 | 2013-04-03 | 北京经纬恒润科技有限公司 | File format converting method |
| CN103092993A (en) * | 2013-02-18 | 2013-05-08 | 五八同城信息技术有限公司 | Data exporting method and data exporting device |
| CN105117378A (en) * | 2015-08-05 | 2015-12-02 | 联动优势电子商务有限公司 | Method and apparatus for converting JSON file into EXCEL file |
| CN107291674A (en) * | 2017-06-12 | 2017-10-24 | 广东川田卫生用品有限公司 | A kind of method that Excel list datas are converted to database format |
| CN107341109A (en) * | 2017-07-07 | 2017-11-10 | 中国银行股份有限公司 | The generation method and system of a kind of test data |
| CN109918343A (en) * | 2019-03-25 | 2019-06-21 | 苏州中晟宏芯信息科技有限公司 | A kind of method and system automatically generating ralf file |
Non-Patent Citations (1)
| Title |
|---|
| 王德胜;李弘;田佳烨;: "数据抽取及交换工具的设计与实现", 软件, no. 08, 15 August 2015 (2015-08-15) * |
Cited By (7)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| WO2020259141A1 (en) * | 2019-06-27 | 2020-12-30 | 深圳前海微众银行股份有限公司 | File processing method and apparatus, and computer device |
| CN110929485A (en) * | 2019-12-06 | 2020-03-27 | 中国银联股份有限公司 | File generation method, device, equipment and medium |
| CN110929485B (en) * | 2019-12-06 | 2023-09-19 | 中国银联股份有限公司 | File generation method, device, equipment and medium |
| CN111221738A (en) * | 2020-01-10 | 2020-06-02 | 深圳前海环融联易信息科技服务有限公司 | Data execution file generation method and device, computer equipment and storage medium |
| CN112037074A (en) * | 2020-09-11 | 2020-12-04 | 中国银行股份有限公司 | Visualization-based data file analysis method and device |
| CN112037074B (en) * | 2020-09-11 | 2024-04-19 | 中国银行股份有限公司 | Visualization-based data file analysis method and device |
| CN114048939A (en) * | 2021-09-26 | 2022-02-15 | 深圳市高腾科技服务有限公司 | Escrow data cash checking method, device, equipment and storage medium for fund |
Also Published As
| Publication number | Publication date |
|---|---|
| WO2020259141A1 (en) | 2020-12-30 |
Similar Documents
| Publication | Publication Date | Title |
|---|---|---|
| CN110263316A (en) | A kind of document handling method, device and computer equipment | |
| EP3433732B1 (en) | Converting visual diagrams into code | |
| CN108292231B (en) | Method and system for generating applications from data | |
| US8245186B2 (en) | Techniques for offering and applying code modifications | |
| WO2007056898A1 (en) | A method for converting source document to object web page file | |
| Hanchett et al. | Vue. js in Action | |
| AU2011248878B2 (en) | Client application and web page integration | |
| CN110147402A (en) | Excel file introduction method and equipment, deriving method and equipment | |
| CN109308254B (en) | Test method, test device and test equipment | |
| WO2020140940A1 (en) | Code generation method and apparatus, and device and storage medium | |
| CN107451112B (en) | Form tool data checking method, device, terminal equipment and storage medium | |
| US8839251B2 (en) | Automating sequential cross-application data transfer operations | |
| US12086534B2 (en) | Multi-component abstract association and fusion method and apparatus in page design | |
| CN117787153A (en) | Hardware design verification method, device and storage medium | |
| CN113419711A (en) | Page guiding method and device, electronic equipment and storage medium | |
| CN110968513B (en) | Recording method and device of test script | |
| CN117389538A (en) | Page component content development method, device, equipment and storage medium | |
| CN111610973A (en) | Method and device for generating human-computer interaction interface | |
| CN110795137B (en) | Authority configuration method, device, system, electronic equipment and readable medium | |
| CN109101429A (en) | A kind of method and device of the browser page debugging of set-top box | |
| CN114020358A (en) | Interface rendering method and device based on iOS application | |
| CN115098090B (en) | Form generation method and device | |
| CN117075912B (en) | Method for program language conversion, compiling method and related equipment | |
| US20240296296A1 (en) | Translation of rich text | |
| CN118394176B (en) | Python-based clock network automatic generation method and device |
Legal Events
| Date | Code | Title | Description |
|---|---|---|---|
| PB01 | Publication | ||
| PB01 | Publication | ||
| SE01 | Entry into force of request for substantive examination | ||
| SE01 | Entry into force of request for substantive examination |