CN108875029A - Data processing method and device, storage medium and processor - Google Patents
Data processing method and device, storage medium and processor Download PDFInfo
- Publication number
- CN108875029A CN108875029A CN201810654602.7A CN201810654602A CN108875029A CN 108875029 A CN108875029 A CN 108875029A CN 201810654602 A CN201810654602 A CN 201810654602A CN 108875029 A CN108875029 A CN 108875029A
- Authority
- CN
- China
- Prior art keywords
- format
- mentioned
- field name
- target table
- information
- Prior art date
- Legal status (The legal status is an assumption and is not a legal conclusion. Google has not performed a legal analysis and makes no representation as to the accuracy of the status listed.)
- Pending
Links
Abstract
The invention discloses a kind of data processing method and devices, storage medium and processor.Wherein, this method includes：Obtain original document, wherein above-mentioned original document is the document that electricity charge information is used to indicate derived from power information platform；Determine the format information of target table, wherein include at least in above-mentioned target table：The corresponding list data of field name, field name, above-mentioned format information include at least：The format of the format of above-mentioned field name, above table data；Above-mentioned original document is converted to above-mentioned target table by the format information according to above-mentioned target table.The present invention solves in the prior art through the artificial counting user electricity charge information of staff, is easy the technical problem to malfunction and working efficiency is lower.
Description
Technical field
The present invention relates to data processing field, in particular to a kind of data processing method and device, storage medium and
Processor.
Background technique
In the prior art, each power supply unit can pay detail information by the electricity charge that staff collects electricity consumption user,
Also, staff will not only collect the electricity charge information of user, also to count all results and carry out calculating analysis, due to
As many as the quantity of electric user, even being counted with unit carried out by power supply, quantity also should not be underestimated, artificial by staff
Counting user electricity charge information, is easy error and working efficiency is lower.
For above-mentioned problem, currently no effective solution has been proposed.
Summary of the invention
The embodiment of the invention provides a kind of data processing method and devices, storage medium and processor, at least to solve
In the prior art by the artificial counting user electricity charge information of staff, it is easy the technical problem to malfunction and working efficiency is lower.
According to an aspect of an embodiment of the present invention, a kind of data processing method is provided, including：Original document is obtained,
Wherein, above-mentioned original document is the document that electricity charge information is used to indicate derived from power information platform；Determine the lattice of target table
Formula information, wherein included at least in above-mentioned target table：The corresponding list data of field name, field name, above-mentioned format information is extremely
Include less：The format of the format of above-mentioned field name, above table data；Format information according to above-mentioned target table will be above-mentioned first
Beginning document is converted to above-mentioned target table.
Further, above-mentioned field name include at least one:Power supply station's title should collect charges for electricity, the paid electricity charge, arrearage gold
Volume, arrearage amount, tariff recovery rate, meter reader, the arrearage amount of money corresponding with meter reader.
Further, the type of above-mentioned target table includes at least：Excel table, the format according to above-mentioned target table
Above-mentioned original document is converted to above-mentioned target table by information：Obtain the field name in above-mentioned Excel table format and
The format of list data；According to the macros of above-mentioned Excel table, the lattice of the format of above-mentioned field name and above table data
Above-mentioned original document is converted to above-mentioned Excel table by formula.
Further, after obtaining original document, the above method further includes：Determine the graphical information of targeted graphical,
In, it is included at least in above-mentioned targeted graphical：Above-mentioned field name, the corresponding list data of above-mentioned field name, above-mentioned graphical information is extremely
Include less：The format of the format of above-mentioned field name, above table data；Graphical information according to above-mentioned targeted graphical will be above-mentioned first
Beginning document is converted to above-mentioned targeted graphical.
Further, the type of above-mentioned targeted graphical includes at least one following：Column diagram, bar chart, sector diagram.
Further, it is determined that the format information of target table includes：Receive the control instruction of user's input, wherein above-mentioned
Control instruction is used to indicate the format information of the above-mentioned target table of user's selection；Above-mentioned target is determined according to above-mentioned control instruction
The format information of table.
According to another aspect of an embodiment of the present invention, a kind of data processing equipment is additionally provided, including：Module is obtained, is used
In acquisition original document, wherein above-mentioned original document is the document for being used to indicate electricity charge information derived from power information platform；Really
Cover half block, for determining the format information of target table, wherein included at least in above-mentioned target table：Field name, field name pair
The list data answered, above-mentioned format information include at least：The format of the format of above-mentioned field name, above table data；Modulus of conversion
Above-mentioned original document is converted to above-mentioned target table for the format information according to above-mentioned target table by block.
Further, above-mentioned field name include at least one:Power supply station's title should collect charges for electricity, the paid electricity charge, arrearage gold
Volume, arrearage amount, tariff recovery rate, meter reader, the arrearage amount of money corresponding with meter reader.
According to another aspect of an embodiment of the present invention, a kind of storage medium is additionally provided, above-mentioned storage medium includes storage
Program, wherein above procedure operation when control above-mentioned storage medium where equipment execute following steps：Obtain initial text
Shelves, wherein above-mentioned original document is the document that electricity charge information is used to indicate derived from power information platform；Determine target table
Format information, wherein included at least in above-mentioned target table：The corresponding list data of field name, field name, above-mentioned format information
It includes at least：The format of the format of above-mentioned field name, above table data；Format information according to above-mentioned target table will be above-mentioned
Original document is converted to above-mentioned target table.
According to another aspect of an embodiment of the present invention, a kind of processor is additionally provided, above-mentioned processor is used to run program,
Wherein, following steps are executed when above procedure is run：Obtain original document, wherein above-mentioned original document is power information platform
The derived document for being used to indicate electricity charge information；Determine the format information of target table, wherein at least wrap in above-mentioned target table
Contain：The corresponding list data of field name, field name, above-mentioned format information include at least：Format, the above table of above-mentioned field name
The format of data；Above-mentioned original document is converted to above-mentioned target table by the format information according to above-mentioned target table.
In embodiments of the present invention, by obtaining original document, wherein above-mentioned original document is the export of power information platform
The document for being used to indicate electricity charge information；Determine the format information of target table, wherein include at least in above-mentioned target table：
The corresponding list data of field name, field name, above-mentioned format information include at least：Format, the above table number of above-mentioned field name
According to format；Above-mentioned original document is converted to above-mentioned target table by the format information according to above-mentioned target table, has been reached and has been mentioned
The rate of high statistics demand charge information and the purpose of accuracy, thus realize improve according to electricity charge information press for payment of the electricity charge can
It by the technical effect of property, and then solves in the prior art through the artificial counting user electricity charge information of staff, is easy error
And the technical problem that working efficiency is lower.
Detailed description of the invention
The drawings described herein are used to provide a further understanding of the present invention, constitutes part of this application, this hair
Bright illustrative embodiments and their description are used to explain the present invention, and are not constituted improper limitations of the present invention.In the accompanying drawings：
Fig. 1 is a kind of flow chart of data processing method according to an embodiment of the present invention；
Fig. 2 is a kind of flow chart of optional data processing method according to an embodiment of the present invention；And
Fig. 3 is a kind of schematic diagram of data processing equipment according to an embodiment of the present invention.
Specific embodiment
In order to enable those skilled in the art to better understand the solution of the present invention, below in conjunction in the embodiment of the present invention
Attached drawing, technical scheme in the embodiment of the invention is clearly and completely described, it is clear that described embodiment is only
The embodiment of a part of the invention, instead of all the embodiments.Based on the embodiments of the present invention, ordinary skill people
The model that the present invention protects all should belong in member's every other embodiment obtained without making creative work
It encloses.
It should be noted that description and claims of this specification and term " first " in above-mentioned attached drawing, "
Two " etc. be to be used to distinguish similar objects, without being used to describe a particular order or precedence order.It should be understood that using in this way
Data be interchangeable under appropriate circumstances, so as to the embodiment of the present invention described herein can in addition to illustrating herein or
Sequence other than those of description is implemented.In addition, term " includes " and " having " and their any deformation, it is intended that cover
Cover it is non-exclusive include, for example, the process, method, system, product or equipment for containing a series of steps or units are not necessarily limited to
Step or unit those of is clearly listed, but may include be not clearly listed or for these process, methods, product
Or other step or units that equipment is intrinsic.
Firstly, understand the embodiment of the present invention for convenience, below will to part term involved in the present invention or noun into
Row illustrates：
SG18 marketing system：It is State Grid Corporation of China's integration firm grade information integrated platform, it can be with integrated power system enterprise
Management level, business model, operation flow in terms of marketing management, promotion State Grid Corporation of China's marketing ability and service level
Fast lifting.
Embodiment 1
According to embodiments of the present invention, a kind of embodiment of the method for data processing method is provided, it should be noted that attached
The step of process of figure illustrates can execute in a computer system such as a set of computer executable instructions, though also,
So logical order is shown in flow charts, but in some cases, it can be to be different from shown by sequence execution herein
Or the step of description.
Fig. 1 is a kind of flow chart of data processing method according to an embodiment of the present invention, as shown in Figure 1, this method includes
Following steps：
Step S102 obtains original document, wherein above-mentioned original document is to be used to indicate electricity derived from power information platform
The document of charge information.
In an alternative embodiment, above-mentioned power information platform can be, but not limited to as SG18 marketing system, above-mentioned
Original document is the receivable data file of the diversified electricity charge of complexity derived from SG18 marketing system, and the statistical time of original document can
By but be not limited to as unit of month, time.
Step S104 determines the format information of target table, wherein includes at least in above-mentioned target table：Field name, word
The corresponding list data of section name, above-mentioned format information include at least：The format of the format of above-mentioned field name, above table data.
Optionally, above-mentioned target table can be, but not limited to as Microsoft Excel table (referred to as：Excel table),
In the embodiment of the present application, the control instruction that can be analyzed, and be inputted according to user according to demand, according to the individual character of user
Change demand predefines the format of Excel table, for example, each field name of Excel table, list data put in order
Deng；Wherein, above-mentioned field name can be：Column name, Sheet.
In an alternative embodiment, above-mentioned field name include at least one:Power supply station's title should collect charges for electricity, is paid
The electricity charge, the arrearage amount of money, arrearage amount, tariff recovery rate, meter reader, the arrearage amount of money corresponding with meter reader.
By taking above-mentioned field name is above-mentioned column name as an example, power supply station's title should collect charges for electricity, the paid electricity charge, the arrearage amount of money, arrearage
Amount, tariff recovery rate etc. can check the electricity charge information of each power supply station and the cumulative information of all power supply stations.
By taking above-mentioned field name is above-mentioned Sheet as an example, then field name can be power supply station's title, by clicking power supply station
Title can check the corresponding arrearage detail of the power supply station：Customs Assigned Number, user's name, electricity charge month, total electricity, receivable gold
The corresponding arrearage amount of money of volume, meter reader, meter reader.
Above-mentioned original document is converted to above-mentioned target table by step S106, the format information according to above-mentioned target table.
In the embodiment of the present application, the format and list data of field name in above-mentioned Excel table can first be obtained
Format；It, will be above-mentioned first according to the macros of above-mentioned Excel table, the format of the format of above-mentioned field name and above table data
Beginning document is converted to above-mentioned Excel table, by carrying out conversion process on the basis of original original document data, can keep away
Exempt from the nonopen problem in port of document data, reduces the influence of various aspects factor.
In turn, one key of the information such as electricity charge arrearage can be generated and be shown on Excel table by the embodiment of the present application, be shortened
Data preparation time, avoid wasting manpower and material resources and financial resources；It can also be convenient for inquiry electricity charge arrearage letter by Excel table
Breath improves the accuracy of arrearage collection, reduces the risk of electricity charge arrearage.
It should be noted that corresponding to above-mentioned original document, the statistical time of above-mentioned target table also be can be, but not limited to
As unit of month, time.
Based on the embodiment of the present application, the macros of Excel table can use, complexity derived from SG18 marketing system is more
The receivable data of the electricity charge of sample, carry out classification analysis, for example, can by click SG18 marketing system interface on " arrearage is looked into
Ask " button, original document is exported, and original document is converted into Excel table, can intuitively be embodied by Excel table each
The arrearage total value of unit, tariff recovery rate, the arrearage amount of money of each meter reader under one's name etc., it is practical for arrearage recovery operation,
It is easy to use, it avoids wasting manpower and material resources' financial resources, replace manpower internal or office work finishing time using technology.
In embodiments of the present invention, by obtaining original document, wherein above-mentioned original document is the export of power information platform
The document for being used to indicate electricity charge information；Determine the format information of target table, wherein include at least in above-mentioned target table：
The corresponding list data of field name, field name, above-mentioned format information include at least：Format, the above table number of above-mentioned field name
According to format；Above-mentioned original document is converted to above-mentioned target table by the format information according to above-mentioned target table, has been reached and has been mentioned
The rate of high statistics demand charge information and the purpose of accuracy, thus realize improve according to electricity charge information press for payment of the electricity charge can
It by the technical effect of property, and then solves in the prior art through the artificial counting user electricity charge information of staff, is easy error
And the technical problem that working efficiency is lower.
In an alternative embodiment, Fig. 2 is a kind of optional data processing method according to an embodiment of the present invention
Flow chart, as shown in Fig. 2, the above method further includes after obtaining original document：
Step S202 determines the graphical information of targeted graphical, wherein includes at least in above-mentioned targeted graphical：Above-mentioned field
Name, the corresponding list data of above-mentioned field name, above-mentioned graphical information include at least：Format, the above table number of above-mentioned field name
According to format.
In the embodiment of the present application, above-mentioned targeted graphical is the present graphical in Excel table, in a kind of optional implementation
In example, the type of above-mentioned targeted graphical includes at least one following：Column diagram, bar chart, sector diagram.
As a kind of optional embodiment, by taking above-mentioned targeted graphical is column diagram as an example, which can be used for showing
The recovering state of the electricity charge arrearage amount of money, ordinate can be the rate of recovery of the electricity charge arrearage amount of money, and abscissa can be each confession
The accumulated result of electric institute and all power supply stations.
Above-mentioned original document is converted to above-mentioned targeted graphical by step S204, the graphical information according to above-mentioned targeted graphical.
In above-mentioned optional embodiment, user can be clicked on user interface by way of mouse or touch
The instruction of button input control, and then can determine the graphical information of above-mentioned targeted graphical, for example, determining the field for needing selection
Name, list data put in order, and according to above-mentioned graphical information original document are converted to column diagram, can pass through cylindricality
The intuitive arrearage total value for embodying constituent parts of figure, tariff recovery rate, the arrearage amount of money of each meter reader under one's name etc..
In the embodiment of the present application, the format of the field name in above-mentioned column diagram and the lattice of list data can first be obtained
Formula；It, will be above-mentioned initial according to the macros of above-mentioned Excel table, the format of the format of above-mentioned field name and above table data
Document is converted to above-mentioned column diagram.In turn, one key of the information such as electricity charge arrearage can be generated and is shown on column diagram, shortened
The data preparation time, avoid wasting manpower and material resources and financial resources；It can also be improved by column diagram convenient for inquiry electricity charge arrearage information
The accuracy of arrearage collection reduces the risk of electricity charge arrearage.
It should be noted that corresponding to above-mentioned original document, the statistical time of above-mentioned targeted graphical also be can be, but not limited to
As unit of month, time.
In an alternative embodiment, the format information for determining target table includes：The control for receiving user's input refers to
It enables, wherein above-mentioned control instruction is used to indicate the format information of the above-mentioned target table of user's selection；According to above-mentioned control instruction
Determine the format information of above-mentioned target table.
In above-mentioned optional embodiment, user can be clicked on user interface by way of mouse or touch
Button inputs above-mentioned control instruction, and then can determine the format information of above-mentioned target table, for example, determination needs selection
Field name, list data put in order, and according to above-mentioned format information original document are converted to column diagram, can pass through
Column diagram intuitively embodies the arrearage amount of money etc. of the arrearage total value, tariff recovery rate, each meter reader of constituent parts under one's name.
Based on data processing method provided by the present application, working efficiency can effectively improve, lower labor intensity, reduce electricity
Take arrears risk；Shorten electric power data finishing time, internal or office work arranges arrearage detail, and the time shortens to the 1/5 of former time, avoids wave
Take the waste of manpower, material resources and financial resources；The accuracy of arrearage collection is improved, marketing good service is improved；Guarantee that multi-user largely owes
Take, by secondary analysis, remains to facilitate inquiry.
Embodiment 2
According to embodiments of the present invention, it additionally provides a kind of for implementing the Installation practice of above-mentioned data processing method, Fig. 3
It is a kind of schematic diagram of data processing equipment according to an embodiment of the present invention, as shown in figure 3, above-mentioned data processing equipment, including：
Module 30, determining module 32 and conversion module 34 are obtained, wherein：
Module 30 is obtained, for obtaining original document, wherein above-mentioned original document is to be used for derived from power information platform
Indicate the document of electricity charge information；Determining module 32, for determining the format information of target table, wherein in above-mentioned target table
It includes at least：The corresponding list data of field name, field name, above-mentioned format information include at least：The format of above-mentioned field name, on
State the format of list data；Conversion module 34 converts above-mentioned original document for the format information according to above-mentioned target table
For above-mentioned target table.
In an alternative embodiment, above-mentioned field name include at least one:Power supply station's title should collect charges for electricity, is paid
The electricity charge, the arrearage amount of money, arrearage amount, tariff recovery rate, meter reader, the arrearage amount of money corresponding with meter reader.
In embodiments of the present invention, by obtaining module, for obtaining original document, wherein above-mentioned original document is electricity
The document of electricity charge information is used to indicate derived from force information platform；Determining module, for determining the format information of target table,
In, it is included at least in above-mentioned target table：The corresponding list data of field name, field name, above-mentioned format information include at least：On
State the format of field name, the format of above table data；Conversion module, for the format information according to above-mentioned target table by
It states original document and is converted to above-mentioned target table, achieved the purpose that the rate and accuracy that improve counting user electricity charge information,
To realize the technical effect for improving the reliability for pressing for payment of the electricity charge according to electricity charge information, and then solves and pass through in the prior art
The artificial counting user electricity charge information of staff is easy the technical problem to malfunction and working efficiency is lower.
It should be noted that above-mentioned modules can be realized by software or hardware, for example, for the latter,
It can be accomplished by the following way：Above-mentioned modules can be located in same processor；Alternatively, above-mentioned modules are with any
Combined mode is located in different processors.
Herein it should be noted that above-mentioned acquisition module 30, determining module 32 and conversion module 34 correspond in embodiment 1
Step S102 to step S106, above-mentioned module is identical as example and application scenarios that corresponding step is realized, but is not limited to
1 disclosure of that of above-described embodiment.It should be noted that above-mentioned module may operate in computer as a part of device
In terminal.
It should be noted that the optional or preferred embodiment of the present embodiment may refer to the associated description in embodiment 1,
Details are not described herein again.
Above-mentioned data processing equipment can also include processor and memory, above-mentioned acquisition module 30, determining module 32
It waits with conversion module 34 and is stored in memory as program unit, above-mentioned journey stored in memory is executed by processor
Sequence unit realizes corresponding function.
Include kernel in processor, is gone in memory to transfer corresponding program unit by kernel, above-mentioned kernel can be set
One or more.Memory may include the non-volatile memory in computer-readable medium, random access memory (RAM)
And/or the forms such as Nonvolatile memory, such as read-only memory (ROM) or flash memory (flash RAM), memory includes at least one
Storage chip.
According to the embodiment of the present application, a kind of storage medium embodiment is additionally provided.Optionally, in the present embodiment, above-mentioned
Storage medium includes the program of storage, wherein equipment where controlling above-mentioned storage medium in above procedure operation executes above-mentioned
Any one data processing method.
Optionally, in the present embodiment, above-mentioned storage medium can be located in computer network in computer terminal group
In any one terminal, or in any one mobile terminal in mobile terminal group, above-mentioned storage medium packet
Include the program of storage.
Optionally, when program is run, equipment where control storage medium executes following functions：Original document is obtained,
In, above-mentioned original document is the document that electricity charge information is used to indicate derived from power information platform；Determine the format of target table
Information, wherein included at least in above-mentioned target table：The corresponding list data of field name, field name, above-mentioned format information is at least
Include：The format of the format of above-mentioned field name, above table data；Format information according to above-mentioned target table will be above-mentioned initial
Document is converted to above-mentioned target table.
Optionally, when program is run, equipment where control storage medium executes following functions：Obtain above-mentioned Excel table
In field name format and list data format；According to the macros of above-mentioned Excel table, the format of above-mentioned field name and
Above-mentioned original document is converted to above-mentioned Excel table by the format of above table data.
Optionally, when program is run, equipment where control storage medium executes following functions：Determine the figure of targeted graphical
Shape information, wherein included at least in above-mentioned targeted graphical：Above-mentioned field name, the corresponding list data of above-mentioned field name, above-mentioned figure
Shape information includes at least：The format of the format of above-mentioned field name, above table data；Graphical information according to above-mentioned targeted graphical
Above-mentioned original document is converted into above-mentioned targeted graphical.
Optionally, when program is run, equipment where control storage medium executes following functions：Receive the control of user's input
System instruction, wherein above-mentioned control instruction is used to indicate the format information of the above-mentioned target table of user's selection；According to above-mentioned control
Instruction determines the format information of above-mentioned target table.
According to the embodiment of the present application, a kind of processor embodiment is additionally provided.Optionally, in the present embodiment, above-mentioned place
Reason device is for running program, wherein above procedure executes any one of the above data processing method when running.
The embodiment of the present application provides a kind of equipment, equipment include processor, memory and storage on a memory and can
The program run on a processor, processor realize following steps when executing program：Obtain original document, wherein above-mentioned initial
Document is the document that electricity charge information is used to indicate derived from power information platform；Determine the format information of target table, wherein on
It states in target table and includes at least：The corresponding list data of field name, field name, above-mentioned format information include at least：Above-mentioned word
The format of the section format of name, above table data；Format information according to above-mentioned target table is converted to above-mentioned original document
Above-mentioned target table.
Optionally, when above-mentioned processor executes program, can also obtain the field name in above-mentioned Excel table format and
The format of list data；According to the macros of above-mentioned Excel table, the lattice of the format of above-mentioned field name and above table data
Above-mentioned original document is converted to above-mentioned Excel table by formula.
Optionally, when above-mentioned processor executes program, the graphical information of targeted graphical can also be determined, wherein above-mentioned mesh
It is included at least in shape of marking on a map：Above-mentioned field name, the corresponding list data of above-mentioned field name, above-mentioned graphical information include at least：On
State the format of field name, the format of above table data；Graphical information according to above-mentioned targeted graphical turns above-mentioned original document
It is changed to above-mentioned targeted graphical.
Optionally, when above-mentioned processor executes program, the control instruction of user's input can also be received, wherein above-mentioned control
System instruction is used to indicate the format information of the above-mentioned target table of user's selection；Above-mentioned object table is determined according to above-mentioned control instruction
The format information of lattice.
Present invention also provides a kind of computer program products, when executing on data processing equipment, are adapted for carrying out just
The program of beginningization there are as below methods step：Obtain original document, wherein above-mentioned original document, which is that power information platform is derived, to be used
In the document of instruction electricity charge information；Determine the format information of target table, wherein include at least in above-mentioned target table：Field
Name, the corresponding list data of field name, above-mentioned format information include at least：The format of above-mentioned field name, above table data
Format；Above-mentioned original document is converted to above-mentioned target table by the format information according to above-mentioned target table.
Optionally, when above-mentioned computer program product executes program, the field name in above-mentioned Excel table can also be obtained
Format and list data format；According to the macros of above-mentioned Excel table, the format of above-mentioned field name and above table number
According to format, above-mentioned original document is converted into above-mentioned Excel table.
Optionally, when above-mentioned computer program product executes program, the graphical information of targeted graphical can also be determined,
In, it is included at least in above-mentioned targeted graphical：Above-mentioned field name, the corresponding list data of above-mentioned field name, above-mentioned graphical information is extremely
Include less：The format of the format of above-mentioned field name, above table data；Graphical information according to above-mentioned targeted graphical will be above-mentioned first
Beginning document is converted to above-mentioned targeted graphical.
Optionally, when above-mentioned computer program product executes program, the control instruction of user's input can also be received,
In, above-mentioned control instruction is used to indicate the format information of the above-mentioned target table of user's selection；It is determined according to above-mentioned control instruction
The format information of above-mentioned target table.
The serial number of the above embodiments of the invention is only for description, does not represent the advantages or disadvantages of the embodiments.
In the above embodiment of the invention, it all emphasizes particularly on different fields to the description of each embodiment, does not have in some embodiment
The part of detailed description, reference can be made to the related descriptions of other embodiments.
In several embodiments provided herein, it should be understood that disclosed technology contents can pass through others
Mode is realized.Wherein, the apparatus embodiments described above are merely exemplary, such as the division of the unit, Ke Yiwei
A kind of logical function partition, there may be another division manner in actual implementation, for example, multiple units or components can combine or
Person is desirably integrated into another system, or some features can be ignored or not executed.Another point, shown or discussed is mutual
Between coupling, direct-coupling or communication connection can be through some interfaces, the INDIRECT COUPLING or communication link of unit or module
It connects, can be electrical or other forms.
The unit as illustrated by the separation member may or may not be physically separated, aobvious as unit
The component shown may or may not be physical unit, it can and it is in one place, or may be distributed over multiple
On unit.It can some or all of the units may be selected to achieve the purpose of the solution of this embodiment according to the actual needs.
It, can also be in addition, the functional units in various embodiments of the present invention may be integrated into one processing unit
It is that each unit physically exists alone, can also be integrated in one unit with two or more units.Above-mentioned integrated list
Member both can take the form of hardware realization, can also realize in the form of software functional units.
If the integrated unit is realized in the form of SFU software functional unit and sells or use as independent product
When, it can store in a computer readable storage medium.Based on this understanding, technical solution of the present invention is substantially
The all or part of the part that contributes to existing technology or the technical solution can be in the form of software products in other words
It embodies, which is stored in a storage medium, including some instructions are used so that a computer
Equipment (can for personal computer, server or network equipment etc.) execute each embodiment the method for the present invention whole or
Part steps.And storage medium above-mentioned includes：USB flash disk, read-only memory (ROM, Read-OnlyMemory), arbitrary access are deposited
Reservoir (RAM, Random Access Memory), mobile hard disk, magnetic or disk etc. be various to can store program code
Medium.
The above is only a preferred embodiment of the present invention, it is noted that for the ordinary skill people of the art
For member, various improvements and modifications may be made without departing from the principle of the present invention, these improvements and modifications are also answered
It is considered as protection scope of the present invention.
Claims (10)
1. a kind of data processing method, which is characterized in that including：
Obtain original document, wherein the original document is the document that electricity charge information is used to indicate derived from power information platform；
Determine the format information of target table, wherein include at least in the target table：The corresponding table of field name, field name
Lattice data, the format information include at least：The format of the format of the field name, the list data；
The original document is converted to the target table by the format information according to the target table.
2. the method according to claim 1, wherein the field name include at least one:Power supply station's title is answered
It collects charges for electricity, the paid electricity charge, the arrearage amount of money, arrearage amount, tariff recovery rate, meter reader, the arrearage amount of money corresponding with meter reader.
3. the method according to claim 1, wherein the type of the target table includes at least：Excel table
The original document is converted to the target table and includes by lattice, the format information according to the target table：
Obtain the format of the field name in the Excel table and the format of list data；
It, will be described initial according to the macros of the Excel table, the format of the format of the field name and the list data
Document is converted to the Excel table.
4. the method according to claim 1, wherein after obtaining original document, the method also includes：
Determine the graphical information of targeted graphical, wherein include at least in the targeted graphical：The field name, the field name
Corresponding list data, the graphical information include at least：The format of the format of the field name, the list data；
The original document is converted to the targeted graphical by the graphical information according to the targeted graphical.
5. according to the method described in claim 4, it is characterized in that, the type of the targeted graphical includes at least one following：
Column diagram, bar chart, sector diagram.
6. method as claimed in any of claims 1 to 5, which is characterized in that determine the format information of target table
Including：
Receive the control instruction of user's input, wherein the control instruction is used to indicate the target table of user's selection
Format information；
The format information of the target table is determined according to the control instruction.
7. a kind of data processing equipment, which is characterized in that including：
Module is obtained, for obtaining original document, wherein the original document is to be used to indicate electricity derived from power information platform
The document of charge information；
Determining module, for determining the format information of target table, wherein included at least in the target table：Field name, word
The corresponding list data of section name, the format information include at least：The format of the format of the field name, the list data；
The original document is converted to the target table for the format information according to the target table by conversion module.
8. device according to claim 7, which is characterized in that the field name include at least one:Power supply station's title is answered
It collects charges for electricity, the paid electricity charge, the arrearage amount of money, arrearage amount, tariff recovery rate, meter reader, the arrearage amount of money corresponding with meter reader.
9. a kind of storage medium, which is characterized in that the storage medium includes the program of storage, wherein run in described program
When control the storage medium where equipment execute following steps：Obtain original document, wherein the original document is electric power letter
The document of electricity charge information is used to indicate derived from breath platform；Determine the format information of target table, wherein in the target table
It includes at least：The corresponding list data of field name, field name, the format information include at least：The format of the field name, institute
State the format of list data；The original document is converted to the target table by the format information according to the target table.
10. a kind of processor, which is characterized in that the processor is for running program, wherein executed when described program is run with
Lower step：Obtain original document, wherein the original document is the text that electricity charge information is used to indicate derived from power information platform
Shelves；Determine the format information of target table, wherein include at least in the target table：The corresponding table of field name, field name
Data, the format information include at least：The format of the format of the field name, the list data；According to the object table
The original document is converted to the target table by the format information of lattice.
Priority Applications (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN201810654602.7A CN108875029A (en) | 2018-06-22 | 2018-06-22 | Data processing method and device, storage medium and processor |
Applications Claiming Priority (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN201810654602.7A CN108875029A (en) | 2018-06-22 | 2018-06-22 | Data processing method and device, storage medium and processor |
Publications (1)
| Publication Number | Publication Date |
|---|---|
| CN108875029A true CN108875029A (en) | 2018-11-23 |
Family
ID=64294539
Family Applications (1)
| Application Number | Title | Priority Date | Filing Date |
|---|---|---|---|
| CN201810654602.7A Pending CN108875029A (en) | 2018-06-22 | 2018-06-22 | Data processing method and device, storage medium and processor |
Country Status (1)
| Country | Link |
|---|---|
| CN (1) | CN108875029A (en) |
Cited By (2)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN109582941A (en) * | 2018-11-29 | 2019-04-05 | 杭州迪普科技股份有限公司 | A kind of list data display methods, device, equipment and storage medium |
| CN111597771A (en) * | 2019-02-21 | 2020-08-28 | 珠海金山办公软件有限公司 | Method, device, electronic equipment and medium for adjusting document content format |
Citations (11)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN1664817A (en) * | 2005-03-24 | 2005-09-07 | 上海全富汉得软件技术有限公司 | Method for automatically switching between Oracle Form 9i and Microsoft Excel perspective charts |
| CN101499162A (en) * | 2009-03-05 | 2009-08-05 | 唐文超 | Medical research data management system and method |
| CN102013056A (en) * | 2010-12-14 | 2011-04-13 | 广东雅达电子股份有限公司 | Configurable power report management system and operating method thereof |
| CN102436498A (en) * | 2011-11-14 | 2012-05-02 | 深圳市华力特电气股份有限公司 | Report form generating method and relative device |
| CN102682035A (en) * | 2011-03-18 | 2012-09-19 | 富泰华工业（深圳）有限公司 | Data management method and system |
| CN104484419A (en) * | 2014-12-17 | 2015-04-01 | 上海斐讯数据通信技术有限公司 | Test case document conversion system and test case document conversion method |
| CN105045775A (en) * | 2015-08-12 | 2015-11-11 | 深圳联友科技有限公司 | Method and apparatus for generating Excel document in designated format |
| CN105117378A (en) * | 2015-08-05 | 2015-12-02 | 联动优势电子商务有限公司 | Method and apparatus for converting JSON file into EXCEL file |
| CN105446948A (en) * | 2015-11-13 | 2016-03-30 | 武汉鸿图节能技术有限公司 | Report automatic generation method and system |
| US20160132495A1 (en) * | 2014-11-06 | 2016-05-12 | Accenture Global Services Limited | Conversion of documents of different types to a uniform and an editable or a searchable format |
| CN107480186A (en) * | 2017-07-07 | 2017-12-15 | 中国建设银行股份有限公司 | A kind of business model data processing method and computer equipment |
-
2018
- 2018-06-22 CN CN201810654602.7A patent/CN108875029A/en active Pending
Patent Citations (11)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN1664817A (en) * | 2005-03-24 | 2005-09-07 | 上海全富汉得软件技术有限公司 | Method for automatically switching between Oracle Form 9i and Microsoft Excel perspective charts |
| CN101499162A (en) * | 2009-03-05 | 2009-08-05 | 唐文超 | Medical research data management system and method |
| CN102013056A (en) * | 2010-12-14 | 2011-04-13 | 广东雅达电子股份有限公司 | Configurable power report management system and operating method thereof |
| CN102682035A (en) * | 2011-03-18 | 2012-09-19 | 富泰华工业（深圳）有限公司 | Data management method and system |
| CN102436498A (en) * | 2011-11-14 | 2012-05-02 | 深圳市华力特电气股份有限公司 | Report form generating method and relative device |
| US20160132495A1 (en) * | 2014-11-06 | 2016-05-12 | Accenture Global Services Limited | Conversion of documents of different types to a uniform and an editable or a searchable format |
| CN104484419A (en) * | 2014-12-17 | 2015-04-01 | 上海斐讯数据通信技术有限公司 | Test case document conversion system and test case document conversion method |
| CN105117378A (en) * | 2015-08-05 | 2015-12-02 | 联动优势电子商务有限公司 | Method and apparatus for converting JSON file into EXCEL file |
| CN105045775A (en) * | 2015-08-12 | 2015-11-11 | 深圳联友科技有限公司 | Method and apparatus for generating Excel document in designated format |
| CN105446948A (en) * | 2015-11-13 | 2016-03-30 | 武汉鸿图节能技术有限公司 | Report automatic generation method and system |
| CN107480186A (en) * | 2017-07-07 | 2017-12-15 | 中国建设银行股份有限公司 | A kind of business model data processing method and computer equipment |
Cited By (2)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN109582941A (en) * | 2018-11-29 | 2019-04-05 | 杭州迪普科技股份有限公司 | A kind of list data display methods, device, equipment and storage medium |
| CN111597771A (en) * | 2019-02-21 | 2020-08-28 | 珠海金山办公软件有限公司 | Method, device, electronic equipment and medium for adjusting document content format |
Similar Documents
| Publication | Publication Date | Title |
|---|---|---|
| CN101350869B (en) | Method and apparatus for removing repeat of telecom charging based on index and hash | |
| CN110347732A (en) | A kind of data transfer device and device | |
| CN105913233A (en) | SDK processing method suitable for application client end payment | |
| CN109872232A (en) | It is related to illicit gain to legalize account-classification method, device, computer equipment and the storage medium of behavior | |
| CN104156811A (en) | Bill generation method based on in-cloud OS | |
| CN107862613A (en) | Premium paying method, premium pay equipment and readable storage medium storing program for executing | |
| CN112297934B (en) | Charging station processing method and device, storage medium and processor | |
| US20190149344A1 (en) | Intelligent search system for service cost and method thereof | |
| CN102262664A (en) | Quality estimating method and quality estimating device | |
| CN109711801A (en) | A kind of Internetbank account checking method and device | |
| CN109255480A (en) | Between servant lead prediction technique, device, computer equipment and storage medium | |
| CN101437215A (en) | Syncretized charging method of data business platform | |
| CN109474923A (en) | Object identifying method and device, storage medium | |
| CN108875029A (en) | Data processing method and device, storage medium and processor | |
| CN109685545A (en) | Virtual network resource predictor method, device and electronic equipment to be provided | |
| CN109461066A (en) | Electric power enterprise reconciliation system and method | |
| CN106878031B (en) | Method and system for accelerating processing of telephone bill of telecommunication package user | |
| CN102075896B (en) | Price previewing method and system | |
| CN115130811A (en) | Method and device for establishing power user portrait and electronic equipment | |
| CN107977855A (en) | A kind of method and device of managing user information | |
| CN106651356A (en) | Two-dimensional code payment system for electric meters | |
| CN109658529A (en) | Virtual parking area charging method and Related product | |
| CN110188255A (en) | Power consumer Behavior mining method and system based on the shared fusion of business datum | |
| CN109086289A (en) | A kind of media data processing method, client, medium and equipment | |
| CN107105440A (en) | A kind of information processing method, device and business operation support system |
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 | ||
| RJ01 | Rejection of invention patent application after publication | ||
| RJ01 | Rejection of invention patent application after publication |
Application publication date: 20181123 |