CN107229750A - table data processing method, device, storage medium and processor - Google Patents
table data processing method, device, storage medium and processor Download PDFInfo
- Publication number
- CN107229750A CN107229750A CN201710500378.1A CN201710500378A CN107229750A CN 107229750 A CN107229750 A CN 107229750A CN 201710500378 A CN201710500378 A CN 201710500378A CN 107229750 A CN107229750 A CN 107229750A
- Authority
- CN
- China
- Prior art keywords
- data
- page
- file
- configuration information
- configuration
- Prior art date
- Legal status (The legal status is an assumption and is not a legal conclusion. Google has not performed a legal analysis and makes no representation as to the accuracy of the status listed.)
- Granted
Links
Classifications
-
- G—PHYSICS
- G06—COMPUTING; CALCULATING OR COUNTING
- G06F—ELECTRIC DIGITAL DATA PROCESSING
- G06F16/00—Information retrieval; Database structures therefor; File system structures therefor
- G06F16/20—Information retrieval; Database structures therefor; File system structures therefor of structured data, e.g. relational data
- G06F16/24—Querying
- G06F16/248—Presentation of query results
-
- G—PHYSICS
- G06—COMPUTING; CALCULATING OR COUNTING
- G06F—ELECTRIC DIGITAL DATA PROCESSING
- G06F16/00—Information retrieval; Database structures therefor; File system structures therefor
- G06F16/20—Information retrieval; Database structures therefor; File system structures therefor of structured data, e.g. relational data
- G06F16/24—Querying
- G06F16/245—Query processing
- G06F16/2455—Query execution
-
- G—PHYSICS
- G06—COMPUTING; CALCULATING OR COUNTING
- G06F—ELECTRIC DIGITAL DATA PROCESSING
- G06F9/00—Arrangements for program control, e.g. control units
- G06F9/06—Arrangements for program control, e.g. control units using stored programs, i.e. using an internal store of processing equipment to receive or retain programs
- G06F9/44—Arrangements for executing specific programs
- G06F9/445—Program loading or initiating
- G06F9/44505—Configuring for program initiating, e.g. using registry, configuration files
- G06F9/4451—User profiles; Roaming
Landscapes
- Engineering & Computer Science (AREA)
- Theoretical Computer Science (AREA)
- Physics & Mathematics (AREA)
- General Engineering & Computer Science (AREA)
- General Physics & Mathematics (AREA)
- Software Systems (AREA)
- Computational Linguistics (AREA)
- Data Mining & Analysis (AREA)
- Databases & Information Systems (AREA)
- Document Processing Apparatus (AREA)
- Information Retrieval, Db Structures And Fs Structures Therefor (AREA)
Abstract
The embodiment of the invention discloses a kind of table data processing method, device, storage medium and processor.This method includes：File is obtained, wherein, file is the file of spreadsheet software or application generation, and file includes：Configuration page and data page, wherein, configuration page preserves configuration information, wherein, configuration information includes at least one of：Configuration information used in data is read from data page, carries out the data read to export used configuration information；Data page preserves data；Data are read from data page and exported according at least to configuration information.The problems of the prior art are solved by the present invention, all data are all described in Microsoft Excel, without additional documents and instrument so that the data in form use more convenient.
Description
Technical field
The present invention relates to data processing field, it is situated between in particular to a kind of table data processing method, device, storage
Matter and processor.
Background technology
At present, during development of games, due to the design method that service logic and data configuration are separated, so needing
Data configuration is individually managed.Data refer to program function configuration, the configuration of planning playing method numerical value, the configuration of reward numerical value, skill
The configuration of energy numerical value, the configuration of UI text prompts etc..Because the various playing method logics of above-mentioned these data correlations game, data
It is various and complicated, thus how effective configuration data is a difficult point.In the prior art usually using the electronic watch of EXCEL classes
Lattice are configured to data.And the editting function that Microsoft Excel has in itself is all fairly simple pure editting function.Table 1 is
A kind of Microsoft Excel example provided according to correlation technique, as shown in Figure 1：
Table 1
| Topic ID | Topic types | Content | Associate bibliography |
| 101 | 1 | ({ " official loyal to his sovereign without friendship overseas, it is good that disciple has that beam repaiies " }) | 101 |
| 102 | 1 | ({ " he does not touch by force, and he is weak not to take advantage of " }) | 102 |
| … | … | … | … |
One data class of each row correspondence, the first row is to carry out an explanation to the data class of all row, is opened from the second row
Begin one data of correspondence per a line.However, the Microsoft Excel of prior art, which describes data, following defect：
Defect one, data of the prior art do not have type classification, for each cell inside every data line
It is that no data type is distinguished.Data type be for describing data, such as, and int (integer), float (floating number),
String (character string) etc., by a same data explain assign different types of data after, it is representative be meant that it is different.
Therefore, the data read from form belong to plain text data, need to carry out understanding differentiation again when using plain text data,
Inefficiency.
Defect two, data of the prior art do not have safety check, in other words, can not verify and carry when data entry error
Show, cause to influence the logical sum structure of the use, even data of data.As shown in table 1, " topic ID " attributes must be one
Datum purpose positive number, when fill in the table mistake " topic ID " attributes, for example：Fill in a negative or be not present
Topic ID, the logic that list data can be influenceed subsequently to use.And when not filling in the attribute of a certain row, after having a strong impact on
It is continuous to use, the situation for the data corruption such as easily occur misplacing.
Defect three, data of the prior art do not have default value function, and each lattice data in the table need to fill in tool
The value of body, in the case that the attribute of a certain column data is same property value in the table, still needs to fill in data one by one, wave
The Fei Peibiao times.
Row in defect four, in the prior art data form are not classified, being listed in data form be read out or
All it is to carry out simultaneously during other operations.When needing only to read some row or some classification, such as, merely desire to read ID pairs of topic
Topic types are answered, now and the content of topic need not be read, but prior art but still reads whole form, both adds
Read access time, can not find out corresponding classification again.
For the above mentioned problem present in prior art, not yet propose to efficiently solve scheme at present.
The content of the invention
At least part embodiment of the present invention provides a kind of table data processing method, device, storage medium and processor,
Usually using the electrical form of EXCEL classes data are carried out with allocative efficiency is low, fault-tolerance is poor in the prior art to solve
The problem of.
One side according to embodiments of the present invention there is provided table data processing method, including：File is obtained, wherein,
The file is the file of spreadsheet software or application generation, and the file includes：Configuration page and data page, wherein, institute
State configuration page and preserve configuration information, wherein, the configuration information includes at least one of：Number is read from the data page
Carry out exporting used configuration information according to used configuration information, by the data read；The data page preserves number
According to；Data are read from the data page and exported according at least to the configuration information.
Further, the data and description item of at least one classification are preserved in the data page, the description is used for
The attribute information of the data of the category is described, data are read from the data page and output is carried out includes：According to the description
Item is handled the data of the type of reading；Data after output processing.
Further, the description item is at least one of：Data item description, data name, data type, default value,
Check value, non-null marks and label.
Further, the description item is shown in the form of annotating and/or the description item enters in table form
Row displaying.
Further, obtaining the file includes：Obtain the data of user's input；Write according to the data that the user inputs
Enter the file, generate the data page.
Further, before the data are read from the data page according to the configuration information, methods described is also
Including：Obtain the information of user's input；The information inputted according to the user writes the file, generates the configuration page.
Other side according to embodiments of the present invention, additionally provides a kind of list data processing unit, including：Obtain single
Member, for obtaining file, wherein, the file is the file of spreadsheet software or application generation, and the file includes：Match somebody with somebody
Page and data page are put, wherein, the configuration page preserves configuration information, wherein, the configuration information includes at least one of：
Read from the data page configuration information used in data, by the data read exported used in confidence
Breath；The data page preserves data；Output unit, for reading number from the data page according at least to the configuration information
According to and exported.
Further, the data and description item of at least one classification are preserved in the data page, the description is used for
The attribute information of the data of the category is described, the output unit includes：Processing module, for according to it is described description item to read
The data of the type handled；Output module, the data after being handled for output.
Further, the description item is at least one of：Data item description, data name, data type, default value,
Check value, non-null marks and label.
Further, the description item is shown in the form of annotating and/or the description item enters in table form
Row displaying.
Further, it is characterised in that the acquiring unit includes：Acquisition module, the data for obtaining user's input；
Generation module, the data for being inputted according to the user write the file, generate the data page.
Further, described device also includes：The data are being read from the data page according to the configuration information
Before, the information of user's input is obtained；The information inputted according to the user writes the file, generates the configuration page.
Other side according to embodiments of the present invention, has been also provided on a kind of storage medium, the storage medium and has protected
Computer program stored, performs upper described method when described program is run.
Other side according to embodiments of the present invention, has been also provided to a kind of processor, has been held when described program is run
The above-mentioned method of row.
According to embodiments of the present invention, using acquisition file, wherein, the file is spreadsheet software or application life
Into file, the file includes：Configuration page and data page, wherein, the configuration page preserves configuration information, wherein, it is described
Configuration information includes at least one of：Configuration information used in data is read from the data page, by the number read
Used configuration information is exported according to progress；The data page preserves data；According at least to the configuration information from the number
Data and exported according to being read in page.Pass through the electrical form of the invention solved in the prior art usually using EXCEL classes
, fault-tolerance poor low to data progress allocative efficiency, all data are all described in Microsoft Excel, nothing
Need additional documents and instrument so that the data in form use more convenient.
Brief description of the drawings
The accompanying drawing for constituting the part of the application is used for providing a further understanding of the present invention, schematic reality of the invention
Apply example and its illustrate to be used to explain the present invention, do not constitute inappropriate limitation of the present invention.In the accompanying drawings：
Fig. 1 is the flow chart according to the present invention wherein table data processing method of an embodiment；
Fig. 2 is the schematic diagram according to the present invention wherein configuration page of a preferred embodiment；
Fig. 3 is the schematic diagram according to the present invention wherein configuration page of a preferred embodiment；
Fig. 4 is the schematic diagram according to the present invention wherein data page of a preferred embodiment；
Fig. 5 is a kind of schematic diagram of list data processing unit according to a wherein embodiment of the invention.
Embodiment
It should be noted that in the case where not conflicting, the feature in embodiment and embodiment in the application can phase
Mutually combination.Describe the present invention in detail below with reference to the accompanying drawings and in conjunction with the embodiments.
In order that those skilled in the art more fully understand the present invention program, below in conjunction with the embodiment of the present invention
Accompanying drawing, the technical scheme in the embodiment of the present invention is clearly and completely described, it is clear that described embodiment is only
The embodiment of a part of the invention, rather than whole embodiments.Based on the embodiment in the present invention, ordinary skill people
The every other embodiment that member is obtained under the premise of creative work is not made, should all belong to the model that the present invention is protected
Enclose.
It should be noted that term " first " in description and claims of this specification and above-mentioned accompanying drawing, "
Two " etc. be for distinguishing similar object, without for describing specific order or precedence.It should be appreciated that so using
Data can exchange in the appropriate case, so as to embodiments of the invention described herein.In addition, term " comprising " and " tool
Have " and their any deformation, it is intended that covering is non-exclusive to be included, for example, containing series of steps or unit
Process, method, system, product or equipment are not necessarily limited to those steps clearly listed or unit, but may include without clear
It is listing to Chu or for the intrinsic other steps of these processes, method, product or equipment or unit.
A wherein embodiment of the invention provides a kind of table data processing method.Fig. 1 is real according to the present invention wherein one
Apply the flow chart of the table data processing method of example.As shown in figure 1, this method comprises the following steps：
Step S102, obtains file, wherein, file is the file of spreadsheet software or application generation, and file includes：
Configuration page and data page, wherein, configuration page preserves configuration information, wherein, configuration information includes at least one of：From data
Configuration information used in data is read in page, carries out the data read to export used configuration information；Data page is protected
There are data；
Step S104, reads data from data page according at least to configuration information and is exported.
Employed in above-mentioned steps by way of configuration page and data page are set hereof, all data are entered
Row input and output, and prior art carries out input and output to data only with the simple editing function of form in itself, should
Mode needs extra document and instrument subsequently to handle data, and the present embodiment solves table present in prior art
The problem of data in lattice are inconvenient to use, all data are all described in Microsoft Excel, without additional documents and
Instrument so that the data in form use more convenient.
Above-mentioned configuration page is done below in conjunction with an alternative embodiment and further described in detail.
Fig. 2 is the schematic diagram according to the present invention wherein configuration page of a preferred embodiment；As shown in Fig. 2 in form
CONFIG labels represent configuration page, and subsection labels represent page of data, and basicbuff labels represent the non-data page.
The name of the page is according to the autonomous definition of user's custom.The non-data page is used for carrying out remarks explanation in table form or to criticize
The form of note is illustrated.Form document in Fig. 2 preserves configuration information by CONFIG, and configuration page is also form.
The configuration information that configuration page is preserved can be that configuration information used in data is read from data page, and the configuration information can be with
It is whether the related description information of file, file need the information of detection, whether file needs to filter the information of certain table page,
Whether file associates information of other forms etc..Above-mentioned configuration information is to carry out configuration information to whole form, so as to carry out complete
Office's description.
The data read are carried out to export used configuration information in addition, above-mentioned configuration information can also be, or,
Can be that this reads the template file configured information of association, output file configured information, form exports the coded system of data,
Information of form page information filtering row etc..Above-mentioned configuration information is that digital independent behavior is configured.
In an optional embodiment, above-mentioned digital independent behavior can configure multiple, for example, as shown in Fig. 2 on
State that " digital independent behavior " refers to the first row in Fig. 2：
Generate file 1a_CommonSheetData.pat ALL_SHEET_GEN utf-8ALL_SHEETS
Client/Data/BuffData.py"filter":"Client"；
Fig. 3 is the schematic diagram according to the present invention wherein configuration page of a preferred embodiment, as shown in figure 3, the generation in Fig. 3
File 1- generation files 9 can represent 9 configuration behaviors respectively, so digital independent behavior can configure multiple, that is, can
So that according to different demand conditions (some generation file), a variety of sides are carried out to the data page in the form where the configuration page
The reading of formula, above-mentioned data page can be that one page can also be multipage.It can cause table by configuring multiple digital independent behaviors
Data description in lattice is more flexibly and convenient.
The data and description item of at least one classification are preserved in above-mentioned steps, in data page, description item is used to describe
The attribute information of the data of the category, reads data in the configuration information in configuration page and is exported from the data page
In the case of, in an optional embodiment, the data of the type of reading are handled according to description item；At output
Data after reason.
Data are described by above-mentioned steps, so as to flexibly easily be configured to data, without subsequent artefacts
Classifying again and screen to data, improve the efficiency of digital independent.
Foregoing description can have plurality of classes, to adapt to the requirement of different data type and data output and input,
Follow-up operation software can be even coordinated to carry out certain category setting, it is above-mentioned to retouch in an optional embodiment
Item is stated at least one of：Data item description, data name, data type, default value, check value, non-null marks and label.
Foregoing description is stored in data page, can be shown in a variety of forms, consequently facilitating user is carried out at any time
Configure and change so that configuration is more directly perceived convenient, is easy to operation, in an optional embodiment, describes item to annotate
Form be shown and/or describe item and be shown in table form.
Illustrate below and above-mentioned data page and its description item are illustrated, Fig. 4 is preferable to carry out according to the present invention wherein one
The schematic diagram of the data page of example；As shown in figure 4, data page of the prior art only describes data, and the number in the present embodiment
The description that the acquisition model in description item, the second row of Fig. 4 tables, buff classes are exactly each column data attribute is also described according to page
, and it can be data item description, data name, data type etc. that these, which describe item, this above-mentioned several properties describe item with form
Form be directly illustrated in each cell of data form.In addition, the annotation part in Fig. 4 is also description item, the part
Description can be the functions such as default value, check value, non-null marks, label, description item is located at the cell of the second row in Fig. 4
And in the annotation corresponding to the cell.Can by describing the various data contents of description of item selectivity so that
So that all data descriptions are all carried out in the table, without extra document and instrument.
The data of data page are defined by describing item, in processing data, the requirement of data are set, according to data
It is required that removing input description item, initial data is checked according to description item, when the information and description item of judging the data
When information is inconsistent, represent that the data are undesirable, data are repaired and the data of mistake are reported.Above-mentioned inspection
Checking method such as can avoid occurring in the case where not filling in the attribute of a certain row misplacing the situation of data corruption so that data
Treatment effeciency is improved.
The type of data can be distinguished by above-mentioned steps, can also go to set default value of a certain data etc., such as,
" topic types " as shown in table 1, if the data probability of the cell is all 1, can configure the description of the data
For " default value is 1 ", and when the row are not filled out, the property value of the row is exactly 1, matches somebody with somebody the table time so as to save, and is improved
Serious forgiveness.
Above-mentioned data page when being inputted, can by way of artificial or software input data, can also be defeated
Setting description item while entering data, if using the mode of software input data, in an optional embodiment, obtained
File includes：Obtain the data of user's input；The data inputted according to user write file, generate data page.Pass through above-mentioned side
Formula efficiently input data and its description item.
Before data are read from data page according to configuration information, it is necessary to first obtain in an optional embodiment
Take the information of family input；File is write further according to the information that user inputs, configuration page is generated.Efficiently match somebody with somebody through the above way
Confidence ceases.
The above-mentioned process that is preferable to carry out is described in further detail below in conjunction with a preferred embodiment.
In the preferred embodiment, table data processing method can include following process step：
The first step, form is described, i.e., according to the different types of representation function (configuration information) of offer describe
CONFIG pages and the attribute item of each data page.
Second step, reads the data in form, and the initial data read according to configuration information is added according to description item
Work processing, the method according to description item processing is as follows：
1) data of given filter can be read
Refer to and read schemes (configuration information) are configured in CONFIG pages, judge whether included in the program (configuration information)
Filter condition, it is read-only to take the row that the filtering is carried in data page if including filter condition in the program (configuration information).
2) read and specify form page
Read schemes (configuration information) are configured in CONFIG pages, specifies and reads single page or multipage or whole pages.
3) data encoding is read to specify
When configuring read schemes (configuration information) in CONFIG pages, it is necessary to specify the specific coding for reading result, than
Such as utf-8, gbk, then can be specified according to this and coded treatment is carried out to result.
4) description to data page sets variable name and types of variables
The data name that variable name correspondence is read out in second row of data page in Figure 5, data type (description item)
It is to process initial data.The data type supported at present includes：
INT：Integer；BOOL：Boolean type；FLOAT：Floating number；TEXT：Plain text；STRING：Character string；LIST：Row
Table；ILIST：Integer List；FLIST：Floating number list；SLIST：Character string list；ARRAY：Array；DICT：Dictionary；
CODE：Free-format；EXPR：Expression solution.
The attribute column (description item) of data page could be arranged to default value.The description cell of each attribute column (description item)
Can be inside the corresponding annotation of the unit plus default descriptions, so as to set default value.
In addition to this it is possible to which the attribute column (description item) to data page sets " not reading ", i.e., the interior of the row is not read
Hold, can be specifically by the way that the variable name of attribute column (description item) is set to " _ _ " beginning name, then it represents that the attribute column
Do not read, the functions such as remarks may be used only to.
Data in form are carried out safety inspection, the data in each cell read out are pressed by the 3rd step
Checked according to the safety conditions defined in attribute column (description item), may specify that safety conditions include：no_empty：Can not
For sky；min：Minimum value；max：Maximum；enum：Inspection is enumerated, the value in enumerating can only be configured.
More flexible and convenient configuration, more can be carried out to data by the description of list data in above preferred embodiment
Intuitively expression, it is safer verify, more efficient management.
A wherein embodiment of the invention additionally provides a kind of list data processing unit, and the device can pass through acquiring unit
52nd, output unit 54 realizes its function.It should be noted that the list data processing unit of the embodiment of the present invention can be used for holding
The table data processing method that the row embodiment of the present invention is provided, the table data processing method of the embodiment of the present invention can also lead to
List data processing unit that the embodiment of the present invention provided is crossed to perform.
Fig. 5 is a kind of schematic diagram of list data processing unit according to a wherein embodiment of the invention.As shown in figure 5,
A kind of list data processing unit includes：
Acquiring unit 52, for obtaining file, wherein, file is the file of spreadsheet software or application generation, text
Part includes：Configuration page and data page, wherein, configuration page preserves configuration information, wherein, configuration information include it is following at least it
One：Configuration information used in data is read from data page, carries out the data read to export used configuration information；
Data page preserves data；
Output unit 54, for reading data from data page according at least to configuration information and being exported.
By setting configuration page and data page to input and export all data hereof, and prior art is only
Only it is data to be carried out after input and output, the extra document of which needs and instrument using the simple editing function of form in itself
It is continuous that data are handled, and the data that the present embodiment is solved present in prior art in form are inconvenient to use asks
Topic, all data are all described in Microsoft Excel, without additional documents and instrument so that the data in form make
With more convenient.
In an optional embodiment, the data and description item of at least one classification, description are preserved in data page
Item is used for the attribute information for describing the data of the category, and output unit includes：Processing module, for according to description item to reading
The data of the type are handled；Output module, the data after being handled for output.
In an optional embodiment, description item is at least one of：Data item description, data name, data class
Type, default value, check value, non-null marks and label.
In an optional embodiment, description item is shown and/or described item with form in the form of annotating
Form is shown.
In an optional embodiment, acquiring unit includes：Acquisition module, the data for obtaining user's input；
Generation module, the data for being inputted according to user write file, generate data page.
In an optional embodiment, device also includes：Read according to configuration information from data page data it
Before, obtain the information of user's input；The information inputted according to user writes file, generates configuration page.
According to a wherein embodiment of the invention, a kind of storage medium is additionally provided, storage medium includes the program of storage, its
In, equipment performs above table data processing method where controlling storage medium when program is run.Above-mentioned storage medium can be with
Including but not limited to：USB flash disk, read-only storage (ROM), random access memory (RAM), mobile hard disk, magnetic disc or CD etc.
It is various can be with the medium of store program codes.
According to a wherein embodiment of the invention, a kind of processor is additionally provided, processor is used for operation program, wherein, journey
Above table data processing method is performed during sort run.Above-mentioned processor can include but is not limited to：Microprocessor (MCU) can
The processing unit of programmed logic device (FPGA) etc..
According to a wherein embodiment of the invention, a kind of terminal is additionally provided, including：One or more processors, memory,
Display device and one or more programs, wherein, one or more programs are stored in memory, and be configured as by
One or more processors are performed, and program includes being used to perform above table data processing method.In certain embodiments, it is above-mentioned
Terminal can be smart mobile phone (for example：Android phone, iOS mobile phones etc.), tablet personal computer, palm PC and mobile interchange
The terminal devices such as net equipment (Mobile Internet Devices, referred to as MID), PAD.Above-mentioned display device can be tactile
The liquid crystal display (LCD) of screen formula is touched, the liquid crystal display may be such that user can interact with the user interface of terminal.This
Outside, above-mentioned terminal can also include：Input/output interface (I/O interfaces), USB (USB) port, network interface,
Power supply and/or camera.
It should be noted that for foregoing each method embodiment, in order to be briefly described, therefore it is all expressed as a series of
Combination of actions, but those skilled in the art should know, the present invention is not limited by described sequence of movement because
According to the present invention, some steps can be carried out sequentially or simultaneously using other.Secondly, those skilled in the art should also know
Know, embodiment described in this description belongs to preferred embodiment, involved action and module is not necessarily of the invention
It is necessary.
In the above-described embodiments, the description to each embodiment all emphasizes particularly on different fields, and does not have the portion being described in detail in some embodiment
Point, it may refer to the associated description of other embodiment.
, can be by another way in several embodiments provided herein, it should be understood that disclosed device
Realize.For example, device embodiment described above is only schematical, such as the division of described unit is only one kind
Division of logic function, can there is other dividing mode when actually realizing, such as multiple units or component can combine or can
To be integrated into another system, or some features can be ignored, or not perform.It is another, it is shown or discussed each other
Coupling direct-coupling or communication connection can be by some interfaces, the INDIRECT COUPLING or communication connection of device or unit,
Can be electrical or other forms.
The unit illustrated as separating component can be or may not be it is physically separate, it is aobvious as unit
The part shown can be or may not be physical location, you can with positioned at a place, or can also be distributed to multiple
On NE.Some or all of unit therein can be selected to realize the mesh of this embodiment scheme according to the actual needs
's.
In addition, each functional unit in each embodiment of the invention can be integrated in a processing unit, can also
That unit is individually physically present, can also two or more units it is integrated in a unit.Above-mentioned integrated list
Member can both be realized in the form of hardware, it would however also be possible to employ the form of SFU software functional unit is realized.
If the integrated unit is realized using in the form of SFU software functional unit and as independent production marketing or used
When, it can be stored in a computer read/write memory medium.Understood based on such, technical scheme is substantially
The part contributed in other words to prior art or all or part of the technical scheme can be in the form of software products
Embody, the computer software product is stored in a storage medium, including some instructions are to cause a computer
Equipment (can be personal computer, mobile terminal, server or network equipment etc.) performs side described in each embodiment of the invention
The all or part of step of method.And foregoing storage medium includes：USB flash disk, read-only storage (ROM, Read-Only Memory),
Random access memory (RAM, Random Access Memory), mobile hard disk, magnetic disc or CD etc. are various to be stored
The medium of program code.
The preferred embodiments of the present invention are the foregoing is only, are not intended to limit the invention, for the skill of this area
For art personnel, the present invention can have various modifications and variations.Within the spirit and principles of the invention, that is made any repaiies
Change, equivalent substitution, improvement etc., should be included in the scope of the protection.
Claims (15)
1. a kind of table data processing method, it is characterised in that including：
File is obtained, wherein, the file is the file of spreadsheet software or application generation, and the file includes：Configuration
Page and data page, wherein, the configuration page preserves configuration information, wherein, the configuration information includes at least one of：From
Configuration information used in data is read in the data page, carries out the data read to export used configuration information；
The data page preserves data；
Data are read from the data page and exported according at least to the configuration information.
2. according to the method described in claim 1, it is characterised in that the data of at least one classification are preserved in the data page
With description item, the description is used for the attribute information for describing the data of the category, reads data from the data page and goes forward side by side
Row output includes：
The data of the type of reading are handled according to the description item；
Data after output processing.
3. method according to claim 2, it is characterised in that the description is at least one of：Data item description,
Data name, data type, default value, check value, non-null marks and label.
4. method according to claim 2, it is characterised in that the description item be shown in the form of annotating and/or
The description item is shown in table form.
5. according to the method described in claim 1, it is characterised in that obtaining the file includes：
Obtain the data of user's input；
The data inputted according to the user write the file, generate the data page.
6. according to the method described in claim 1, it is characterised in that read according to the configuration information from the data page
Before the data, methods described also includes：
Obtain the information of user's input；
The information inputted according to the user writes the file, generates the configuration page.
7. a kind of list data processing unit, it is characterised in that including：
Acquiring unit, for obtaining file, wherein, the file is the file of spreadsheet software or application generation, described
File includes：Configuration page and data page, wherein, the configuration page preserves configuration information, wherein, the configuration information include with
It is at least one lower：Configuration information used in data is read from the data page, the data read are exported made
Configuration information；The data page preserves data；
Output unit, for reading data from the data page according at least to the configuration information and being exported.
8. device according to claim 7, it is characterised in that the data of at least one classification are preserved in the data page
With description item, the description is used for the attribute information for describing the data of the category, and the output unit includes：
Processing module, for being handled according to the description item the data of the type of reading；
Output module, the data after being handled for output.
9. device according to claim 8, it is characterised in that the description is at least one of：Data item description,
Data name, data type, default value, check value, non-null marks and label.
10. device according to claim 8, it is characterised in that the description item be shown in the form of annotating and/or
The description item is shown in table form.
11. device according to claim 7, it is characterised in that the acquiring unit includes：
First acquisition module, the data for obtaining user's input；
First generation module, the data for being inputted according to the user write the file, generate the data page.
12. device according to claim 7, it is characterised in that described device also includes：
Second acquisition module, for before the data are read from the data page according to the configuration information, obtaining and using
The information of family input；
Second generation module, the information for being inputted according to the user writes the file, generates the configuration page.
13. a kind of storage medium, it is characterised in that program is preserved on the storage medium, is performed when described program is run
Table data processing method in claim 1 to 6 described in any one.
14. a kind of processor, it is characterised in that when described program is run in perform claim requirement 1 to 6 described in any one
Table data processing method.
15. a kind of terminal, it is characterised in that including：One or more processors, memory, display device and one or many
Individual program, wherein, one or more of programs are stored in the memory, and are configured as by one or many
Individual computing device, one or more of programs include being used for the form number in perform claim requirement 1 to 6 described in any one
According to processing method.
Priority Applications (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN201710500378.1A CN107229750B (en) | 2017-06-27 | 2017-06-27 | Table data processing method, device, storage medium and processor |
Applications Claiming Priority (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN201710500378.1A CN107229750B (en) | 2017-06-27 | 2017-06-27 | Table data processing method, device, storage medium and processor |
Publications (2)
| Publication Number | Publication Date |
|---|---|
| CN107229750A true CN107229750A (en) | 2017-10-03 |
| CN107229750B CN107229750B (en) | 2020-02-07 |
Family
ID=59935287
Family Applications (1)
| Application Number | Title | Priority Date | Filing Date |
|---|---|---|---|
| CN201710500378.1A Active CN107229750B (en) | 2017-06-27 | 2017-06-27 | Table data processing method, device, storage medium and processor |
Country Status (1)
| Country | Link |
|---|---|
| CN (1) | CN107229750B (en) |
Cited By (10)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN109117468A (en) * | 2018-08-01 | 2019-01-01 | 北京数字雷暴信息科技有限公司 | A kind of data processing method and device |
| CN109446201A (en) * | 2018-11-01 | 2019-03-08 | 郑州云海信息技术有限公司 | A kind of method for sorting, device and the equipment of Excel table endorsement information |
| CN111291302A (en) * | 2020-03-20 | 2020-06-16 | 成都药王科技股份有限公司 | Method for quickly creating active page |
| CN111324575A (en) * | 2020-03-20 | 2020-06-23 | 成都药王科技股份有限公司 | OM operation activity management system |
| CN111339741A (en) * | 2020-02-26 | 2020-06-26 | 腾讯科技（深圳）有限公司 | Account application method and device, computer readable storage medium and electronic equipment |
| CN111626869A (en) * | 2020-05-25 | 2020-09-04 | 泰康保险集团股份有限公司 | Data processing method and device, electronic equipment and readable storage medium |
| CN112241267A (en) * | 2020-09-16 | 2021-01-19 | 武汉木仓科技股份有限公司 | Configuration tool and method for realizing form page development by using same |
| CN112241235A (en) * | 2019-07-01 | 2021-01-19 | 珠海金山办公软件有限公司 | Electronic form annotation method, electronic form display method and corresponding device |
| CN117539460A (en) * | 2023-10-30 | 2024-02-09 | 浙江工企信息技术股份有限公司 | Data set editing processing method and system |
| CN117688915A (en) * | 2023-11-28 | 2024-03-12 | 中国人寿保险股份有限公司江苏省分公司 | Method for automatically generating result based on data display and separation technology |
Citations (3)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN101686246A (en) * | 2008-09-27 | 2010-03-31 | 国家电力调度通信中心 | Datamodel describing method for massive information exchanging and processing |
| CN101794289A (en) * | 2009-12-30 | 2010-08-04 | 北京数码大方科技有限公司 | Method and system for exporting data |
| CN105574130A (en) * | 2015-12-14 | 2016-05-11 | 浪潮通用软件有限公司 | Data transmission method and service system |
-
2017
- 2017-06-27 CN CN201710500378.1A patent/CN107229750B/en active Active
Patent Citations (3)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN101686246A (en) * | 2008-09-27 | 2010-03-31 | 国家电力调度通信中心 | Datamodel describing method for massive information exchanging and processing |
| CN101794289A (en) * | 2009-12-30 | 2010-08-04 | 北京数码大方科技有限公司 | Method and system for exporting data |
| CN105574130A (en) * | 2015-12-14 | 2016-05-11 | 浪潮通用软件有限公司 | Data transmission method and service system |
Cited By (13)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN109117468A (en) * | 2018-08-01 | 2019-01-01 | 北京数字雷暴信息科技有限公司 | A kind of data processing method and device |
| CN109446201A (en) * | 2018-11-01 | 2019-03-08 | 郑州云海信息技术有限公司 | A kind of method for sorting, device and the equipment of Excel table endorsement information |
| CN112241235A (en) * | 2019-07-01 | 2021-01-19 | 珠海金山办公软件有限公司 | Electronic form annotation method, electronic form display method and corresponding device |
| CN112241235B (en) * | 2019-07-01 | 2022-08-09 | 珠海金山办公软件有限公司 | Electronic form annotation method, electronic form display method and corresponding device |
| CN111339741A (en) * | 2020-02-26 | 2020-06-26 | 腾讯科技（深圳）有限公司 | Account application method and device, computer readable storage medium and electronic equipment |
| CN111339741B (en) * | 2020-02-26 | 2021-08-24 | 腾讯科技（深圳）有限公司 | Account application method and device, computer readable storage medium and electronic equipment |
| CN111324575A (en) * | 2020-03-20 | 2020-06-23 | 成都药王科技股份有限公司 | OM operation activity management system |
| CN111291302A (en) * | 2020-03-20 | 2020-06-16 | 成都药王科技股份有限公司 | Method for quickly creating active page |
| CN111324575B (en) * | 2020-03-20 | 2023-05-02 | 成都药王科技股份有限公司 | OM operation activity management system |
| CN111626869A (en) * | 2020-05-25 | 2020-09-04 | 泰康保险集团股份有限公司 | Data processing method and device, electronic equipment and readable storage medium |
| CN112241267A (en) * | 2020-09-16 | 2021-01-19 | 武汉木仓科技股份有限公司 | Configuration tool and method for realizing form page development by using same |
| CN117539460A (en) * | 2023-10-30 | 2024-02-09 | 浙江工企信息技术股份有限公司 | Data set editing processing method and system |
| CN117688915A (en) * | 2023-11-28 | 2024-03-12 | 中国人寿保险股份有限公司江苏省分公司 | Method for automatically generating result based on data display and separation technology |
Also Published As
| Publication number | Publication date |
|---|---|
| CN107229750B (en) | 2020-02-07 |
Similar Documents
| Publication | Publication Date | Title |
|---|---|---|
| CN107229750A (en) | table data processing method, device, storage medium and processor | |
| CN108415980A (en) | Question and answer data processing method, electronic device and storage medium | |
| CN109359284A (en) | A kind of reporting and processing method, device and terminal device | |
| CN108628741A (en) | Webpage test method, device, electronic equipment and medium | |
| CN104239073B (en) | Data maintenance system rapid prototyping development system and method | |
| CN109285076A (en) | Intelligent core protects processing method, server and storage medium | |
| US20080109780A1 (en) | Method of and apparatus for optimal placement and validation of i/o blocks within an asic | |
| CN109710237A (en) | A kind of online modification method of calibration and equipment based on customized two-dimentional report | |
| CN107784063B (en) | Algorithm generation method and terminal equipment | |
| CN108153719A (en) | Merge the method and apparatus of electrical form | |
| CN107203498A (en) | A kind of method, system and its user terminal and server for creating e-book | |
| CN110263007A (en) | A kind of file naming method, system and electronic equipment and storage medium | |
| CN115344504B (en) | Software test case automatic generation method and tool based on requirement specification | |
| CN106528896A (en) | Database optimization method and apparatus | |
| CN107592399A (en) | The display methods and mobile terminal of a kind of contact person | |
| CN104375814A (en) | Generation method and device of an interface document | |
| CN113407254B (en) | Form generation method and device, electronic equipment and storage medium | |
| CN107329756A (en) | Generation method, device, storage medium, processor and the terminal of program file | |
| CN107071553A (en) | Method, device and computer readable storage medium for modifying video and voice | |
| CN109933766B (en) | File generation method, device and storage medium | |
| CN107092716A (en) | The implementation method and device of a kind of Electronic Design | |
| CN110619116A (en) | Data processing method, device, terminal and storage medium | |
| CN110503378A (en) | A kind of BOM standardized method, system and electronic equipment and storage medium | |
| US8347219B1 (en) | Object-level display building | |
| CN109117469A (en) | Excel report file generation method, device, computer equipment and storage medium |
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 | ||
| GR01 | Patent grant | ||
| GR01 | Patent grant |